SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member
    Join Date
    Jan 2006
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    mysql dump error

    I am new to mysql. i am using the database dvd in my windows xp machine. i tried the following command in the mysql prompt but everything created error. So i got doubt whether it should be executed in this mysql propmpt or in the command prompt. This is urgent for me. So if you find the result please dont hesitate to reply me.


    Enter password: ********
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 306 to server version: 5.0.18-nt

    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

    mysql> use dvd
    Database changed
    mysql> mysqldump dvd>c:\mysqldump\backupfile.sql
    ERROR:
    Unknown command '\m'.
    ERROR:
    Unknown command '\b'.
    -> ;
    ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
    corresponds to your MySQL server version for the right syntax to use near 'mysql
    dump dvd>c:\mysqldump\backupfile.sql' at line 1
    mysql> mysqldump dvd>backupfile.sql
    -> ;
    ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
    corresponds to your MySQL server version for the right syntax to use near 'mysql
    dump dvd>backupfile.sql' at line 1
    mysql> mysqldump -u root -p autoraja dvd>backup.sql
    -> mysqldump -u admin -p admin accounts>accounts.sql
    -> ;
    ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
    corresponds to your MySQL server version for the right syntax to use near 'mysql
    dump -u root -p autoraja dvd>backup.sql
    mysqldump -u admin -p admin account' at line 1
    mysql>

  2. #2
    SitePoint Wizard guelphdad's Avatar
    Join Date
    Oct 2003
    Location
    St. Catharines, ON Canada
    Posts
    1,706
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Use quotes around the path to the filename:
    "c:\mysqldump\backupfile.sql"

  3. #3
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by daveman
    Use quotes around the path to the filename:
    "c:\mysqldump\backupfile.sql"
    nope, that won't do it.

    rajadilly- the problem is that mysqldump is not a command in the mysql cli. mysqldump is its own program.


Bookmarks

Posting Permissions

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