O'Reilly logo

MySQL 8 Cookbook by Karthik Appigatla

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Backup to rebuild another server with a different schema

There can be a situation where you want to have a different schema on another server. In that case, you have to dump and restore the schema, alter the schema as you need, and then dump and restore the data. Altering the schema with data can take a long time, depending on the amount of data you have. Note that this method will work only when the modified schema is compatible with inserts. The modified table can have extra columns but it should have all the columns present in the original table.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required