On 19-Feb-2003 Jeff Mao wrote:
> Greetings all,
>
> Not sure if this is the right place to ask this,...I use the
> following script on an OS X server to backup my mysql databases:
>
> #!/bin/sh
> DATE=`/bin/date +%Y%m%d"_"%H%M%S`;
> cd /Users/usernmae/Documents;
> /usr/bin/mysqldump -hhost -u
Jeff Mao <[EMAIL PROTECTED]> writes:
> Greetings all,
>
> Not sure if this is the right place to ask this,...I use the following
> script on an OS X server to backup my mysql databases:
>
> #!/bin/sh
> DATE=`/bin/date +%Y%m%d"_"%H%M%S`;
> cd /Users/usernmae/Documents;
> /usr/bin/mysqldump -hho
You need a combo of cron jobs (man crontab) and use either mysqldump or
mysqlhotcopy.
cron:
* 3 * * *
script
./mysqldump --opt -A > -u
this is just one of the many ways.
- Original Message -
From: "Ilyas Keser" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 27, 2
Mark Stringham :
i think that you can use task plan on windows.such as,
backup.bat:
mysqldump -uroot -pmysql databasename tablename > tablename.sql
move tablename.sql d:\where you want store it\
and add a tast plan in control panel, set the time to 3 o'lock,
set the
Pada Mon, 26 Aug 2002 20:37:46 -0600
"Mark Stringham" <[EMAIL PROTECTED]> menulis :
> Anyone done it on widows?
>
> Thanks
>
> Mark
for dumping, the syntax is same ... mysqldump bla bla bla ;-)
but for the time, you have to use scheduler application to run the mysqldump :D
--
Write c
Anyone done it on widows?
Thanks
Mark
- Original Message -
From: "Ilyas Keser" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 26, 2002 4:26 PM
Subject: backup script
> Has anyone a shell script example to backup all mysql databases at 3
> o'clock at the night?
>
> Tha
I use a shell script and set up a cron job. Here's the shell script (I call
it mydbbak.sh)
#
#!/bin/sh
#
# Create /dbbakup directory
# $1 = Unix/MySQL Username
# $2 = Unix/MySQL Password
if [ ! -e /dbbakup ]
then
mkdir /dbbakup
