How to Export MySQL Database

[Anon]

Hi,

Could anyone tell me how to export a local mysql database onto a server where another Mysql server is running.

In the Case of MS-SQL SErver we have Import/Export Wizard ,Do we have any equivalent wizard or command in MYsql.

bye
shankar

[adrianl]

to "export", type:

mysqldump -u<username> -p<your_password> <database_name> > output_file

eg. username=dolphin, password=passwd, database_name=whale, I would type:

mysqldump -udolphin -ppasswd whale > whaleDB.sql

Then, to "import", type the following:

mysql -udolphin -ppasswd whale < whaleDB.sql