EN
MySQL - restore database from backup using Linux Command Line
23
points
In this short article we would like to show how to make MySQL database baskup using Linux Terminal (command line).
Quick solution:
cat /path/to/backup.sql | mysql -u db_username -pdb_password db_nameor:
cat /path/to/backup.sql | mysql -u db_username -pdb_password -h db_hostname db_nameNotes:
- do not use space beetween
-panddb_password,-h db_hostnameis optional (lack meanslocalhostconnection).
Practical examples
Example 1:
cat ./2020_09_12_17_21_gallery.sql | mysql -u root -pSecretPassword -h 127.0.0.1 galleryExample 2:
cat '/path/to/backup/db/2020_09_12_17_21_gallery.sql' | mysql -u 'root' -p'SecretPa$$word' -h '127.0.0.1' 'gallery'Secure command example
Calling command with password as parameter is not save because is visible as process and stays in command history.
We can type password in program with:
cat /path/to/backup.sql | mysql -u db_username --password db_name