MYSQL - Backup database to a file

The mysqldump utility will allow you to backup your entire database to a file (tables definitions, relationships and data). The following statement will extract the tablenamehere definition to a file called test.sql...

Code Snippet

1. mysqldump -u root -p tablenamehere > test.sql

End of Code Snippet