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
1880
May 04, 2016 07:46AM
1156
May 04, 2016 09:24AM
1268
May 04, 2016 11:57AM
1214
May 04, 2016 12:21PM
1027
May 04, 2016 12:22PM
1083
May 04, 2016 04:13PM
Re: Importing backups.
1226
May 04, 2016 04:39PM
1205
May 04, 2016 04:53PM
1108
May 04, 2016 05:02PM
1063
May 04, 2016 07:07PM
1937
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.