Large SQL file import via mySQL

J

jezzad

Expert Member
Joined
Jan 2, 2013
Messages
1,605
Reaction score
784
A client sent me an old backup of their original Wordpress site and they would like me to set it up on a staging environment.

Files are moved over but the SQL file is 900mb in size. Too big for a mySQL import so I tried using a php script to import it and am getting the following error:

Unknown system variable 'SQL_REQUIRE_PRIMARY_KEY'

Researching online suggests setting this to “0” in the SQL dump. I have tried this and it is not working.

Im trying to import this to a shared server on Xneelo

If anyone is able to assist I would be happy to pay for your time to get this resolved.
 
Can this help link something about database version.

Can you import it on your local box?
 
Last edited:
jezzad said:
A client sent me an old backup of their original Wordpress site and they would like me to set it up on a staging environment.

Files are moved over but the SQL file is 900mb in size. Too big for a mySQL import so I tried using a php script to import it and am getting the following error:

Unknown system variable 'SQL_REQUIRE_PRIMARY_KEY'

Researching online suggests setting this to “0” in the SQL dump. I have tried this and it is not working.

Im trying to import this to a shared server on Xneelo

If anyone is able to assist I would be happy to pay for your time to get this resolved.
Click to expand...
What do you mean 900mb is too big for a mySQL import?

I suspect what you mean to say, is that you're doing the import via cPanel or myphpadmin? and that the upload limit is too small? If so just raise it and import it again.

There's no reason mysql itself should have an issue with a 900mb file. Especially if you're doing a mysql import via the cli.
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X