MySQL backup FAQ - How do I backup/dump a MySQL database schema?
Answer: Use the mysqldump database utility.
MySQL dump examples using the mysqldump utility
On a DOS/Windows pc with no name/password protection, you can dump a database named
my_db with the following command, but don't do this just yet:
Note that this gets you not only the database schema, but also the current data in the table.