Export & Import MySQL Database
Jump to navigation
Jump to search
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