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

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

Any ideas appreciated, or even any other backu p methods =
for innodb
tables that don't require costly software.

Thanks,
James Dickson

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

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 <JDickson [at] tokairo.com> 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!
>
> Any ideas appreciated, or even any other backup methods for innodb
> tables that don't require costly software.
>
> Thanks,
> James Dickson
>
> ____________________________________________________________ ____________
> 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
> ____________________________________________________________ ____________
>


--
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 [at] m.gmane.org

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 [at] m.gmane.org

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 [at] m.gmane.org

"Peter Monk" <peter.monk [at] uwi.com.au> wrote in message
news:430404FB.3010501 [at] 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 [at] m.gmane.org

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 <dbefc [at] furiousgames.com> wrote:
> "Peter Monk" <peter.monk [at] uwi.com.au> wrote in message
> news:430404FB.3010501 [at] 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 (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?
>
> Thanks
> DanB
>
>
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=3Ddanieldaveiga [at] gma=
il.com
>
>


--
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 [at] m.gmane.org

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 [at] m.gmane.org

Dan Baker wrote:

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

mysqldump.exe -a -c -e -i -B -Q -u<user> -p<password> -r<destination file> <database name>

> 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 [at] m.gmane.org

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 [at] m.gmane.org

Thanks Peter,
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 cur=
rent date, I have to
use a static filename which is always the sa me. What s=
yntax did you use
to set the filename in your batchfile/cron job ? Do you =
pipe it through
Gzip or is there a switch I've missed! My DB dump is=
4GB so a compressed
daily version would be rather nice...

James

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

____________________________________________________________ ____________
This e-mail has been scanned for all viruses=2 0by Star. =
The
service is powered by MessageLabs. For more in formation on=
a proactive
anti-virus service working around the clock, aro und the gl=
obe, 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=3Dgcdmw-win32 [at] m.gmane.org

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=<backup folder>
set Filename=backup_%Year%%Month%%Day%.sql

mysqldump.exe -a -c -e -i -B -Q -u<user> -p<pass> -r%Filepath%\%Filename% <database>


Peter.

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

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

Thanks.
James

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

____________________________________________________________ ____________
This e-mail has been scanned for all viruses=2 0by Star. =
The
service is powered by MessageLabs. For more in formation on=
a proactive
anti-virus service working around the clock, aro und the gl=
obe, 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=3Dgcdmw-win32 [at] m.gmane.org

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

Karam

--- James Dickson <JDickson [at] Tokairo.com> wrote:

>
> That's simple enough - should have thought of it!
>
> Thanks.
> James
>
> > -----Original Message-----
> > From: Peter Monk [mailto:peter.monk [at] uwi.com.au]
> > Sent: 19 August 2005 09:32
> > To: James Dickson; win32 [at] 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=<backup folder>
> > set Filename=backup_%Year%%Month%%Day%.sql
> >
> > mysqldump.exe -a -c -e -i -B -Q -u<user> -p<pass>
> > -r%Filepath%\%Filename% <database>
> >
> >
> > 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 [at] 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 [at] m.gmane.org

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 [at] m.gmane.org