#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    9
    Rep Power
    0
    I'm trying to back up a database on my ISP's server using mysqldump -

    mysql -u User -p Password mysqldump db_name > backupfile.sql

    I can't get it to work properly. When I opened the backup file I did not find the database structure that I expected -- instead I found that I had copied a mysql help file!

    It seems like this should be an easy thing to do (if only I could figure out how to do it)! I would really appreciate any help!

    Thanks!
  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    19
    The proper syntax is:

    mysqldump -u User -pPassword db_name >backupfile.sql

    The reason you got the help dump was that mysqldump is NOT an option for mysql, but it's own executable.

    Also, note there is no <space> between -p and Password.

  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    9
    Rep Power
    0
    Thank You!! I knew it was a stupid problem, I just didn't realize how stupid!

    But I guess that's how you learn.

    Thanks again!

Similar Threads

  1. Replies: 5
    Last Post: February 2nd, 2005, 12:28 AM
  2. UTF-8 problem in 4.1.1a
    By mehran20 in forum MySQL Help
    Replies: 1
    Last Post: February 8th, 2004, 02:21 PM
  3. Wierd problem inserting data with VB6
    By gregquinn in forum MySQL Help
    Replies: 5
    Last Post: February 2nd, 2004, 07:37 AM
  4. weird java problem..please help
    By suwandy in forum Java Help
    Replies: 1
    Last Post: January 26th, 2004, 04:13 AM
  5. Replies: 1
    Last Post: January 22nd, 2004, 07:56 AM

IMN logo majestic logo threadwatch logo seochat tools logo