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
1797
May 04, 2016 07:46AM
1134
May 04, 2016 09:24AM
1221
May 04, 2016 11:57AM
1170
May 04, 2016 12:21PM
996
May 04, 2016 12:22PM
Re: Importing backups.
1052
May 04, 2016 04:13PM
1199
May 04, 2016 04:39PM
1177
May 04, 2016 04:53PM
1068
May 04, 2016 05:02PM
1027
May 04, 2016 07:07PM
1856
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.