MySQL Forums
Forum List  »  Backup

Re: Importing backups.
Posted by: erik theising
Date: May 04, 2016 04:39PM

I did another export, which was not self contained and it ddi show it used "InnoDB". This does not seem to go for self contained however.

"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."

I figured you were talking about memory the program can reserve, not actually machine resources available. I posted the system specs in my first post, so this was very confusing. I am very familiar with Windows OS, just not MySQL

innodb_buffer_pool_size=8M

I will try a backup that's not self contained to see if it makes any difference, the export was very quick. literally seconds.

Okay I just tried making another backup. not self contained and it went so fast I could barely see it happen.

However before I was able to make the backup I got a mismatch mysqldump error, which with help of the forums I fixed. Maybe this is why I got the issue to begin with. will make another backup tomorrow as it's quite late here :)

Options: ReplyQuote


Subject
Views
Written By
Posted
1799
May 04, 2016 07:46AM
1135
May 04, 2016 09:24AM
1224
May 04, 2016 11:57AM
1174
May 04, 2016 12:21PM
1000
May 04, 2016 12:22PM
1055
May 04, 2016 04:13PM
Re: Importing backups.
1201
May 04, 2016 04:39PM
1178
May 04, 2016 04:53PM
1070
May 04, 2016 05:02PM
1030
May 04, 2016 07:07PM
1859
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.