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 feedback on my previous blog about MySQL Interview with ChatGPT. Here is a video recording of the steps described below for restoring single table from […]
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 position. This blog post is a result of that interview, during which I asked ChatGPT a range of questions related to MySQL and other relevant […]
Restoring MariaDB (MySQL) slave using Xtrabackup & GTID.
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 and ran into issues following standard commands (assuming no changes): To prepare the backup I used apply-log as follows: $] innobackupex-1.5.1 –defaults-file=/usr/local/mysql/data/backup-my.cnf –apply-log /usr/local/mysql/data –ibbackup […]
Change Is Inevitable