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

MySQL - database backup using Linux Command Line

2 contributors
7 contributions
0 discussions
4 points
Created by:
Root-ssh
91240

In this short article we would like to show how to make MySQL database baskup using Linux Terminal (command line).

Quick solution:

mysqldump -u db_username -pdb_password -h db_hostname db_name > /path/to/backup.sql

Notes:

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

 

Practical examples

Example 1:

mysqldump -u root -pSecretPassword -h 127.0.0.1 gallery > ./2020_09_12_17_21_gallery.sql

Example 2:

/usr/bin/mysqldump -u 'root' -p'SecretPa$$word' -h '127.0.0.1' 'gallery' > '/path/to/backup/db/2020_09_12_17:21_gallery.sql'

Where:

  • MySQL server is installed on same machine, so we can use 127.0.0.1 host address,
  • we used root account because of allowsed access to any database on server,
  • putting parameters to apostrophes allows us to use any characters.

See also

  1. MySQL - restore database from backup using Linux Command Line

MySQL

MySQL - AND, OR, NOT operators
MySQL - AVG() function example
MySQL - Aliases
MySQL - BETWEEN clause
MySQL - CASE statement
MySQL - COUNT() function example
MySQL - Comments
MySQL - Create database
MySQL - Create table
MySQL - Create table if not exists
MySQL - Create view
MySQL - Create view if not exist
MySQL - Delete query
MySQL - Drop database
MySQL - Drop table
MySQL - Drop table if exists
MySQL - Drop view
MySQL - Drop view if exists
MySQL - GROUP BY statement
MySQL - INSERT INTO statement
MySQL - JOIN list + SQL Query
MySQL - LIKE operator
MySQL - LIMIT clause
MySQL - LOWER() function example
MySQL - MAX() function example
MySQL - MIN() function example
MySQL - ORDER BY clause
MySQL - SELECT DISTINCT statement
MySQL - SUM() function example
MySQL - Select query
MySQL - UPPER() function example
MySQL - Update statement
MySQL - WHERE clause
MySQL - boolean data type
MySQL - check database size
MySQL - check version from command line
MySQL - convert unix timestamp to datetime
MySQL - create new column with index on existing database table with data
MySQL - database backup using Linux Command Line
MySQL - delete row where column is empty string
MySQL - delete row where column is null
MySQL - get row position with SELECT query
MySQL - group rows by days
MySQL - group rows by months
MySQL - insert data from one table to another
MySQL - numeric data types
MySQL - restore database from backup using Linux Command Line
MySQL - select rows with dates between
MySQL - set root password
MySQL - subtract days from current date
Native Advertising
🚀
Get your tech brand or product in front of software developers.
For more information Contact us
Posts you may like
Dirask - we help you to
solve coding problems.
Ask question.

❤️💻 🙂

Join