[HELP] Importing DB - 89 hours and running?

[мιяаgє]

Hey guys,
I did a backup a few weeks back (just of my server db)
and I am now importing it because we lost all our data.
But... it has been running for 89 hours STRAIGHT, uninterupted... its at abvout 800000 queries... how much longer will this go on?
It's driving me crazy.

--Ill--

[2dgreengiant]

Do the querys still go up or have they stopped?

[мιяаgє]

They are still going up, at about 2 per second... x.x
If I were to load in, lets say, Chrispee DB, it would take like 2 minutes, but how come this backup seems like its going to take months?

[2dgreengiant]

How big is your file size like is it 100mb? Also what did you use to export it such as Navicat or SQLyog.

[мιяаgє]

We used Navicat to export it, and we are using Navicat to import it, and it is only 12 MB lol...
It only has a couple customt hings too, I don't understand why it's taking sol ong.

[2dgreengiant]

Try using SQLyog just to see as thats good for importing.

[мιяаgє]

But I don't want to cancell this one - it's been running for so long, and well, what If I gotta start all over again? X.X.X

[Cursed]

What are you asking for then?

[мιяаgє]

I'm wondering if this usually happens.

[SectorSeven]

Not really, use an Importer Tool. It doesn't put as much pressure on the MySQL Server. Instead of 1 hour import (normally), I have a 2 minute import.

[мιяаgє]

Where can I find one of these 'Importer Tools' ?

[Bapesy]

I think he means a .bat Importer Tool like whyDB has.

Bapes