Some people works with phpmyadmin to upload their .sql files. But phpmyadmin has some limitations to upload the large files then 2MB.
To over come this problem the follwing work can be done:
Then try your upload. Hope it will work. And you will get the following confirmation:
Import has been successfully finished, 499 queries executed. (your_db_name.sql)
To over come this problem the follwing work can be done:
in /etc/php5/apache2/php.ini:
max_execution_time = 60
max_input_time = 90
memory_limit = 128M
upload_max_filesize = 22M
post_max_size = 22M
max_execution_time = 60
max_input_time = 90
memory_limit = 128M
upload_max_filesize = 22M
post_max_size = 22M
Then try your upload. Hope it will work. And you will get the following confirmation:
Import has been successfully finished, 499 queries executed. (your_db_name.sql)
No comments:
Post a Comment