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

Trouble after restoring backup v2.1.3

Peter ThorunPeter Thorun EntrantInactive User Role Beginner
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:[/I]


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

Shutdown MySQL process, clean datadir then:[/I]





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.

Comments

  • niljoshiniljoshi MySQL Sage Inactive User Role Beginner
    Hi,

    Can you provide full error log, MySQL/Percona Server version?
  • Peter ThorunPeter Thorun Entrant Inactive User Role Beginner
    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.
  • niljoshiniljoshi MySQL Sage Inactive User Role Beginner
    Hi, I'm glad that you found out the problem and solution for it. :)
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.