Database

Error (near “ON” at position 25)

Less than a minute to read

Error (near “ON” at position 25).
The references I’ve read don’t explain the cause of this error.
But I experienced it when uploading a fairly large database via phpmyadmin.
To fix it, this is how I managed to implement it.
First, you need to stop Apache and MySql from running, via the Xampp Control Panel.
Then, follow these steps.

Changing php.ini at C:\xampp\php\php.ini

 max_execution_time = 600
 max_input_time = 600
 memory_limit = 1024M
 post_max_size = 1024M

Changing my.ini at C:\xampp\mysql\bin\my.ini

 max_allowed_packet = 1024M

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Posts

× Chat