db file size exceeds error in phpMyAdmin 3.5.7

SarahGurung · 03-11-2013, 10:58 PM

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?

fortran · 03-12-2013, 12:07 AM

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.

SarahGurung · 03-12-2013, 01:39 AM

yes i did for php.ini but then in my.cnf there isnt option like 'max_allowed_packet'..

fortran · 03-12-2013, 03:09 AM

Add this line under [mysqld]
max_allowed_packet=128M
Restart mysql and apache.
Try again.