U
U
user_tm2020-08-26 07:48:24
MySQL
user_tm, 2020-08-26 07:48:24

How to import a database or what does the notification of error #1064 in MySql mean?

A month ago, or even a little more, I reinstalled the local Open Server and forgot to export the database, but yesterday I managed to restore the remote database in .opt format. And now when I try to import it, the following happens, here is a screen 5f45e918bfb51045386321.jpegin the blue notification:

Ошибка

Статический анализ:

Найдено 1 ошибок при анализе.

    Неизвестный оператор. (near "default" at position 0)

SQL запрос:

default-character-set=utf8 default-collation=utf8_general_ci

Ответ MySQL: Документация
#1064 - У вас ошибка в запросе. Изучите документацию по используемой версии MariaDB на предмет корректного синтаксиса около 'default-character-set=utf8
default-collation=utf8_general_ci' на строке 1

What does this mean and how to fix it?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
R
Roman Mirilaczvili, 2020-08-26
@2ord

default-character-set=utf8 default-collation=utf8_general_ci

This does not look like a SQL query, but more like command line options for the mysql utility, though without--

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question