2
votes
1answer
25 views

Trying to sync live data to a backup server

I'd like to take the data from the live system to a backup system (to test new features etc) Piecing together an rsync command, I have the following. How do I ensure everything is copied? Things ...
1
vote
1answer
78 views

Shutting down ALL services (server backup)

I am running Ubuntu server 12.04 LTS. After many trials and errors, the backup strategy I have selected resorts to using TAR (mostly because I was unable to find a tool to backup/restore dovecot ...
0
votes
5answers
570 views

crontab not running as root

Mysql backup scripts not running as root crontab - help I'm trying to run a crontab as root but the script is not running successfully. I can see in syslog that the script is executing but it does ...
0
votes
1answer
706 views

Is there any way to get a MySQL database from a /var backup?

I upgraded from Ubuntu 12.10 to Ubuntu 13.10. After some time, I found that I didn't export all my MySQL databases. Some of them are missing. I still have a backup from my /var/ partition, but I ...
0
votes
0answers
128 views

AutoMySQLBackup - how to store username / password

I'm trying to setup AutoMySQLBackup on Ubuntu 12.04.3 LTS in security conscious manner. I've setup a mysql user with minimum privileges for backups. But when installing AutoMySQLBackup from apt-get ...
0
votes
0answers
75 views

How backup and restore Horde manualy

how can I backup and restore my horde sql database The Databse ist located in /var/lib/mysql/horde There are many *.frm files and one db.opt My Server ist broken, so I want to reinstall it. Can i ...
1
vote
1answer
359 views

Backup MYSQL DB on one server and restore on other, do i need the same version of MYSQL?

I backupped my old db on ubuntu 10.10 server using mysql 5.1.49 using mysqldump now I want to restore the file on my other machine, using ubuntu 12.04 server with Mysql version 5.5.32 on it. I ...
1
vote
1answer
2k views

How to remotely backup a MySQL database?

How to backup MySQL database in a remote location using rsync? I tried mysqldump but it is storing the backup in the local machine only. Also I need the backup files to be stored in tar format in the ...
4
votes
4answers
25k views

Bash script not executing from crontab [duplicate]

I have the following bash script: #!/bin/bash mysqldump -u ******** -p******** --all-databases | gzip > /home/srvlinux01/MySQLBackups/database_$(date +\%Y-\%m-\%d).sql.gz which is located in ...
3
votes
1answer
628 views

root cron job not running

I am trying to configure automysqlbackup to run via a cronjob to backup my dbs nightly. When I execute sudo automysqlbackup from a terminal, the process executes as expected and creates the backup ...
0
votes
1answer
744 views

How to restore on another Ubuntu computer a MySQL backup made by rsnapshot?

How to restore on another Ubuntu computer a MySQL database backup made by rsnapshot on an external USB hard disk? This seems to be difficult because the UID and GID of mysql differ on both computers. ...
12
votes
1answer
9k views

how do I stop automysqlbackup throwing LOCK TABLES error?

How to stop automysqlbackup's cron.daily script -- as installed and configured from apt-get install automysqlbackup -- throwing the following error: mysqldump: Got error: 1142: SELECT,LOCK TABL ...
0
votes
1answer
345 views

How do I automatically backup Mysql-Cluster database?

I need to automatically and frequently backup Mysql-cluster databases. How can I do this?
3
votes
1answer
620 views

Backup MySQL databases from broken Ubuntu

Here is my problem, and I hope someone would help me to find a solution. My Ubuntu 12.04 is broken after an upgrade from 11.10, it won't boot up, just stops at the purple Ubuntu screen, but I can ...
2
votes
3answers
1k views

What is the easiest, most effective backup system for Ubuntu Servers?

I'm trying to backup my /var/www/ folder, MySQL, and any other special documents like in the /etc/apache2/ folder. Does anyone have any solutions for backup software? Maybe something that's ...
1
vote
2answers
521 views

Backing up MySQL Database (Up to a month or while theres space)

I am backing up my files using deja-dup. But how do I do the same with MySQL? I see some cron scripts, but that will keep backups forever. I thought the feature of deja-dup that allows backups to be ...
6
votes
1answer
8k views

How can I export MySQL database manually - without phpmyadmin [closed]

My phpmyadmin doesn't work, i see only white blank page when i open it(it's has some issue), However, I'd like to export my project databased manually to another computer. i saw all my databases ...
5
votes
4answers
6k views

MySQL Automatic backup tools

I use back-in-time for backuping up my projects. but my Database's are not included. I'd like to backup all database's scheduling by day or hours. Is there any tool to backup MySQL automatically?
0
votes
1answer
1k views

How to take daily backup of database?

Hey I am using mysql in ubuntu along with 15 more ppl who also has root privilege. I am afraid they might accidentally tamper with the database, so I want to take a daily and hourly incremental ...