hi, > Still a newbie, and running mysql on windows 2000 Advanced Server. I am trying to backup > mysql and was confused as to which command to use. I see the following options use mysqldump . If you want backup whole database(s) , proceed to next : mysqldump -u username -p --opt --databases --complete-insert --flush-logs mysql > d:\path\to\backup\filename.sql
> do I need to first create the directory where I want mysql to be backed up? you can do this, and give this directory in the path. > So the backup is a local backup anyway Thierno 6C -----Original Message----- From: Ola Ogunneye [mailto:[EMAIL PROTECTED] Sent: jeudi 31 juillet 2003 14:21 To: [EMAIL PROTECTED] Subject: Help!!! Need to backup mysql using - MYSQL Second Edition? Hello again, Still a newbie, and running mysql on windows 2000 Advanced Server. I am trying to backup mysql and was confused as to which command to use. I see the following options mysqldump mysqlhotcopy Now the confusion is really in the syntax used in the MYSQL Second Edition. I looked on page 718 and I am thinking that the command is for a Unix system. Since I am running on Windows, do I need to first create the directory where I want mysql to be backed up? And secondly, it is recommended that I do not backup in the same volume, so what exactly is the command for me to use, if mysql resides on C:\> and I want to back it up in the D:\>? I should tell you that my PC is still a standalone, and I am planning to take it online soon. So the backup is a local backup. Thank you all in advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]