File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Back of database

 
Mahesh Lohi
Ranch Hand
Posts: 151
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
author & internet detective
Marshal
Posts: 33697
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 151
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Bartender
Posts: 2577
11
C++ Linux Netbeans IDE
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
    Ranch Hand
    Posts: 151
    • 0
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    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
    Bartender
    Posts: 2577
    11
    C++ Linux Netbeans IDE
    • 0
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    Do you have a MySQL user named ODBC that has the correct rights?
     
    Mahesh Lohi
    Ranch Hand
    Posts: 151
    • 0
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    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
    Bartender
    Posts: 3908
    9
    Chrome Fedora Hibernate
    • 0
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    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
    Ranch Hand
    Posts: 234
    • 0
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    How can I make the backup of my MySQL database step by step please?
     
    Vijitha Kumara
    Bartender
    Posts: 3908
    9
    Chrome Fedora Hibernate
    • 0
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    André Asantos wrote:How can I make the backup of my MySQL database step by step please?

    MySQL backup methods.
     
    Mahesh Lohi
    Ranch Hand
    Posts: 151
    • 0
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    Thnak you for your replies
     
    I agree. Here's the link: http://aspose.com/file-tools
    • Post Reply
    • Bookmark Topic Watch Topic
    • New Topic