ra <[EMAIL PROTECTED]> wrote:
> I try to create a cron in Linux (Debian Sarge) and the content for this cron
> is a mysql database backup. I read documentation about mysqldump command and
> use, but I forgot something because it not works for me. I put this in bash:
> # mysqldu
I try to create a cron in Linux (Debian Sarge) and the content for this cron is
a mysql database backup. I read documentation about mysqldump command and use,
but I forgot something because it not works for me. I put this in bash:
# mysqldump --opt -c -C dp > /var/tmp_save/dproject.sql
But w
Cabbar Duzayak wrote:
...
I have setup cronjobs to take daily backups of my db using mysqldump.
But the problem is, mysqldump requires the password to be passed via
command line, which means anyone on the same machine can take a peek
at my password using "top", "ps -ef", etc.
Is there a way of a
ng in my case.
Anurag
-Original Message-
From: Rich Allen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 20, 2005 6:20 AM
To: Cabbar Duzayak
Cc: mysql@lists.mysql.com
Subject: Re: MySQLDump - Command line password
have you looked at using a my.cnf file?
eMac:~ hcir$ mysqldump test &g
have you looked at using a my.cnf file?
eMac:~ hcir$ mysqldump test > /temp/test.sql
eMac:~ hcir$ ls -l /temp/test.sql
-rw-r--r-- 1 hcir staff 78893008 Jul 19 16:47 /temp/test.sql
contents of ~/.my.cnf
[client]
user= username
password= password
# actual username and passw
Hi,
I have setup cronjobs to take daily backups of my db using mysqldump.
But the problem is, mysqldump requires the password to be passed via
command line, which means anyone on the same machine can take a peek
at my password using "top", "ps -ef", etc.
Is there a way of avoiding this, i.e. maki
"joe collins" <[EMAIL PROTECTED]> wrote:
> I have read the documentation on the MySQLDump, but have been unable to
> launch a mysql dump.
> Is the dump performed while logged on to the database that you want to
> dump, or do you log onto the machine where the database is and specify
> which databas
Hello Joe,
mysqldump is a seperate programto be execute at the system prompt.
Therefore it is not to be run under the mysql prompt.
Bernard
On Friday 26 March 2004 06:09, joe collins wrote:
> I have read the documentation on the MySQLDump, but have been unable to
> launch a mysql dump.
> Is t
I have read the documentation on the MySQLDump, but have been unable to
launch a mysql dump.
Is the dump performed while logged on to the database that you want to dump,
or do you log onto the machine where the database is and specify which
database you want to dump?. I have looked at and applied
