Exporting Data in MySQL
The MySQL terminal provides a simple way to export data in SQL format using the following command:
mysqldump -u [username] -p [database name] > [file name].sql
For example, to export the database katra
using the username app__db_user
, you would use the following command, mydb_backup.sql
will be your backup file of database katra
After running this command it will prompt you for your Mysql user app_db_user
password
mysqldump -u app__db_user -p katra > mydb_backup.sql
Importing Data in MySQL
The following command can be used to import an SQL file:
mysql -u [username] -p [database name] < [file name].sql
For example, to import the "mydb_backup.sql" file using the username app_db_user
, and the database mydb
you would use the following command: we can also define host option -h if you are using hosted Database
mysql -u root -p mydb < mydb_backup.sql
Note: For importing to Database please make sure the user you are using has access