Reg:mysqldump

------=_Part_19114_19881811.1138602221665
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

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

------=_Part_19114_19881811.1138602221665--

Re: Reg:mysqldump

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
>
>
>


--
Alexander Foken
mailto:alexander@foken.de http://www.foken.de/alexander/

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" 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
>>
>>
>>
>

Re: Reg:mysqldump

Dilly,

Mysql is a command line argument.

Open up a Dos box, locate the program in your directory and
run it as per below

C:\>\mysql\mysql-4.1.10a-win32\bin\mysqldump.exe -help
Usage: \mysql\mysql-4.1.10a-win32\bin\mysqldump.exe [OPTIONS] database
[tables]
OR \mysql\mysql-4.1.10a-win32\bin\mysqldump.exe [OPTIONS]
--databases [OPTIONS] DB1 [DB2 DB3...]
OR \mysql\mysql-4.1.10a-win32\bin\mysqldump.exe [OPTIONS]
--all-databases [OPTIONS]
For more options, use \mysql\mysql-4.1.10a-win32\bin\mysqldump.exe --help

Rgds
Trevor

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
>
>
>