Buy Percona ServicesBuy Now!

Restoring backup has no tables

  • Filter
  • Time
  • Show
Clear All
new posts

  • Restoring backup has no tables

    I am trying to get xtrabackup working on a very old version of MySQL. This system is 5.1 (all InnoDB), yes the plan is to update it but it will be a month out. I am just trying to get better backups then the existing once a day mysqldump.

    I have xtrabackup 2.0 installed, run the backup. Prepare the backup. Tar up transfer to s3. Unpack on instance that has MySQL 5.1 and xtrabackup 2.0.

    After I ran the restore procedures in the 2.0 docs (using rsync). I start MySQL and the databases are there. But no tables. The data is there, if I grep for some keywords in the ibdata1.

    Any suggestions ? I am rather baffled at this.

  • #2
    Doh! I figured it out. I missed the part of the docs that say to use innobackupex since xtrabackup does not copy the .frm files.

    I got it working


    • #3
      Hi Jengo,

      thx for your "resulution".

      I still have this problem in a scenario with percona mysql 5.5 and xtrabackup 2.2.10-1.lucid .

      No frm files have been copied and I think that should be versions where innobackupex should haven been marked depcreated ... but how to I get the xtrabackup with frm files then ?