GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Restore to new name

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Restore to new name

    Hi,
    I have a backup of a database, called 'myDataBase', and would like to restore it on the same server but under a different schema name. In other words after a restore I would like to have the original schema 'myDataBase' existing next to 'myDataBase_copy' and they are identical in everything but name. How can I do this?

    Many Thanks

    Mike

  • #2
    Hi Mike,

    You can not directly do that but if you have innodb_file_per_table ON then you can use option like Import/Export tablespace option to restore tables in new database name from the backup.
    http://www.percona.com/doc/percona-x...ables_ibk.html

    Even, MySQL 5.6 supporting exportable tablespaces.
    http://www.percona.com/doc/percona-x...ables_ibk.html

    Thanks.

    Comment

    Working...
    X