Difference between revisions of "Export & Import MySQL Database"
Jump to navigation
Jump to search
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | == Source == | ||
| + | |||
Export & import Dump File : https://www.alibabacloud.com/help/doc-detail/26133.htm | Export & import Dump File : https://www.alibabacloud.com/help/doc-detail/26133.htm | ||
<br>Select database in MySQL : https://www.liquidweb.com/kb/select-a-mysql-database-on-linux-via-command-line/ | <br>Select database in MySQL : https://www.liquidweb.com/kb/select-a-mysql-database-on-linux-via-command-line/ | ||
| + | |||
| + | == Purpose == | ||
| + | |||
| + | This topic describes how to use the mysqldump command to backup the MySQL database to a dump file. | ||
| + | |||
| + | == Export the Dump File == | ||
| + | |||
| + | Just run below command and change it with the database value. | ||
| + | root@gejoreuy ~]# mysqldump -u username -h hostname -p databasename > /directorylocation/filename.sql | ||
Latest revision as of 19:15, 20 February 2020
Source
Export & import Dump File : https://www.alibabacloud.com/help/doc-detail/26133.htm
Select database in MySQL : https://www.liquidweb.com/kb/select-a-mysql-database-on-linux-via-command-line/
Purpose
This topic describes how to use the mysqldump command to backup the MySQL database to a dump file.
Export the Dump File
Just run below command and change it with the database value.
root@gejoreuy ~]# mysqldump -u username -h hostname -p databasename > /directorylocation/filename.sql
