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
1705
May 04, 2016 07:46AM
1093
May 04, 2016 09:24AM
1162
May 04, 2016 11:57AM
1087
May 04, 2016 12:21PM
949
May 04, 2016 12:22PM
1006
May 04, 2016 04:13PM
Re: Importing backups.
1143
May 04, 2016 04:39PM
1116
May 04, 2016 04:53PM
1013
May 04, 2016 05:02PM
977
May 04, 2016 07:07PM
1737
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.