MySQL dump FAQ - How do I "dump" a MySQL database schema? (Also written as, "How do I make a MySQL database backup?")
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.