Cannot upload SQL Data

[pasacom]

Well, I moved here from another site who used cPanel. I was able to get a backup of my files and databases. Since I have 8,000 members on the site I run, the SQL databases are obviously very big. 3,623KB big.

So, I try to upload the SQL file via phpMyAdmin and I always get an error like so:

Fatal error: Maximum execution time of 300 seconds exceeded in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/import/sql.php on line 118

There is a LOT of text in the database file and I do not know how to upload the content to the SQL server. I'm stumped. and confused and frustrated and really need my site to be up again, otherwise traffic dives.

Can someone help me out? Could one of the admins upload the file for me? They shouldn't have a 300 second limit for SQL queries.

Thanks for any and all help

 

[Synkc]

Have you tried dividing up the sql file into sections and importing each one separately, instead of trying to import the entire file at once?

 

[pasacom]

I tried that but there is one specific table called "users" and that's the tricky part. Everything else is easy to slice, dice, and insert into the database, but I can't, or don't know how, to cut up a table. My users table has over 8,000 rows and each row contains at least 15 options within them (e.g. username, display name, password, IP, etc.)

I've tried importing just the users table by itself, but have failed at that as well and received the same error message. Any suggestions?

 

[Bryon]

Divide the file up into multiple smaller parts and run each one individually. With a few small exceptions, most SQL queries should be able to be run individually, so it really does not matter where you split it up, as long as you run them in the correct order (top -> bottom).

To 'cut up' the 'user' table, just cut/go down it like 1/4th of the way and run that in PHPMyAdmin, do the next 1/4th, etc etc.

 

[pasacom]

Divide the file up into multiple smaller parts and run each one individually. With a few small exceptions, most SQL queries should be able to be run individually, so it really does not matter where you split it up, as long as you run them in the correct order (top -> bottom).

To 'cut up' the 'user' table, just cut/go down it like 1/4th of the way and run that in PHPMyAdmin, do the next 1/4th, etc etc.

I tried to cut up the table as you said, but I keep on getting SQL errors. There should be nothing wrong with the whole query. It was generated by cPanel itself (cPanel 11 on my old host).

So I've failed to cut it up. I've attached a document with the query for the creation of table "e107_users" and the insertion of the data into that table.

Can somebody take a look at that and tell me what's wrong or where I should chop it up?

Thanks

The attachment is clean:
http://www.virustotal.com/analisis/6c8290ea4793a5538b71b1b25720f8c5

 

[pasacom]

Can anyone help?