MySQL Forums
Forum List  »  Backup

Reload of sql dump file failed
Posted by: Damien Mulcahy
Date: May 04, 2017 05:33AM

Hi,

I created a SQL dump using "mysqldump --all-databases --add-drop-database" and transferred it to a backup server. When I tried to import it using the mysql command it failed during the drop of the "mysql" schema leaving that schema empty. Before I could recreate it the mysqld process failed and now it won't start up again as it says it needs the mysql.priv table to start up.

How can I recover from this?

I am using MySQL 5.5.23 on RedHat Linux 6.

Thanks,
Damien.

Options: ReplyQuote


Subject
Views
Written By
Posted
Reload of sql dump file failed
1451
May 04, 2017 05:33AM


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.