mysqldump : MySQL's Client Backup Utility

learn more… | top users | synonyms

-5
votes
1answer
33 views

MySQL : How dump is works? [closed]

I have a 10GB database and the dump takes just a few minutes. I want to know how the system of dump works ? Someone can tell me ?
0
votes
1answer
39 views

Mysql database restore

My mysql backup is running everyday at 4 am & accidently my database got corrupted at 7am. Now how to restore data updated between time period of 4am & 7am
0
votes
0answers
36 views

Options to include with mysqldump when taking backup of hybrid databases

I'm planning on taking backups of all MySQL databases on a remote production server. The combined database size is around 2 GB. Most of the tables are InnoDB ~1.8 GB and the rest are MyISAM. Now I've ...
2
votes
2answers
76 views

Two databases synced backup

I got a system that need two databases to work. I need a script to backup both databases at given point of time. I need databases to be in sync, so I need to be sure that backup does not allow changes ...
0
votes
1answer
45 views

Parallel mysqlimport Syntax Wrong?

I'm trying to import a large 70GB+ database (all InnoDB) using mysqlimport. This is a development system on Windows using WAMP server. MySQL 5.6.17. I'm getting the following error: mysqlimport: ...
1
vote
4answers
245 views

Logrotate appends “1” at the end of compressed file

I have a script which runs as a cronjob every 30 mins and takes mysqldump of some tables. The dump files are stored in /var/log/ as ...
0
votes
1answer
107 views

trouble running mysqldump on Ubuntu via cron job

I'm trying to set up a cron job to back up my database every night at midnight. Based on a few tutorials I've read, I've written a script that executes the following command: mysqldump -u my_username ...
-1
votes
1answer
43 views

How can i use my local mysqldump through ssh tunnel

I would like to dump a mysql-database with mysqldump. But: This command isn't installed on the remote server. It is possible to use my local mysqldump command, to connect via an ssh tunnel to achieve ...
1
vote
2answers
208 views

Server 2012 Scheduled Task CMD mysqldump not doing what is intended

I'm running a batch file to back up some mysql databases on a 2012 webserver. The batch file creates a folder, then runs the following for each db: mysqldump -u *username* -p*Password* *db_name* ...
1
vote
0answers
179 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
16 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
451 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
48 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
95 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
218 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
55 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
58 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
761 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
36 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
130 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
38 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
759 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
720 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
1answer
124 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
88 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
25 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
46 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 ...
3
votes
2answers
2k 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
182 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
239 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 ...
4
votes
1answer
1k 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
33 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
208 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
68 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 ...
1
vote
2answers
683 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
815 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
75 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
2k 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
268 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
215 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
181 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
33 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 ...
2
votes
2answers
1k 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
54 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
201 views

mysqldump not working/running via cron job [duplicate]

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
724 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
61 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
252 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
325 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 ...