Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

WordPress Local WordPress Development Local WordPress Development Migrating WordPress from Local to Live Server

Santiago Barrionuevo
Santiago Barrionuevo
14,176 Points

phpMyAdmin error: SQL file size

My database size is 2.6 KB and phpMyAdmin (in localhost) only allow a max of 2.048 KB...

How can I solve this?

Thanks!

Hugo Paz
Hugo Paz
15,622 Points

Hi Santiago,

Do you get this error when trying to upload the database?

To increase the limit you need to change PHP settings. The settings to change (with their typical defaults are):

post_max_size = 8M upload_max_filesize = 2M

You must ensure that post_max_size is the same or larger than upload_max_filesize.

These settings can be changed globally by changing them in your php.ini file. After changing the settings, remember to restart your web server.

2 Answers

Alessandra Vaughn
Alessandra Vaughn
13,915 Points

Hi, I'm not sure if I am understanding your issue or not. But I have run into file size issues when I tried to load too large of a .csv file. Instead, I zipped the file and loaded it, which worked.

Santiago Barrionuevo
Santiago Barrionuevo
14,176 Points

Problelm solved. Thank you very much!