Top "Mysqldump" questions

MySQL is a free, open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL).

How to obtain a correct dump using mysqldump and single-transaction when DDL is used at the same time?

I'm new to MySQL and I'm figuring out the best way to perform an on-line hot logical backup using mysqldump. …

mysql mysqldump corruption
Does mysqldump handle binary data reliably?

I have some tables in MySQL 5.6 that contain large binary data in some fields. I want to know if I …

mysql mysqldump binary-data
Fix serialized data broken due to editing MySQL database in a text editor?

Background: I downloaded a *.sql backup of my WordPress site's database, and replaced all instances of the old database table …

mysql wordpress mysqldump mariadb
Foreign key constraint error 1452 in MySQL - Magento import

i am trying to import a sql dump of magento along with some product data and i get this foreign …

mysql magento mysqldump mysql-error-1452
How to include MySQL database schema on GitHub?

Stackoverflow and MySQL-via-command-line n00b here, please be gentle! I've been looking around for answers to my question but could …

mysql github mysqldump database-schema dump
why is the `tcgetattr` error seen when ssh is used for dumping the backup file on another server?

I want to dump a tables backup on another server and I am using ssh for doing it. when I …

mysql ssh mysqldump database-backups
Configuring MySQL server to avoid "MySQL Server has gone away" error

When I tried to establish a MySQL database using a dump, I got the following error message ERROR 2006 (HY000) at …

mysql mysqldump mysql-management
mysqldump not creating create database syntax

I am using mysql database. I am using mysqldump to create a dump of my database. I want the database …

mysql mysqldump database-backups mysql-backup
Split up a mysqldump file with multiple databases, by database

I have a mysqldump file of multiple databases (5). One of the database takes a very long time to load, is …

mysql database backup mysqldump reload
How to write the Mysql binary log position of master when doing a mysqldump from slave?

I am currently running mysqldump on a Mysql slave to backup our database. This has worked fine for backing up …

mysql mysqldump database-backups master-slave