My server A (linux) uses the mariadb database, and server B (linux) uses the mysql database. Now I move all databases of A to B. On A, use the command mysqldump to back up all databases and generate SQL files. Use the source command on B to restore the database. The problem is sou...
My server A (linux) uses the mariadb database, and server B (linux) uses the mysql database.
Now I move all databases of A to B.
On A, use the command mysqldump to back up all databases and generate SQL files.
Use the source command on B to restore the database.
The problem is that the source execution reports an error.
Mariadb uses the innodb Storage engine.
Reply content:
My server A (linux) uses the mariadb database, and server B (linux) uses the mysql database.
Now I move all databases of A to B.
On A, use the command mysqldump to back up all databases and generate SQL files.
Use the source command on B to restore the database.
The problem is that the source execution reports an error.
Mariadb uses the innodb Storage engine.
Paste the mysqldump command you executed on mariadb to check it out.
Are you sure you want to export all the databases below?
Mysqldump-u DB username-p DB password -- all-databases> all. SQL
You should paste your dump statement. This error may be caused by no related database.
SetMysqldump
Paste the command