0
votes
1answer
26 views

how to use mysql database replication to backup a single database

Suppose I want to replicate a single database in mysql on my slave, the master might be creating and writing to multiple databases. is this possoible? or does the replication slave have to replicate ...
0
votes
1answer
51 views

How many incremental backups to keep with Percona xtrabackup?

I'm looking to replace an aging and decidedly suboptimal mysqldump-based database backup strategy with Percona's Xtrabackup. This all looks pretty straightforward, except that I'm wondering: how many ...
0
votes
1answer
68 views

s3cmd: on-the-fly backup

To do backups I created a script that makes an archive of all the folders I need to backup, sends it to S3 (through s3cmd) and then deletes it after upload has been completed. I'm looking for a way ...
1
vote
1answer
263 views

Percona XtraBackup: Getting an error regarding “Too many open files”, how can I solve this issue?

I'm trying to backup using Percona XtraBackup and getting the following error: [root@ads-dev1 ~]# innobackupex /root/db InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy and ...
0
votes
1answer
52 views

MySql Replication Stored to Central Database

Hi I maybe looking with the wrong terminology. But i have a situation where i need to replicate / copy data to a centralized database. Shop1.dbshop - > Central.dbshop1 Shop2.dbshop - > ...
0
votes
2answers
66 views

What is the best/most secure way to download/send/keep offline backups?

I have a small app that uses MySQL. I'm on a small Ubuntu box using Apache on Digital Ocean. In case anything ever goes wrong, I would like to have something that periodically sends me or downloads in ...
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
2answers
129 views

how to pipe a mysql dump to s3cmd

I want to transfer a mysql dump, compressed, to s3. I tried: mysqldump -u root -ppassword -all-databases | gzip -9 | s3cmd put s3://bucket/sql/databases.sql.gz but then I get: ERROR: Not enough ...
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 ...
2
votes
5answers
137 views

MySQL DB Backups: Lockless, Per-Table Restore, MyISAM/InnoDB

The Problem I'd like to implement a MySQL backup strategy on a dedicated server. It has multiple databases on, combined total is about 150GB. Most of this is weighted toward one of the databases. ...
2
votes
1answer
389 views

Percona Xtrabackup incremental backup based on prepared full backup

I want to create an hourly backup of our MySQL database to a staging system using Percona XtraBackup. Is it possible to prepare the $BACKUPBASE and then use this prepared backupbase as base for the ...
3
votes
1answer
103 views

SSH port forwarding to a host that needs to contact a third named host to access MySQL

We customize and support standard web applications that our customers host on managed servers from different web hosters. Usually, the application consists of a web application in PHP and a database ...
0
votes
1answer
84 views

Bacula Backups Failing with Duplicate Primary Key Error

All of my Bacula backups started failing over the weekend with the following MySQL error: Fatal error: sql_create.c:XXX Fill File table Query failed: INSERT INTO File (FileIndex, JobId, PathId, ...
-2
votes
2answers
82 views

is there any auto backup of mysql database? [closed]

Unfortunately I have lost some part of my data (a field of table) in a mysql database on a linux server and my backup is old I want to know is there any solution to recover that table?
0
votes
0answers
64 views

disconnect and reconnect node from percona xtradb cluster

I have a Percona Xtradb Cluster with 3 nodes. Which is the best way to disconnect and reconnect 1 node from the cluster with the node still working? Some suggestions include clear wsrep_provider or ...
1
vote
1answer
119 views

How to monitor regular MySQL backups.

I am a developer and I am discussing with my sysadmin how to backup the MySQL database we are using. The previous sysadmin told me he had started backing up the database, but the new guy, who isn't ...
0
votes
1answer
297 views

innobackupex - after restoring - quit without updating PID file

After restoring a backup the server can't start.. command line tar -izxf /var/bak/db/2013-11-16-2300_mysql.tar.gz -C /var/bak/db_import innobackupex --defaults-file=/var/ini/my.cnf --use-memory=1G ...
0
votes
2answers
107 views

Restoring MySQL backup from disk image

I recently flubbed a query and nuked a table in MySQL. I also realized that I don't have a cron doing a nightly SQL dump. But I do have a nightly disk image, which I've restored and mounted on the ...
1
vote
2answers
2k views

Centos backup mysql using cron job

According to this tutorial http://www.a2hosting.com/kb/getting-started-guide/backing-up-your-data/backups-on-dedicated-servers-and-vps trying to backup mysql database I did: 1) created folders in ...
0
votes
1answer
59 views

How to run a safe, responsible, fast MySQL backup

I've been tasked with assorted maintenance of a DB. I have very little experience with MySQL, so pardon any ignorance :) Two (well, four) related questions: The DB is supposed to be replicated to a ...
1
vote
3answers
1k views

How can I run a Cron job to make backups of a MySQL server by SSH

I have a production server running CentOS with a MySQL database. At home, I have a QNAP NAS (runs a little embed linux). I want to make a Cron job on my NAS to backup the data from my CentOS ...
2
votes
2answers
69 views

Segmenting mysql backups using tar

In addition to using mysqldump, I've been backing up my mysql server by tarring up /var/lib/mysql for redundancy and convenience. This directory includes ibdata, ib_logfile0, and ib_logfile1 as well ...
-5
votes
1answer
44 views

How much memory will this PHP Script need? [duplicate]

I'm trying to use a WordPress Plugin to backup my database and files but it keeps running out of memory. How much memory will this script need to finish and how much should I ask for from my hosting ...
-1
votes
1answer
147 views

Backup/Recovery like barman for MySQL [closed]

I'd like to have a Backup/Recovery tool for MySQL (MariaDB/Percona) servers which has somehow the same features as barman has for postgresql take full backups on a regular basis (xtrabackup, but ...
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 ...
1
vote
2answers
536 views

automysqlbackup - dumped files permissions

I'm using automysqlbackup, here is the default cron entry created #!/bin/sh test -x /usr/sbin/automysqlbackup && /usr/sbin/automysqlbackup My files are stored here ...
1
vote
1answer
583 views

automysqlbackup then rsync

I'm trying to configure an automatic MySQL backup solution under an Ubuntu server. I have chosen automysqlbackup and rsync for this purpose (does it seem to be a good choice ?) rsync will be used in ...
1
vote
1answer
195 views

Mysql incremental backup and point in time recovery

I have a requirement for doing Incremental backup of MySQL database. For which I'm writing a shell script using the concept of binary logs. Now, the scenario is such that a full-backup will happen ...
1
vote
1answer
83 views

MySQL InnoDB Backup: are dump files enough?

What exactly does the default ibdata1 file store that does not exist in a mysqldump? I've got a backup/rsync job that stores dump files of a MySQL 5.5 database on a remote server for rotating ...
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
2answers
310 views

How do I take backup of mysql databases from my crashed server

I have linux server running Fedora 5. My server is crashed now and I can not access mysql. But I can still have access to my hard disk. Since It is crashing again and again now I really want to ...
1
vote
3answers
401 views

Hourly database backup

I have a VPS with Kloxo control panel, I want to have database backup from one of my websites in every 2 hour. How i can do this? Kloxo doesnt support Hourly backups, only support daily, weekly and ...
0
votes
1answer
243 views

Upload database backup from mysql to Amazon S3 or Glacier without creating local file

Is there a tool that makes possible to backup a Mysql database to Amazon S3 or Amazon Glacier without having o create a local file with the database contents? Something like that: mysqldump -u ...
0
votes
1answer
989 views

location of mysql database files when using direct admin to create the databases

I would like to know where the database files are located when using directadmin. I use phpmyadmin to create the databases. When I check /var/lib/mysql directory I cannot see the database I created. ...
0
votes
1answer
630 views

Restore mysql databases that is created using direct admin

PS: I'm sorry my description is a bit long. I am just trying to give all the information. At first, I was not able to login to direct admin. I research on the web on what are the causes and found out ...
0
votes
1answer
140 views

Centos VPS server backup

I have a quick question. I would like to create a backup of my entire centos VPS, including mysql. Would this work? tar -zcvpf /backup/testbackup.tar.gz --directory / Can I restore a tar backup by ...
0
votes
2answers
146 views

MySQL Backup - incremental

I know that you can use mysqldump. I am currently dumping the following way: ${MYSQLDUMP} --single-transaction -u ${MUSER} -h ${MHOST} -p${MPASS} $db | ${GZIP} -9 > $FILE From my understanding ...
1
vote
1answer
277 views

Backup files with backup-manager are empty

On my ubuntu server I use from long time backup-manager to dump and backup on FTP all MySQL databases, everything worked like a charm form this time. All of a sudden the backups files are empty. I try ...
1
vote
1answer
86 views

Is it safe to use password in script to backup database of remote server?

Currently, Im using a small script to automatically backup my database (of a webserver). To backup the database, I have created a user account with only read and lock privilages. The script will use ...
0
votes
1answer
277 views

Using rsync to make daily backups every 24hrs

I would like to backup /home/* /root/* and mysql databases to a set of RAIDed drives. Performance wise I want to do incremental backups. Would this be the idea? rsync -al /home ...
0
votes
2answers
556 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 ...
2
votes
2answers
93 views

Backing up Entire MySQL Directory

In regards to: Remounting MySQL under a new mount point What would be the best way to backup MySQL data before moving the mount point? Can this be done with MySQL running? Would a simple rsync off ...
2
votes
0answers
25 views

Percona backup to different database name [duplicate]

Possible Duplicate: MySQL: How to backup and restore using different schema name using xtrabackup I'm using percona backup tool Xtrabackup for backing up different MySQL server, right now I ...
1
vote
3answers
2k views

Bash script for mysql backup - error handling

I'm trying to backup a bunch of MyISAM tables in a way that would allow me to rsync/rdiff the backup directory to a remote location. I've came up with a script that dumps only the recently changed ...
2
votes
2answers
769 views

backing up MySQL living on a SAN using LVM snapshots. is this doable?

So I was looking into LVM snapshots and it seems like a feasible method for backing up mysql so that it's at least crash consistent. My issue is that I have mysql servers where the mysql data ...
2
votes
2answers
671 views

Setting automatic backups of MySQL database including table lock etc - MySQL Workbench?

We've got a Virtual Server with full ssh and root access running LAMP on Ubuntu Server. I've got a small computer in the office running ubuntu that isn't being used for anything. I thought I should ...
0
votes
1answer
410 views

Ubuntu automysqlbackup configure to have separate databases in one folder with gzip

I have automysqlbackup running on Ubuntu 10.04 and it works perfectly fine. I currently have it performing daily backups for all databases, but I would like to adjust the configuration to do the ...
0
votes
0answers
161 views

Best way to backup Apache server vhosts and MySQL DBs

I want to keep a backup of my apache servers vhosts and MySQL databases without having to go into mysqladmin and do it manually and ftp downloading the domain which is what I do now. Is there some ...
0
votes
1answer
97 views

MySQL hot backups on database inside a Virtuozzo container

R1soft's CDP doesn't currently work on MySQL databases inside a Virtuozzo container. Is there any backup software that offers the same kind of 'continuous data protection'? An alternative to this ...
3
votes
1answer
341 views

automysqlbackup file empty

I recently set up automysqlbackup on a Ubuntu server. The script runs fine and doesn't report any errors-- it creates the tar.gz file as expected. However, when I extract the actual sql file from the ...