Ubuntu Servers :: Mysql-admin Won't Schedule Backup But Will Manual Backup
Jan 19, 2010
I have a scheduled backup to run on our server at work and since the 7/12/09 it has be making 592k files instead of 10Mb files, In mysql-admin (the GUI tool) I have a stored connection for the user 'backup', the user has select and lock rights on the databases being backed up. I have a backup profile called 'backup_regular' and in the third tab along its scheduled to backup at 2 in the morning every week day. If I look at one of the small backup files generated I see the following:
Code:
-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version`
[code]....
It seems that MySQL can open and write to the file fine, it just can't dump
View 3 Replies
ADVERTISEMENT
Aug 29, 2010
I'm running:
OpenSuSE 11.1
MySQL 5.0.67
MySQL Administrator 1.2.12
I have one database for my web application. It's using MyISAM tables. In MySQL admin, I went to Backup and created a scheduled backup project called backup1. On the advanced tab, I selected "Lock All Tables" and checked the box for "Backup Selected Database Completely". On the Schedule Backup tab I have "Execute this Project Daily" selected and the time 1AM. The target directory is set along with the connection name. The connection it's using is the same MySQL user that my web application uses in order to utilize the database. It has full access to that database. Now when the backup file is created, it backs up no data at all.
Instead in creates files that are 580bytes in size. When I open the files they contain:
-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version5.0.67
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
View 1 Replies
View Related
Nov 11, 2010
I have setup Rsync as a daemon on a Ubuntu 10.04 box and the setup was successful. Here are my configs
Code:
root@hurricane:`# nano /etc/default/rsync
# defaults file for rsync daemon mode
# start rsync in daemon mode from init.d script?
# only allowed values are "true", "false", and "inetd"
[Code].....
View 6 Replies
View Related
Sep 20, 2010
I did a search and came up with many different opinions and suggestions, and I could not find any similar threads for this (if there is I must apoligize in advance and did not look hard enough). I am trying to create a backup schedule for client computers and servers; and I would like your opinion on what I came up with. Here is network infrastrusture setup:
16 client computers
6 serevrs
- Primary and Secondary Web Server (RAID 1)
- Primary and Secondary Domain Controller (RAID 1)
- File/Print Server (RAID 5)
- Backup Server (RAID 1) with USB 2.0 1TB External Drive
Of course I will evetually upgrade to Tape Drives, but I am saving up for that. Anyways I want to backup ALL client computers, Primary Web and DC server, and File/Print Server. This will be done (of course) on the Backup Server) Here is the schedule:
[Code]..
View 2 Replies
View Related
Apr 9, 2011
I have installed an application manager(monitoring application) on my linux server. Now, i need to have backup schedule for my application. The application itself has executive file to backup database.But when i put this file in my crontab to schedule the backup program it wont run!50 09 * * * root /opt/ME/AppManager9/bin/BackupMysqlDB.sh
View 1 Replies
View Related
Sep 23, 2010
I am manually backing up my server now with mysqldump and that works but I was wondering about mechanizing the process.
Nirvana would be to dump to a file named with the date
This way I have backups going back over time
View 9 Replies
View Related
May 10, 2010
Does anyone know of any decent enterprise level backup solutions for Linux? I need to backup a few servers and a bunch of desktops onto one backup server. Using rsync/tar.gz won't cut it. I need like bi-monthly full HDD backups, and things such as that, with a nice GUI interface to add/remove systems from the backup list. I need basically something similar to CommVault or Veritas. Veritas I've used before but it has its issues, such as leaving 30GB cache files. CommVault, I have no idea how much it is, and if it supports backing up to a hard drive rather than tape.
View 7 Replies
View Related
Mar 15, 2011
I am currently using a script to backup my Ubuntu 10.04.1 system. The mySQL databases are backed up separately from the the system / data.
My problem is with the mySQL incremental / binary log backups.
The problem is that the binary log file(s) are always named xxxx-bin.1.
Up to about a month ago the binary logs were named xxxx-bin.000001, xxxx-bin.000002, etc.
I did make some changes at about the time that this change in file naming ocurred, but I can not identify what, if any, setting I may have changed that has caused all of the binary log files to always have the same name.
My back up script uses both mysqldump and mysqladmin flush-logs to create the binary logs.
All of the setting for mysqldump and mysqladmin are contained in the my.cnf file.
The my.cnf file contents that are relavent are as follows:
Code:
The statements in the backup script that do the backup are:
mysqladmin flush-logs
or
mysqldump | gzip > $DB_BACKUP_DIR/$ARCHIVE_FILE #Note: delete-master-logs in my.cnf
View 3 Replies
View Related
Jan 23, 2010
I am attempting to write a backup script that will do the following:
1) lock and flush tables on a mysql db
2) dump the db to a file
3) unlock the tables
4) rsync the file to offsite storage
It all seems to be going well. However, obviously I don't want to setup ssh to the storage server on another network as the root user without a password. so I am attempting to su as the backup user inside of the script but when I try to run the script everything happens as it should until I try to so.. then it jumps out of the script .. akss me to login as the backup user.. proceeds to rsync to the offsite storage it does all this and then resumes execiting the script. it is not going to be setup as a cron job. it will be executed manually. assuming that is the case, how can I get the script to run without prompting for a password?
Here is what I've come up with so far... assuming that the script is run as root and the identity of the backup user will need to be assumed inside the script without perstering the user to enter the backup user's password.
[Code]....
View 8 Replies
View Related
Jun 20, 2011
I have a problem need help, I want to do a schedule with using shell script with crontab in linux SuSE SLES 10.
1. I have many server that want to do backup mysql all from that server everyday. I need advice for for write shell script to backup all mysql in different server to server backup everyday and create auto folder as date example 27102009, 28102009..........for a month will has 30 folder in server backup.
2. Also need to write shell script to delete all folder but keep only one week last example from 1 to 30 it will has 30 folder in sever backup but i want to keep only 7 folder last and want to set schedule delete it every saturday night.
3. used that shell script with crontab in linux.
View 3 Replies
View Related
Jan 30, 2011
I installed mediawiki the other day and went with the default innodb option. However a week later something went wrong. And since I have scripts that nightly backup /var/ I just copied the backup of /var/lib/mysql/wikidb/ (as I've done with MyISAM). Then when I connect the wikidb database. I can see the tables (via "show tables"), but when I do any query with them (check table X, select * from X) I get:
Code:
Table 'wikidb.X' doesn't exist I've since read that can can't just copy the database directory like MyISAM, and there appears to be no way that I can find to restore or fix Innodb, without a dump of the data. And I never got a chance to do a mysqldump of the data. So has anybody got any idea how I can at least view the "page" table from the files I've backed up in /var/lib/mysql/wikidb/ ?
View 1 Replies
View Related
Mar 5, 2010
i have oracle installed on Linux i want to schedule a script "backup.sh" to run in oracle user.
oracle@linux1]crontab -e
*/2 * * * * /tmp/backup.sh
this script does not execute by cron.
BUT
oracle@linux1 tmp] ./backup.sh ------executes successfully
I dont know why the script is not being executed by cron
View 5 Replies
View Related
May 18, 2010
using Back In Time to backup my home directory to a second hdd that is mounted at /media/backupThe trouble is, I can do this using Back In Time (Root), but not using Back In Time without the root option. This is definitely a permissions issue - it can't write to the folder, but when I checked by right clicking on the backup directory and looking at the permission tab, it said I was the owner
View 2 Replies
View Related
May 10, 2011
I install and tested Restore EE Backup server on a test PC with basic configuration and its working fine.
[URL]
The issue i have is where is the location these backup snapshots or files are saving? I want to add a separate Storage to save the backup?
View 1 Replies
View Related
Feb 2, 2011
I've tried to google but not much luck. What I would like to do is have anumber of folders on my desktop and their contents, replicated/duplicated into another folder on the same PC in real time. So for example, if I were to change an OpenOffice document in a specific folder on my Desktop it would be replicated/duplicated in real time. If I had three folders on my Desktop A, B and C they would also appear/be backed up (in real time) in a folder called /home/backup. Can this be done?
View 3 Replies
View Related
Jun 30, 2010
does anyone know of a good backup software for Ubuntu 10.4 that will let me select which folders to backup, rather than a complete backup? My install and settings etc can be replaced, but my photos and memories cannot!
View 6 Replies
View Related
Sep 1, 2011
I have installed Ubuntu 11.04 onto HP EliteBook 8540w notebook and would like to backup the entire disk using some popular backup tool.
I have searched in the internet and found the closest tool is PartImage. But the bad news is that it does not support ext4 fs!
View 5 Replies
View Related
Jun 12, 2010
I have been looking for a complete backup solution like "Acronis True Image Backup and Recovery" on Windows for Slackware a while.
View 12 Replies
View Related
Jan 15, 2010
After I spent some time discovering The BIG BANG of Universe and The Meaning of Life :
I managed somehow to create a script to make some backup of files on server and TAR it and then FTP the archive to another location FTP server and then emails result.
It also measures time needed to complete it and deletes archive older than XX days (set in find -mtime +20) and makes incremental backup every weekday and FULL on Sundays (which suits me bcoz no heavy load).
Files for TAR to include and exclude are in txt files listed each line separate name:
file: including.txt:
View 7 Replies
View Related
Feb 2, 2010
I had a problem with my ubuntu installation, but I don't want to get into that...The OS wouldn't load...Now, that I have a ubuntu partition mounted on a live cd, is there a way I can access or backup my database without booting the system? I'm pretty sure the database is stored somewhere, but how can I find it and back it up?
View 8 Replies
View Related
May 4, 2011
How to backup from an old mysql in a hard drive?I have this HD which used to have an Ubuntu 7.04... However, the system crashed and it is not possible to boot anymore.I have moved the HD to another computer and made a copy for every important file and folder... But I am facing trouble to backup mysql... To copy /etc/lib/mysql doesn't work because it is probably in an older version from the mysql I use on Ubuntu 10.10
View 3 Replies
View Related
Nov 10, 2010
This script simply deletes files older than a certain age (in this case 7 days) from a certain location; I use it to purge old backups nightly, and it works as expected:
# delete backups older than 7 days
find /mnt/backup/* -mtime +7 -exec rm -Rf {} ;
The problem is, every morning I get an email with an error message something like this:
find: `/mnt/backup/subfolder': No such file or directory
View 2 Replies
View Related
Sep 15, 2009
I am trying to create a backup script that will back up a single folder for a class i am in. I was wandering if I could get some help. If possible I would also like to know how to write a script that can encrypt that same file . I will be putting the back up in my /home/usr/Backup directory. I am not trying to back up my whole system just a single folder. I am using Fedora 11
View 2 Replies
View Related
May 21, 2011
I'm just setting up a partition on a seperate HDD in my system. I plan to use the partition to backup the important files on my main HDD (to guard against HD crash).
The question I have is about where would be the typical location to auto mount this partition? Which would it be normal to go for:
1. /backup/
2. /media/backup/
3. /mnt/backup/
4. /home/chris/backup/
View 7 Replies
View Related
Aug 10, 2011
I want to make a backup from my Email and my Favorites from Mozilla.
But which folders I have to make a backup from.
View 3 Replies
View Related
Nov 18, 2009
I want to write the shell script which
1)Finds all the databases in mysql
2)create the folder who ever is the creater of that database or owner of that database. I think the databse starts with username_ so i think i have to split the database name to get folders name . How to do that? backs up the databases belonging to that user.
View 3 Replies
View Related
Jun 27, 2011
How to backup a particular Databases..through Bash script! For example i have 6 databases;
Anish
linux
Software
Questions
Rhce
Google
these are the databases i have from that i want to take "Anish" and "questions" database backup regularly.
View 8 Replies
View Related
May 6, 2011
how to take tar backup and restore in mysql,Iam new to mysql,i searched in google but i did not get the exact one.
View 4 Replies
View Related
Feb 4, 2011
I am now preparing myself to upgrade lenny to squeeze and decided to do a backup on my system. I used backup-manager to do the job and it worked fine. how do you restore said backup data?
View 4 Replies
View Related
Sep 13, 2010
Can some one give me a sample of a crontab for backing a directory please, System is Ubuntu 9.04Quote:
#!/bin/bash
# this file is an automated backup script, backup.sh.
# this backs up my domain site.
[code]....
View 7 Replies
View Related
