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