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
1566
May 04, 2016 07:46AM
1004
May 04, 2016 09:24AM
1067
May 04, 2016 11:57AM
979
May 04, 2016 12:21PM
880
May 04, 2016 12:22PM
Re: Importing backups.
925
May 04, 2016 04:13PM
1018
May 04, 2016 04:39PM
1011
May 04, 2016 04:53PM
920
May 04, 2016 05:02PM
905
May 04, 2016 07:07PM
1432
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.