If you look at the 'text' file you created with the 'dump', you'll see that
it contains all of the 'SQL commands' to recreate the tables and 'insert' the
data you've extracted.
So you simply type:
mysql mydbf_db < /mydir/mydbf.backup
(you might have to insert/add the -u and a username and
Don Pro writes:
>Hi,
>
>I back up my entire database with the following command:
>
>mysqldump --opt -p"password" mydbf_db > /mydir/mydbf.backup
I've got:
mysqldump -h mysql.io.com -u "user" -p --opt "database" >! backup-file.sql
mysql -h mysql.io.com -u "user" -p "database" < backup-f
Hi,
I back up my entire database with the following command:
mysqldump --opt -p"password" mydbf_db > /mydir/mydbf.backup
Does anyone know the counterpart command to restore from the backup
file?
Thanks,
Don
-
Before posting,
