2 years ago

#35818

test-img

Romantik

MySql dump and restore all dbs with saving type

How to dump and restore all dbs with saving type?

When I do it with mysqldump it dump bigint instead of bigint(20) as example.Look like it was working with mysql 5.7 but not work anymore in mysql 8. The problem with release or I do something wrong?

dump:

mysqldump --user root --password --all-databases > all-databases.sql

restore:

mysql --user root --password mysql < all-databases.sql

mysql

bigint

0 Answers

Your Answer

Accepted video resources