www.webdeveloper.com
Results 1 to 4 of 4

Thread: Mysqldump syntax error

  1. #1
    Join Date
    Dec 2005
    Posts
    7

    Mysqldump syntax error

    Hi all!
    I was wondering what I miss out below in mysqldump syntax

    mysql> mysqldump -u root -p dbaseName >file.sql;

    or

    mysql> mysqldump -u root dbaseName >file.sql;

    I connect as "root" and tehre is no password.
    In both cases I get errors.
    Thanks!

  2. #2
    Join Date
    Aug 2004
    Location
    Ankh-Morpork
    Posts
    19,148
    What errors do you get?
    "Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
    ~ Terry Pratchett in Nation

    eBookworm.us

  3. #3
    Join Date
    Dec 2005
    Posts
    7
    Right, in case someone is wondering, I figured this out. Mysqldump is standalone and shouldn't be runing inside mysql.
    Cheers.

  4. #4
    Join Date
    Oct 2007
    Posts
    1

    reply

    Quote Originally Posted by renesis
    Hi all!
    I was wondering what I miss out below in mysqldump syntax

    mysql> mysqldump -u root -p dbaseName >file.sql;

    or

    mysql> mysqldump -u root dbaseName >file.sql;

    I connect as "root" and tehre is no password.
    In both cases I get errors.
    Thanks!

    Hello,

    mysqldump is standalone application,
    so go C:\Program Files\MySQL\MySQL Server 5.0\bin folder
    copy the path
    past in command prompt
    type

    C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqldump -uroot -p directorymaps >a.sql
    Enter password:

    now it will work, i am sure
    #
    Open the Command Line utility by Clicking on 'Start' and 'Run' and typing 'CMD' and pressing 'ok'
    #
    Type 'mysqldump'
    #
    Type -u and your username '-uusername'
    #
    Type -p and your password '-ppassword'
    #
    Type your database name 'mydatabase'
    #
    Type a greater-than sign to put the results in to a file '>'
    #
    Type the name of the file to put the results in 'mybackupfile.sql

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles