mysqldump : MySQL's Client Backup Utility

learn more… | top users | synonyms

1
vote
0answers
19 views

Mysqldump not working with SELECT, LOCK TABLES, SHOW VIEW, EVENT, TRIGGER privileges

My system: CentOS 6.5 + MySQL 5.6 I have created a backupuser for mysqldump: CREATE USER 'usr_backup'@'localhost' IDENTIFIED BY 'XXX'; GRANT USAGE ON *.* TO 'usr_backup'@'localhost' IDENTIFIED BY ...
0
votes
0answers
14 views

How to verify dumpedfiles.sql is taken correctly with no errors

I had a problem before on one of my servers, Database backup was taken using: mysqldump --single-transaction and one day i needed to restore the daily backup and found the dumpedfile.sql is ...
0
votes
1answer
43 views

Can't install mysqldump on Ubuntu

Another technician recently reinstalled our mysql on our LAMP-server and now I can't use mysqldump anymore. # mysqldump The program 'mysqldump' is currently not installed. You can install it by ...
0
votes
0answers
28 views

What is appropriate configuration for mysqldump to use as backup

There are some resources on how to dump databases using mysqldump (1, 2, 3 or 4) , but most of them are like "just mysqldump the whole thing". My mysqldump result differs from one I obtain from my ...
0
votes
1answer
47 views

How to use screen with mysql import

I need to import a very large MySQL table on remote server. Usually I'm using mysql -u mysql_user -pMypass db_name < sql_data.sql But it takes about 5 hours to complete the task. I tried using ...
1
vote
1answer
107 views

MariaDB 10.0 slow work mysqldump

i have 1.800(innodb) DBs in my MariaDB 10.0, 'mysqldump' work very slowly! If i run 'mysqldump' starts the process: "SELECT LOGFILE_GROUP_NAME, FILE_NAME, TOTAL_EXTENTS, INITIAL_SIZE, ENGINE , EXTRA ...
0
votes
1answer
35 views

Invalidating email addresses from sql dump before import

Synopsis I would like to import production data into the development environment so testing can be done in an almost accurate way. Of course I need to invalidate e-mail addresses as I don't want ...
0
votes
0answers
17 views

mysqldump --flush-logs - logs not flushed

I using this command on a loop to dump each db into a separate .GZ file. mysqldump -ubakup -ppasswd -hserver.edu --single-transaction --flush-logs --master-data=2 --routines --triggers --quick $fn | ...
0
votes
1answer
185 views

How do I connect to an AWS RDS with MySQL Workbench? [closed]

I've read this documentation and several other sources but to no avail: I cannot connect to my MySQL instance from MySQL Workbench. I can connect to my RDS instance through EC2, but I cannot dump ...
0
votes
0answers
24 views

Failures from MySQLDump

I'm using the following command to dump a mysql installation to disk one DB at a time: mysqldump -ubkp_user -ppasswd -hdbserver.edu --single-transaction --flush-logs --master-data=2 --routines ...
0
votes
1answer
51 views

Increase the speed of mysqldump

Are there any flags or tricks to speed up mysqldump for backups? Here is what we are currently using: mysqldump --skip-opt --flush-logs --routines --triggers --allow-keywords --create-options ...
0
votes
0answers
29 views

Ubuntu backup script kills performance

I run a nightly backup, which takes about 1 hour. During that the performance is bad as hell. It looks pretty much like this: # DB dump ionice -c 3 nice -n 20 mysqldump --skip-lock-tables --user=foo ...
2
votes
1answer
220 views

mysqldump error #1557: corrupt event table?

I just noticed the following error from my old mysql backup scripts: % mysqldump -hsql -uXXXX -pXXXX --events --all-databases > /dev/null mysqldump: Couldn't execute 'show events': Cannot proceed ...
1
vote
1answer
221 views

How to calculate the size of an AWS RDS instance from a MySQL dump?

We are importing a large historical database into RDS from a mysqldump The gziped sql file was 3GB, the uncompressed sql file is 18GB. We created a 30GB AWS RDS instance and imported the file... the ...
3
votes
0answers
86 views

Restore database by files from broken Ubuntu server

I'm pretty lost right now. The RAID controller auf my server broke and all attached hard drives were corrupted. Luckily I copied the plain files off the server right before the crash (phew). I set ...
0
votes
0answers
60 views

mysqldump over ssh and mysql restore - security issue?

I've just found a one liner to mirror a local mysql database on a remote server, over ssh: mysqldump -uroot -proot zedatabase | ssh -p4551 geek@12.34.56.78 "mysql -udoom -pmySqlPassword zedatabase" ...
0
votes
0answers
17 views

Access Denied to Database Information_Schema

I have an SQL dump that is around 70GB in size with over a thousand databases inside of it. I am attempting to import it via command line, however I receive the error message... Access Denied for ...
1
vote
1answer
35 views

Import SQL Dump from Command Line

I have an SQL Backup that has hundreds of individual databases inside of it. The backup is around 70GB in size and I have spent countless hours attempting to restore it on a new machine due to the ...
2
votes
2answers
755 views

Couldn't execute 'show events' on mysqldump

While trying to backup all MySQL databases with mysqldump I get the following error: Couldn't execute 'show events': Access denied for user 'user'@'localhost' to database 'performance_schema'
2
votes
2answers
95 views

mysqldump has a “quick” option. Why isn't this enabled by default?

In the mysqldump docs I see a "--quick" option, however there is no indication as to why somebody would want this disabled. What are the disadvantages to enabling it or why is it even an option? ...
1
vote
3answers
137 views

Running mysqldump on a debian system that has gone into read-only mode

An old Debian system of mine has recently had the primary hard drive go into read-only mode due to some disk problem. I have a MySQL database on the server that I would like to backup before trying ...
3
votes
1answer
525 views

How to avoid mysqldump warning “Skipping the data of table mysql.event”

After a recent Debian upgrade on my LAMP webserver to Wheezy, mysqldump is throwing a warning: -- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly. Events ...
0
votes
2answers
50 views

how to restore sql file?

I have 2 MySQL servers. Server A is up to date. I run the following on Server A: mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql on Server B I run: mysql -u root ...
-2
votes
1answer
30 views

What are the various ways to backup an MySQL server? [closed]

I am trying to figure out how someone backed up our database. We had a person working for us who was able to backup the database on a server without having mysql client or mysqldump installed on the ...
0
votes
1answer
172 views

How to run a mysqldump automated with SAFELY stored mysql credentials?

I'm looking for a way to SAFELY run daily backups using mysqldump. Safely means not storing username/password in a text file or any other unencoded format. I know there is (apparently it isn't) a way ...
3
votes
1answer
43 views

Is it safe to lock tables on a mysql replica slave?

I have a master mysql database where the application writes and read production data, and then I setup a slave database just in case something goes wrong with the master database server (and I can do ...
0
votes
2answers
461 views

mysqldump isn't able to export a specific database, phpMyAdmin crashes

I'm experiencing problems with a database on my server (Note: All other databases work fine). Once I try to export it with mysqldump I get this error: # mysqldump -u root -pXXXXXXXXX databasename ...
2
votes
1answer
550 views

MySQL “Zombie”-table, cannot delete

I have two MySQL servers, running master/slave replication. At one point i had to write huge general.log on the slave. I had the glorious idea to write it to the datadir of MySQL. Mock me. Later I ...
1
vote
1answer
68 views

How to properly migrate mysql server?

Currently I am dealing with server migration. I have mysqldump --all-databases dump, which contains also mysql and might be information schema databases. All I need is somehow safely and fast ...
0
votes
1answer
729 views

mysqldump ignore table with wildcard

I need to take a dump of a database containing 50 odd tables of which I want to exclude about 15 odd that have prefix 'exam_' I tried mysqldump --ignore-table=dbname.exam_* and even tried ...
-1
votes
2answers
144 views

mysqldump in cron not working [duplicate]

I am trying to do a mysqldump on the cron for every 5 minutes but it seems that it is not working. I try to execute the mysqldump and it works fine. mysqldump mysqldump -uroot -ppassword ...
0
votes
0answers
104 views

Mysql won't start after replacing data in datadir.

so I have a little problem. I had errors with our old system and was unable to backup the old databases properly so I went ahead and backed up the datadir which had all of the databases folders inside ...
0
votes
1answer
143 views

How to dump remote database without using mysqlDump

I have a similar problem from this question How to dump remote database without mysqldump? How ever when I run ssh -f L 3306:localhost:3306 user@remoteserver -N I am receive the following error ...
0
votes
1answer
26 views

Database replication with old data

I am using MySQL to accomplish Database replication. The replication process is works very well. What my problem is, the old record is not copied from the master database. Is there is any way to keep ...
1
vote
2answers
456 views

how to execute bash script with crontab in centos? [duplicate]

My bash file is not executed by cronjob created as root. The cronjob setup looks as it follows 0 0 * * * mysql_backup.sh does need to be decalared with the bash command 0 0 * * * bash ...
0
votes
2answers
49 views

Weird mysqldump behaviour

I'm trying to use mysqldump on a remote host. My local IP is 111.111.111.111, and the remote IP is 222.222.222.222 I run this command: mysqldump --host=222.222.222.222 -u user test_db This doesn't ...
1
vote
0answers
192 views

mysqldump not working/running via cron job

I have a crontask which runs at 1am every morning and dumps all databases. 0 1 * * * /var/backups/dumpit.sh 2>&1>> /var/backups/dumpit.log The dumpit.sh source: #!/bin/bash ...
0
votes
1answer
381 views

How Do I Restore a MySQL Database from Time Machine Backup?

I develop locally on a Mac, and my computer completely died yesterday. The hard drive is gone, apparently not recoverable. I have a current backup on Time Machine. So my question is: How exactly do ...
1
vote
1answer
59 views

Restoring mysql dumps from incrementals

This is probably bordering on a silly question, but if I recently restored a Full mysql DB dump via cat dump.mysql |mysql dbname to a new instance of mysql in order to migrate; and I want to restore ...
2
votes
1answer
199 views

automysqlbackup on cPanel server not ignoring eximstats

I am backing up my cPanel server databases with automysqlbackup, in /etc/automysqlbackup.conf I have set: CONFIG_db_exclude=( 'information_schema' 'cphulkd' 'eximstats' 'leechprotect' 'mysql' 'modsec' ...
0
votes
0answers
216 views

Migrate existing mysql server data to percona xtradb cluster

I currently have one server which is a mysql server. I want to get the data from it, into a new 3 node percona xtradb cluster i've set up. I am wondering if there's any alternatives to simply doing a ...
1
vote
1answer
272 views

MySQL ZRM restore failed with mysql error unknown command \0

I am restoring an incremental backup with ZRM server on mysql database. I am having blob data in the tables. The incremental backup not getting restored and giving mysql error unknown command '\0'. ...
1
vote
1answer
124 views

unable to restore mysql database, getting ERROR 1153 (08S01)

trying to restore pressflow database and getting this error, I even tried it with --max_allowed_packet, still getting same error: [root@6shdbm01 tmp]# mysql --max_allowed_packet=1024M pressflow < ...
0
votes
3answers
190 views

mysqldump --single-transaction with dump files separated by table?

Using mysqldump, how can I create a consistent backup of a MySQL (InnoDB) database and have the dump files be separated by table? To create a consistent backup using mysqldump, I know there is ...
0
votes
2answers
80 views

How to proceed setting up a secondary mysql linux slave?

I have a mysql database master and slave in production. I want to setup additional mysql slave. There is around 15 Terabyte of data in the database and there are MYISAM and InnoDB tables in the ...
0
votes
3answers
99 views

MySQL backup and save in external server

I have MySQL 5 installed in a Ubuntu server. I want backup the database for: latest 7 days weekly and store those backups in another server. I prefers the tool runs in the same server that host ...
1
vote
1answer
265 views

Making a mysql dump causes web application to hang.

Can the following command on a live server mysqldump -h XXXX -u root -pXXXXX --skip-opt --flush-privileges --flush-logs --routines --triggers --allow-keywords --create-options --add-locks ...
0
votes
1answer
92 views

Is it possible to dump a postgresql db and restore it in mysql?

I'm trying to get migrate data from a postgre db into mysql (mariaDB) and was wondering if it is possible to restore a db in mysql from a pgsql dump?
-3
votes
2answers
153 views

crontab -e on Red Hat 4.1.2-48 [closed]

The following command on crontab does not work at all. 0 12 * * * mysqldump -hserverhpost -uuser -ppass db > /path/to/backu/$(date +%d-%m-%Y) I read extensively about this and i cannot see what ...
1
vote
2answers
2k views

MySQL lost connection error on mysqldump

I have a 1 TB MySQL database that I'd like to dump and reload. Most of the data is in one table. A lot of data has been deleted, so I'm pretty sure if I dump it with mysql, rebuild the database, ...