OpenSUSE :: Unable To Schedule Successfully MySQL Backup Jobs

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


ADVERTISEMENT

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 View Related

Software :: Scheduling Backup In Crontab When Put This File In Crontab To Schedule The Backup Program It Wont Run?

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

Ubuntu Servers :: Rsync Auto Login And Schedule Backup?

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

General :: Create A Backup Schedule For Client Computers And Servers?

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

General :: Using Shell Script Crontab Backup And Delete With Schedule?

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

Server :: Recover MySQL Innodb From /var/lib/mysql/ Backup?

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

General :: Schedule A Script "backup.sh" To Run In Oracle User?

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

OpenSUSE Network :: ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/mysql/mysql.sock

Jun 7, 2011

I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:

Code:
the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
Code:
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory

[Code]...

View 6 Replies View Related

Ubuntu Installation :: Unable To Install And Successfully Run 9.10

Feb 1, 2010

I have not been able to install and successfully run Ubuntu 9.10. I am now wondering if I will be able to go from 9.04 to 10.04 this coming April. I think that somewhere I read it isn't good to do this, but I don't have much choice.

View 3 Replies View Related

Server :: Users Unable To Run Cron Jobs

Jan 6, 2010

I have a file server that is an NIS client. User home directories are auto-mounted from another server. Users are not able to run cron jobs. The /var/log/cron logs says:
Jan 6 14:33:01 inclination crond[3217]: (username) ORPHAN (no passwd entry)

I tried adding an entry in /etc/passwd, /etc/group, and /etc/shadow but the test script I have still doesn't seem to run although cron thinks it did. The log entry for these attempts looks like:
Jan 6 15:30:01 inclination crond[4312]: (username) CMD (/home/username/test-script)

Now root does seem to be able to run cron jobs with no problem. My test script works fine from cron when runs as root. I suspect there's an issue with how I have NIS configured but I can't find any info. The test script runs fine from the command line when logged in as myself.

View 2 Replies View Related

Ubuntu Networking :: Unable To Successfully Use Bluetooth Dongle

Aug 14, 2010

I recently purchased an inexpensive bluetooth dongle for my laptop running lucid 64-bit. the device, however, doesn't seem to want to work in ubuntu. most functions (everything but turning the device OFF) fail, causing gui windows to hang, and i mostly receive messages relating to the device timing out.

Before you ask, it is not the device: the dongle works flawlessly in windows 7 after being autodetected and autoinstalled. i attempted to boot from the lucid cd, and the problem persisted.

Code:

Code:

View 4 Replies View Related

Ubuntu Installation :: HDD Is Unable To Successfully Display Partition Table

Jan 26, 2011

I'm trying to install Ubuntu Netbook Edition 10.10 on my Eee PC 1015PE. but it appears that GParted which is used to partition the HDD is unable to successfully display partition table, it just shows that /dev/sda is all unallocated, and it offers just to create new partition table.

View 7 Replies View Related

General :: Unable To Successfully Start A KDE Session(SLAX), Check Out The Error?

May 1, 2010

I'm not able to successfully start a KDE session(SLAX), check out the error, Code: xauth: creating new authority file /root/.serverauth.7378

X.Org X Server 1.4.2
Release Date: 11 June 2008
X Protocol Version 11, Revision 0

[code]....

View 9 Replies View Related

Software :: ERROR: Unable To Find Mysql Headers (mysql.h)

Apr 3, 2010

I'm trying to install snort-2.8.5.3 on centos5-i386 an I get this error from ./configure --with-mysql --enable-dynamicplugin command:

ERROR: unable to find mysql headers (mysql.h)
checked in the following places
/usr
/usr/include

[Code].....

I've read here it has to do with libmysqlclient12-dev. How can I install libmysqlclient12-dev on centOS?

Is it possible to install snort from repositories using yum?

View 3 Replies View Related

General :: Backup All Tables In Mysql?

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

General :: Backup A Particular Database In MYSQL?

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

Server :: Tar Backup And Restore In Mysql?

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

OpenSUSE Multimedia :: Successfully Installed Sabnzbd On Opensuse?

Jul 18, 2010

Has anyone ever successfully installed sabnzbd on opensuse? It works great on Ubuntu and is easy to install, but on opensuse, I can't figure it out.

View 4 Replies View Related

Ubuntu :: Backup MYSQL Database From Where Its Stored?

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

Ubuntu :: Backup From An Old Mysql In A Hard Drive?

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

Server :: Mysql Backup And Restore Scripts?

Apr 11, 2011

writting shell scripts,i searched in google but could not get the exact,pls can anyone help how to take mysql backup & restore using shell scripts.

View 3 Replies View Related

Server :: Recover A Compressed Mysql Backup?

Dec 6, 2009

I'm trying to recover a compressed mysql backup. As the backup is extremely large, I dont wanna decompress it before importing. How can I make a mysql variable take effect before I load this compressed file into the database.

View 7 Replies View Related

Server :: Stop Mysql In Order To Preform A Backup?

Apr 12, 2010

I'm working on an old redhat server with mysql installed and I need to find a way to stop the service in order to preform a backup.

some info that I found on the server code...

View 9 Replies View Related

Server :: MySQL Backup Cron Job Not Executing Correctly?

Mar 2, 2011

I own a CentOS 5 VPS. I typed crontab -e, and then I added the following line to automatically have my server backup mysql

0 * * * * mysqldump -u root -p password --all-databases | gzip > /home/dbbackup/database_`date '+%m-%d-%Y_%H'`.sql.gz

When I go in and look, it doesn't place any files in /home/dbbackup. When I run

mysqldump -u root -p password --all-databases | gzip > /home/dbbackup/database_`date '+%m-%d-%Y_%H'`.sql.gz

View 3 Replies View Related

OpenSUSE :: Has Anyone Successfully Installed DockBarX?

Sep 10, 2010

I tried out DockBarx on my previous Ubuntu computer and really liked it. I installed openSUSE not too long ago and I just decided it's about time to get it back! However, I'm having some trouble installing it. My initial attempt was to simply download the tarball of dockbarx from GNOME-Look, untar it and run setup.py. Unfortunately, it will not run for me..not as root, standard user, anything. I do have Python-Base installed, and my "cnf python" does return a successful response. My PATH has /python's location in it and everything.I then tried the .rpm but I need to install python-keybinder, pyxdg and dbus, but I cannot find any downloads or repo's with it. I could simply be missing it though. So, basically, I'm asking all of you who have successfully installed it on your openSUSE system to inform me on how you did it.

View 9 Replies View Related

OpenSUSE Install :: Can't Successfully Download 11.4

Mar 29, 2011

I've tried downloading 11.4 64-bit about a dozen times, and it always failed to checksum comparison. I've tried downloading it directly using Mozilla. I've tried that from a mirror (several actually). I've tried using Download Them All to get it and is failed both the MD5 and SHA1. BTW, those fail the checksum as soon as the Download Them All window opens. I've tried bitTorrent. I've tried it on two different machines. I've tried it from linux through Mozilla and Download Them All just to be sure it's not my anti-virus or software firewall.

BTW, in the process of installing a new HD on my desktop, somehow my OpenSUSE linux install has gotten corrupted (or something), so I don't have access to a linux install. Any suggestions how I can get a good download? I'm hoping I can use it to repair my existing install, and to install openSUSE on my laptop.

View 9 Replies View Related

Ubuntu Servers :: Backup MySQL To A Date Named File?

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

Server :: MySQL Backup - Deal With Large Amounts Of Data?

Feb 15, 2011

we've been trying to become a bit more serious about backup. It seems the better way to do MySQL backup is to use the binlog. However, that binlog is huge! We seem to produce something like 10Gb per month. I'd like to copy the backup to somewhere off the server as I don't feel like there is much to be gained by just copying it to somewhere else on the server. I recently made a full backup which after compression amounted to 2.5Gb and took me 6.5 hours to copy to my own computer ... So that solution doesn't seem practical for the binlog backup.Should we rent another server somewhere? Is it possible to find a server like that really cheap? Or is there some other solution? What are other people's MySQL backup practices?

View 8 Replies View Related

Ubuntu Servers :: MySQL Incremental Backup - Binary Log File Names

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







Copyrights 2005-15 www.BigResource.com, All rights reserved