Scheduled backups

------_=_NextPart_001_01C5A366.AD10A7CE
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi=20all,
New=20to=20the=20list=20but=20I'm=20really=20looking=20for=2 0some=20help.=20=
I=20decided=20to=20use
the=20Administrator=20backup=20project=20to=20setup=20schedu led=20backups=20=
for=20our
databases.=20This=20seems=20to=20generate=20a=20fantasticall y=20long=20com=
mand=20line=20and
a=20windows=20scheduled=20task=20to=20run=20it=20at=20the=20 specified=20ti=
me.=20Problem=20is=20it
never=20runs.=20The=20job=20is=20on=20a=20Windows=202000=20s erver,=20I've=20=
set=20the=20job=20to=20run
as=20domain=20admin=20(small=20domain=20with=20limited=20acc ess=20so=20no=20=
security=20issue).
When=20the=20job=20runs=20it=20typically=20reports a=20 file=20not=20f=
ound.=20If=20I=20copy=20the
command=20line=20from=20the=20job,=20paste=20it=20into=20the =20run=20promp=
t,=20it=20runs=20fine!
=20
Any=20ideas=20appreciated,=20or=20even=20any=20other=20backu p=20methods=20=
for=20innodb
tables=20that=20don't=20require=20costly=20software.
=20
Thanks,
James=20Dickson

____________________________________________________________ ____________
This=20e-mail=20has=20been=20scanned=20for=20all=20viruses=2 0by=20Star.=20=
The
service=20is=20powered=20by=20MessageLabs.=20For=20more=20in formation=20on=
=20a=20proactive
anti-virus=20service=20working=20around=20the=20clock,=20aro und=20the=20gl=
obe,=20visit:
http://www.star.net.uk
____________________________________________________________ ____________
------_=_NextPart_001_01C5A366.AD10A7CE--

Re: Scheduled backups

I use the MySQL Administrator backup projects for a long time, but I
noticed that Windows requires an account with a password to run it...

Never had trouble with it...

On 8/17/05, James Dickson wrote:
> Hi all,
> New to the list but I'm really looking for some help. I decided to use
> the Administrator backup project to setup scheduled backups for our
> databases. This seems to generate a fantastically long command line and
> a windows scheduled task to run it at the specified time. Problem is it
> never runs. The job is on a Windows 2000 server, I've set the job to run
> as domain admin (small domain with limited access so no security issue).
> When the job runs it typically reports a file not found. If I copy the
> command line from the job, paste it into the run prompt, it runs fine!
>=20
> Any ideas appreciated, or even any other backup methods for innodb
> tables that don't require costly software.
>=20
> Thanks,
> James Dickson
>=20
> ____________________________________________________________ ____________
> This e-mail has been scanned for all viruses by Star. The
> service is powered by MessageLabs. For more information on a proactive
> anti-virus service working around the clock, around the globe, visit:
> http://www.star.net.uk
> ____________________________________________________________ ____________
>=20


--=20
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

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

Re: Scheduled backups

James Dickson wrote:

> New to the list but I'm really looking for some help. I decided to use
> the Administrator backup project to setup scheduled backups for our
> databases.

I've just implemented nightly backups for mysql. I must say, I had
problems with MySQL Administrator as well (nothing ever seemed to
happen with the backup operation I set up).

My method was pretty simple: cron running (under Windows), triggering
a batch file. The batch file would use mysqldump and the current date
to create a uniquely named backup file (ie: backup_20050818.sql),
which was then gzipped and copied to a remote computer.

It's run flawlessly so far - the hardest part was finding a version
of cron for Windows that didn't crash every day or so! (and i'm still
not convinced that problem's been solved...)

Peter.

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Scheduled backups

At 10:48 PM 8/17/2005, Peter Monk wrote:
>It's run flawlessly so far - the hardest part was finding a version
>of cron for Windows that didn't crash every day or so! (and i'm still
>not convinced that problem's been solved...)
>Peter.

OK, Peter: I gotsta know. If you were having trouble getting cron going on
Windows, why didn't you just use the Windows Scheduled Tasks?

-jgl

******************* PLEASE NOTE *******************

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Scheduled backups

"Peter Monk" wrote in message
news:430404FB.3010501@uwi.com.au...
> James Dickson wrote:
>
>> New to the list but I'm really looking for some help. I decided to use
>> the Administrator backup project to setup scheduled backups for our
>> databases.
>
> I've just implemented nightly backups for mysql. I must say, I had
> problems with MySQL Administrator as well (nothing ever seemed to
> happen with the backup operation I set up).
>
> My method was pretty simple: cron running (under Windows), triggering
> a batch file. The batch file would use mysqldump and the current date
> to create a uniquely named backup file (ie: backup_20050818.sql),
> which was then gzipped and copied to a remote computer.

I'm curious to know what parameters you use to mysqldump?
I would like to get something that I can use to rebuild the database (with
all tables), and re-populate every table.
Have you tried using one of your .sql files to rebuild from scratch, and did
it work correctly?

Thanks
DanB




--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Scheduled backups

I used the mysql administrator backup to schedule and run the dump,
but before it was release I too had a batch running (of course it was
failing now and then), I don't remember the exact syntax for the dump,
but a simple database dump should do the job.

And I've rebuild the whole database from zero with it, it worked....
(of course I lost the last day of work, better than the whole month
:))

On 8/18/05, Dan Baker wrote:
> "Peter Monk" wrote in message
> news:430404FB.3010501@uwi.com.au...
> > James Dickson wrote:
> >
> >> New to the list but I'm really looking for some help. I decided to use
> >> the Administrator backup project to setup scheduled backups for our
> >> databases.
> >
> > I've just implemented nightly backups for mysql. I must say, I had
> > problems with MySQL Administrator as well (nothing ever seemed to
> > happen with the backup operation I set up).
> >
> > My method was pretty simple: cron running (under Windows), triggering
> > a batch file. The batch file would use mysqldump and the current date
> > to create a uniquely named backup file (ie: backup_20050818.sql),
> > which was then gzipped and copied to a remote computer.
>=20
> I'm curious to know what parameters you use to mysqldump?
> I would like to get something that I can use to rebuild the database (wit=
h
> all tables), and re-populate every table.
> Have you tried using one of your .sql files to rebuild from scratch, and =
did
> it work correctly?
>=20
> Thanks
> DanB
>=20
>=20
>=20
>=20
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gma=
il.com
>=20
>=20


--=20
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

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

Re: Scheduled backups

Jonathan G. Lampe wrote:

> OK, Peter: I gotsta know. If you were having trouble getting cron going
> on Windows, why didn't you just use the Windows Scheduled Tasks?

I guess a couple of reasons:

The other admin who looks after the server is a bit of a linux fan
and prefers cron over windows scheduler. Also, I have more experience
with cron than with scheduler.

I also find it easier to add another line to a cron.tab file rather
than go through the scheduler interface.

So, perhaps no really good reasons! But now I have a personal crusade:
find a windows cron service that doesn't suck. ;)

Peter.

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Scheduled backups

Dan Baker wrote:

> I'm curious to know what parameters you use to mysqldump?

mysqldump.exe -a -c -e -i -B -Q -u -p -r

> I would like to get something that I can use to rebuild the database (with
> all tables), and re-populate every table.
> Have you tried using one of your .sql files to rebuild from scratch, and did
> it work correctly?

Yes, this creates a complete .sql file - I have, on another machine, gone into
phpMyAdmin and imported the gzipped .sql file directly (phpMyAdmin can handle
gzipped files now, yay!) and it has recreated the database perfectly.

This was my goal - to be able to have a nightly backup file that, in the
event of our server failing, I could load on to any suitable machine and
have running in very little time.

Peter.

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Scheduled backups

Peter Monk wrote:

Jonathan G. Lampe wrote:

> OK, Peter: I gotsta know. If you were having trouble getting cron
> going on Windows, why didn't you just use the Windows Scheduled Tasks?

Oo, wait, I do have a good reason. :)
Windows scheduler can't do anything more often than once per day.
In addition to our nightly MySQL backups, there are other tasks
that need to be run once every minute. So, either cron, or
multiple solutions (complex!).

Peter.

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Scheduled backups

James Dickson wrote:

> I was, and am now, using MySQLDump to get my backups. The only problem I
> have is getting it to output a file based on the current date, I have to
> use a static filename which is always the same. What syntax did you use
> to set the filename in your batchfile/cron job?

James,

I grabbed the current date via environment variables, like so:

set Day=%Date:~4,2%
set Month=%Date:~7,2%
set Year=%Date:~10,4%

set Filepath=
set Filename=backup_%Year%%Month%%Day%.sql

mysqldump.exe -a -c -e -i -B -Q -u -p -r%Filepath%\%Filename%


Peter.

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: Scheduled backups

Thanks=20Peter,
I=20was,=20and=20am=20now,=20using=20MySQLDump=20to=20get=20 my=20backups.=20=
The=20only=20problem=20I
have=20is=20getting=20it=20to=20output=20a=20file=20based=20 on=20the=20cur=
rent=20date,=20I=20have=20to
use=20a=20static=20filename=20which=20is=20always=20the=20sa me.=20What=20s=
yntax=20did=20you=20use
to=20set=20the=20filename=20in=20your=20batchfile/cron=20job ?=20Do=20you=20=
pipe=20it=20through
Gzip=20or=20is=20there=20a=20switch=20I've=20missed!=20My=20 DB=20dump=20is=
=204GB=20so=20a=20compressed
daily=20version=20would=20be=20rather=20nice...

James=20

>=20-----Original=20Message-----
>=20From:=20Peter=20Monk=20[mailto:peter.monk@uwi.com.au]=20
>=20Sent:=2018=20August=202005=2004:48
>=20To:=20win32@lists.mysql.com
>=20Subject:=20Re:=20Scheduled=20backups
>=20
>=20James=20Dickson=20wrote:
>=20
>=20>=20New=20to=20the=20list=20but=20I'm=20really=20looking =20for=20some=20=
help.=20I=20
>=20decided=20to=20use=20
>=20>=20the=20Administrator=20backup=20project=20to=20setup= 20scheduled=20=
backups=20for=20our=20
>=20>=20databases.
>=20
>=20I've=20just=20implemented=20nightly=20backups=20for=20my sql. I=20=
must=20say,=20
>=20I=20had=20problems=20with=20MySQL=20Administrator=20as=2 0well=20(nothi=
ng=20ever=20
>=20seemed=20to=20happen=20with=20the=20backup=20operation=2 0I=20set=20up)=
..
>=20
>=20My=20method=20was=20pretty=20simple:=20cron=20running=20 (under=20Windo=
ws),=20
>=20triggering=20a=20batch=20file. The=20batch=20file=2 0would=20use=20=
mysqldump=20
>=20and=20the=20current=20date=20to=20create=20a=20uniquely= 20named=20back=
up=20file=20
>=20(ie:=20backup_20050818.sql),=20which=20was=20then=20gzip ped=20and=20co=
pied=20
>=20to=20a=20remote=20computer.
>=20
>=20It's=20run=20flawlessly=20so=20far=20-=20the=20hardest=2 0part=20was=20=
finding=20a=20
>=20version=20of=20cron=20for=20Windows=20that=20didn't=20cr ash=20every=20=
day=20or=20
>=20so! (and=20i'm=20still=20not=20convinced=20that=20p roblem's=20bee=
n=20solved...)
>=20
>=20Peter.
>=20
>=20--=20
>=20
>=20MySQL=20Windows=20Mailing=20List
>=20For=20list=20archives:=20http://lists.mysql.com/win32
>=20To=20unsubscribe:
>=20http://lists.mysql.com/win32?unsub=3Djdickson@tokairo.co m
>=20
>=20
>=20________________________________________________________ ______
>=20__________
>=20This=20e-mail=20has=20been=20scanned=20for=20all=20virus es=20by=20Star=
..=20The=20
>=20service=20is=20powered=20by=20MessageLabs.=20For=20more= 20information=20=
on=20a=20
>=20proactive=20anti-virus=20service=20working=20around=20th e=20clock,=20a=
round=20
>=20the=20globe,=20visit:
>=20http://www.star.net.uk
>=20________________________________________________________ ______
>=20__________
>=20

____________________________________________________________ ____________
This=20e-mail=20has=20been=20scanned=20for=20all=20viruses=2 0by=20Star.=20=
The
service=20is=20powered=20by=20MessageLabs.=20For=20more=20in formation=20on=
=20a=20proactive
anti-virus=20service=20working=20around=20the=20clock,=20aro und=20the=20gl=
obe,=20visit:
http://www.star.net.uk
____________________________________________________________ ____________

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

RE: Scheduled backups

That's=20simple=20enough=20-=20should=20have=20thought=20of= 20it!

Thanks.
James

>=20-----Original=20Message-----
>=20From:=20Peter=20Monk=20[mailto:peter.monk@uwi.com.au]=20
>=20Sent:=2019=20August=202005=2009:32
>=20To:=20James=20Dickson;=20win32@lists.mysql.com
>=20Subject:=20Re:=20Scheduled=20backups
>=20
>=20James=20Dickson=20wrote:
>=20
>=20>=20I=20was,=20and=20am=20now,=20using=20MySQLDump=20to= 20get=20my=20b=
ackups.=20The=20
>=20only=20problem=20
>=20>=20I=20have=20is=20getting=20it=20to=20output=20a=20fil e=20based=20on=
=20the=20current=20date,=20I=20
>=20>=20have=20to=20use=20a=20static=20filename=20which=20is =20always=20th=
e=20same.=20What=20syntax=20
>=20>=20did=20you=20use=20to=20set=20the=20filename=20in=20y our=20batchfil=
e/cron=20job?
>=20
>=20James,
>=20
>=20I=20grabbed=20the=20current=20date=20via=20environment=2 0variables,=20=
like=20so:
>=20
>=20set=20Day=3D%Date:~4,2%
>=20set=20Month=3D%Date:~7,2%
>=20set=20Year=3D%Date:~10,4%
>=20
>=20set=20Filepath=3D
>=20set=20Filename=3Dbackup_%Year%%Month%%Day%.sql
>=20
>=20mysqldump.exe=20-a=20-c=20-e=20-i=20-B=20-Q=20-u=20-p=20
>=20-r%Filepath%\%Filename%=20
>=20
>=20
>=20Peter.
>=20
>=20________________________________________________________ ______
>=20__________
>=20This=20e-mail=20has=20been=20scanned=20for=20all=20virus es=20by=20Star=
..=20The=20
>=20service=20is=20powered=20by=20MessageLabs.=20For=20more= 20information=20=
on=20a=20
>=20proactive=20anti-virus=20service=20working=20around=20th e=20clock,=20a=
round=20
>=20the=20globe,=20visit:
>=20http://www.star.net.uk
>=20________________________________________________________ ______
>=20__________
>=20

____________________________________________________________ ____________
This=20e-mail=20has=20been=20scanned=20for=20all=20viruses=2 0by=20Star.=20=
The
service=20is=20powered=20by=20MessageLabs.=20For=20more=20in formation=20on=
=20a=20proactive
anti-virus=20service=20working=20around=20the=20clock,=20aro und=20the=20gl=
obe,=20visit:
http://www.star.net.uk
____________________________________________________________ ____________

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

RE: Scheduled backups

I prefer to use SQLyog at http://www.webyog.com to do
my scheduled backups.

Karam

--- James Dickson wrote:

>
> That's simple enough - should have thought of it!
>
> Thanks.
> James
>
> > -----Original Message-----
> > From: Peter Monk [mailto:peter.monk@uwi.com.au]
> > Sent: 19 August 2005 09:32
> > To: James Dickson; win32@lists.mysql.com
> > Subject: Re: Scheduled backups
> >
> > James Dickson wrote:
> >
> > > I was, and am now, using MySQLDump to get my
> backups. The
> > only problem
> > > I have is getting it to output a file based on
> the current date, I
> > > have to use a static filename which is always
> the same. What syntax
> > > did you use to set the filename in your
> batchfile/cron job?
> >
> > James,
> >
> > I grabbed the current date via environment
> variables, like so:
> >
> > set Day=%Date:~4,2%
> > set Month=%Date:~7,2%
> > set Year=%Date:~10,4%
> >
> > set Filepath=
> > set Filename=backup_%Year%%Month%%Day%.sql
> >
> > mysqldump.exe -a -c -e -i -B -Q -u -p
> > -r%Filepath%\%Filename%
> >
> >
> > Peter.
> >
> >
>
____________________________________________________________ __
> > __________
> > This e-mail has been scanned for all viruses by
> Star. The
> > service is powered by MessageLabs. For more
> information on a
> > proactive anti-virus service working around the
> clock, around
> > the globe, visit:
> > http://www.star.net.uk
> >
>
____________________________________________________________ __
> > __________
> >
>
>
____________________________________________________________ ____________
> This e-mail has been scanned for all viruses by
> Star. The
> service is powered by MessageLabs. For more
> information on a proactive
> anti-virus service working around the clock, around
> the globe, visit:
> http://www.star.net.uk
>
____________________________________________________________ ____________
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
>
http://lists.mysql.com/win32?unsub=karam_chand03@yahoo.com
>
>


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Scheduled backups

At 01:16 AM 8/19/2005, Peter Monk wrote:
>Peter Monk wrote:
>Jonathan G. Lampe wrote:
>>OK, Peter: I gotsta know. If you were having trouble getting cron going
>>on Windows, why didn't you just use the Windows Scheduled Tasks?
>Windows scheduler can't do anything more often than once per day.
>In addition to our nightly MySQL backups, there are other tasks
>that need to be run once every minute.

Oops - I think you missed the "Repeat Task" options under the "Advanced"
button. (That's different than "multiple schedules".) That lets you
schedule tasks to be repeated up to one minute and lets you define a time
window in which a task should be run...check it out.

-jgl

******************* PLEASE NOTE *******************

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org