Export the table

Discussion in 'Databases' started by HuaMin, Jan 25, 2010.

0
  1. #1
    Hi,
    I've tried this and have got

    C:\Program Files\MySQL\MySQL Server 5.1\bin>mysqldump -u user_name -p the_password -database
    s DBname > backup.sql

    mysqldump: unknown option '-b'

    Furthermore, is there any example for that we insert one record with one image file (from the local disk), to the DB table?

    Many Thanks & Best Regards,
    HuaMin Chen
     
    HuaMin, Jan 25, 2010 IP
  2. sahabcse

    sahabcse Well-Known Member

    Messages:
    272
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    140
    #2
    try below command

    #mysqldump -u user_name -p the_password DBname > backup.sql

    - databases ---> not required.
     
    sahabcse, Jan 25, 2010 IP
  3. rochem1867

    rochem1867 Guest

    Messages:
    34
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Hmm cant u just export through myphp?
     
    rochem1867, Jan 28, 2010 IP