MySQL Forums
Forum List  »  Backup

Re: Importing backups.
Posted by: Peter Brawley
Date: May 04, 2016 04:13PM

The dump file will show what engine the tables use---in each Create Table command.

If you're running MySQL processes, especially one that take hours, you need to get familiar with the resources you have (eg Task Manager for memory available once all relevant software is running, File Explorer for disk space remaining, my.ini buffer settings), and the resources you need.

If the tables use the defaukt engine, that's InnoDB. So, what is the innodb_buffer_pool_size setting in my.ini?

Options: ReplyQuote


Subject
Views
Written By
Posted
1733
May 04, 2016 07:46AM
1108
May 04, 2016 09:24AM
1185
May 04, 2016 11:57AM
1108
May 04, 2016 12:21PM
970
May 04, 2016 12:22PM
Re: Importing backups.
1024
May 04, 2016 04:13PM
1167
May 04, 2016 04:39PM
1138
May 04, 2016 04:53PM
1032
May 04, 2016 05:02PM
996
May 04, 2016 07:07PM
1777
June 04, 2016 05:38AM


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.