GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Backup failure on Ubuntu

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

  • Backup failure on Ubuntu

    Trying to backup a MYISAM only database using this:-

    innobackupex --defaults-file=/etc/mysql/my.cnf --stream=tar --user=root --password=whatever ./ | gzip - >backup.tar.gz

    and it fails with these messages...

    InnoDB: The first specified data file ./ibdata1 did not exist:
    InnoDB: a new database to be created!
    110909 11:47:26 InnoDB: Setting file ./ibdata1 size to 10 MB
    InnoDB: Database physically writes the file full: wait...
    xtrabackup: Something wrong with source files...
    innobackupex: Error: ibbackup child process has died at /usr/bin/innobackupex line 336.

    Can the script only be used with InnoDB tables?
    TIA
    Rich

  • #2
    It is an InnoDB backup tool that can also back up MyISAM tables. If you have big MyISAM tables, I don't recommend using it that way (use xtrabackup binary only, not innobackupex, to back up the InnoDB tables). If you don't have InnoDB tables, don't use this tool for backups.

    Comment

    Working...
    X