
This works great and it preserves all of the data that you’ll need. old_database should be changed to the name of the database that you want to copy tables from. I hope that you find this helpful. //CREATE THE NEW TARGET DATABASE create database new_database; //CHANGE TO THE NEW DATABASE use new_database; //Create each table that [...]