administration

mysql

backup

database

linux

[Edit]

MySQL - restore database from backup using Linux Command Line

2 contributors

7 contributions

0 discussions

23 points

Created by:

Root-ssh

175400

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_name

or:

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

Calling command with password as parameter is not save. It makes the password visible on processes list and stays in command line history.

So, it is good to use --password option and type password when mysql command requests it, by:

cat /path/to/backup.sql | mysql -u db_username --password db_name

Alternative titles

Donate to Dirask

Our content is created by volunteers - like Wikipedia. If you think, the things we do are good, donate us. Thanks!

Direct link

Join to our subscribers to be up to date with content, news and offers.

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