mysqldump : MySQL's Client Backup Utility

learn more… | top users | synonyms

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 ...
1
vote
1answer
2k 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
792 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
228 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
224 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
554 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 ...
15
votes
2answers
10k 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
133 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
365 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
741 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
651 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
847 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
3k 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
706 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
100 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
4k 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 ...
18
votes
5answers
4k 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 ...