Import your old database

Community support
#1

Dear Comrade administrators

Import my old database：

Error
Static analysis:

2 errors were found during analysis.

Unexpected beginning of statement. (near “phpMyAdmin” at position 2)
Unrecognized statement type. (near “SQL” at position 13)
SQL query:

  • phpMyAdmin SQL Dump SET SQL_MODE=“NO_AUTO_VALUE_ON_ZERO”

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '- phpMyAdmin SQL Dump

SET SQL_MODE=“NO_AUTO_VALUE_ON_ZERO”’ at line 1

What shall I do?

#2

Did you follow the tutorial to import the old database? Is this migration related?

#3

Yes,I follow the tutorial.

In phpMyAdmin, export and import

#4

Maybe @nginx or @Infinity can take a look at this, they know about mysql stuff

#5

Hi @Alp!

The problem can be caused because of the incompatibility between the MySQL versions. I have sent you a PM.