mysqldump : MySQL's Client Backup Utility

learn more… | top users | synonyms

1
vote
1answer
1k views

Mysql - innoDb - is in the future! Current system log sequence number

I have this error in my syslog. I restored an older dump to solve this problem, after some reading. Now The errors in syslog are far less than before. But still a few times an hour I get Sep 1 ...
0
votes
1answer
848 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 ...
-3
votes
1answer
28 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
25 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
28 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
33 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
3answers
14k views

What causes the MySQL error 1062 - duplicate entry when starting slave?

MySQL Master version: 5.5.16-1 MySQL Slave version: 5.5.18-1 The master's snapshot is created by: mysql> FLUSH TABLES WITH READ LOCK; shell> mysqldump --all-databases --master-data > ...
-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 ?
1
vote
2answers
246 views

Better alternative to mysqldump [closed]

Is there a better (free) alternative to mysqldump? Because lately i'm having problems with corrupted database dumps. Mysqldump creates faulty sql code and when trying to restore the DB it fails with a ...
0
votes
1answer
44 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
10
votes
3answers
13k views

Can't backup the mysql table with mysqldump. SELECT,LOCK TABL command denied for 'cond_instances'

I am having trouble running mysqldump as the mysql root user. When I try to backup the mysql table I get this error: mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user ...
0
votes
0answers
48 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
79 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
55 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: ...
0
votes
2answers
2k views

MySQL dump, output each table row on a new line whilst using --extended-insert

I'm having an issue, where for ease of use, I'd like to be able to format a command line MySQL dump so that each row of a given table is on a new line when using the --extended-insert option. Usually ...
1
vote
4answers
274 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 ...
1
vote
2answers
1k views

Error code 1005 (errno: 121) upon create table while restoring MySQL database from a dump

I have a linux prod machine and a Win7 64bit dev machine. My workflow includes dumping the production MySQL database on the linux machine and restoring it in my local MySQL database on the windows ...
0
votes
1answer
141 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
60 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
1k views

Unknown command error while restoring database from MySQL dump

I am using MySQL 5.1.36. While importing form a MySQL dump I am getting the following error. The 'max_allowed_packet' size is set to 100M in the my.cnf. ERROR at line 1647: Unknown command '\''. Can ...
1
vote
2answers
283 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* ...
3
votes
5answers
3k views

Incremental MySQL Backup using Subversion

Our MySQL database servers host several dozens of databases, with dump file size ranging from 1 to ~100 MB. Currently, our backup approach is mysqldump, wrapped in a shell script, and run from a ...
3
votes
1answer
137 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 ...
4
votes
5answers
1k views

MySQL, is there a way to tell when was database last changed/modified?

I'm creating MySQL dump of 5 databases every hour. 3 of those databases very rarely change, so creating a MySQL dump for those 3 dbs is pretty much a waste of time and resources. Is there a way I can ...
1
vote
0answers
239 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 ...
1
vote
3answers
7k views

How do I dump view schemas for a MySQL database?

I have a MySQL database for which I wish to dump schemas for views. How do I do this? I tried mysqldump with --no-data, but that only dumps table schemas.
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
564 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
53 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 ...
16
votes
2answers
11k views

Out of resources for mysqldump

I'm trying to do a mysqldump on a Windows server and I get the following error message : mysqldump: Got error: 23: Out of resources when opening file '.\db\sometable.MYD' (Errcode: 24) when using ...
1
vote
1answer
262 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
107 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 ...
0
votes
1answer
953 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 ...
1
vote
3answers
2k views

Howto: mysqldump cron on godaddy

I have a MySql database that I want to backup to a file daily. (Which I will later download for off-server backup). I have set up the following command in my crontab (ran daily): mysqldump -–opt -Q ...
0
votes
1answer
62 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
63 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
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 ...
3
votes
2answers
12k views

How do I ignore errors with mysqldump?

When dumping a database, I'm getting mysqldump: Couldn't execute 'show create table `some_table`': execute command denied to user 'some_user'@'%' for routine 'some_routime' (1370) and then the ...
0
votes
1answer
154 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 ...
13
votes
5answers
8k views

How can I speed up a MySQL restore from a dump file?

I am restoring a 30GB database from a mysqldump file to an empty database on a new server. When running the SQL from the dump file, the restore starts very quickly and then starts to get slower and ...
0
votes
2answers
3k views

MySQL Tables Missing/Corrupt After Recreation

Yesterday I dumped my MySQL databases to an SQL file and renamed the ibdata1 file. I then recreated it and imported the SQL file and moved the new ibdata1 file to my MySQL data directory, deleting the ...
0
votes
0answers
43 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 ...
0
votes
1answer
1k views

Restoring MySQL dump - ERROR 2006 (HY000)

I am just trying to restore a mysql dump. Below are the command and error message. Can anybody give me some clues how to approach this? 10:54:16 Restoring ...
1
vote
1answer
859 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 ...
2
votes
1answer
916 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 ...
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
0answers
128 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
55 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'