When I’m trying to add a big file to my WordPress database, I keep getting errors like this:

To solve this errors you can following this simple step:
- Goto XAMPP control panel>
- Stop Apache and MySql services>
- Click on Config of Apache>select php.ini and change the followings:
max_execution_time = 600
max_input_time = 600
memory_limit = 1024M
post_max_size = 1024M
Note:- Changing php.ini at C:\xampp\php\php.ini
4. Click on Config button of MySql and select my.ini and change:
max_allowed_packet = 1024M
Note:- Changing my.ini at C:\xampp\mysql\bin\my.ini
5. Again Start the services and try.. I hope it will work.

Thank you for visiting our blog post.
Dealing with foreign key constraints during WordPress database importFixing foreign key error in WordPress table importForeign key error in WordPress database importImporting tables with foreign key constraints in WordPressResolving SQL error "near 'ON' at position 25" in WordPress importSolutions for foreign key issues in WordPress table importTroubleshooting foreign key error while importing WordPress tableUnderstanding foreign key constraints in WordPress databaseWordPress database import error near 'ON' position 25WordPress table import foreign key error