Languages
Wiki
All Wiki Articles Create Wiki Article
administration
mysql
backup
database
db
linux
[Edit]
EN

MySQL - restore database from backup using Linux Command Line

2 contributors
7 contributions
0 discussions
8 points
Created by:
Root-ssh
104710

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 db_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 -pSecretPassword -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

MySQL - Problems

MySQL - Create or replace view
MySQL - Create table if not exists
MySQL - Create table with AUTO_INCREMENT field
MySQL - Create table with FOREIGN KEY
MySQL - Create table with JSON field
MySQL - Create view if not exist
MySQL - Drop table if exists
MySQL - Drop view if exists
MySQL - GROUP BY multiple columns
MySQL - Insert JSON type value to the table
MySQL - Insert NULL values
MySQL - Select from multiple tables (using JOIN)
MySQL - Select from view
MySQL - UPDATE query with LIMIT
MySQL - Update all rows
MySQL - Update multiple rows at once
MySQL - add FOREIGN KEY to existing table
MySQL - add column to existing table
MySQL - average value for grouped rows
MySQL - boolean data type
MySQL - calculate average of column values and display the result with no decimals
MySQL - check version from command line
MySQL - concatenate multiple columns into one
MySQL - concatenate multiple rows into one field
MySQL - convert value to CHAR (using CAST() function)
MySQL - convert value to CHAR (using CONVERT() function)
MySQL - count characters in string (CHAR_LENGTH())
MySQL - count distinct values
MySQL - count duplicated rows
MySQL - count rows with NULL values
MySQL - database backup using Linux Command Line
MySQL - delete all duplicated rows except one
MySQL - delete row where column is empty string (blank)
MySQL - delete row where column is null
MySQL - duplicate table
MySQL - find all tables with specific column names
MySQL - find duplicated values
MySQL - find duplicated values in multiple columns
MySQL - find first row
MySQL - find row with null value in column
MySQL - find row with null value in one of many columns
MySQL - find rows where column is empty string (blank)
MySQL - get difference between two columns
MySQL - get size of every table in database (in MB)
MySQL - get table size (in MB)
MySQL - how to check database size?
MySQL - how to check existing table engine? (HeidiSQL example)
MySQL - make column values unique
MySQL - max value for grouped rows
MySQL - minimum value for grouped rows
MySQL - numeric data types
MySQL - restore database from backup using Linux Command Line
MySQL - search for NULL values in multiple columns
MySQL - select first N rows
MySQL - select last N rows
MySQL - select last row
MySQL - select rows with max value of column
MySQL - set root password
MySQL - sort in ascending or descending order
MySQL - sum value for grouped rows
MySql - get row position with SELECT query
MySql - insert data from one table to another
Mysql - create new column with index on existing database table with data
Native Advertising
🚀
Get your tech brand or product in front of software developers.
For more information Contact us
Dirask - we help you to
solve coding problems.
Ask question.

❤️💻 🙂

Join