How do I upload a 40 MB SQL dump file using phpmyadmin

I have been mostly using MSSQL but now I am shifting to MySQl. The problem I am facing now is to upload a 40 MB SQL dump file onto my godaddy shared hosting account. They have phpadmin through which I can upload the files. But the max file limit is set to 2MB only. How have you guys been doing?

Thanks for looking

 

You can contact hosting company after uploading it via ftp

 

I have never tried it with phpMyAdmin, but what I think could be a solution:
1. Using phpMyAdmin, export the database into a SQL file (Check the 'Save as file' checkbox while exporting the database.)
2. Create a password protected directory on your server.
3. Now upload a PHP file to the same directory and disable its execution time out. Load the SQL statements from the SQL file and let the PHP script execute as a query.
4. Once the database is imported delete the SQL file!

I have not tested this method, but I think this should work smoothly. Do let me know if youa re able to do it this way.

 

as issue is about file size and limitation, you will have to contact your hosting provider for the solution! may be you have to pay some extra amount to resolve the space issue

 

Or you can use an client side app like SqlYOG - and load it that way.
You establish a connection between the client and DB - then just load the file - it processes it on your local box and applies it to the database. Ive been able to load dumps over 2gig that way with no problems.
You just may need to make sure you can access the db from outside - I know a lot of hosting companies lock it down to only allow localhost.

 

Or you can just cut the file into 2MB sections.

 

Or you can contact me and I'll do it in 5 minutes.
I never ever use phpmyadmin for large files.

 

u can use this tool :

http://www.ozerov.de/bigdump.zip

Code (markup):

is very good and easy to use
it will upload large databases , u first need to upload ur database to the ftp host and then that tool and setup in it database details and then runn tool from browser ! And in few - sec , minutes will be redy !

 

My suggestion is also Bigdump
The homepage of Bigdump is http://www.ozerov.de/bigdump.php

 

Thank you for all the suggestion guys. I am checking out bigdump . Hope It gets the work done

 

bigdump gets the job done, did a while ago a database of joy-scape.com that was 4.3 GB in size, no problem at all for a 40 MB sql file.

Peter

 

My friends use bigdump even for importing small databases, that thingy is easier and faster that get into your phpMyAdmin and all the other stuff so I'm with those who pointed at bigdump tough I personally haven't used it on my sites... my friends helping to do this job

 

Hi ,

It is as easy as you can say ... upload file in a folder then write a php script to read that file in a variable .... after that run mysql_query($variable);

every thing in that file will go to database

Thanks

 

The easiest way is to ask GoDaddy to do it for you - in my experience with them, they will handle requests like this.

 

My experiment with bigdump did not work . Gave me the following error

PHP version 4.1.0 is required for BigDump to proceed. You have PHP 4.3.11 installed. Sorry!

Got to try some other way. Maybe try to write a script

 

Thanks for sharing vihutuo. Nice script and i have used it a lot of times.

 

just search file php.ini and change the value of this parameter :

upload_max_filesize


also dont forget to adjust max execution time:

max_execution_time