0
votes
4answers
67 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
315 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
85 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
48 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
312 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
1k 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 ...
3
votes
4answers
16k 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 ...
2
votes
1answer
538 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
708 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. ...
9
votes
1answer
7k 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
282 views

How do I automatically backup Mysql-Cluster database?

I need to automatically and frequently backup Mysql-cluster databases. How can I do this?
2
votes
1answer
502 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
470 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
5k 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 ...
4
votes
4answers
4k views

MySQL Automatic backup tools

I use back-in-time for backuping up my projects automatically. but my Database is not backing up automatically. like, scheduling by day or hours. Is there any tool to backup MySQL automatically?
0
votes
1answer
922 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 ...