Importing MySQL Databases?

[Thomas]

I'm currently importing my forum database to a new server (moving hosts) and its been 'importing' for the past 2 hours or so? The database is 2.1MB big, how long should it take?

[Tom]

If it's 2.1mb it should have been done long ago.

[Chippiewill]

I suggest restarting the import. May I ask which method you're using to import?

[Tom]

I suggest restarting the import. May I ask which method you're using to import?

I would imagine he's importing it on PMA (Clicking Import etc.)

[Chippiewill]

Well, I could assume that, but it's possible he's using the run sql box (Which I've found tends to run better).

[Thomas]

I suggest restarting the import. May I ask which method you're using to import?im using the import option on phpmyadmin

[Chippiewill]

If your database is in the form of a zip file try extracting it and importing the files inside individually

[Vinnie:Safety]

go to cotonti tutorials on youtube, they have one video on uploading my sql

[triston220]

Try running the contents of the SQL file as a query.