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 -p to the command...)
Don Pro wrote:
> 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
>
>
