2 years ago
#35818
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