Hello.
> It looks like there is something called a InnoDB Hot Backup that is a = > perl script. Is this something that Mysql offers, or is it something one = > needs to purchase. InnoDB Hot Backup is a good tool. Have a look here: http://www.innodb.com/order.php But mysqldump is very often good as well. Have a look here: http://dev.mysql.com/doc/mysql/en/mysqldump.html You should read carefully about --lock-all-tables, --lock-tables, --single-transaction, --all-databases command line options. Search in the archives at: http://lists.mysql.com/mysql for possible backup solutions where tables of both types are present. "Scott Purcell" <[EMAIL PROTECTED]> wrote: > Hello, > > I am running mysql 4.0.15 on a Win2000 operating system. I would like = > to be able to back up the system with a perl script. I have a mix of = > InnoDB and MyISAM table types. Upon investigating this, I found this web = > site, with an article about backing up mysql databases: > > http://www.databasejournal.com/features/mysql/article.php/3421751 > > It looks like there is something called a InnoDB Hot Backup that is a = > perl script. Is this something that Mysql offers, or is it something one = > needs to purchase. > > My database is rather small, and I basically want to pull 2 backups a = > day, in case I have any hardware failures. > > > If someone could help advise me on this topic, I would appeciate it. > > Thanks, > Scott > > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]