Not the answer you need?
Register and ask your own question!

Backup and restore just one database...

macktabmacktab EntrantInactive User Role Beginner
Guys, can you help me.
I have server, which is working on production.
I need to backup one database on this server, and restore this database on another server, and restorep process must not recycle other databases on server...
Can somebody give me an advice?

Comments

  • niljoshiniljoshi MySQL Sage Inactive User Role Beginner
    Hi,

    Can you provide some more information like what is the size of database and which storage engine you are using?
  • macktabmacktab Entrant Inactive User Role Beginner
    Sorry.
    CentOS 5.8
    Kernel 2.6.18-308.13.1.el5
    MariaDB-server 5.5.25
    percona-xtrabackup 2.0.2
    /var/lib/mysql/ 916M
    percona xtradb
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.