The default maximum size of file that can be imported via phpMyAdmin is 2MB. If your back-up script larger than 2MB then you have to change the maximum limit of file import size of phpMyAdmin.
Open your php.ini file, find and modify the following parameters:
upload_max_filesize = 256MB
post_max_size = 256MB
In the example above, I set the maximum upload size to 256MB. Make sure the size of the imported sql script below the limit or you have to raise the limit again.
If you have no access to file php.ini then you are out of luck. Ask your administrator to set it for you.
Restart your Apache webserver to apply the new configurations.
No comments:
Post a Comment