Отсутствует выражение near on at position 25

Обновлено: 22.12.2024

Here is the screen shot

i do following steps to resolve issue

  1. try to export by MYSQL_40 and import
  2. try by disabling the FOREIGN_KEY checkbox when export and try to import
  3. Used the database plugin but same error

But no luck i think it is an issue with bluehost server when i am trying to export

Follow asked May 19 '17 at 13:19 Aakanksh Patel Aakanksh Patel 555 1 1 gold badge 6 6 silver badges 19 19 bronze badges Aug 31 '17 at 9:11 @CesarMartinezDominguez thanks for the reply but I check this options as well not luck and at the end, I change the server and migrate to HostGator and also the support of Bluehost is worst. I am not saying I am right but they should have technical support like HostGator & wpengine. Aug 31 '17 at 10:46

3 Answers 3

This Error, Mostly We get while importing the database from PhpMyAdmin. I solved it by importing database through commands.

or by changing in database file_name.sql as:

put this line SET FOREIGN_KEY_CHECKS = 0; just the beginning of database file_name.sql .

And put this line SET FOREIGN_KEY_CHECKS = 1; just before the end of file at last line of file_name.sql .

Note: The first line will disable foreign key checks and the last line will enable it again.

Читайте также: