how to upload a very large sql backup file?

[ben harry]

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

[RobWUK]

How big is it?

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

Rob

[flamer]

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

post_max_size = 8M
upload_max_filesize = 2M

OR

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

[Website Rob]

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