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


ADVERTISEMENT

General :: Binary - Use Logs To Have Incremental Backup

May 7, 2009

I had full backup in mysql. now i added some tables .i got new binary logs. how i can i use these logs to have incremental backup.

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

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

CentOS 5 :: Backup Script With TAR - Incremental Backup With Simple FTP To Another Location And Email Status

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

Fedora Servers :: Incremental Tar Creates Wrong File?

Sep 6, 2010

set up incremental backups with crontab. I just discovered that tar is not actually incrementing the tar files. I first created the tar files, then in crontab I have:

Code:
cd /; tar -cpf --incremental --exclude-from=/root/ExcludeFromTar.txt mnt/PATRIOT/bkp/home.tar home

I only just discovered that this creates a file whose filename is "/--incremental". I also tried using tar's -G switch instead of --incremental:

[Code]....

View 2 Replies View Related

Ubuntu :: Rsync Like Incremental Backup

Oct 20, 2010

when rsync is finished the update, or in the meantime - i need to move the updated files to a different location - like date +%Y%m%d something or what ..the reason is, because of the development, i need the modified files, but all of them, not just the last one - so i have to store them daily, but i dont want to store the whole dir - just that few files which are updated does it make sense?

View 5 Replies View Related

Ubuntu :: How To Incremental Backup Of Folder

Mar 8, 2011

incremental backup of folder.The problem with e.g. find&tar is, that I want backup not only files with modification time after x:y , but also older files, that have been copied into this folder after last backup.

View 6 Replies View Related

Fedora :: Incremental Automatic Backup

Jul 18, 2011

I am trying to find a backup program to incrementally backup some files to an external disk every week for example. I would prefer not to have to write a script as I am not really used to it.

View 4 Replies View Related

General :: Administrator - How To Take Incremental Backup

Mar 16, 2011

I'm trying to take backup for my data for rhel, but I not able to take all backup. Could anybody help show me how I take incremental and full backups? What is the process?

View 3 Replies View Related

Server :: Incremental Backup In Linux

Sep 18, 2010

A complete back up using tar takes consumes more time. so is there any way to take incremental backups using tar.And i also want to take incremental backup dump of my databases too.Any suggestions and links will be very helpful.i keep on googling for this,but could find any exact for this.

View 14 Replies View Related

Ubuntu :: Cron - Backup Runs To Have Incremental Number

Apr 3, 2010

I am trying to write as bash script in order to have backup done by cron on the webhosting server. I want all backup runs to have incremental number in front of them. I came up with an idea to store incremental number of a backup in txt file on a server so when next one runs is can check the number in the file. However I am having terrible issues. My script:

[code]....

View 7 Replies View Related

Debian :: Incremental Encyrpted Local Backup Utility?

Sep 17, 2010

I want to backup data and upload to online hosting services.Since I'm uploading stuff online, I only want to upload encrypted data (so that even the hostiing service admins cannot look at the data).Thus, I first want to encyrpt my data locally that I want to backup. Since I will be making changes locally to the data, I want some sort of incremental imaging system where the incremental changes are stored in seperate files so that I only have to upload the incremental encrypted changes.

Duplicity is an option, but it uses GPG, which makes it a bit complicated; and I was wondering if there was any alternative which was simpler as I am only doing the encryption and backup locally.

View 1 Replies View Related

Ubuntu Servers :: 10.04 Cannot Execute Binary File

Dec 22, 2010

Trying to install Parallels Plesk Panel 10 x86_64 onto a completely new installation of Ubuntu 10.04.1 LTS

root@server:~# chmod +x parallels_installer_v3.7.1_build101014.17_os_Ubunt u_10.04_x86_64
root@server:~# ./parallels_installer_v3.7.1_build101014.17_os_Ubunt u_10.04_x86_64
-bash: ./p.arallels_installer_v3.7.1_build101014.17_os_Ubun tu_10.04_x86_64: cannot execute binary file

View 5 Replies View Related

Software :: Incremental Encrypted Local Backup Utility Alternative To Duplicity?

Aug 10, 2010

I want to backup data and upload to online hosting services. I first want to encyrpt my data locally that I want to backup. Since I will be making changes locally to the data, I want some sort of incremental imaging system where the incremental changes are stored in seperate files so that I only have to upload the incremental encrypted changes. Duplicity is an option, but it uses GPG, which makes it a bit complicated; and I was wondering if there was any alternative which was simpler as I am only doing the encryption and backup locally.

EDIT:I have only ONE computer on which the data resides, and on which the backup image image is made. That is, I have a directory foo on my computer, the backup of which will be made to back-foo on the same computer. I want back-foo to be in an encypted form Then back-foo will be uploaded (unencrypted) to microsft live storage or to spideroak storage etc. Since back-foo is encrypted, my upload is secure. And since I'm uploading, I want incremental backup support, that is, the backup utility should create new files which contain the incremental changes so that I can upload only the new files which contain the changes.

View 2 Replies View Related

Ubuntu Servers :: Su As Backup User Inside Of Bash Script - Lock And Flush Tables On A Mysql Db

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

Software :: Mysql Full Backup Script Not Archiving The Dump File?

Mar 20, 2011

I have a problem with a script i wrote, the script runs fine if manually executed however it doesn't run *fully* when executed via cron

here's the script :

Code:

#!/bin/bash
FILENAME=mysql_full_dump_`date '+%m.%d.%y'`.sql
`which mysqldump` --all-databases -uroot -p************ -h127.0.0.1 > /root/$FILENAME
RETVAL=$?

[code]....

the script resides in /root/bin and the cron entry is as follows:

Code:

0 0 * * * root "/root/bin/mysql_daily.sh"

the result is the .sql file, but it doesn't archive it.

View 2 Replies View Related

Programming :: Finding A Utility To Combine Two Or More Binary Files Into A Single Binary File?

May 5, 2011

Is there any Linux utility to combine two or more binary files into a single binary file ?

View 7 Replies View Related

Ubuntu Servers :: Apache Include Hostname In Access.log And Error.log File Names?

Feb 8, 2010

I am sure this information is out there somewhere, but Googling apache access.log and hostname does not give you any good leads... so I hope someone here might be able to provide me with a quick answer...I am setting up a cluster of web servers, so I would like to name the access.log and error.log with the hostname of the individual servers to be able to distinguish one from another.

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

Ubuntu Servers :: Strange File Names - Getting Larger And Larger All The Time

May 3, 2011

Using Samba I have looked into the file that stores all my web sites, there were a few strange files that get larger and larger all the time. File names are _Za01716 and _Za01820, they are nearly 50mb in size now. I know these are not Log files so what are they and can I delete them?

View 1 Replies View Related

Ubuntu Servers :: Trying To Insert JPG File Into MySQL Table

Mar 12, 2011

I would like to store JPG files in a mysql database table. I figured that using BLOB fields on the one hand and the 'load_file' command on the other would do the trick. Here is how I set up the table:

mysql> create table blobtable (id int(10) not null auto_increment,
fileName varchar(15) not null,
file longblob not null, primary key(id) );
Query OK, 0 rows affected (0.51 sec)

Then I tried to enter the data:
mysql> insert into blobtable(filename,file)values('pic',load_file('/var/www/temp/IMGP4764.JPG'));

Which got me the following error signal:
ERROR 1048 (23000): Column 'file' cannot be null

It seems to me that the file path to the JPG file (although correct) is the source of the problem, and is causing the load_file command not to work. My first attempt was with the JPG file in my PC's home directory. When that returned the same error message, I figured that maybe the file had to be in the PC's (server's) web area so I put it under the 'www' directory.

View 7 Replies View Related

General :: Purging Binary Logs In MySQL Replication?

Sep 15, 2010

I had Configured a MySQL Master-Slave replication.It seems that the binary logs steals so much space of My storage.

i.)My Master

show master status;

+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000144 | 475823 | | |
+------------------+----------+--------------+------------------+
1 row in set (0.00 sec)

ii.)My Slave.

mysql> SHOW SLAVE STATUSG;
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 10.277.55.141

[code]....

If i remove all binary files up tp mysql-bin.000144 using "PURGE",will it affect my existing database/any data loss.

View 14 Replies View Related

Ubuntu Servers :: Backup-script - Ssh - Output Result To Text File?

Nov 5, 2010

Im using this script to save a backup to a NAS, however i want to print the result to a file that later can be mailed to me.

Code:

tar --totals -czf - /var/www | ssh user@host "cat > /backup_path/`date "+%Y-%m-%d"`.tar.gz"

i have tried just adding ">> logfile.txt" at the end of the command, but that obviously does not work. How should i do this?

View 2 Replies View Related

General :: Copying Open And Incremental File?

May 6, 2010

I'm getting a video from a camera connected to the computer and saving it to a constantly increasing file.

The thing is that I'm trying to make a non-stop copy of this file over the network (i.e. using scp, rsync or something like that).

View 4 Replies View Related

Fedora Servers :: Create A Backup To A Remote File System?

Jun 26, 2010

Attempting to create a backup script to copy files from one file system to a remote file system.

When I try this I get:

Quote:

# tar -cf - /mnt/raid_md1 | gzip -c | ssh -i ~/.ssh/key -l user@192.168.1.1 "cat > /mnt/backup/fileserver.md1.tar.gz"
tar: Removing leading `/' from member names
Pseudo-terminal will not be allocated because stdin is not a terminal.
ssh: Could not resolve hostname cat > /mnt/backup/fileserver.md1.tar.gz: Name or service not known

[Code].....

I know that the remote file system dir is RW and the access is working fine. I am stumped...

View 3 Replies View Related

Programming :: Incremental Backup Using DUMP Command - Error "DUMP: Only Level 0 Dumps Are Allowed On A Subdirectory"

Sep 6, 2010

I have used Dump Command to dump the application files. For Full backup the level 0 is working fine. For incremental backup I used the level 1 or 2 it is getting the error as

DUMP: Only level 0 dumps are allowed on a subdirectory
DUMP: The ENTIRE dump is aborted.

The code I used
===============================
#!/bin/bash
#Full Day Backup Script
#application folders backup
#test is the username
now=$(date +"%d-%m-%Y")
[Code]...

View 2 Replies View Related

Ubuntu Servers :: Update DHCP Leased File To PowerDNS MySQL DB?

Mar 2, 2010

I setup PowerDNS for my local system following

[URL]

How can I update client info from DHCPd leased file to PDNS MySQL for lookup/reverse my network?

View 1 Replies View Related

Ubuntu Servers :: Separate Virtual Machines For Apache, Mysql, File Server?

Jul 11, 2011

I'm working on a side project where I would like to install three ubuntu server systems,each with only one task.So server0 would be the apache server, server1 would be the database and server2 would be the file server.which key terms I should be researching?

View 9 Replies View Related

General :: Rsync Command - Sending Incremental File List?

Feb 14, 2010

I received the following output from an rsync (3.0.0) command that was executed:
sending incremental file list
sent 77214 bytes received 484 bytes 155396.00 bytes/sec
total size is 254531170 speedup is 3275.90
What does "sending incremental file list" mean?

View 9 Replies View Related







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