Exporting mySQL tables?

[furious5]

I recently cset mysql up at home and have created a specific database with a number of tables and data which I would now like to transfer to a server with mySQL installed.

Anyone know how I can go about exporting the information and importing it on to the other machine?

 

[sleipnir214]

One way is to use mysqldump to export the database to a set of SQL statements.

Then run that set of SQL statements against the server.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!