hi help to take backup-mysql-windows-xp

--0016364268b34fa6ee047e984f66
Content-Type: text/plain; charset=ISO-8859-1

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

--0016364268b34fa6ee047e984f66--

Re: hi help to take backup-mysql-windows-xp

--00504502ae63a9023e047e986380
Content-Type: text/plain; charset=ISO-8859-1

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

--00504502ae63a9023e047e986380--

Re: hi help to take backup-mysql-windows-xp

--0016364170d7728901047e987972
Content-Type: text/plain; charset=ISO-8859-1

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

--0016364170d7728901047e987972--

Re: hi help to take backup-mysql-windows-xp

--part21314-boundary-852911488-1075352568
Content-Transfer-Encoding: base64
Content-Type: text/plain; charset="Windows-1252"

SGkgTXVyYWxpLA0KWW91IGhhdmUgdG8gZXhlY3V0ZSBpdCBvdXRzaWRlIG15 c3FsIHByb21wdCBp
LmUgY29tbWFuZCBwcm9tcHQuDQoNClRoYW5rcw0KU3VyZXNoIEt1bmENCk15 U1FMIERCQQ0KU2Vu
dCBmcm9tIEJsYWNrQmVycnmuIG9uIEFpcnRlbA0KDQotLS0tLU9yaWdpbmFs IE1lc3NhZ2UtLS0t
LQ0KRnJvbTogbXVyYWxpa3Jpc2huYSBnIDxtdXJhbGlrcmlzaG5hNGdAZ21h aWwuY29tPg0KRGF0
ZTogVHVlLCAyIEZlYiAyMDEwIDEyOjE3OjI0IA0KVG86IFN1cmVzaCBLdW5h PHN1cmVzaGt1bWFy
aWx1QGdtYWlsLmNvbT4NCkNjOiA8bXlzcWxAbGlzdHMubXlzcWwuY29tPg0K U3ViamVjdDogUmU6
IGhpIGhlbHAgdG8gdGFrZSBiYWNrdXAtbXlzcWwtd2luZG93cy14cA0KDQpo aSB0byBhbGwuLg0K
aSB3YXMgaW4gbmVlZCB0byB0YWtlIGJhY2t1cCBvZiBkYXRhYmFzZS4uDQpp IGFtIHVzaW5nIHNx
bCBzZXJ2ZXIgdmVyc2lvbjo1LjAuMjctY29vbXVuaXR5LW50DQppIGhhdmUg dHJpZWQgYnkgdXNp
bmcNCm15c3FsZHVtcCAtdSBuYW1lIC1wIHBhc3N3b3JkIGRhdGFiYXNlX25h bWUgPiBiYWNrdXAu
c3FsOw0KDQpidXQgaSBhbSBnZXR0aW5nIGVycm9yLi4gaSBhbSB1c2luZyB3 aW5kb3dzIHhwIHN5
c3RlbS4uDQoNCnBsZWFzZSBoZWxwIG1lDQpteXNxbD4gbXlzcWxkdW1wIC11 IHJvb3QgLXAgZGJh
ZG1pbiBtdXJhbGkgPiBiYWNrdXBmaWxlLnNxbDsNCg0KRVJST1IgMTA2NCAo NDIwMDApOiBZb3Ug
aGF2ZSBhbiBlcnJvciBpbiB5b3VyIFNRTCBzeW50YXg7IGNoZWNrIHRoZSBt YW51YWwNCnRoYXQN
CmNvcnJlc3BvbmRzIHRvIHlvdXIgTXlTUUwgc2VydmVyIHZlcnNpb24gZm9y IHRoZSByaWdodCBz
eW50YXggdG8gdXNlIG5lYXINCidteXNxbA0KZHVtcCAtdSByb290IC1wIGRi YWRtaW4gbXVyYWxp
ID4gYmFja3VwZmlsZS5zcWwnIGF0IGxpbmUgMQ0KDQpteXNxbD4gbXlzcWxk dW1wIC11cm9vdCAt
cGRiYWRtaW4gbXVyYWxpID4gYmFja3VwZmlsZS5zcWw7DQoNCkVSUk9SIDEw NjQgKDQyMDAwKTog
WW91IGhhdmUgYW4gZXJyb3IgaW4geW91ciBTUUwgc3ludGF4OyBjaGVjayB0 aGUgbWFudWFsDQp0
aGF0DQpjb3JyZXNwb25kcyB0byB5b3VyIE15U1FMIHNlcnZlciB2ZXJzaW9u IGZvciB0aGUgcmln
aHQgc3ludGF4IHRvIHVzZSBuZWFyDQonbXlzcWwNCmR1bXAgLXVyb290IC1w ZGJhZG1pbiBtdXJh
bGkgPiBiYWNrdXBmaWxlLnNxbCcgYXQgbGluZSAxDQpteXNxbD4NCg0KDQoN Ck9uIDIvMi8xMCwg
U3VyZXNoIEt1bmEgPHN1cmVzaGt1bWFyaWx1QGdtYWlsLmNvbT4gd3JvdGU6 DQo+DQo+IFBsZWFz
ZSBwYXN0ZSB0aGUgZXJyb3IgYW5kIGRvbid0IGdpdmUgdGhlIHNwYXZlIGJl dHdlZW4gLXAgYW5k
IHBhc3N3b3JkLg0KPg0KPg0KPiBPbiBUdWUsIEZlYiAyLCAyMDEwIGF0IDEy OjA1IFBNLCBtdXJh
bGlrcmlzaG5hIGcgPA0KPiBtdXJhbGlrcmlzaG5hNGdAZ21haWwuY29tPiB3 cm90ZToNCj4NCj4+
IGhpIHRvIGFsbC4uDQo+PiBpIHdhcyBpbiBuZWVkIHRvIHRha2UgYmFja3Vw IG9mIGRhdGFiYXNl
Li4NCj4+IGkgYW0gdXNpbmcgc3FsIHNlcnZlciB2ZXJzaW9uOjUuMC4yNy1j b29tdW5pdHktbnQN
Cj4+IGkgaGF2ZSB0cmllZCBieSB1c2luZw0KPj4gbXlzcWxkdW1wIC11IG5h bWUgLXAgcGFzc3dv
cmQgZGF0YWJhc2VfbmFtZSA+IGJhY2t1cC5zcWw7DQo+Pg0KPj4gYnV0IGkg YW0gZ2V0dGluZyBl
cnJvci4uIGkgYW0gdXNpbmcgd2luZG93cyB4cCBzeXN0ZW0uLiBwbGVhc2Ug aGVscCBtZQ0KPj4N
Cj4NCj4NCj4NCj4gLS0NCj4gVGhhbmtzDQo+IFN1cmVzaCBLdW5hDQo+IE15 U1FMIERCQQ0KPg0K
DQo=

--part21314-boundary-852911488-1075352568--

RE: hi help to take backup-mysql-windows-xp

DQpIZXkgZ3V5cw0KDQoNClRyeSB1c2luZyB0aGlzIG9wdGlvbiBmcm9tIHRo ZSBjb21tYW5kIHBy
b21wdCB2aWEgcnVuDQoNCk15c3FsZHVtcC5leGUgLXUgcm9vdCAtcCAtLWFs bC1kYXRhYmFzZSA+
IGJhY2t1cC50eHQNCg0KVGhpcyBzaG91bGQgd29yay4NCg0KVGhhbmtzLA0K RGlsaXBrdW1hcg0K
RGF0YWJhc2UgRW5naW5lZXJpbmcNCu+AqCBwaG9uZTogKzkxLTQ0LTY2Mzcg MzE2Nw0K74CrIG1h
aWx0bzogZGlsaXBrdW1hci5wYXJpa2hAZWRzLmNvbSANClBhZ2VyIG1haWw6 OTg4NDQzMDk5OEBu
bWEudm9kYWZvbmUuaW4NCg0KLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0N CkZyb206IHN1cmVz
aGt1bWFyaWx1QGdtYWlsLmNvbSBbbWFpbHRvOnN1cmVzaGt1bWFyaWx1QGdt YWlsLmNvbV0gDQpT
ZW50OiBUdWVzZGF5LCBGZWJydWFyeSAwMiwgMjAxMCAxMjoyMiBQTQ0KVG86 IG11cmFsaWtyaXNo
bmEgZw0KQ2M6IG15c3FsQGxpc3RzLm15c3FsLmNvbQ0KU3ViamVjdDogUmU6 IGhpIGhlbHAgdG8g
dGFrZSBiYWNrdXAtbXlzcWwtd2luZG93cy14cA0KDQpIaSBNdXJhbGksDQpZ b3UgaGF2ZSB0byBl
eGVjdXRlIGl0IG91dHNpZGUgbXlzcWwgcHJvbXB0IGkuZSBjb21tYW5kIHBy b21wdC4NCg0KVGhh
bmtzDQpTdXJlc2ggS3VuYQ0KTXlTUUwgREJBDQpTZW50IGZyb20gQmxhY2tC ZXJyecKuIG9uIEFp
cnRlbA0KDQotLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KRnJvbTogbXVy YWxpa3Jpc2huYSBn
IDxtdXJhbGlrcmlzaG5hNGdAZ21haWwuY29tPg0KRGF0ZTogVHVlLCAyIEZl YiAyMDEwIDEyOjE3
OjI0IA0KVG86IFN1cmVzaCBLdW5hPHN1cmVzaGt1bWFyaWx1QGdtYWlsLmNv bT4NCkNjOiA8bXlz
cWxAbGlzdHMubXlzcWwuY29tPg0KU3ViamVjdDogUmU6IGhpIGhlbHAgdG8g dGFrZSBiYWNrdXAt
bXlzcWwtd2luZG93cy14cA0KDQpoaSB0byBhbGwuLg0KaSB3YXMgaW4gbmVl ZCB0byB0YWtlIGJh
Y2t1cCBvZiBkYXRhYmFzZS4uDQppIGFtIHVzaW5nIHNxbCBzZXJ2ZXIgdmVy c2lvbjo1LjAuMjct
Y29vbXVuaXR5LW50DQppIGhhdmUgdHJpZWQgYnkgdXNpbmcNCm15c3FsZHVt cCAtdSBuYW1lIC1w
IHBhc3N3b3JkIGRhdGFiYXNlX25hbWUgPiBiYWNrdXAuc3FsOw0KDQpidXQg aSBhbSBnZXR0aW5n
IGVycm9yLi4gaSBhbSB1c2luZyB3aW5kb3dzIHhwIHN5c3RlbS4uDQoNCnBs ZWFzZSBoZWxwIG1l
DQpteXNxbD4gbXlzcWxkdW1wIC11IHJvb3QgLXAgZGJhZG1pbiBtdXJhbGkg PiBiYWNrdXBmaWxl
LnNxbDsNCg0KRVJST1IgMTA2NCAoNDIwMDApOiBZb3UgaGF2ZSBhbiBlcnJv ciBpbiB5b3VyIFNR
TCBzeW50YXg7IGNoZWNrIHRoZSBtYW51YWwNCnRoYXQNCmNvcnJlc3BvbmRz IHRvIHlvdXIgTXlT
UUwgc2VydmVyIHZlcnNpb24gZm9yIHRoZSByaWdodCBzeW50YXggdG8gdXNl IG5lYXINCidteXNx
bA0KZHVtcCAtdSByb290IC1wIGRiYWRtaW4gbXVyYWxpID4gYmFja3VwZmls ZS5zcWwnIGF0IGxp
bmUgMQ0KDQpteXNxbD4gbXlzcWxkdW1wIC11cm9vdCAtcGRiYWRtaW4gbXVy YWxpID4gYmFja3Vw
ZmlsZS5zcWw7DQoNCkVSUk9SIDEwNjQgKDQyMDAwKTogWW91IGhhdmUgYW4g ZXJyb3IgaW4geW91
ciBTUUwgc3ludGF4OyBjaGVjayB0aGUgbWFudWFsDQp0aGF0DQpjb3JyZXNw b25kcyB0byB5b3Vy
IE15U1FMIHNlcnZlciB2ZXJzaW9uIGZvciB0aGUgcmlnaHQgc3ludGF4IHRv IHVzZSBuZWFyDQon
bXlzcWwNCmR1bXAgLXVyb290IC1wZGJhZG1pbiBtdXJhbGkgPiBiYWNrdXBm aWxlLnNxbCcgYXQg
bGluZSAxDQpteXNxbD4NCg0KDQoNCk9uIDIvMi8xMCwgU3VyZXNoIEt1bmEg PHN1cmVzaGt1bWFy
aWx1QGdtYWlsLmNvbT4gd3JvdGU6DQo+DQo+IFBsZWFzZSBwYXN0ZSB0aGUg ZXJyb3IgYW5kIGRv
bid0IGdpdmUgdGhlIHNwYXZlIGJldHdlZW4gLXAgYW5kIHBhc3N3b3JkLg0K Pg0KPg0KPiBPbiBU
dWUsIEZlYiAyLCAyMDEwIGF0IDEyOjA1IFBNLCBtdXJhbGlrcmlzaG5hIGcg PA0KPiBtdXJhbGlr
cmlzaG5hNGdAZ21haWwuY29tPiB3cm90ZToNCj4NCj4+IGhpIHRvIGFsbC4u DQo+PiBpIHdhcyBp
biBuZWVkIHRvIHRha2UgYmFja3VwIG9mIGRhdGFiYXNlLi4NCj4+IGkgYW0g dXNpbmcgc3FsIHNl
cnZlciB2ZXJzaW9uOjUuMC4yNy1jb29tdW5pdHktbnQNCj4+IGkgaGF2ZSB0 cmllZCBieSB1c2lu
Zw0KPj4gbXlzcWxkdW1wIC11IG5hbWUgLXAgcGFzc3dvcmQgZGF0YWJhc2Vf bmFtZSA+IGJhY2t1
cC5zcWw7DQo+Pg0KPj4gYnV0IGkgYW0gZ2V0dGluZyBlcnJvci4uIGkgYW0g dXNpbmcgd2luZG93
cyB4cCBzeXN0ZW0uLiBwbGVhc2UgaGVscCBtZQ0KPj4NCj4NCj4NCj4NCj4g LS0NCj4gVGhhbmtz
DQo+IFN1cmVzaCBLdW5hDQo+IE15U1FMIERCQQ0KPg0KDQo=

RE: hi help to take backup-mysql-windows-xp

What error are you getting?

===================3D

John Daisley

MySQL 5.0 Certified Database Administrator (CMDBA)
MySQL 5.0 Certified Developer
Cognos BI Developer

Telephone: +44(0)1283 537111
Mobile: +44(0)7812 451238
Email: john.daisley@butterflysystems.co.uk

===================3D

Sent via HP IPAQ mobile device=0A=
=0A=
-----Original Message-----=0A=
From: muralikrishna g
Sent: 02 February 2010 06:45
To: mysql@lists.mysql.com
Subject: 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 General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg