MySQL Forums
Forum List  »  Newbie

Re: Attach database to new Schema
Posted by: Peter Brawley
Date: December 06, 2017 05:01PM

There's no option to "attach" old db files, to an existing schema in a mysql installation.

On another machine, install the mysql version in which the files were created, stop it, import the files to the appropriate folder, restart the server, check that it is using the files correctly, export them with mysqldump without create-schema and create-db cmds, and import that script into the current installation as desired.

Options: ReplyQuote


Subject
Written By
Posted
December 06, 2017 04:35PM
Re: Attach database to new Schema
December 06, 2017 05:01PM
December 07, 2017 12:22PM
December 07, 2017 01:02PM


Sorry, only registered users may post in this forum.

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.