Top "Mysqldump" questions

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

How to use mysqlimport to read in result of mysqldump --databases

I have successfully dumped an entire MySQL database using mysqldump --databases generating a nice .txt file. However, I can't see …

mysql mysqldump mysqlimport
mysqldump with db in a separate file

I'm writing a single line command that backups all databases into their respective names instead using of dumping all in …

bash awk backup mysqldump
mysqldump extracting data without table structure

I'm trying to dump all of my mysql data for one database into a single file. That said, I don't …

mysql mysqldump database-backups
Where I can find a list of "mysqldump" exit codes?

I know that exit code = 0 means No error. I got exit code = 2. What does it means ? Where I can see …

mysqldump exit-code
How to copy a database with mysqldump and mysql in Python?

I am writing a simple Python script to copy a MySQL database. I am attempting to copy the database based …

python mysql subprocess mysqldump pymysql
Using mysqldump to format one insert per line?

This has been asked a few times but I cannot find a resolution to my problem. Basically when using mysqldump, …

mysql mysqldump mysql-workbench mysqladministrator
How do I restore one database from a mysqldump containing multiple databases?

I have a mysql dump with 5 databases and would like to know if there is a way to import just …

mysql database import mysqldump restore
InnoDB tables exist in MySQL but says they do not exist after copying database to new server

I used mysqldump to export my database and then I imported it into MySQL on my other server. I can …

mysql innodb mysqldump mysql-error-1146 my.cnf
Edit very large sql dump/text file (on linux)

I have to import a large mysql dump (up to 10G). However the sql dump already predefined with a database …

linux mysqldump large-files
How can I download db from heroku?

I'm using heroku and I want to download the database from my app(heroku) so I can make some changes …

postgresql heroku mysqldump heroku-postgres