Set foreign_key_checks = on wordpress error

Question

I have a Bluehost account, and now I am switching to a new digitalocean.com account. I do export and import, as in phpmyadmin, but here, when I import my sql.zip or sql.gz files to a new server, it shows me an error like

Error
Static analysis:

1 errors were found during analysis.

Missing expression. (near "ON" at position 25)
SQL query: Edit Edit

SET FOREIGN_KEY_CHECKS = ON;

MySQL said: Documentation

#2006 - MySQL server has gone away

Here is a screenshot

https://www.awesomescreenshot.com/image/2511553/fa78fad9e1108051c84538f2314df7

I take the following steps to solve the problem

1. try exporting MYSQL_40 and import
2. try disabling the FOREIGN_KEY flag when exporting and try to import
3. Database plugin used but same error

But no luck, I think this is a problem with the bluehost server when I try to export

Answer 1

, PhpMyAdmin. , .

mysql -u username -p database_name < file_name.sql

file_name.sql as:

1. SET FOREIGN_KEY_CHECKS = 0; file_name.sql.

2. SET FOREIGN_KEY_CHECKS = 1; file_name.sql.

. , .

SQL MySQL?

Answer 2

, MariaDB 10.3, , / mariadb mysql ,