Restore single MySQL table (ibd) from Xtrabackup (video demo)
Kedar
In this blog we will create MySQL backup and then restore single table from Percona Xtrabackup without doing full restore. This post is basically a work-log in response to a…
Browsing Tag
xtrabackup
5 posts
MySQL Interview – ChatGPT is not your DBA
Given the recent surge of interest in ChatGPT and the AI capabilities it offers, I decided to conduct an interview with it to assess its suitability for a MySQL Consultant…
Setup and configure MySQL backup using Holland and Xtrabackup
Setting up a database backup is a primary task for database administrators and we see perl and shell scripts wrapped around few of the backup-tools in practice. With right tools…
MariaDB slave restore using GTID & xtrabackup bug
Restoring MariaDB (MySQL) slave using Xtrabackup & GTID.
xtrabackup_51: not found & no ‘mysqld’ group in MySQL options
Recently I happen to setup a new MySQL instance with my tools – a standard MySQL 5.1+, xtrabackup setup and last-hotbackup.tar.gz. To restore from the backup we used xtrabackup binaries…
2 responses to “xtrabackup_51: not found & no ‘mysqld’ group in MySQL options”
Slackware 14.2, with MariaDB 10.0.37, Percona XtraBackups 2.1.5, and the following command results in the error below: shell>innobackupex –include=’^zabbix’ /home/cesarmsj/backups/ –user=root –password= zabbix
sh: xtrabackup_56: command not found
innobackupex: Error: no ‘mysqld’ group in MySQL options at /usr/bin/innobackupex line 4247
The version 2.1.5 is a unique available in SlackBuilds.
I also face the same problem. I was thinking about how to solve it. The backup thingy was giving me a terrible headache. Now I am going to do what you are telling here and lets see if I can get through. Fingers X.