Is it normal to import 1.5g sql file and take 11+hours?

I am not sure if it is normal for this to take long... I understand it is a huge file 1g++ worth of data.

I used :

    mysql> source myfilename.sql;  

Code (markup):

to import the database. It is taking like forever though... This is in wampp, I used the mysql.exe to import.

 

i don't think so, ofcourse 1 GB is big but it doesn't take that long ( 11 hours )

 

Oh I forgot to mention this is an sql.gz file, will that make a difference? (sorry the code above I copied from a tutorial)

It should be

    mysql> source myfilename.sql.gz;

Code (markup):

 

My guess is that it timed out about 10 hours and 50 minutes earlier and just got hung there.

 

There is no error message or timeout message, just:
"Query OK, 1 row affected <0.5 sec>"

This message repeats over and over and over ... with varying secs of course.

I don't understand why it won't stop, I've checked the size of the db and the records seem to increase, then decrease... and stops in that range then repeat. What is going on? Is it possible to loop like that?

 

Really depends on your server speed ! Th, yes - it's possible .. just watch out of "Timed out" msg

 

It's not normal, since most sql files are under 1mb for most small - medium sites. The only way you'd have a gig (IMHO) would be if you owned a site like http://earn3.com/ or bigger. ( Probably Alot Bigger )