Copy MySQL database

lynchie wrote:

mysqldump -u <username> -p <database name> > backup.sql

Then on machine at home..

mysqladmin -u <username> -p create <database name>

then mysql -u <username> -p <database name> < backup.sql

Ok, so if my username is root, password is pass, the database name is data would i do this:

1. Open command prompt
2. Type: mysqldump -u root -p pass data > backup.sql

All on one line? Should I specify a place to put backup.sql? (i.e. C:\backup.sql)?

Then do the reverse on second machine?

1. Open command prompt
2: Type: mysqladmin -u root -p pass create data
3: mysql -u root -p pass data < backup.sql

All on one line? Should I specify where backup.sql is? (i.e. F:\backup.sql)?

Sorry for all questions, i'm rubbish at using command prompt and stuff...

Edit: I presume this won't delete the original db, will it?

Never realised that MySQL administrator could do that... (it's kinda obvious now that it would)

Did a test moving from comp. to laptop @ work, worked a treat... Cheers lads!