A
A
anvoevodin2016-09-22 00:50:01
MySQL
anvoevodin, 2016-09-22 00:50:01

How to properly export from mysql to mariaDB?

Hello. Immediately I apologize for the terminology in the title and the subject in general, not very in the subject.
In general, there are two databases of 1.2 GB each, which were on regular mysql. There is a need to transfer them to another server where MariaDB is already installed. Judging by the information from Google, they are comparable, almost the same, and that there should be no problems, but I import through the console and get a response.

ERROR 1064 (42000) at line 11108851: 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 '<br />
<b>Fatal error</b>:  Maximum execution time of 300 seconds exceeded in <b' at line 368

I see two errors: query syntax and a timeout of 300 seconds. The second error seemed to me not plausible and that it came out somehow from the first error (since the import command is executed for about 15 minutes before these errors).
Is it necessary to increase the "Maximum execution time" simply or is there really a difference between the syntaxes of these databases? It may be possible to install mysql separately, so as not to torment mariaDB (mariaDB itself cannot be deleted, it is used by another application on the server).
Thanks in advance for your replies!

Answer the question

In order to leave comments, you need to log in

1 answer(s)
W
WebDev, 2016-09-22
@anvoevodin

You have one mistake, not two. Your export was interrupted by timeout and now the inscription

Maximum execution time of 300 seconds exceeded in
you have it inside the dump and does not allow it to be imported. It is broken and not complete.
Make a new dump through the console, you probably did some kind of web interface.
And when importing, there is no difference between MySQL and MariaDB.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question