14 Feb

MySQL Console Database Backup/Dump and Restore via console

Backup a DB via console The backup/dump is performed using mysqldump, which takes the contents of the specified database and creates a set of “CREATE TABLE” and “INSERT INTO” SQL commands that can be used to re-create the database again. In short, the mysqldump tool is called like this: mysqldump –user [user] –password=[pass] [db] > […]