My a server (Linux) uses the MARIADB database, and b server (Linux) uses the MySQL database.
Now I'm going to move all the databases of A to B.
Use the command mysqldump on a to back up all the databases and generate the SQL files.
Restore the database using the source command on B.
The problem is that source executes an error.
The InnoDB storage engine is used on the mariadb.
Reply content:
My a server (Linux) uses the MARIADB database, and b server (Linux) uses the MySQL database.
Now I'm going to move all the databases of A to B.
Use the command mysqldump on a to back up all the databases and generate the SQL files.
Restore the database using the source command on B.
The problem is that source executes an error.
The InnoDB storage engine is used on the mariadb.
You mariadb on the execution of the mysqldump command the entire post to see
Do you want to export all libraries as follows?
mysqldump -u DB用户名 -p DB密码 --all-databases > all.sql
You should paste out your dump statement, which could be caused by the absence of a related database.
Put mysqldump
a sticker on the execution of the order.