mysqldump Archives

mysql dump best practices for development

By adminPosted on March 21, 2023

Question : I have an application that has a large database that includes, among many other tables, a table called […]

By adminPosted on March 21, 2023

Question : We face the same issue like this posting on dba.stackexchange.com Deadlock from mysqldump –single-transaction, is it possible?. We […]

By adminPosted on March 20, 2023

Question : I have approx 90 GB sized database, and I need to schedule a mysqldump backup. How long will […]

By adminPosted on March 18, 2023

Question : i have very hugh table , around 100 M records and 100 GB in a dump file , […]

By adminPosted on March 11, 2023

Question : I’m a mariadb/mysql newbie. I want to take a complete backup. Apparently this is the way (please correct […]

By adminPosted on March 9, 2023

Question : I’ve a MySQL Server 5.1.58-1ubuntu1 installed on an Ubuntu 12.04 LTS. Every night we do a backup of […]

By adminPosted on March 4, 2023

Question : I have a local test machine with 2 GB RAM and a dual core processor. I imported a […]

By adminPosted on March 1, 2023

Question : I have a MySQL dump file generated from a MySQL 5.5.53 database. I am loading it on into […]

By adminPosted on February 23, 2023

Question : I have MySQL Database and its 1.5TB. I need to setup replication for this. I have 32core CPU […]

By adminPosted on February 22, 2023

Question : Is it possible to exclude the master data from a mysql dump? From the manual it seems like […]