Thread: MySQL automatic backup script I can run??
View Single Post
Old 10-24-2007, 10:35 AM  
Juicy D. Links
So Fucking Banned
 
Industry Role:
Join Date: Apr 2001
Location: N.Y. -Long Island --
Posts: 122,992
Quote:
Originally Posted by psili View Post
Not sure about InnoDB tables, but can't you put the following in a shell script:

mysqldump --user=[user] --pass=[pass] --opt [database] > /path/to/backup.sql
hmm that looks ripe. i try it
Juicy D. Links is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote