Back Up MySQL Databases From The Command Line

Dec 17, 2020    Janaki Mahapatra, Database

mysqldump command in mysql helps to create textfile dumps of databases. here is few commands to do in commandline Single Database backup:

mysqldump –u[user name] –p[password]  database_name > database_name.sql

Multiple Database backup:

mysqldump –u[user name] –p[password]  database_one database_two > dumpdatabases.sql

All Database backup:

mysqldump –u[user name] –p[password] -all-databases > all_databases.sql

Restoring from Database backup:

mysql –u[user name] –p[password] database_name < database_name.sql

To restore a single database from dump of all the database

mysql –u[user name] –p[password] -one-database database_name < all_databases.sql