exporting MySQL database

[Syngin]

Once I log into MySQL, how do I export a database (tables and all) to a comma delimited text file? I'm a little confused on the necessary paths since the MySQL server is a dedicated machine.

I just want to make sure I back things up as recommened in your FAQs. ALso, the import command sting would be helpful too.

Thanks.

[Bob]

Hello,

Have you viewed these two Aota Tutorials?

http://www.aota.net/PHP_and_MySQL/mysqldump.php4
http://www.aota.net/PHP_and_MySQL/mysqlbackup.php3

The first explains how to do a "dump" or backup of your MySQL data and the second explains the "restore" procedure on the FutureQuest servers.

These also contain the correct command strings for these procedures.

Hope this helps,
Bob