L
L
Leonid2017-02-02 09:01:59
PHP
Leonid, 2017-02-02 09:01:59

DB dump import errors in phpMyAdmin - how to fix?

I'm trying to transfer the database of a WordPress site from one abnormal hosting (nic.ru) to another hosting.
On nic.ru, only phpMyAdmin is provided, with the help of which I do a standard export to a sql.gz file, which I then try to upload to a new hosting in phpMyAdmin, but I get an error like this when importing:

#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 '?' at line 19


Can something be done in the phpMyAdmin export settings so that the import goes through without errors?

ps: Do not offer to make a dump from SSH - SSH does not work on our account, tech. support is dead for us - we have been writing letters for the third day already, the site is down, no hello or answer from them.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
d-stream, 2017-02-02
@d-stream

With 95% probability the problem is in encodings. For example, the dump is done in Unicode, and when uploading, MySQL tries to interpret it as 1251.
In order not to guess, it would be better to bring at least the first 19-20 lines of the dump.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question