I use something like this: mysqldump --tab=/var/lib/mysql/backup --all --user=root -p --fields-terminated-by="|" ecom Problem with this is you have to type in your mySQL root password or pass it in the script. Which seems inconvenient or unsafe respectively... Brady > Well... if you were using PostgreSQL I'd tell you to run `pg_dump -F c > -Z 9 <dbname>'. You're not so I'll just have to assume the MySQL folks > have a similar utility. > > Joshua Jore > Minneapolis Ward 3, precinct 10 > "The irony of this man being imprisoned in the United States and longing > to return to once-Communist Russia so he can regain his right to free > speech is simply staggering." - someone else > > On Tue, 4 Sep 2001, Mike Nielsen wrote: > > > > > Hi there, > > > > I know which Microsoft SQL and Veritas > > Backup exec I need to either install the Veritas > > SQL agent or scedule MsSQL to do a database dump to a > > file every night to be sure I have a valid backup of that data. > > > > > > I assume the procedure is somewhat the same with MySQL > > regardless the backup software I use? For now I'm > > toying with Kbackup .... > > > > I would like to avoid having to kill mysqld backing up and then > > restarting if at all possible. > > > > Any ideas?