September 28th, 2000, 12:33 PM
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!
September 28th, 2000, 12:38 PM
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.
September 28th, 2000, 12:51 PM
Thank You!! I knew it was a stupid problem, I just didn't realize how stupid!
But I guess that's how you learn.