Forums / General Questions / how to upload a very large sql backup file?

how to upload a very large sql backup file?

Results 1 to 4 of 4

18 Aug 2011, 8:37 PM

ben_harry

Zen Follower

Join Date:: Mar 2007
Location:: Cornwall - uk
Posts:: 462
Plugin Contributions:: 0

how to upload a very large sql backup file?

i need to upload a backup but i cant work out how to do it. ive gone into phpmyadmin and tried to import the saved sql file but it says its too big. What other way can i do it?

thanks

18 Aug 2011, 9:37 PM

robwuk

Zen Follower

Join Date:: Aug 2005
Location:: United Kingdom
Posts:: 458
Plugin Contributions:: 0

Re: how to upload a very large sql backup file?

How big is it?

Does it have the extension .SQL as you might be able to break the file up for uploading

Rob

19 Aug 2011, 2:12 AM

flamer

New Zenner

Join Date:: May 2010
Posts:: 44
Plugin Contributions:: 0

Re: how to upload a very large sql backup file?

You can increase the allowed size either globally or locally in your php.ini file

post_max_size = 8M
upload_max_filesize = 2M

If you have command line access, you can upload the sql file via ftp, then run this command from your prompt
mysql -u myuser -p mydatabase < myfile.sql

19 Aug 2011, 8:45 PM

website_rob

Inactive

Join Date:: Oct 2006
Location:: Alberta, Canada
Posts:: 4,572
Plugin Contributions:: 0

Re: how to upload a very large sql backup file?

Contact your Hoster. They should be willing to help with this type situation.

The learning is in the doing.

Potent Products