MySQL Forums
Forum List  »  MySQL Administrator

Re: Problem restoring backup
Posted by: Barry Galbraith
Date: July 26, 2009 04:21PM


Backup recovery is covered in the Reference Manual Sect 6.2.2.

Basically, you use mysql command line client to run the backup sql file.

shell> mysql -u<user> -p<password> < <backupfile>

Example for user root, password is password, file is backup.sql

mysql -uroot -ppassword < backup.sql

If you have the user name and the password stored in the [client] section of the my.ini file, you don't need them here.

Storing the user and password in the ini file is not recommended.

See the Reference manual for full details.

Good Luck.

Options: ReplyQuote

Written By
July 26, 2009 02:52PM
Re: Problem restoring backup
July 26, 2009 04:21PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.