Restore MySQL database with MySQLdump (from the command line)

preview_player
Показать описание
Quickly restore a MySQL database backup from the command line, using mysqldump

MySQL database backups are important, but so is being able to quickly restore a database backup. All from the command line using `mysqldump`.

How to backup a MySQL database:

Read the full article here:
Рекомендации по теме
Комментарии
Автор

this is the best tutorial that i have been watched for this (MySQLdump) its very simple, very clear, very professional, thanks a lot! Keep going what you do!

Ameer
Автор

Thank you for the video, I have a question please, let me explain my problem :
I am in a test mode before production.
I have A machine with database, B machine for back up
I created the dump file of the data from A
Do I need to delete the table from B to restore ? because using this method I am not able to update the records on B from added records on A after running the command.
both A and B are local machines ( Ubuntu hosted on windows for A, Mac for B)
No errors I am seeing when I give the command in B machine to restore yet I cannot see the added records..!

photozen