Difference between revisions of "Export & Import MySQL Database"

From Gejoreuy
Jump to navigation Jump to search
Line 1: Line 1:
 
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/
 +
 +
<br>Just run below command and change it with the database value.
 +
  root@gejoreuy ~]# mysqldump -u username -h hostname -p databasename > /directorylocation/filename.sql

Revision as of 19:13, 20 February 2020

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/


Just run below command and change it with the database value.

  root@gejoreuy ~]# mysqldump -u username -h hostname -p databasename > /directorylocation/filename.sql