This is what you're looking for:
BigDump: The Staggered MySQL Dump Importer
I wonder when the hell phpmyadmin will start handling imports properly...
I have done this kinda things earlier when I changed my server to a new one.
Again, I'm in a similar situation. I tried to upload the backup file by entering phpmyadmin and then issuing the import command. But as always it returns some error. Ahh, I don't use import function for the same reason - earlier i used - some utility to restore - if i remember it correctly- it was a php file and i had to upload it to my server - I had to enter db details, destination sql file details etc in that php file - and things went fine that time - i was able to restore a big sql dump file. But I just don't remember that things name - also this time the file is just 3.5 mb in size ---- I have the file in my server - so i think there would be some way to store it to the right place from the server itself - i mean is there any need to download to my pc again ? anyways its in the server only - there is a need to just do some importing - actually its a .sql file - and some sql commands have to be run - thats all.
Anyone pls come up with some ideas....
intelli (8 July, 2009)
Yup, that is what I was looking for.
Thanks Shenron. You deserve a "thanks"
I have never had a problem moving large SQL files.
3.5mb is not very large. I wonder if you are running into the compatibility issue with different versions of MySQL.
Are you using an old version of MySQL on one of the servers? If remember correctly, some of the file parameters changed around version 4.1.
I once had a problem restoring an old SQL file and I had to manually change some of the parameters in the SQL file to get past the errors. The errors were coming from some of the MySQL parameters tagged on to the end of the CREATE TABLE command.
"Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote." -- Benjamin Franklin