db file size exceeds error in phpMyAdmin 3.5.7
Hello all,
i have installed centos 6.3 on a web server and installed phpMyAdmin 3.5.7 for the database. The problem is i was trying to import a db file for one of the websites and it said,cannot upload as the db file is large n crosses the phpMyAdmin limit.. Therefore i even changed the settings in php.ini file but it gave the same error. So can anyone tell me what could be the reason and what should i b doing? |
Have you changed following attributes in php.ini?
post_max_size & upload_max_filesize When you try to import database in phpmyadmin, what is the filesize limit there? Beside browse button ((Max: ) ) What is this attribute in your my.cnf max_allowed_packet=128M under [mysqld] Increase this size. Restart apache and mysql and try again. |
yes i did for php.ini but then in my.cnf there isnt option like 'max_allowed_packet'..
|
Add this line under [mysqld]
max_allowed_packet=128M Restart mysql and apache. Try again. |
All times are GMT -5. The time now is 04:10 AM. |