database source errors

[kedobin]

I've finally found time to set up the emu on my new pc, but I keep getting errors when I source it in, ranging from numerous that appear when running through the console and navicat, to out of memory or unable to allocate memory from mysql workbench or navicat.

I've tried resourcing the db, but that only cuts out the beginning 'no existing table' errors, since a portion of the database does source successfully. I've deleted/recreated the database, but sourcing didn't change. I've uninstalled/reinstalled via the same installer, making sure I never strayed from the emu server setup instructions, but no change. I've also deleted/redownloaded the primary database file, but no change.

I can't access all the errors from the console, since there's too much data for it all to remain, but the ones I've seen match up well, if not identically, with those that appear within navicat. It shows on a fresh db source, out of 737 queries, 452 were processed, and I had 285 errors. A number of errors include: [Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'hread. If used carefully,`I can use less shimmering `steel thread to make a mor' at line 1
[Err] REPLACE INTO `books` (`name`, `txtfile`) VALUES
('', 'CHRMLDoNCHA'),
...
('ABYFletchingRecipeB', 'The Beauty of a Simple Stone` by Bansama Nysawi``I am a simple person and I `find beauty in the simple `things. I\'ve been a `crafte
[Err] 1136 - Column count doesn't match value count at row 50
[Err] REPLACE INTO `doors` (`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_instance`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `client_version_mask`, `is_ldon_door`) VALUES
(9, 8, 'Tox', 0, 'POKTELE500', 2324.96, -582.532, -47.8143, 120, 58, 0, 0, 0, 0, 0, 0, 0, 0, 'poknowledge', 0, 35.9378, 630, -145, 128, 0, 0, 100, 0, 4294967295, 0),
...
(84, 91, 'PoKnowledge', 0, 'POKDOOR500', 100.012, 1399.93, -111.998, 384, 5, 0, 0
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '200, 0, 4294967295, 0),
(17011, 61, 'moors', 0, 'OBJ_BUCKET_STRP', -1188.61, -' at line 50
[Err] REPLACE INTO `doors` (`id`, `doorid`, `zone`, `version`, `name`, `pos_y`,
...
11282, 94, 'potranquility', 0, 'POKDOOR500', -360.36, 527.804, -93.998, 256, 5, 0, 0, 0, 0, 0, 0, 0, -1, 'NONE', 0, 0, 0, 0, 0, 0, 0, 100, 0, 4294967295, 0),
...
(11304, 133, 'potranquility', 0, 'SHBOOK306', 879.287, 644.085, -160.249, 472, 58, 0, 0, 0, 0, 0,
...
[Err] 1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
[Err] /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
[Err] 1231 - Variable 'foreign_key_checks' can't be set to the value of 'NULL'
[Err] /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
[Err] 1231 - Variable 'character_set_client' can't be set to the value of 'NULL'
[Err] /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
...
I can't list all the errors and relevant info, because there are 14,996 lines in the error log

Thanks for any help
MySQL: 5.1.56 (32-bit)
Navicat: 091 lite
DB: Revision 54 (with database_incremental.zip containing db_dump.sql)
OS: Win 7 Ult 64-bit
CPU: AMD Athlon II X3 440 (3ghz)
RAM: 6gb installed, 5gb usable
DB Source order: db_dump.sql, then load_player, then bots. Instructions haven't said to do things in any other order.
Server revision: 1975 (I know not most up to date, but should be a good base until I get it running). Compiled just fine via VC++ 2010 + Perl 5.12

[nosfentora]

Dunno what to tell you...

I just pulled rev 54, and using the console


create database test;
\u test
source peqdb_rev1751.sql;
source load_player.sql;
source load_bots.sql;
source db_dump.sql;
and it all sourced, no errors. using MySQL ver 5.1.51, 32bit.

Try deleting the database completely and creating it from scratch using the console only. I've had alot of problems in the past sourcing large files with NaviCat.

[kedobin]

I'll try that. If it still fails, I'll try and find another mysql version.

I successfully got rev 54 to source on my 32-bit win xp laptop running mysql 5.1.44. Unfortunately, I can't find the installer, so I'll either have to do more digging on my laptop, dig through google, or see whether the latest 5.1.x release would let me source it.

[lerxst2112]

I use a 5.0 version and have no trouble.

http://dev.mysql.com/downloads/mysql/5.0.html

[nosfentora]

Try dumping the db via the console on your laptop, then source that db.

[kedobin]

I tried all the suggestions, from using only the console, to dumping the laptop db and sourcing that source, to downgrading to 5.1.44, to downgrading to 5.0.92, but none worked.

What did work, however, was setting up xp-mode. I was able to install mysql onto it, then source the db onto this vm successfully. I've gotten the vm and the firewall to allow me to ping back and forth between the vm and the host, so it's only a matter of finishing the server setup and telling it where to look for the db.

Thanks for all the help and suggestions.