MySQL Forums
Forum List  »  MySQL Administrator

Re: Restore of Small Database Taking Way Too Long
Posted by: Josh McCullough
Date: March 10, 2010 05:15PM

FYI, I've worked around this. I was restoring a Mantis database with about 20MB in the table that stores attachments. I removed the inserts to this table from the script and the restore was nice and fast. I then took those inserts and put them in a seperate file and used the command line to run the script on the database, this was also super quick.

In closing, there is some issue with the restore utility where it either doesn't like long lines of text or doesn't like large blocks of data.

Options: ReplyQuote

Written By
Re: Restore of Small Database Taking Way Too Long
March 10, 2010 05:15PM

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.