hi, the > sign remains in the command , so you will have : C:\mysql\bin\>mysqldump -u ola -p --opt --databases --complete-insert --flush-logs > d:\path\to\backup\filename.sql
The > sign will redirect output into file. Thierno 6C -----Original Message----- From: Ola Ogunneye [mailto:[EMAIL PROTECTED] Sent: jeudi 31 juillet 2003 15:52 To: [EMAIL PROTECTED] Subject: RE: Help!!! Need to backup mysql using - MYSQL Second Edition? Thank you once again, so the correct thing is: C:\mysql\bin\>mysqldump -u ola -p --opt --databases --complete-insert --flush-logs > d:\path\to\backup\filename.sql Or does the > sign come out as well? Thanks Ola >>> Thierno Cissé <[EMAIL PROTECTED]> 07/31/03 11:48AM >>> Hi, rapid correction !! in the backup command, retrieve the word mysql placed just after --flush-logs . Thierno 6C -----Original Message----- From: Thierno Cissé [mailto:[EMAIL PROTECTED] Sent: jeudi 31 juillet 2003 15:40 To: 'Ola Ogunneye' Cc: [EMAIL PROTECTED] Subject: RE: Help!!! Need to backup mysql using - MYSQL Second Edition? Hi, when you run this backup command, it wait that you provide a password (it is as if it were spirit to treat the command) without prompt; so just after you press enter key to run the backup command, type here you password. Also you can place directly the password in the command like this : mysqldump -u username -pyour_password --opt --databases --complete-insert --flush-logs mysql > d:\path\to\backup\filename.sql NOTE : -p and your password are stuck > and that the --databases will take care of all the databases? yes , it will backup all databases. Hope this run -----Original Message----- From: Ola Ogunneye [mailto:[EMAIL PROTECTED] Sent: jeudi 31 juillet 2003 15:15 To: [EMAIL PROTECTED] Subject: RE: Help!!! Need to backup mysql using - MYSQL Second Edition? Hi, sorry to bother you, but from what you recommended, am I typing everything just the way you typed it out except for the username which would be my username, or are there other variables in there that I need to change to something else? In essence, if my username is ola, is all I am now doing is changing the username to ola or do I need to provide the password for user ola, I also have created 3 databases apart from the default test and mysql (5 Databases in all), I take it that I do not have to specify each by its name, and that the --databases will take care of all the databases? The user ola has a password being the root user, do I put in the password somewhere as well or is mysql going to promt me for the passsword? Is all I am typing the following? C:\mysql\bin\>mysqldump -u ola -p --opt --databases --complete-insert --flush-logs mysql > d:\path\to\backup\filename.sql Thanks in advance Ola >>> Thierno Cissé <[EMAIL PROTECTED]> 07/31/03 11:03AM >>> 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]