Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: xtrabackup

MySQL restore only Incremental backups with innobackupex

By adminPosted on May 20, 2023

Question : I am migrating a product to AWS and we have 1.5TB of MySQL database. I want to migrate […]

xtrabackup “failed to read metadata” [closed]

By adminPosted on April 10, 2023

Question : This question is unlikely to help any future visitors; it is only relevant to a small geographic area, […]

How password can be prompted in percona xtrabackup

By adminPosted on February 26, 2023

Question : How password can be prompted while using percona xtrabackup.–ask-pass option is not working with xtrabackup. Thanks in advance. […]

is it possible to get innobackupex to print the filenames it’s busy with?

By adminPosted on January 7, 2023

Question : I am getting crashes when trying to run innobackupex –apply-log. How can I find out what files it’s […]

Does Percona Xtrabackup support RedHat release 4

By adminPosted on January 6, 2023

Question : I downloaded Percona’s Xtrabackup rpm file for RedHAT. I attempted to install but hit into an error. The […]

Percona: Do I need apply-log switch for a weekly full backup and hourly incremental?

By adminPosted on December 18, 2022

Question : I am planning a script to work on our percona. Our strategy is to do full backup weekly […]

What is a LSN (log sequence number)? How does xtrabackup Incremental Backup work?

By adminPosted on November 24, 2022

Question : I was surprised that xtrabackup supports incremental backups. xtrabackup copies the data files and understand the format of […]

Percona Xtrabackup on Suse EL 10 — Failing

By adminPosted on September 30, 2022

Question : I have evaluated Percona Xtrabackup successfully and it works like a charm on my several CentOS / RHEL […]

Can I use xtrabackup to import a database without altering others?

By adminPosted on September 21, 2022

Question : Context: Each time a demo branch is built, I want to download a copy of the prod database […]

Tools for working with xtrabackup files?

By adminPosted on August 7, 2022

Question : I have database backups in xtrabackup format. I would like to load them into hive without restoring to […]

  • 1
  • 2
  • 3
  • 4

Recent Posts

  • What happens when a stored procedure executes one of two different queries based on an input parameter?
  • T-SQL Optimization
  • Why my BEFORE UPDATE trigger takes values from the NEW record? [closed]
  • Split a query results multiple times
  • Improve reading speed of MySQL table storing stock prices (100 Mil. entries)
  • Adding sql users via linked servers
  • Postgres – caching of recently inserted data?
  • Does Oracle randomly switch execution plans to check if there is a better solution?
  • Cannot INSERT into database on a shared server
  • Simple query with a single join very slow
  • How to replicate and sync MongoDB localhost to a remote server using replica set
  • How can I increase performance for select in select statement
  • Optimize UNION query in MySQL
  • Mysql Performance tuning for myisam tables.
  • Get-ClusterParameter Not Returning Expected Results
  • SQL Server Extended Events to Capture Objects access by a User [duplicate]
  • Execution time of triggers fired when a procedure is executed in postgresql
  • Efficient query to get last row group by multiple columns
  • How to use GROUP BY after the Having clause Mysql
  • PGSQL- syntax error at or near “-“

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding