MySQL Forums
Forum List  »  Newbie

Re: Chamging a MySQL schema
Posted by: Peter Brawley
Date: December 18, 2019 12:00PM

You'll need to change some DDL and massage some data, so you need to make (i) backup (ii) test and (iii) working copy of the db, develop and test the changes in the working copy, write and debug a self-standing script that executes all of them against the test copy of the db, then finally run it against the live db.

Re the details let's see Show Create Table results for people, artists, roles, songs, albums.



Edited 1 time(s). Last edit at 12/18/2019 01:53PM by Peter Brawley.

Options: ReplyQuote


Subject
Written By
Posted
December 17, 2019 11:12PM
Re: Chamging a MySQL schema
December 18, 2019 12:00PM
December 18, 2019 02:03PM
December 18, 2019 02:20PM
December 18, 2019 03:01PM
December 18, 2019 09:25PM
December 18, 2019 10:11PM
December 19, 2019 10:06AM
December 18, 2019 04:05PM
December 18, 2019 12:59PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.