Announcement

Announcement Module
Collapse
No announcement yet.

Trouble after restoring backup v2.1.3

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

  • Trouble after restoring backup v2.1.3

    Hello guys,

    I am having an annoying issue here and would like to know if you have some tips for me.

    After restoring the backup i cant put the mysql up again the service just stucks at the start and restart commands.

    Here are the steps i am doing:

    sudo innobackupex --compress --ibbackup=xtrabackup --user=root --password=pass /home/ubuntu/Backup/ => for backup

    Uncompress then:


    sudo innobackupex --apply-log /home/ubuntu/Backup/my-backup-folder => to prepare

    Shutdown MySQL process, clean datadir then:


    sudo innobackupex --copy-back --user=root --password=pass /home/ubuntu/Backup/copy-that-i-want => to restore


    After doing this MySQL service seems completely broken, any ideia of that could be going on?

    Thank for the help and have a nice day.







  • #2
    Hi,

    Can you provide full error log, MySQL/Percona Server version?

    Comment


    • #3
      The messages that i got repeatedly in log are:

      InnoDB: File name ./ibdata1
      InnoDB: File operation call: 'open'.
      InnoDB: Cannot continue operation.
      130607 20:33:57 [Note] Plugin 'FEDERATED' is disabled.
      130607 20:33:57 InnoDB: Initializing buffer pool, size = 8.0M
      130607 20:33:57 InnoDB: Completed initialization of buffer pool
      130607 20:33:57 InnoDB: Operating system error number 13 in a file operation.
      InnoDB: The error means mysqld does not have the access rights to
      InnoDB: the directory.

      and

      File name ./ibdata1
      InnoDB: File operation call: 'open'.
      InnoDB: Cannot continue operation.
      130610 15:44:45 [Note] Plugin 'FEDERATED' is disabled.
      ^G/usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
      130610 15:44:45 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
      130610 15:44:45 InnoDB: Initializing buffer pool, size = 8.0M
      130610 15:44:45 InnoDB: Completed initialization of buffer pool
      130610 15:44:45 InnoDB: Operating system error number 13 in a file operation.
      InnoDB: The error means mysqld does not have the access rights to
      InnoDB: the directory.

      Np i found out that doing chmod 777 to /var/lib i could bypass the error, later i figured that after the restore the files inside that folder was owned by root.

      Changing the permission to the files or changing the owner to mysql solves the problem.

      I am still posting here to help some other people that may face the same problem.






      Comment


      • #4
        Hi, I'm glad that you found out the problem and solution for it.

        Comment

        Working...
        X