MySQL Forums
Forum List  »  InnoDB

Mysqldump and innodb
Posted by: Dimitrios Panagiwtidis
Date: June 05, 2009 10:55AM

Hi to all...

i had a backup of rather large database using mysqldump...

the "problem" is that is takes so long to restore the data from sql file....
my "new" personal database is a pc with 4gb ram.. i use innodb by default...
one of the sql files is 2gb. can i make some adjustments in key buffer etc so the restoration can complete more quicker...

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysqldump and innodb
4832
June 05, 2009 10:55AM
2618
June 08, 2009 05:19AM
1735
June 28, 2009 04:55PM


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.