backup

Hi,

Does any one have a shell script to ftp a file to another location, so that I can schedule to run this file with cron.

Many thanks,
Hasan

----- Original Message -----
From: +ACI-Gerald R. Jensen+ACI- +ADw-gjensen+AEA-autodatasys.com+AD4-
To: +ACI-Impex Holidays Maldives / Hasan+ACI- +ADw-hasan+AEA-impex.com.mv+AD4AOw- +ADw-mysql+AEA-lists.mysql.com+AD4-
Sent: Sunday, February 24, 2002 10:56 PM
Subject: Re: backup


+AD4- We us a shell script that calls a cronjob (root) at 3am daily.
+AD4-
+AD4- The line in the cronjob is:
+AD4- +ACo- 3 +ACo- +ACo- +ACo- /usr/local/bin/dbbakup.sh username password
+AD4-
+AD4- The shell script:
+AD4-
+AD4- +ACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACM AIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwA jACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIw-
+AD4- +ACMAIQ-/bin/sh
+AD4- +ACM- +ACQ-1 +AD0- Unix/MySQL Username
+AD4- +ACM- +ACQ-2 +AD0- Unix/MySQL Password
+AD4-
+AD4- if +AFs- +ACE- -e /dbbakup +AF0-
+AD4- then
+AD4- mkdir /dbbakup
+AD4- fi
+AD4-
+AD4- mysqldump -u+ACQ-1 -p+ACQ-2 -c --add-drop-table --add-locks --flush-logs --databases
+AD4- account+AD4-/dbbakup/account.sql
+AD4- mysqldump -u+ACQ-1 -p+ACQ-2 -c --add-drop-table --add-locks --flush-logs --databases
+AD4- payroll+AD4-/dbbakup/payroll.sql
+AD4- mysqldump -u+ACQ-1 -p+ACQ-2 -c --add-drop-table --add-locks --flush-logs --databases
+AD4- contact+AD4-/dbbakup/contact.sql
+AD4-
+AD4- +ACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACM AIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwA jACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIw-
+AD4-
+AD4- If you wanted to ftp the resulting scripts to another server, you could add
+AD4- code to the shell script to run ncftpput, etc.
+AD4-
+AD4- Gerald Jensen
+AD4-
+AD4- ----- Original Message -----
+AD4- From: +ACI-Impex Holidays Maldives / Hasan+ACI- +ADw-hasan+AEA-impex.com.mv+AD4-
+AD4- To: +ADw-mysql+AEA-lists.mysql.com+AD4-
+AD4- Sent: Sunday, February 24, 2002 10:31 AM
+AD4- Subject: backup
+AD4-
+AD4-
+AD4- Hello everyone,
+AD4-
+AD4- I am trying to do backups using the crond daemon on my Linux server.
+AD4-
+AD4- Can I write a similar line as below on my crontab file. Any examples would
+AD4- be appreciated.
+AD4-
+AD4- mysqldump impex +AD4- siteroot/home/hasan/backup/backup.sql
+AD4-
+AD4- Alternatively i am thinking of running a perl file ...which will find access
+AD4- to the database and then do the backing and add this
+AD4- file to the crontab.
+AD4- Has anyone got a file pre-written for this purpose.
+AD4-
+AD4- thank you so much.
+AD4- Hasan
+AD4-
+AD4-
+AD4-
+AD4- ------------------------------------------------------------ ---------
+AD4- Before posting, please check:
+AD4- http://www.mysql.com/manual.php (the manual)
+AD4- http://lists.mysql.com/ (the list archive)
+AD4-
+AD4- To request this thread, e-mail +ADw-mysql-thread100889+AEA-lists.mysql.com+AD4-
+AD4- To unsubscribe, e-mail
+AD4- +ADw-mysql-unsubscribe-autodata+AD0-execpc.com+AEA-lists.mys ql.com+AD4-
+AD4- Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
+AD4-
+AD4-
+AD4-
+AD4-
+AD4-
+AD4- ------------------------------------------------------------ ---------
+AD4- Before posting, please check:
+AD4- http://www.mysql.com/manual.php (the manual)
+AD4- http://lists.mysql.com/ (the list archive)
+AD4-
+AD4- To request this thread, e-mail +ADw-mysql-thread100894+AEA-lists.mysql.com+AD4-
+AD4- To unsubscribe, e-mail +ADw-mysql-unsubscribe-hasan+AD0-impex.com.mv+AEA-lists.mysq l.com+AD4-
+AD4- Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
+AD4-
+AD4-


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: backup

DBI is the Perl module used to communicate with the database. The error =
message is informing you that you do not have the DBI module installed =
on your system.

This isn't a mysql-specific problem, so you should probably consult with =
an actual Perl help group. At the risk of going off-topic though, you =
can try the following to install the module...

NT (with activestate perl): C:\> ppm install DBI
Linux: perl -MCPAN -e 'install DBI'



-----Original Message-----
From: Massimo Petrini [mailto:massimo.petrini@infinito.it]
Sent: Thursday, July 18, 2002 9:06 AM
To: mysql@lists.mysql.com; Ilyas Keser
Subject: Re: backup


Also in may NT machine appear the same error. Which is the problem ?
----- Original Message -----
From: "Ilyas Keser"
To:
Sent: Thursday, July 18, 2002 1:58 PM
Subject: backup


> Hi list...
>
> What is the best way to backup a Mysql database? I read in the
> documentation that mysqlhotcopy is the best and quickest way to do
> this.
> But I can not start mysqlhotcopy...
> Error Message is:
>
> Can't locate DBI.pm in @INC (@INC contains:
> /System/Library/Perl/darwin /System/Library/Perl /Library/Perl/darwin
> /Library/Perl /Library/Perl /Network/Library/Perl/darwin
> /Network/Library/Perl /Network/Library/Perl .) at ./mysqlhotcopy line
> 8.
> BEGIN failed--compilation aborted at ./mysqlhotcopy line 8.
>
> What is DBI.pm?
>
> Thanks
>
> ------------------------------------------------------------ ---------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail
> To unsubscribe, e-mail

> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail
To unsubscribe, e-mail =

Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: backup

Try useing something like :

mysqldump -Q --opt -F --all-databases -h serverName -u root
--password=3Dyourpasswd > /some/where/backup.sql

It generates a SQL commands file able to completely rebuild the DB, e.g.
useful after a mysql_install_db command.

Ciao,
Stefano

> -----Original Message-----
> From: Massimo Petrini [mailto:massimo.petrini@infinito.it]=20
> Sent: 18 July 2002 16:06
> To: mysql@lists.mysql.com; Ilyas Keser
> Subject: Re: backup
>=20
>=20
> Also in may NT machine appear the same error. Which is the problem ?
> ----- Original Message -----
> From: "Ilyas Keser"
> To:
> Sent: Thursday, July 18, 2002 1:58 PM
> Subject: backup
>=20
>=20
> > Hi list...
> >
> > What is the best way to backup a Mysql database? I read in the
> > documentation that mysqlhotcopy is the best and quickest way to do
> > this.
> > But I can not start mysqlhotcopy...
> > Error Message is:
> >
> > Can't locate DBI.pm in @INC (@INC contains:
> > /System/Library/Perl/darwin /System/Library/Perl=20
> /Library/Perl/darwin
> > /Library/Perl /Library/Perl /Network/Library/Perl/darwin
> > /Network/Library/Perl /Network/Library/Perl .) at=20
> ./mysqlhotcopy line
> > 8.
> > BEGIN failed--compilation aborted at ./mysqlhotcopy line 8.
> >
> > What is DBI.pm?
> >
> > Thanks
> >
> >=20
> ------------------------------------------------------------ ---------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail
> > To unsubscribe, e-mail
>
> > Trouble unsubscribing? Try:=20
> http://lists.mysql.com/php/unsubscribe.php
> >
>=20
>=20
>=20
> ------------------------------------------------------------ ---------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>=20
> To request this thread, e-mail
> To unsubscribe, e-mail=20
>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>=20
>=20

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: backup

> -----Message d'origine-----
> De : Rick [mailto:ricardo@gremradio.com.mx]
> Envoy=E9 : Saturday, December 27, 2003 6:33 AM
> =C0 : mysql@lists.mysql.com
> Objet : backup
>=20
>=20
> i guys!! im newbie, how can i backup a mysql database? what=20
> do you recommend
> me?
>=20
mysqldump to begin
>=20
> --=20
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: =20
> http://lists.mysql.com/mysql?unsub=3Dugob@camo-route.com
>=20
>=20

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql@m.gmane.org

Re:Backup

------=_NextPart_000_0001_01CB67FD.6451A450
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit



Hi ,

My database size is 900GB.i don't want full database backup. I
need only yesterday backup. how can I take, please help me.



Thanks & Regards,

Kranti


------=_NextPart_000_0001_01CB67FD.6451A450--

Re: Backup

2010/10/10 kranthi :
>
>
> Hi ,
>
> =A0 =A0 =A0 =A0 =A0 My database size is 900GB.i don't want full database =
backup. I
> need only yesterday backup. how can I take, please help me.
>

How about the document there:
http://dev.mysql.com/doc/refman/5.1/en/backup-strategy-examp le.html

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Backup

--0016e6dee96554f0230492450cd2
Content-Type: text/plain; charset=ISO-8859-1

Hey Kranthi,

If you have binlogs enabled, do a binary logs backup everyday i.e going to
be your everyday backup which consists of the sql modified statements.

On Sun, Oct 10, 2010 at 11:13 AM, yung wrote:

> 2010/10/10 kranthi :
> >
> >
> > Hi ,
> >
> > My database size is 900GB.i don't want full database backup. I
> > need only yesterday backup. how can I take, please help me.
> >
>
> How about the document there:
> http://dev.mysql.com/doc/refman/5.1/en/backup-strategy-examp le.html
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=sureshkumarilu@gmail.com
>
>


--
Thanks
Suresh Kuna
MySQL DBA

--0016e6dee96554f0230492450cd2--

Re: Backup

--0016362844d4833e19049254d61c
Content-Type: text/plain; charset=ISO-8859-1

Do keep in mind that what you get there is going to be useless if your
database doesn't already contain all the previous data. The inserts will
work, of course, but any data modification may fail because the rows you
modify aren't there when you restore.

Make sure you know exactly what you want and what you're doing before
implementing this.


On Mon, Oct 11, 2010 at 5:10 PM, kranthi wrote:

> I get, I use following
>
>
>
> mysqlbinlog --start-date="2010-10-09 9:55:00" \
>
> --stop-date="2010-10-10 10:05:00" \
>
> /var/log/mysql/bin.123456 \
>
> > /tmp/mysql_restore.sql
>
>
>
>
>
> Thanks all
>
>
>
>
>
> From: andrew.2.moore@nokia.com [mailto:andrew.2.moore@nokia.com]
> Sent: Sunday, October 10, 2010 4:46 AM
> To: kranthikiran.inf@gmail.com
> Subject: Re: Backup
>
>
>
> hmm a yesterday backup? MySqldump using where clauses? Why do you only want
> yesterday?
>
> -- Sent from my HTC Desire on 3 --
>
> ----- Reply message -----
> From: "ext kranthi"
> Date: Sun, Oct 10, 2010 04:51
> Subject: Backup
> To: "backup@lists.mysql.com"
>
> Hi ,
>
> My database size is 900GB.i don't want full database backup. I
> need only yesterday backup. how can I take, please help me.
>
>
>
> Thanks & Regards,
>
> Kranti
>
>


--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

--0016362844d4833e19049254d61c--

Re: Backup

--001636c5b8b93633c1049255380d
Content-Type: text/plain; charset=ISO-8859-1

Hi kranthi,

Take a look at LVM and xtrabackup.

http://www.mysqlperformanceblog.com/2009/02/24/xtrabackup-op en-source-alternative-for-innodb-hot-backup-call-for-ideas/

http://marcus.bointon.com/archives/87-MySQL-backups-with-Per conas-XtraBackup.html

Krishna

CGI (cgi.com)

On Sun, Oct 10, 2010 at 10:30 AM, kranthi wrote:

>
>
> Hi ,
>
> My database size is 900GB.i don't want full database backup. I
> need only yesterday backup. how can I take, please help me.
>
>
>
> Thanks & Regards,
>
> Kranti
>
>

--001636c5b8b93633c1049255380d--

Re: Backup

------=_NextPart_000_0007_01CB691B.D407B720
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

I get, I use following



mysqlbinlog --start-date="2010-10-09 9:55:00" \

--stop-date="2010-10-10 10:05:00" \

/var/log/mysql/bin.123456 \

> /tmp/mysql_restore.sql





Thanks all





From: andrew.2.moore@nokia.com [mailto:andrew.2.moore@nokia.com]
Sent: Sunday, October 10, 2010 4:46 AM
To: kranthikiran.inf@gmail.com
Subject: Re: Backup



hmm a yesterday backup? MySqldump using where clauses? Why do you only want
yesterday?

-- Sent from my HTC Desire on 3 --

----- Reply message -----
From: "ext kranthi"
Date: Sun, Oct 10, 2010 04:51
Subject: Backup
To: "backup@lists.mysql.com"

Hi ,

My database size is 900GB.i don't want full database backup. I
need only yesterday backup. how can I take, please help me.



Thanks & Regards,

Kranti


------=_NextPart_000_0007_01CB691B.D407B720--