Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
Luke
The Ninja Space Mod
Posts: 6424 Joined: Fri Aug 05, 2005 1:53 pm
Location: Paradise, CA
Post
by Luke » Mon May 22, 2006 1:22 pm
I am having a very hard time doing a mysqldump. What is the syntax to do a mysqldump from a command prompt? (phpmyadmin has rendered me useless in the world of mysql commands).
Luke
The Ninja Space Mod
Posts: 6424 Joined: Fri Aug 05, 2005 1:53 pm
Location: Paradise, CA
Post
by Luke » Mon May 22, 2006 1:38 pm
I tried
Code: Select all
mysqldump databasename > C:\dbase.sql;
and it just dropped me down to another line with one of these:
I am confused.
timvw
DevNet Master
Posts: 4897 Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium
Post
by timvw » Mon May 22, 2006 1:51 pm
mysqldump -u username -ppassword -h invalid.org dbname > ~/mysql.dmp