Copy db to remote mysql

[andreash]

I have a mySQL database filled with different tables and data.
Now I have to move to another server, and therefor I ask If there
is anyway that I could copy the mySQL data to the new server.

The new server runs mySQL just as the old one.
Thanx in advance!

[Anon]

You can use the mysqldump program.

Use it from the command line like:
mysqldump --opt dbname table > somefile.out

you also can leave out the table name if you want the whole db.

then copy the output file over to the new machine, create the databases and run

mysql dbname < somefile.out

you may also have to specify the username and/or passwords to run those commands...

-Jeff

[mhowey]

This resource would probably answer that question:

http://www.mysql.com/doc/m/y/mysqldump.html

Utility to dump a database or a collection of database for backup or for transferring the data to another SQL server (not necessarily a MySQL server). The dump will contain SQL statements to create the table and/or populate the table.

shell> mysqldump [OPTIONS] database [tables]

OR mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...]

OR mysqldump [OPTIONS] --all-databases [OPTIONS]

[andreash]

It doesn't seem to be working for me. I get syntax error.

You have an error in your SQL syntax near 'mysqldump --opt forum_i > fil.sql' at line 1

By the line:

mysqldump --opt forum_i > fil.sql

Can you help?

[Anon]

You must execute this from the command line, NOT within your mysql client.

-Jeff