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
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 ...
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
184 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
3answers
109 views

MySQL backup and save in external server

I have MySQL 5 installed in a Ubuntu server. I want backup the database for: latest 7 days weekly and store those backups in another server. I prefers the tool runs in the same server that host ...
1
vote
1answer
354 views

rsnapshot - not correctly archiving mysql databases

My rsnapshot configuration: snapshot_root /.snapshots/ backup /home/user localhost/ backup_script /usr/local/backup_mysql.sh localhost/mysql/ Using this file: NOW=$(date ...
0
votes
2answers
557 views

How to delete older dump in automysqlbackup.sh

I use with success automysqlbackup.sh script. All is fine. Dump's are rotate in daily/weekly/monthly folders. But is it the option to delete dump older than 3 month or sth. like that? I tried to found ...
0
votes
2answers
102 views

Disallowing certain user from dumping database (MySQL)

Under the privileges that can be assigned to a user, I can't find whether to allow or disallow a user from being able to dump a database. I want to disallow a user from taking backup of a database.
1
vote
1answer
200 views

Does Zmanda support backup Event Scheduler?

I've been digging up the Zmanda Wiki, but cannot find out any option to backup the event scheduler (--events, -E). Does Zmanda support it?
1
vote
1answer
323 views

will mysqldump lockout select or read only based queries

i have a large database to backup nightly and we currently do mysqldump on the master server which locks all inserts when dumping we use a master slave mysql setup with magento configured to send all ...
2
votes
2answers
1k views

How to dump a mysql database and transfer to remote ftp in one line -for crontab-?

I need to do a weekly backup of a mySQL table and then transfer it to a remote machine using ftp. This is the command I have now in crontab: 0 18 * * 1 /usr/bin/mysqldump --add-drop-table ...
2
votes
1answer
175 views

Is it safe to backup crashed MySQL table?

The cache table (MyISAM) marked as crashed. Is it safe to backup before repair? (I'm worried if the repair process gone wrong)
8
votes
2answers
9k views

How do I create a read only MySQL user for backup purposes with mysqldump?

I'm using the automysqlbackup script to dump my mysql databases, but I want to have a read-only user to do this with so that I'm not storing my root database password in a plaintext file. I've ...
1
vote
1answer
289 views

How to backup MySQL (mysqldump) when Memcached installed?

The server OS is CentOS, with Memcached installed Before Memcached installed, I use mysqldump -u root -p --lock-tables --add-locks --disable-keys --skip-extended-insert --quick wcraze > ...
1
vote
3answers
278 views

MySQL Backup and Recover

I have been running mysqldump on my set of MySQL databases (MyISAM and INNDOB). Recently I wanted to restore the databases to another server, and so I created the databases and imported the dump file. ...
0
votes
3answers
1k views

Making a simple MySQL backup script to be run via cron, having permissions issues

This is a very basic mysqldump script that will do a dump and store it locally. Running mysqldump by itself works fine as does gzip (i.e. they are where they need to be in my path) ...
1
vote
2answers
582 views

Mysqldump stopping website service during backup process

I have a website running on a MySQL database backend which is backed up daily by the following command: mysqldump -h server.com -uuser -ppass database > /home/directory/backup`date +"%Y%m%d"`.sql ...
1
vote
5answers
362 views

Do I need to bring my website down just in order to use mysqldump?

I have a LAMP website with mysql backend with InnoDb engine for tables I would like to be able to use mysqldump to take periodic dumps of the database - WITHOUT having to stop the mysql server (i.e. ...
1
vote
4answers
361 views

Shell MySQL Backups - What's your solution?

I'm looking for a great solution to backup my MySQL databases - all of them. I'd like each one in at least it's own file. I need FTP ability later, but not right now. Right now I just need it to ...
0
votes
1answer
483 views

Populate a remote databse using MySQL Workbench and remote .sql file

I'm using MySQL Workbench 5.2 CE, and I try to figure out how to populate or restore a mysql_dump.sql file uploaded to the root of my domain (./mysql_dump.sql). Since the file is a little bit ...
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 ...
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 ...
1
vote
5answers
930 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 ...
1
vote
1answer
831 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. ...
3
votes
1answer
240 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 ...
0
votes
2answers
138 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 ...
1
vote
2answers
378 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 ...
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 ...
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 ...
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
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 ...