A
A
Alexander2020-07-19 00:11:51
MySQL
Alexander, 2020-07-19 00:11:51

How to transfer database dump from MariaDB to MySQL?

Such a simple question, but it confuses me ... I

transferred several databases and everything was fine until I ran into the fact that one of the databases was not completely filled.

Everything is as usual:
mysqldump -u root -p******** db > dump.sql
and
mysql -u su -p********** db < dump.sql But

no - parts of the tables not in the flooded base. No bugs. No messages.

Donor 5.5.47-MariaDB-log, recipient - 5.7.30-0ubuntu0.18.04.1

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
alekseyHunter, 2020-07-19
Madzhugin @Suntechnic

Do it with phpmyadmin.
Maybe you have triggers that work with another account.
There may be a syntax error when creating the file. There is varchar, here is text.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question