ButtlerKid

OS: Windows Server 2008 Web Trinity rev: 2bda5330d091+ 2013-12-10 09:09:16 -0600 (master branch) (Win32, Release) (worldserver-daemon) TDB rev : TDB 335.52 // Player saving 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); this is how that part works take something from here 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. Hope some of you guys can help me. :S