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.
1577
May 04, 2016 07:46AM
1016
May 04, 2016 09:24AM
1073
May 04, 2016 11:57AM
989
May 04, 2016 12:21PM
889
May 04, 2016 12:22PM
933
May 04, 2016 04:13PM
1034
May 04, 2016 04:39PM
1021
May 04, 2016 04:53PM
928
May 04, 2016 05:02PM
910
May 04, 2016 07:07PM
1463
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.