Отсутствует выражение near on at position 25
Обновлено: 05.11.2024
Here is the screen shot
i do following steps to resolve issue
- try to export by MYSQL_40 and import
- try by disabling the FOREIGN_KEY checkbox when export and try to import
- 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:463 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.
Читайте также: