Re: shell script to backup

2002-07-18 Thread jusob
En réponse à Ilyas Keser <[EMAIL PROTECTED]>: Hi you can use mysqldump et a crontab to save all databases in a text file. Regards Julien Sobrier > Hi all... > > I am a new Linux user. Does any one have a shell script to backup all > Mysql databases? > > Thanks > ilyas... > > -

RE: shell script to backup

2002-07-18 Thread Stefano Incontri
You could use something like : mysqldump -Q --opt -F --all-databases -h serverName -u root --password=yourpasswd > /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

Re: shell script to backup

2002-07-18 Thread Duncan Hill
On Thu, 18 Jul 2002, Ilyas Keser wrote: > Hi all... > > I am a new Linux user. Does any one have a shell script to backup all > Mysql databases? Read The fine Manual - it gives several ways. - Before posting, please check:

RE: shell script to backup

2002-07-18 Thread Cal Evans
mysqldump -opt > everything.sql * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Ilyas Keser [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 18, 2002 8:44 AM To: [EMAIL PROTECTED] Subject: shell script to backup Hi all... I am a new Linux user. D