Hi Murali, You have to execute it outside mysql prompt i.e command prompt. Thanks Suresh Kuna MySQL DBA Sent from BlackBerry® on Airtel
-----Original Message----- From: muralikrishna g <muralikrishn...@gmail.com> Date: Tue, 2 Feb 2010 12:17:24 To: Suresh Kuna<sureshkumar...@gmail.com> Cc: <mysql@lists.mysql.com> Subject: Re: hi help to take backup-mysql-windows-xp hi to all.. i was in need to take backup of database.. i am using sql server version:5.0.27-coomunity-nt i have tried by using mysqldump -u name -p password database_name > backup.sql; but i am getting error.. i am using windows xp system.. please help me mysql> mysqldump -u root -p dbadmin murali > 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 -u root -p dbadmin murali > backupfile.sql' at line 1 mysql> mysqldump -uroot -pdbadmin murali > 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 -uroot -pdbadmin murali > backupfile.sql' at line 1 mysql> On 2/2/10, Suresh Kuna <sureshkumar...@gmail.com> wrote: > > Please paste the error and don't give the spave between -p and password. > > > On Tue, Feb 2, 2010 at 12:05 PM, muralikrishna g < > muralikrishn...@gmail.com> wrote: > >> hi to all.. >> i was in need to take backup of database.. >> i am using sql server version:5.0.27-coomunity-nt >> i have tried by using >> mysqldump -u name -p password database_name > backup.sql; >> >> but i am getting error.. i am using windows xp system.. please help me >> > > > > -- > Thanks > Suresh Kuna > MySQL DBA >