Increase Upload Size MySQL Database in phpMyAdmin?

rwsorensen

WMS Marketplace Seller
Joined
Mar 12, 2014
Messages
193
Points
18
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

New member
Joined
Nov 11, 2014
Messages
706
Points
0
Step 1: Go to php.ini and find the following and change their values to something more higher than your database size.

Code:
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

Code:
service httpd restart (CentOs) / service apache2 restart (ubuntu)
You can also restart directly from their path like
Code:
/etc/init.d/apache2 restart or /etc/init.d/httpd restart
 

ElixantTechnology

New member
Joined
Nov 26, 2014
Messages
622
Points
0
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.

Code:
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

Code:
service httpd restart (CentOs) / service apache2 restart (ubuntu)
You can also restart directly from their path like
Code:
/etc/init.d/apache2 restart or /etc/init.d/httpd restart
 
Newer threads
Latest threads
Replies
2
Views
117
Replies
1
Views
188
Replies
6
Views
423
Replies
11
Views
545
Replies
2
Views
238

Latest postsNew threads

Referral contests

Referral link for :

Sponsors

Popular tags

You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.

Top