Importing backups.

[erik theising]

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 :)