EQEmulator Forums - database source errors

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:

Code:

[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