I have a problem with my mysql on a new host I bought running on Windows Server 2008 (on which everything was fine). The default databases which come with the installation are 0 bytes. They have data in them, but every one of them shows as 0 bytes in Heidisql.
I am running a game server, and upon creating a new character, I get an error :
[ERROR]: [1265] Data truncated for column 'x' at row 1 Unhandled MySQL errno 1265. Unexpected behaviour possible.
I tried contacting my host because I think that the problem is probably from their end, but they do not help with administering customer's dedicated servers.
What I did when I moved is that I backed up each database with Sqlyog, and executed them via the new how without any problem. I have a database which is over 1 Gib in size, and when I view it via Heidisql it just shows as 0 bytes.
I tried reinstalling mysql several times using different options, but that didn't help. I edited my.ini, with options I found upon googling, but those didn't help either. I tried manually editing mysql root user permissions, but that didn't do the trick.
Could someone point me in the right direction?
and this
I have installed a fresh MYSQL 32x and 64x as well, it seems that I don't have some kind of perimission. I use an application which requires its own mysql database.
The default(mysql, information_schema databases are showing as 0 byte, despite the fact that they have data in it. I exported my own databases from my old dedicated server, the data appears, but the main database is showing as 0 byte. I'm using latest version of mysql downloaded fromhttp://dev.mysql.com/downloads/windows/installer/
I searched google, and what I've found is to change from Innodb to myisam, but that didn't help either. I did not have any problems on my other dedicated server from which I moved from. Please take a look at this, because it's causing me a headache, and I cannot figure out what could the problem be.
"unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page
in Help and Support
Posted · Edited by ButtlerKid
PrepareStatement(CHAR_INS_CHARACTER, "INSERT INTO characters (guid, account, name, race, class, gender, level, xp, money, playerBytes, playerBytes2, playerFlags, "
"map, instance_id, instance_mode_mask, position_x, position_y, position_z, orientation, trans_x, trans_y, trans_z, trans_o, transguid, "
"taximask, cinematic, "
"totaltime, leveltime, rest_bonus, logout_time, is_logout_resting, resettalents_cost, resettalents_time, "
"extra_flags, stable_slots, at_login, zone, "
"death_expire_time, taxi_path, arenaPoints, totalHonorPoints, todayHonorPoints, yesterdayHonorPoints, totalKills, "
"todayKills, yesterdayKills, chosenTitle, knownCurrencies, watchedFaction, drunk, health, power1, power2, power3, "
"power4, power5, power6, power7, latency, speccount, activespec, exploredZones, equipmentCache, ammoId, knownTitles, actionBars, grantableLevels) VALUES "
"(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)", CONNECTION_ASYNC);
I am running a game server, and upon creating a new character, I get an error :
[ERROR]: [1265] Data truncated for column 'x' at row 1 Unhandled MySQL errno 1265. Unexpected behaviour possible.
I tried contacting my host because I think that the problem is probably from their end, but they do not help with administering customer's dedicated servers.
What I did when I moved is that I backed up each database with Sqlyog, and executed them via the new how without any problem. I have a database which is over 1 Gib in size, and when I view it via Heidisql it just shows as 0 bytes.
I tried reinstalling mysql several times using different options, but that didn't help. I edited my.ini, with options I found upon googling, but those didn't help either. I tried manually editing mysql root user permissions, but that didn't do the trick.
Could someone point me in the right direction?
The default(mysql, information_schema databases are showing as 0 byte, despite the fact that they have data in it. I exported my own databases from my old dedicated server, the data appears, but the main database is showing as 0 byte. I'm using latest version of mysql downloaded fromhttp://dev.mysql.com/downloads/windows/installer/
I searched google, and what I've found is to change from Innodb to myisam, but that didn't help either. I did not have any problems on my other dedicated server from which I moved from. Please take a look at this, because it's causing me a headache, and I cannot figure out what could the problem be.
Hope some of you guys can help me. :S