Tagged Questions

mysqldump : MySQL's Client Backup Utility

learn more… | top users | synonyms

0
votes
1answer
21 views

Pipe multiple files into one tar gz

I'd like to call mysqldump to create multiple backup files and then archive them in one tar.gz. I am following this tutorial on mysqldump part: ...
0
votes
2answers
46 views

Can I restore the “mysql” system database along with another from a mysqldump backup?

Basically, what I did is: mysqldump -uroot -pxxx <some_options> --result-file Backup.sql --databases mysql customappdb Is it sane to later do mysql -uroot -pxxx < Backup.sql Or do I ...
-3
votes
1answer
50 views

Dump all DB with Bash Script in separate files [duplicate]

I would like to easily dump all my DB without typing same stuff many times ... (I'm a dev and I have a lot of DB on my local machine ) Any Simple scripts that comes to your mind ?
0
votes
0answers
40 views

MariaDB mysqldump fails on tables with underscores

mysqldump -u root -pvagrant --skip-lock-tables --no-data databasename is giving me this: mysqldump: Couldn't execute 'show table status like 'view\_admin\_mu\_list\_view'': SELECT command denied to ...
0
votes
1answer
43 views

Most reliable MariaDB to Postgres dump method

I am in the process of migrating an app to another server, and will need to migrate the database contents from MariaDB to Postgresql. Most documentation indicates that the following format should ...
0
votes
0answers
78 views

How to restore a corrupted MySQL master database from a slave database?

I recently discovered that the master db in a setup I'm running became corrupted. The slave was getting all of the data correctly so I have a solid backup. What I'd like to do is use replication to ...
-5
votes
1answer
35 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
46 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
50 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
81 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
64 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
312 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
143 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
69 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
369 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
267 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
19 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
678 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
56 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
119 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
301 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
68 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
68 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
1k 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
38 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
176 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
45 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
1k 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
1k 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
147 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
187 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
27 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
61 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
254 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
300 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
2k 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
51 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
241 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
83 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
817 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
934 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
76 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 ...
0
votes
2answers
366 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
246 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
191 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
35 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
2k 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 ...