Mysql - Mysqldump backup and restore data, Export and Import mysql database
Mysqldump backup and restore data
To backup a database named 'tutorials_DB' with the username 'root' and with no password to a file tut_backup.sql, you should accomplish this command:
mysqldump -u root -p tutorials_DB > tut_backup.sql
If you are moving your data to a new server, or you have removed the old database completely you can restore it using the code below. This will only work if the database does not already exist:
mysql -u user_name -p mysql_password database_name < file_name.sqlOr using our example from the previous page:
mysql -u root -p your_password LoveData < LoveData.sqlIf your database already exists and you are just restoring it, try this line instead:
mysqlimport -u user_name -p your_password database_name file_name.sqlOr using our example again:
mysqlimport -u root -p your_password Love_Restore Love_Backup.sql
The topic on Mysql - Mysqldump backup and restore data is posted by - Math
Hope you have enjoyed, Mysql - Mysqldump backup and restore dataThanks for your time