Hi, Shut your database down, backup all files, and restart it....
If you use InnoDB you can do a hot backup like Oracle (the implementation of InnoDB is near of Oracle), but it's not free. I can't say more about this, but it's in the documentation about InnoDB. You can also keep a differential between two backup (in case the last backup is corrupted) using binary log of MySQL (use --log-bin at startup). I just begin to test it... To do a backup of all you database(s) you can use mysqldump. The dump contains "create datase, table, ..." and "insert ..." orders. Being beginner, I'm also interested about backup stuff, I hope somebody will complete my post. Sam. -----Message d'origine----- De : Amol Sonaikar [mailto:amol@;kenati.com] Envoyé : mercredi 30 octobre 2002 06:27 À : [EMAIL PROTECTED] Objet : Backup DB HI All I am new to mysql. We have a small application which runs on mysql db. We want to backup the database for mysql. What is the easiest method to that ? Do we have to move datafiles or import export like oracle ? If you can send me a specific link or article for backup and recovery for mysql , I'll be very much thankful. Thanks Amol Oracle 8i DBA --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
