Upgrade & Secure Your Future with DevOps, SRE, DevSecOps, MLOps!

We spend hours on Instagram and YouTube and waste money on coffee and fast food, but won’t spend 30 minutes a day learning skills to boost our careers.
Master in DevOps, SRE, DevSecOps & MLOps!

Learn from Guru Rajesh Kumar and double your salary in just one year.

Get Started Now!

Error (near “ON” at position 25) while importing Table for WORDPRESS ( A foreign key Error)

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:

  1. Goto XAMPP control panel>
  2. Stop Apache and MySql services>
  3. 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.

Related Posts

How to Install and Enable GMP Extension in XAMPP PHP on Linux (Step-by-Step Guide)

Introduction If you are using XAMPP PHP on a Linux server and encounter errors like: then this usually means the GMP extension is not installed, not just Read More

Read More

Error : MySQL shutdown unexpectedly. This may be due to a blocked port, missing dependencies , improper privileges, a crash, or a shutdown by another method.

Step 1: First, stop Apache and MySQL in the XAMPP server, then go to C:\xampp\mysql and back up the data folder. Step 2: After backing up the Read More

Read More

You probably tried to upload a file that is too large. Please refer to documentation for a workaround for this limit.

For Upload large size data in using phpmyadmin Do following steps. than after restart wamp server or restart all services Now Upload data using import function in Read More

Read More

phpMyAdmin Troubleshooting Advance Guides

Here are some advanced troubleshooting guides for PHPMyAdmin: 1. Performance Issues Slow Loading Times: 2. Connection Issues Error Messages like “Access Denied for User”: 3. Session Timeout Read More

Read More

ERROR 1153 (08S01) at line 1582: Got a packet bigger than ‘max_allowed_packet’ bytes

When I’m trying to add a big file to my WordPress phpmyadmin database, I keep getting errors like this:- ERROR 1153 (08S01) at line 1582: Got a Read More

Read More

Setting Up Virtual Hosts in XAMPP for Windows: A Step-by-Step Guide

To create a virtual host in XAMPP, you need to follow these steps: 2. Configure Apache: 3. Restart Apache: 4. Access Your Virtual Host: Make sure that Read More

Read More
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x