Just downloaded the latest backup of this site and when I tried to create the SQL database in phpMyAdmin, by importing the database, I got an error message, file too large, limit 2048 kb.
This got me worried as my site expands the database size will increase and thus I cannot create a backup on my localhost.
After some research I found you have to increase the file size in php.ini. This is how:-
- Make sure you have the latest version of phpMyAdmin.
- Click on phpMyAdmin as below and click on php.ini
This should open the php.ini file in notepad ( Windows)
- Now scroll down until you reach “File upload” section in the php.ini file, as below and increase the file size
Save file and proceed to phpMyAdmin and import your SQL file and this should work.