Back of database

[Mahesh Lohi]

Hi I am facing a problem taking the backup of my DB. mysqldump command shows error. I am using mysql 5.1.. Please help.

Thankyou in advance

[Jeanne Boyarsky]

Mahi Lohi wrote:mysqldump command shows error.

You're likely to get more specific help if you share more information. Let's start with - what was the error message?

[Mahesh Lohi]

Jeanne Boyarsky wrote:

Mahi Lohi wrote:mysqldump command shows error.

You're likely to get more specific help if you share more information. Let's start with - what was the error message?

Am using mysql 5.1

C:\>mysqldump -r root -p password DBName> fileName.sql.

It shows mysqldump is not recognized as internal or external command, operable program or batch file.

However the file to which I like to take the back up is created with no data in it.

Thank you,

[Jan Cumps]

Hi,

the file is created because you use >
This will tell the operating system to create the file, and has nothing to do with mysql.

To be able to run the mysqldump program, you will have to:

navigate to the directory where the mysqldump executable is located, and run it from there - or

add the path when you run the command ( "c:\progr...\mysq...\mysqldump.exe" -r root -p password DBName> fileName.sql) - or

Add the path to the mysql binaries to your operating system PATH

[Mahesh Lohi]

Jan Cumps wrote:Hi,

the file is created because you use >
This will tell the operating system to create the file, and has nothing to do with mysql.

To be able to run the mysqldump program, you will have to:

navigate to the directory where the mysqldump executable is located, and run it from there - or

add the path when you run the command ( "c:\progr...\mysq...\mysqldump.exe" -r root -p password DBName> fileName.sql) - or

Add the path to the mysql binaries to your operating system PATH

I executed the way you have mentioned but then it is asking me for password and gives me an error of this kind after entering the password


mysqldump: Got error :1045 :access denied for user "ODBC" @localhost (using password: Yes) When trying to connect...

Thank you in advance

[Jan Cumps]

Do you have a MySQL user named ODBC that has the correct rights?

[Mahesh Lohi]

Jan Cumps wrote:Do you have a MySQL user named ODBC that has the correct rights?

I have no user named ODBC. I am using Netbean IDE , with jdbc odbc connection .. Does this make a difference..



Thank you

[Vijitha Kumara]

Mahi Lohi wrote:I have no user named ODBC. I am using Netbean IDE , with jdbc odbc connection .. Does this make a difference..

By looking at your previous post you are executing the mysql commands from the command line right? So I think this has nothing to do with the Netbeans. You should have username/password to access mysql DB. Read this for more details.

[André Asantos]

How can I make the backup of my MySQL database step by step please?

[Vijitha Kumara]

André Asantos wrote:How can I make the backup of my MySQL database step by step please?

MySQL backup methods.

[Mahesh Lohi]

Thnak you for your replies