Top "Mysqldump" questions

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

Can't gzip my mysqldump on the command line windows

I'm trying to make a back up of my MySQL db and zip the file. Every time I try to …

mysql command-line mysqldump sqlcommand
Backup MySQL Amazon RDS

I am trying to setup Replica outside of AWS and master is running at AWS RDS. And I do not …

mysql amazon-web-services mysqldump amazon-rds
How to import a mysqldump into Pandas

I am interested if there is a simple way to import a mysqldump into Pandas. I have a few small (~110…

python mysql pandas mysqldump pandas-datareader
MySQL data export changes times

I have some backup and restore scripts that I am using for my database. The table has a timestamp field. …

mysql timezone mysqldump mysqlimport
how can I migrate the database dump of MongoDB into PostgreSQL?

I replicate the application using the database as postgresql but later on I came to know that application was using …

mongodb postgresql ruby-on-rails-4 mysqldump rails-postgresql
Can MySQL reliably restore backups that contain views or not?

Environment: Ubuntu 11.10, MySQL 5.1.58 I have a small database with views. When I try to dump and restore, I get ERROR 1356 (…

mysql mysqldump mysql-management
Error 1142: SELECT and LOCK TABLE commands denied

I reinstalled the server running MySQL. I had created a backup of the database by using MySQL Workbench. Now I'm …

mysql mysqldump mysql-workbench mysql-error-1142
MySQL restoring a database via mysqldump - Does it overwrite the different destination tables?

I am using mysqldump to backup a database containing several tables (say tables D, E, F). I use the following …

mysql backup mysqldump restore
mysqldump exporting data in a bad character set

Yesterday for the first time I exported my Mysql database and I found some very strange characters in the dump …

mysql utf-8 character-encoding mysqldump latin1
mysqldump via SSH tunnel

I have a server setup as follows: webserver (gateway machine, accessible from the Internet via SSH) dbserver (database server, not …

ssh backup mysqldump tunneling