How to Back Up MySQL Databases From The Command Line
While automated backups are important, sometimes you just want to take a quick and dirty snapshot before making a change to your data. When changing files in Linux, you can simply cp a file to another name, and cp it back if your change does not workout. With MySQL, it is not quite that simple, but it is by no means difficult. Creating A Backup The mysqldump command is used to create textfile “dumps” of databases managed by MySQL. These dumps are just files with all the SQL commands needed to recreate the database from scratch. The process is quick and easy. If you want to back up a single database , you merely create the dump and send the output into a file, like so: mysqldump database_name > database_name.sql Multiple databases can be backed up at the same time: mysqldump --databases database_one database_two > two_databases.sql In the code above, database_one is the name of the first datab...
