Re: Reg:mysqldump

mysqldump is not a mysql command. Invoke it from your command line, just as
you invoke mysql from the command line.


On 1/30/06 6:45, "Alexander Foken" <alexander@xxxxxxxx> wrote:

> You may want to ask your question on a mysql mailing list, this is a DBI
> mailing list.
>
> Are you sure "mysqldump" is a command of the mysql monitor and not an
> independant program?
>
> Alexander
>
>
> Dilly raja wrote:
>
>> I have a problem in taking backup of mysql dump in my windows xp machine. I
>> have a database called dvd. i want to take the backup of this database so i
>> tried the following, but it gives error.So i got doubt, whether
>> the following commands should be executed in teh "mysql>" prompt or in some
>> other place. Please give me a result.
>>
>>
>> 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
>>
>>
>>
>> since i am new to mysql i dont know where to execute this commands. please
>> give me a result.
>>
>> --
>> Friendly,
>> Raja.M
>>
>>
>>
>


.

Relevant Pages

  • Re: MySQL gem problem on OS X [SOLVED]
    ... My mysql gem 2.7 is installed in the following directory: ... I have a symlink to the full name of the install to simplify the path name. ... using UNIX command cd) your way to each of those directories in separate terminal windows. ... but start with sudo. ...
    (comp.lang.ruby)
  • Re: Mysqldump password issue
    ... If I use the command: ... I believe that the '-p' flag to MySQL ... is a bit painful in that regard as it doesn't allow whitespace between ... just quote around the -p like so: ...
    (freebsd-questions)
  • Re: Mysqldump password issue
    ... If I use the command: ... I believe that the '-p' flag to MySQL ... is a bit painful in that regard as it doesn't allow whitespace between ... just quote around the -p like so: ...
    (freebsd-questions)
  • Re: [PHP] strange errors from command line vs. web
    ... This is the great way PHP-cli lets you know it hasn't got any MySQL ... can't run the script from the command line even when I su to root. ...
    (php.general)
  • OT: Problems importing SQL queries - drifting off in another direction...
    ... Someone gave has given me a SQL export of the data and table definition required for an OpenSource web app to transfer the data from a dev box to a live box. ... I definitely have all privs as I am logged in as the root MYSQL user. ... It might be worth having a go from the command line if you're feeling brave. ... I wasn't aware that mysqldump produced a nice lot of SQL commands. ...
    (uk.comp.sys.mac)