transfering server from one PC to another

[jimbox114]

I have been attempting to move my server from this PC to my newly built server pc. Problem I am having is moving the database. I didn't think it would work, but my first try was to just install mysql normally, then overwrite it with the one on my PC. Needless to say that didn't work.

So the next thing I tried was to install mysql normally on it, then create the database (eq2) then copy my files into that directory from the database, apparently that didn't work either.

So what would be the easiest way to do this? I imagine I need to make a .sql file of my database and transfer it over? Problem is I can't figure out how to do that. I have searched through the search on this site, looked over the help files with mysql, and did not see anything about this.

So basically can anybody tell me how to take my database and zip it up into a .sql file? I imagine there is some command you do this from in mysql, but heck if I know what it is.

[sotonin]

mysqldump -u user -p database > database.sql

backs up an entire database.

then on new machine

CREATE database newdb;

use newdb;

source database.sql

[jimbox114]

Thanks, that did it.

[samandhi]

Dont forget to GRANT ALL PRIVILEGES on the new server DB.... Could have some problems if not...