Languages
[Edit]
EN

MySQL - restore database from backup using Linux Command Line

5 points
Created by:
Root-ssh
6871

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 -h db_hostname db_name

Notes:

  • do not use space beetween -p and password,
  • -h db_hostname is optional (lack means localhost connection).

Practical examples

Example 1:

cat ./2020_09_12_17_21_gallery.sql | mysql -u root -pEwcrtat318jkD -h 127.0.0.1 gallery

Example 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

See also

  1. MySQL - database backup from Linux Command Line
Hey 👋
Would you like to know what we do?
  • Dirask is a friendly IT community for learners, professionals and hobbyists to share their knowledge and help each other in extraordinary easy way.
  • We welcome everyone,
    no matter what the experience,
    no matter how basic the question is,
    this community will help you.