K
K
Kovalsky2015-11-14 21:32:43
PHP
Kovalsky, 2015-11-14 21:32:43

What to do if the exported mysql backup is not imported back?

With the help of phpmyadmin, a backup was made in .sql format, this very backup does not want to be imported back, it says:

2 errors were found during analysis.
Ending quote 'was expected. (near "" at position 32968)
4 values ​​were expected, but found 3. (near "(" at position 32767)

And at the end also:
#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 ''a:43:{s:10:"dialogname";s:30:"Завтрак Пр о-Лайф";s:15:"contentloca' at line 126

And what to do now when the backup is not uploaded back?)
Update: the backup uploaded without problems on the remote sql server. All through the same phpmyadmin, even the same version. What could be the problem? 0_o

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
Dmitry, 2015-11-14
@lazalu68

first you need to try via terminal (ssh)
mysql -u user -p database < data.sql

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question