Increase database import file size in wampserver
How to increase the WAMPSERVER max file upload capacity.
If you are not able to import the database of bigger file size
Here are the steps
- Start your wampserver.
- Right click on wampserver , go to PHP->php.ini , open the file.
- Search for
upload_max_filesize
- You will find something link this
upload_max_filesize = 2M - Change it to 100M or more according to your requirement.
- Then search for
post_max_size… same increase the size according to your requirement. - Last step but not the least right click on wampserver and click on “Restart All Services”.
How to solve the Error 1115 (42000): Unknown character set: 'utf8mb4' when importing a sql file in PHPMyAdmin
This error usually happens when you try to import an entire database, or single table that was exported from a newer version of PHPMyAdmin. So when you try to import this file into an older version of MySQL that doesn't support the utf8mb4 charset, you will face the exception. The most probably case is that locally you have a major version of MySQL, and on stage/hosted VPS you have MySQL server version less than 5.5.3.
Check the following users.sql file:
/*!40101 SET NAMES utf8mb4 */;
How to solve it
There's a good chance (depending of the kind of characters stored on your table) that you can solve this issue by simply changing the utf8mb4 with just utf8. According to the MySQL docs, the utf8mb4 charset is a superset of utf8 that uses a maximum of four bytes per character and supports supplementary characters (instead of 3 that uses utf8).
Alternatively, if you are able to, you can update the version of MySQL installed on your server that supports the utf8mb4 charset.
Happy coding !
