mysqldump : MySQL's Client Backup Utility

learn more… | top users | synonyms

1
vote
1answer
608 views

Migrating master-slave MySQL database servers to 2 new servers, any tips or suggestions?

I'm setting up 2 new database servers that will be replacing a current master-slave setup. All boxes are running / will be running MySQL on RHEL. Our current naming conventions: db1 - master ...
6
votes
4answers
9k views

How to dump remote database without mysqldump?

I want to dump the database on my remotely hosted site in regular intervals using a shell script. Unfortunately the server is locked down pretty tight, has no mysqldump installed, binary files can't ...
2
votes
1answer
394 views

MySQL: Auto-increment value: 0 is smaller than max used value: xx

Increasingly I'm getting tables having to be repaired dwith the message returned of: Auto-increment value: 0 is smaller than max used value: xx This has happened on tables with 200 rows and tables ...
1
vote
5answers
966 views

How to backup database dumps which only minor changes between the backups?

I have a posgresql dumpfile every night and i like to keep every one of them. Each is 14 GB in size, so my backupdrive will be full soon. The difference from one day to another are only some 100MB. ...
3
votes
3answers
2k views

How to properly backup mediawiki database (mysql) without messing up the data?

I want to backup a mediawiki database stored in a MySQL server 5.1.36 using mysqldump. Most of the wiki articles are written in spanish and a don't want to mess up with it by creating the dump with ...
2
votes
1answer
3k views

mysqldump doesn't create tables or import any data

I am trying to import a mysqldump into a new database. When I run: mysqldump -umydbuser -p --database testimport < database.dump I get the following output: Enter password: -- MySQL dump 10.11 ...
1
vote
1answer
863 views

MySQL equivalent to .pgpass, or automatic authentication in a cron job for mySQL

I'm writing a bash script to back up my databases. Most are postgresql, and in postgres there's a way to avoid having to authenticate by creating a ~/.pgpass file which contains the postgres password. ...
0
votes
1answer
235 views

Sequential MySQL dumps and overwriting updated data

I'm looking to do MySQL dumps on a nightly basis. I already have a solution for outputting just a diff of the data, but what I need is a way to import the data back into MySQL so the data in MySQL is ...
5
votes
10answers
2k views

trouble backing up large mysql database

I have a wordpress MU database with something like 10,000+ tables for various user's blogs. I need to upgrade wordpress MU to newest version, but want to backup the DB before hand. PHPMyAdmin fails ...
3
votes
4answers
2k views

mysqldump --where with = operator doesn't get all rows

I have a situation with a particular table that now thinks it contains 4 Petabytes of data. I know that sounds cool, but I assure you, it is only on a 60GB partition. This table has 9 fields in it. ...
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 ...
3
votes
1answer
246 views

File (FRM) not found? Cant view the tables?

I have 2 version of database backup. Mysqldump > db_backup.sql & FRM files (tables files) The db_backup.sql file is corrupted; it is 0 KB. I think I can't help with it anymore. Now I ...
2
votes
2answers
609 views

Mysql dump from old server

I have to clean up as mess for a client. The DNS record of the domain has been moved to a different server (IP address). But I need to retrieve MySQL data from the old server. I still have the ip ...
16
votes
2answers
12k 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 ...
0
votes
2answers
143 views

MySQL data disappearing after restoring from backup

I recently had to move from one hosting provider to another (if you're in the UK don't use Easyspace for your VPS!) as my previous host dumped my server without warning. Fortunately I had remote ...
3
votes
3answers
4k views

Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table

I'm getting the above mentioned error when backing up with ZRM, which is using mysqldump for backup. mysqldump --opt --extended-insert --single-transaction --create-options ...
1
vote
2answers
417 views

How to restore just ONE mysql database from a collective backup

I have a scheduled mysqldump task that uses the --all-databases option. This includes all databases in one file. How can I tell mysql to import ONE of the databases contained in the dump file? -M ...
2
votes
3answers
2k views

MYSQL backup and restore

I am having trouble getting mysql backups to run properly when their are views in the database. I think this might have something to do with needing a placeholder object for it. In any event I run ...
1
vote
2answers
749 views

Get to know error and error codes of Mysqldump

I would like to back up our mysql database. We have huge records in the database. What are the errors can occur and possible while running mysqldump.? Mysql official site did not mention the specific ...
0
votes
2answers
661 views

mysqldump, myisam, and read local

When mysqldump is run with --lock-tables against a database using MyISAM tables, the documentation states that each table is locked with READ LOCAL. As I understand it, READ LOCAL allows for ...
1
vote
2answers
885 views

How to install/enable ftpcopy binary and mysqldump binary on WHM cPanel

I'm running WHM and cPanel and have a script that requires the following ftpcopy binary (for Create/Refresh local FTP mirror) mysqldump binary (for Create local SQL mirror) And I need to ...
4
votes
10answers
4k views

how to complete mysql daily backup dump without timeouts?

what is best way to complete daily Mysql database backup, we are having critical mysql database connection timeouts during backup dump we use dump and gzip cron has a line: 1 1 * * * root nice ...
0
votes
3answers
2k views

ERROR when restoring MySQL data dump

I am getting the following error when attempting to restore a MySQL data dump to a different server and a different MySQL version ... ERROR 1064 (42000) at line 14165: You have an error in your SQL ...
0
votes
2answers
2k views

MySQL differential dump? Other strategy for restore?

Is it possible to generate a differential dump with mysqldump - between two databases, or, ideally, between a database and a dumped version of that database? Here's the issue I've got - I have an ...
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 ...
1
vote
2answers
865 views

What is the easiest way to move mysql from linux box one my local Vista box?

I am fairly new to mysql...be gentle. I am trying to move mysql db from linux box to windows box where I do all the development. Can someone tell, or reference me, how to do it step by steps? ...
0
votes
2answers
1k views

Automated WHM MySQL backup not working

I am using WHM's automated backup system to make daily backups of my database. I have it set that it only makes a backup of what has changed. I've had this running for a while now and thought it was ...
1
vote
1answer
102 views

Backing up Mysql – indexes and restoring them on a different computer

I have spent most of the day optimizing a Mysql 5.0.x database – now I need to get the changes on to the production server How do I make a backup of table’s index settings and then restore them on ...
1
vote
1answer
2k views

mysqldump for UNIX domain socket

I have setup a new mysql database with my webhosting provider and the hostname is not the default localhost it is localhost:/tmp/mysql5.sock I think this is becuase they are moving from mysql 4 to ...
4
votes
1answer
5k views

mysqldump: Got error: 1066: Not unique table/alias: 'foo' when using LOCK TABLES when lower_case_table_names=1

I'm trying to dump a MYSQL DB on a linux server (Centos 5.2 32bit, MySQL 5.0.45) In /etc/my.cnf the following value is defined: [mysqld] lower_case_table_names=1 When I try and do a dump with ...
19
votes
5answers
5k views

Minimum permissions for a user to perform a mysqldump?

I want to start scheduling remote mysqldump crons, and I'd prefer to use a special account for that purposes. I want to grant that user the minimum permissions for getting a full dump, but I'm not ...