Skip to Main Content

MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How can I use mysqlbackup to restore a database with another database name?

4221600Apr 20 2020 — edited Apr 21 2020

Hi,

I have the following script to backup my database (mysql5.7) with MysqlBackup,

but I don't found how can I restore with the file generated in another database name

/opt/mysql/meb-4.1/bin/mysqlbackup  \

--defaults-file=/etc/my.cnf   \

--databases=DatabaseName\

--compress   \

--compress-level=5  \

-u$USER  \

-p$PASS  \

--backup-dir=/tmp/mysql/$FECHA  \

--backup-image=$DIR_BKP/$FECHA/uyancapuntos_$FECHA.mbi  \

--socket=/var/lib/mysql/mysql.sock  \

--key-file=/opt/mysql/meb-4.1/bin/keyfile  \

backup-to-image

Could someone help me with this?

best regards,

Comments

Post Details

Added on Apr 20 2020
1 comment
177 views