Question : I have an application that has a large database that includes, among many other tables, a table called […]
Tag: mysqldump
Galera backup failing with error “mysqldump: Error 1213: Deadlock found when trying to get lock; try restarting transaction when dumping table”
Question : We face the same issue like this posting on dba.stackexchange.com Deadlock from mysqldump –single-transaction, is it possible?. We […]
Recommendation about mysqldump?
Question : I have approx 90 GB sized database, and I need to schedule a mysqldump backup. How long will […]
how to dump via mysqldump hugh table into chunks
Question : i have very hugh table , around 100 M records and 100 GB in a dump file , […]
Can I use a mariadb/mysql dump from older version in newer version?
Question : I’m a mariadb/mysql newbie. I want to take a complete backup. Apparently this is the way (please correct […]
MySQL backup breakes a table every time
Question : I’ve a MySQL Server 5.1.58-1ubuntu1 installed on an Ubuntu 12.04 LTS. Every night we do a backup of […]
How to prevent high memory, CPU and time consumption by MySQL restore?
Question : I have a local test machine with 2 GB RAM and a dual core processor. I imported a […]
Slow MariaDB Load of MySQL Dump
Question : I have a MySQL dump file generated from a MySQL 5.5.53 database. I am loading it on into […]
MySQL – Fastest restore of 1TB database
Question : I have MySQL Database and its 1.5TB. I need to setup replication for this. I have 32core CPU […]
MySQLdump Exclude master-data
Question : Is it possible to exclude the master data from a mysql dump? From the manual it seems like […]