coping server to a new PC

[GRUMPY]

If you want to do it the easy manual way, it's simple. In a cmd window, cd.. to the
folder where you want to dump the database to. Then type this :
mysqldump --routines -u root -ppassword peqdbname > peqbackup.sql

Assuming you have created an empty sql database name on your new box, put the
backup in a folder on there somewhere, then do the following:
In a cmd window, cd.. to where the backup is and login to your sql.
(mysql -u root -ppassword) Then tell your sql to use the new empty database by
typing this : use newpeqname You will see a message "database changed".
Then simply type: source peqbackup.sql Then let it do it's thing, and you're done.

I've always had 0 problems doing it that way, compared to using 3rd party programs.

[lctucker2999]

I give up. I should just hop on the next short bus out of town.

I tried both ways. In HeidiSQL it somehow doesn't have enough memory to load a 322 mb database even though there's 8 gigs of ram.

Grumpy I tried doing it manually and I have no clue what it actually did... I used my empty database, typed in source etc. then it spend a few minutes doing some stuff (mostly giving me errors about duplicates) and when it was done, it was using peq instead of my new database. I double checked peq on the new system to see if maybe it copied over the data that was different but no such luck.

*edit 2* So it looks like some data WAS in fact copied over, but other data wasn't. For example characters were, but only some inventory items (244 rows vs 340 in the orig db). Looks like none of my custom NPC's or items made it over either.

Sorry I'm retarded but it's frustrating not really knowing what I'm doing.

*edit for typos*