Sponsored Content
Top Forums UNIX for Advanced & Expert Users MYSQL command to take a backup of the database in Redhat linux 7.2 Post 46652 by photon on Wednesday 21st of January 2004 01:16:28 PM
Old 01-21-2004
Here is a way to email a backup using bash, perl, and crontab.

mysqlbackup

Code:
#!/bin/sh 
mysqldump -uroot -ppwd --opt db1 > /sqldata/db1.sql 
mysqldump -uroot -ppwd --opt db2 > /sqldata/db2.sql 
cd /sqldata/ 
tar -zcvf sqldata.tgz *.sql 
cd /scripts/ 
perl emailsql.cgi

Use perl to send a MIME email.

emailsql.cgi

Code:
#!/usr/bin/perl -w 
use MIME::Lite; 
$msg = MIME::Lite->new( 
From => 'mysqlbackup@yoursite.com', 
To => 'you@yoursite.com', 
Subject => 'sqldata.tgz MySQL backup!', 
Type => 'text/plain', 
Data => "Hi You,\n MySQL database backups.");
 
$msg->attach(Type=>'application/x-tar', 
Path =>"/sqldata/sqldata.tgz", 
Filename =>"sqldata.tgz"); 

$msg->send;

Use crontab -e to edit your schedule to run at 2 am every day.

0 2 * * * * /myscripts/mysqlbackup
 

7 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

mysql in redhat

Does anyone know how to get mysql up and running with the installed version that comes with redhat linux? I've spent hours with no progress. Thank you (13 Replies)
Discussion started by: gparsons70
13 Replies

2. UNIX for Dummies Questions & Answers

command(s) to find size of mysql database?

hello, i'm trying to figure out the size of a mysql database shelling into my server with putty / command line. is there / are there any commands that will return the size of a database, in MB? thanks. (4 Replies)
Discussion started by: sbourgeois
4 Replies

3. UNIX for Dummies Questions & Answers

Redhat linux command to check Version

Hi All, I need to know RedHat linux version installed on a different servers. I know uname -a or /proc/version Is any other command to know the Linux version???? When we telnet to any of the Linux server, the version shows very clearly like Red Hat Enterprise Linux ES release 3 (Taroon... (1 Reply)
Discussion started by: bache_gowda
1 Replies

4. Linux

Linux System Backup Command

Hi All, Is there any command to take complete system backup (image) in Linux like mksysb command in AIX ? Regards (1 Reply)
Discussion started by: m_raheelahmed
1 Replies

5. Shell Programming and Scripting

How to backup a particular Database in MYSQL?

Hi All, Thanks in Advance!! 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.... (4 Replies)
Discussion started by: anishkumarv
4 Replies

6. Shell Programming and Scripting

Linux backup command line or live cd?, what do you use?

Linux backup command line or live CD?, what do you use? (4 Replies)
Discussion started by: kaja
4 Replies

7. Shell Programming and Scripting

Increase command length for ksh shell on Redhat Linux

I have a ksh shell script and i need to pass arguments which are generated by data pulled from a database. When the argument to the shell script is too long (about 4000 charecters) the below is the issue observed. I copy the command which is 4000 charecters long from the logs and paste it... (7 Replies)
Discussion started by: mohtashims
7 Replies
File::Type(3)						User Contributed Perl Documentation					     File::Type(3)

NAME
File::Type - determine file type using magic SYNOPSIS
my $ft = File::Type->new(); # read in data from file to $data, then my $type_from_data = $ft->checktype_contents($data); # alternatively, check file from disk my $type_from_file = $ft->checktype_filename($file); # convenient method for checking either a file or data my $type_1 = $ft->mime_type($file); my $type_2 = $ft->mime_type($data); DESCRIPTION
File::Type uses magic numbers (typically at the start of a file) to determine the MIME type of that file. File::Type can use either a filename, or file contents, to determine the type of a file. METHODS
new Returns a new File::Type object. mime_type($argument) Takes either data or a filename, determines what it is, and passes the argument through to the relevant method below. If the argument is a directory, returns undef. checktype_filename($filename) Opens $filename (if possible; if not, returns undef) and returns the MIME type of the file. checktype_contents($data) Matches $data against the magic database criteria and returns the MIME type of the file. TODO
* Add additional magic match criteria BUGS
None known. NOTES Some magic definitions in the mime-magic file used in the creation of this module vary from those in other apps (eg image/x-png not image/png). SEE ALSO
File::MMagic and File::MimeInfo perform the same job, but have a number of problems that led to the creation of this module. File::MMagic inlines a copy of the magic database, and uses a DATA filehandle, which causes problems when running under mod_perl. File::MimeInfo uses an external magic file, and relies on file extensions rather than magic to determine the mime type. As a result, File::Type uses a seperate module and script to create the code at the core of this module, which means that there is no need to include a magic database at all, and that it is safe to run under mod_perl. File::Type::Builder, which generates the code at the heart of this module. ACKNOWLEDGMENTS
File::Type is built from a mime-magic file from cleancode.org. The original can be found at http://cleancode.org/cgi-bin/viewcvs.cgi/email/mime-magic.mime?rev=1.1.1.1 <http://cleancode.org/cgi-bin/viewcvs.cgi/email/mime- magic.mime?rev=1.1.1.1>. AUTHOR
Paul Mison <pmison@fotango.com> COPYRIGHT
Copyright 2003-2004 Fotango Ltd. LICENSE
Licensed under the same terms as Perl itself. perl v5.12.1 2004-05-06 File::Type(3)
All times are GMT -4. The time now is 10:13 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy