mysqlsh dump and load full schema

Question

I want to use mysqlsh to do the following: dump the complete schema of a given database (not just tables, but functions, triggers and everything related to this database schema, same as mysqldump-RDATABASE>DATABASE.sql) and put this The full schema is loaded into the brand new database I just created (something like mysql --database=NEWDATABASE<DATABASE.sql) when I run mysqlsh --execute 'util.dump

P粉764785924 · Answer

I think you can just use a text editor to edit the .sql file before trying to load it.

This tool actually dumps the schema and imports it to a different MySQL instance, but keeps the schema name the same.