MySQL Forums
Forum List  »  Backup

Importing backups.
Posted by: erik theising
Date: May 04, 2016 07:46AM

Hello,

I run a small minecraft community and therefor use mysql (most used for this game). And with running communities I need backups etc,

Now the issue I have is that importing files is extremely slow. Importing a self contained file takes an insane amount of time. 4.4GB file is running for over 4 hours as I speak.

now you may think it's a slow internet connection, but I don't use a network for this. The file is already on the machine. This is no slow machine either, it's dedicated to do very low amount of things, and mysql does not seem to do anything as it's averaging 0.1% cpu usage. Disk (SSD) usage is a bit higher peaking at about 50 MB a second.

I do use mysql workbench on a Windows machine, with an Intel SSD and 32GB, CPU Intel e3 1270v3

Is there any reason this is taking such an insane long amount of time?

Please be easy on me, I just do this to provide kids a good time for free without any real knowledge of mysql :)

Options: ReplyQuote


Subject
Views
Written By
Posted
Importing backups.
1874
May 04, 2016 07:46AM
1155
May 04, 2016 09:24AM
1265
May 04, 2016 11:57AM
1212
May 04, 2016 12:21PM
1026
May 04, 2016 12:22PM
1082
May 04, 2016 04:13PM
1225
May 04, 2016 04:39PM
1204
May 04, 2016 04:53PM
1106
May 04, 2016 05:02PM
1062
May 04, 2016 07:07PM
1936
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.