LinuxQuestions.org
Latest LQ Deal: Linux Power User Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 07-15-2008, 09:26 AM   #16
trickykid
LQ Guru
 
Registered: Jan 2001
Posts: 24,149

Rep: Reputation: 235Reputation: 235Reputation: 235

Quote:
Originally Posted by nawuza View Post
Ok..shutdown the mysql service before backup it.

can you give me a guide on how to check whether the file is download completely?!for example the during the transferring tar file somehow occur a problem. how do it face the problem?!
There's probably several ways to check. Like I said, you could either check for a process copying or moving the file or perhaps create a md5sum of the file first as a separate file, have the copied over first which is almost instant and have a script compare the md5sum from the file to the file being copied to it's final destination, if it matches, the copy is complete, if not, wait and check in a few minutes in a while loop or something.

Or you can maybe print the size of the file in bytes and compare to final destination, same type of scenario of the md5sum. I'd personally go the md5sum route, more reliable or go the route of checking for the PID of the file being copied, etc.
 
Old 07-15-2008, 01:46 PM   #17
0.o
Member
 
Registered: May 2004
Location: Raleigh, NC
Distribution: Debian, Solaris, HP-UX, AIX
Posts: 208

Rep: Reputation: 35
Exit status is probably a good place to start too.
 
Old 08-25-2008, 02:40 PM   #18
rsleventhal
Member
 
Registered: Apr 2007
Location: Sunny Florida, USA
Distribution: CentOS, RHEL, U/X/Kubuntu
Posts: 36

Rep: Reputation: 15
late to this thread...but I love this solution

Sorry for the late post...I found, and have been using, the technique listed here:

http://www.tech-recipes.com/mysql_tips221.html

It's clean, works well and has consistently provided solid backups. Easy to cron, too.

YMMV.

HTH,
-Ray
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: Visual MySQL Database Design in MySQL Workbench LXer Syndicated Linux News 0 06-12-2008 07:00 PM
Create mysql user for backup of database timgerr Linux - Server 2 01-04-2008 10:44 AM
Backup software for MySql database blinton25 Linux - Software 5 06-01-2007 03:40 AM
MySQL :: Auto backup all newly created database Swakoo Linux - General 3 01-22-2007 09:49 PM
How to import a mysql database from backup WindowBreaker Slackware 6 03-16-2006 11:08 PM


All times are GMT -5. The time now is 06:33 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration