Increase Upload Size MySQL Database in phpMyAdmin?

[rwsorensen]

How can I increase upload size MySQL database in phpMyAdmin on my vps?

File may be compressed (gzip, bzip2, zip) or uncompressed.
A compressed file's name must end in .[format].[compression]. Example: .sql.zip
Browse your computer: (Max: 50MiB)

It's showing 50MiB for maximum file site upload while my db size is 250MB

I need to increase this size, can you suggest?

 

[Hassan]

Step 1: Go to php.ini and find the following and change their values to something more higher than your database size.

memory_limit
post_max_size
max_input_time
upload_max_filesize
max_execution_time

Step2 : Restart your apache service for this new change to take effect. Usually the command to restart apache would be

service httpd restart (CentOs) / service apache2 restart (ubuntu)

You can also restart directly from their path like

/etc/init.d/apache2 restart or /etc/init.d/httpd restart

 

[ElixantTechnology]

This requires that you are able to access the server as ROOT, and have full control of it. Hassan gave a well described explination on how to complete this task.

Step 1: Go to php.ini and find the following and change their values to something more higher than your database size.

memory_limit
post_max_size
max_input_time
upload_max_filesize
max_execution_time

Step2 : Restart your apache service for this new change to take effect. Usually the command to restart apache would be

service httpd restart (CentOs) / service apache2 restart (ubuntu)

You can also restart directly from their path like

/etc/init.d/apache2 restart or /etc/init.d/httpd restart