Re: Restoring a backup

Not usre if anyone answered your question yet, but, first off, I'm not positive. I would try............ mysql -u root -p !database_name! < !filename! ignore the (!) characters. :) paul Don wrote: > > Hi, > > I have a cron script that issues a: > > mysqldump --opt -p"password" myfile_db /home/ftpadmin/pub/myfile_db.backup > > Now, I wish to do the opposite, that is, restore it into my database. After > issuing a: > > mysql -p > > and entering the password, what command do I enter to restore my database > from the backup file?