MySQL Forums
Forum List  »  Backup

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


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

Written By
Importing backups.
May 04, 2016 07:46AM
May 04, 2016 09:24AM
May 04, 2016 11:57AM
May 04, 2016 12:21PM
May 04, 2016 12:22PM
May 04, 2016 04:13PM
May 04, 2016 04:39PM
May 04, 2016 04:53PM
May 04, 2016 05:02PM
May 04, 2016 07:07PM
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.