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

2010-02-02 Thread John Daisley
What error are you getting?

===

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.dais...@butterflysystems.co.uk

===

Sent via HP IPAQ mobile device

-Original Message-
From: muralikrishna g muralikrishn...@gmail.com
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=arch...@jab.org



hi help to take backup-mysql-windows-xp

2010-02-01 Thread muralikrishna g
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


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

2010-02-01 Thread Suresh Kuna
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.comwrote:

 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


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

2010-02-01 Thread muralikrishna g
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



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

2010-02-01 Thread sureshkumarilu
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 Kunasureshkumar...@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




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

2010-02-01 Thread Parikh, Dilip Kumar

Hey guys


Try using this option from the command prompt via run

Mysqldump.exe -u root -p --all-database  backup.txt

This should work.

Thanks,
Dilipkumar
Database Engineering
 phone: +91-44-6637 3167
 mailto: dilipkumar.par...@eds.com 
Pager mail:9884430...@nma.vodafone.in

-Original Message-
From: sureshkumar...@gmail.com [mailto:sureshkumar...@gmail.com] 
Sent: Tuesday, February 02, 2010 12:22 PM
To: muralikrishna g
Cc: mysql@lists.mysql.com
Subject: Re: hi help to take backup-mysql-windows-xp

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 Kunasureshkumar...@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




Hi, Help!

2002-02-05 Thread Victoria Reznichenko

Erin,
Tuesday, February 05, 2002, 12:37:33 AM, you wrote:

EL Hi, this is Erin Lilly, I've used support before with you all for
EL bodyconsultant.com and you were extremely helpful. I'm installing mysql on
EL erinlilly.net and have run into that common  /tmp/mysql.sock (111) error
EL version: 3.23.45-pc-linux

EL you then need to type in /usr/local to see where I've installed the
EL mysql-3.23.45



EL Please take a look where I had installed it in
EL /usr/local/mysql-3.23.45-pc-linux-i686

EL I've created a ln -s from tmp to /usr/local/mysql-3.23
EL have created a ln -s from mysql-3.23.45 and mysql

EL What's the problem?? When I go to do the ./bin/safe_mysql  command it turns
EL server on then logs off.  Also when I do bin/mysqladmin -u root -p password
EL it gives me the /tmp/mysql.sock (111) not found - even though I have ln -s
EL that tmp directory to the mysql-3.23.45 ...

EL Have tested the telnet erinlilly.net 3306 - and no connection.

EL MY QUESTIONS:
EL 1.  What do I need to do to get the connection going.
EL 2.  How can I be sure the tables were created.   I ran install_db and it
EL appeared to do everything.

You should do : ls data_dir/mysql
data_dir is the MySQL data directory.

EL 3.  What do I need to do to make things right here?
EL 4.  Have all my ln -s created some inherent problems?

Check the following links:
  http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html
  http://www.mysql.com/doc/m/y/mysql_install_db.html




-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Hi, Help!

2002-02-04 Thread Fred van Engen

On Mon, Feb 04, 2002 at 04:37:33PM -0600, Erin Lilly wrote:
 Hi, this is Erin Lilly, I've used support before with you all for
 bodyconsultant.com and you were extremely helpful. I'm installing mysql on
 erinlilly.net and have run into that common  /tmp/mysql.sock (111) error
 

Hi, you just mailed your root password to an open mailing list.

Take care. You might want to change your password now.


Fred.

-- 
Fred van Engen  XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400 1322 AC  Almere
fax: +31 36 5462424 The Netherlands

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Hi, Help!

2002-02-04 Thread Erin Lilly

Hi, this is Erin Lilly, I've used support before with you all for
bodyconsultant.com and you were extremely helpful. I'm installing mysql on
erinlilly.net and have run into that common  /tmp/mysql.sock (111) error


version: 3.23.45-pc-linux
To telnet in as root:
erinlilly.net
log-admin
pw-paws

you then need to type in /usr/local to see where I've installed the
mysql-3.23.45



Please take a look where I had installed it in
/usr/local/mysql-3.23.45-pc-linux-i686

I've created a ln -s from tmp to /usr/local/mysql-3.23
have created a ln -s from mysql-3.23.45 and mysql

What's the problem?? When I go to do the ./bin/safe_mysql  command it turns
server on then logs off.  Also when I do bin/mysqladmin -u root -p password
it gives me the /tmp/mysql.sock (111) not found - even though I have ln -s
that tmp directory to the mysql-3.23.45 ...

Have tested the telnet erinlilly.net 3306 - and no connection.

MY QUESTIONS:
1.  What do I need to do to get the connection going.
2.  How can I be sure the tables were created.   I ran install_db and it
appeared to do everything.
3.  What do I need to do to make things right here?
4.  Have all my ln -s created some inherent problems?

HERE's the MYSQL registration info:

erin6817
fevnodfi
order number
6755


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Hi help needed!

2001-02-18 Thread Rolf Hopkins

What's your code?  How are you trying to connect?


- Original Message -
From: "manikandan" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, February 17, 2001 15:02
Subject: Hi help needed!



 Hi All!

 I am not able to connect to  remote Mysql  running on a Linux meachine .I
 am running a win2k where apache and php are configured .

 Please let me know what could be wrong or how to connect to remore Mysql
 database

 Thanks in advance

 Manikandan


 _
 Do You Yahoo!?
 Get your free @yahoo.com address at http://mail.yahoo.com


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php