Export & Import MySQL Database

From Gejoreuy
Jump to navigation Jump to search


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/


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