Languages

administration

mysql

backup

database

linux

1 more ...

[Edit]

MySQL - database backup using Linux Command Line

2 contributors

7 contributions

0 discussions

19 points

Created by:

Root-ssh

121330

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

Quick solution:

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

or:

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 the same machine, so we can use 127.0.0.1 host address,
we used root account that has access to any database on the server,
putting parameters to apostrophes allows us to use any characters.

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