This is a collection of articles regarding the MySQL utility mysqldump that were previously published on this blog. This is for quick reference.
MySQLDump Only INSERT Statements
The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table data. It dumps one or more MySQL databases for backup or transfer to another server. The mysqldump command can also generate output in CSV, other delimited text, or XML…
Keep reading
mysqldump – Dump only specific rows
It is possible to dump a specific table and specific rows from a table using mysqldump. This article explains how to do that. The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table data. It dumps one or more…
Keep reading
mysqldump – ignore a single or multiple tables
The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table data. It dumps one or more MySQL databases for backup or transfer to another server. The mysqldump command can also generate output in CSV, other delimited text, or XML…
Keep reading
mysqldump – backup of multiple databases
The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table data. It dumps one or more MySQL databases for backup or transfer to another server. The mysqldump command can also generate output in CSV, other delimited text, or XML…
Keep reading
mysqldump – Include views, routines and triggers
The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table data. It dumps one or more MySQL databases for backup or transfer to another server. The mysqldump command can also generate output in CSV, other delimited text, or XML…
Keep reading
mysqldump – with or without create database
The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table data. It dumps one or more MySQL databases for backup or transfer to another server. The mysqldump command can also generate output in CSV, other delimited text, or XML…
Keep reading
mysqldump – NO LOCK while backup
The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table data. It dumps one or more MySQL databases for backup or transfers to another server. The mysqldump command can also generate output in CSV, other delimited text, or XML…
Keep reading
mysqldump – Copy Schema without Data
The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table data. It dumps one or more MySQL databases for backup or transfer to another server. The mysqldump command can also generate output in CSV, other delimited text, or XML…
Keep reading
MySQLDump – Password with Special Characters
Some people decided to use special characters in the password for the database instances due to security concerns. Although it’s a nice thing, the mysqldump command frequently causes failures when performing a backup (dumping the data into an external file). Look at the example below. MyMac ~ % mysqldump -h dbHostEndPoint -P 3306 -u myUserName…
Keep reading
MySQLDump Usage in AWS RDS
The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table data. It dumps one or more MySQL databases for backup or transfers to another SQL server. Additionally, the mysqldump command can export data in CSV, other delimited text, or…
Keep reading
MySQL Status through mysqldump
You can easily run the following line at command prompt to retrieve the MySQL server uptime statistics along with the number of connected threads, the information regarding expensive queries, Queries per second on average, etc. In other words, it’s a quick and simple approach to determine the mysql instance’s state. C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqladmin -u…
Keep reading
Handling ENUM – Backup using mysqldump and navicat – MySQL
During the backup of MySQL database using mysqldump or during the data transfer using navicat, we do get the following error message if any of the table has a column defined with ENUM data type. If you ignore or skip this error message, you will end up with the truncated data or the column value…
Keep reading
EC2 AWS RDS – MySQLDump Generated Column Error
One of the errors encountered while restoring the MySQL backup created using mysqldump is as follows. I encountered it in my EC2 jump server that connects to AWS RDS. ERROR 3105 (HY000) at line 1238: The value specified for generated column ‘column1’ in table ‘table1’ is not allowed. My backup command: [ec99-root@ip-99-9-9-991 ~]$ mysqldump -h…
Keep reading
Big Data and SQL 