Re: How to delete all rows....

[Dilipkumar]

Hi,

Its delete * from table will only do if you go for a truncate it will 
recreate the table structure ?

It's better to use delete.

Thanks  Regards
Dilipkumar
- Original Message - 
From: Peter Lauri [EMAIL PROTECTED]

To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Wednesday, September 20, 2006 1:25 PM
Subject: RE: How to delete all rows



DELETE FROM table

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 20, 2006 10:35 AM
To: mysql@lists.mysql.com
Subject: How to delete all rows


Hi All,

   How do I delete all the rows of all the tables(but not
table) in the database at one shot.




Regards,

Ravi K







The information contained in this electronic message and any attachments 
to
this message are intended for the exclusive use of the addressee(s) and 
may
contain proprietary, confidential or privileged information. If you are 
not
the intended recipient, you should not disseminate, distribute or copy 
this
e-mail. Please notify the sender immediately and destroy all copies of 
this

message and any attachments.


WARNING: Computer viruses can be transmitted via email. The recipient 
should

check this email and any attachments for the presence of viruses. The
company accepts no liability for any damage caused by any virus 
transmitted

by this email.


www.wipro.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: 
http://lists.mysql.com/[EMAIL PROTECTED]




** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with 
the authority of the Company. If you are not the intended recipient, an 
agent of the intended recipient or a  person responsible for delivering the 
information to the named recipient,  you are notified that any use, 
distribution, transmission, printing, copying or dissemination of this 
information in any way or in any manner is strictly prohibited. If you have 
received this communication in error, please delete this mail  notify us 
immediately at [EMAIL PROTECTED]



Watch the latest updates on Mumbai, with video coverage of news, events,
Bollywood, live darshan from Siddhivinayak temple and more, only on
www.mumbailive.in

Watch the hottest videos from Bollywood, Fashion, News and more only on
www.sifymax.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: replication breaks

[Dilipkumar]

Hi,

Give the command as
Reset slave;
and then run the change master to script.

This will help you to solve.

Pooly wrote:


Hi,

I recently upgrade our master to MySQL 5.0.24. But, I changed on
option to log_bin=server-log-bin, as a result the binary log has
changed from server-bin.000228 to server-log-bin.01...
So now, the slave throw me an could not find first log file in binary
log index.
I suppose I have to do a CHANGE MASTER TO ...
MASTER_LOG_FILE='server-log-bin.01', MASTER_LOG_POS=?
What position should I use 0 ? 1 ? 4?
Thanks for your help,



** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with 
the authority of the Company. If you are not the intended recipient, an 
agent of the intended recipient or a  person responsible for delivering the 
information to the named recipient,  you are notified that any use, 
distribution, transmission, printing, copying or dissemination of this 
information in any way or in any manner is strictly prohibited. If you have 
received this communication in error, please delete this mail  notify us 
immediately at [EMAIL PROTECTED]



Watch the latest updates on Mumbai, with video coverage of news, events,
Bollywood, live darshan from Siddhivinayak temple and more, only on
www.mumbailive.in

Watch the hottest videos from Bollywood, Fashion, News and more only on
www.sifymax.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Backup Errors in MySQL Cluster (5.0.24)

[Dilipkumar]

Hi,

While taking backup in MySQL 5.0.24 for (ndbcluster tables) i am getting the 
following errors :

mysqldump: Error 1296: Got error 241 'Invalid schema object version' from 
ndbcluster when dumping 
table `iib_candidate_tracking` at row: 0
When i checked out using ndberror : 
NDB error code 1296: No message slogan found (please report a bug if you get 
this error code): Unknown: Unknown
Any help would be appericated.



Thanks  Regards
Dilipkumar
** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to
Sify Limited and is intended for use only by the individual or entity to
which it is addressed, and may contain information that is privileged,
confidential or exempt from disclosure under applicable law. If this is a
forwarded message, the content of this E-MAIL may not have been sent with
the authority of the Company. If you are not the intended recipient, an
agent of the intended recipient or a  person responsible for delivering the
information to the named recipient,  you are notified that any use,
distribution, transmission, printing, copying or dissemination of this
information in any way or in any manner is strictly prohibited. If you have
received this communication in error, please delete this mail  notify us
immediately at [EMAIL PROTECTED]


Watch the latest updates on Mumbai, with video coverage of news, events,
Bollywood, live darshan from Siddhivinayak temple and more, only on
www.mumbailive.in

Watch the hottest videos from Bollywood, Fashion, News and more only on
www.sifymax.com

MySQL Cluster 5.0.24 (Import) Slow

[Dilipkumar]

Hi everybody

I am running linuz AS-4  with 5.0.24  max version MySQL Cluster i am able to 
create all the table as ndb but when comming to 
the import i am not able to import 20 lakhs of record for a  table.please help 
to solve the problem .

Any suggestions?...


Thanks  Regards
Dilipkumar
** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to
Sify Limited and is intended for use only by the individual or entity to
which it is addressed, and may contain information that is privileged,
confidential or exempt from disclosure under applicable law. If this is a
forwarded message, the content of this E-MAIL may not have been sent with
the authority of the Company. If you are not the intended recipient, an
agent of the intended recipient or a  person responsible for delivering the
information to the named recipient,  you are notified that any use,
distribution, transmission, printing, copying or dissemination of this
information in any way or in any manner is strictly prohibited. If you have
received this communication in error, please delete this mail  notify us
immediately at [EMAIL PROTECTED]


Watch the latest updates on Mumbai, with video coverage of news, events,
Bollywood, live darshan from Siddhivinayak temple and more, only on
www.mumbailive.in

Watch the hottest videos from Bollywood, Fashion, News and more only on
www.sifymax.com

Re: MySQL Cluster 5.0.24 (Import) Slow

[Dilipkumar]

Hi,

Its saying as (unknown error 1 in ndb cluster) please report a bug to 
mysql.bug.


Thanks  Regards
Dilipkumar
- Original Message - 
From: Dan Trainor [EMAIL PROTECTED]

To: mysql@lists.mysql.com
Sent: Sunday, August 20, 2006 2:06 AM
Subject: Re: MySQL Cluster 5.0.24 (Import) Slow



Dilipkumar wrote:

Hi everybody

I am running linuz AS-4  with 5.0.24  max version MySQL Cluster i am able 
to create all the table as ndb but when comming to the import i am not 
able to import 20 lakhs of record for a  table.please help to solve the 
problem .


Any suggestions?...




Hi -

Do you have any specific errors?  Can you elaborate any?

Thanks
-dant

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: 
http://lists.mysql.com/[EMAIL PROTECTED]




** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with 
the authority of the Company. If you are not the intended recipient, an 
agent of the intended recipient or a  person responsible for delivering the 
information to the named recipient,  you are notified that any use, 
distribution, transmission, printing, copying or dissemination of this 
information in any way or in any manner is strictly prohibited. If you have 
received this communication in error, please delete this mail  notify us 
immediately at [EMAIL PROTECTED]



Watch the latest updates on Mumbai, with video coverage of news, events,
Bollywood, live darshan from Siddhivinayak temple and more, only on
www.mumbailive.in

Watch the hottest videos from Bollywood, Fashion, News and more only on
www.sifymax.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Can a table be copied across the DBs?

[Dilipkumar]

Hi,

Create table can be done across the database but please let me know what 
version are us using  (MYSQL).


mysql create table test.tww  like broadbandnew.cds ;
Query OK, 0 rows affected (0.06 sec)

Thanks  Regards
Dilipkumar
- Original Message - 
From: Dominik Klein [EMAIL PROTECTED]

To: mysql@lists.mysql.com
Sent: Friday, August 18, 2006 1:01 PM
Subject: Re: Can a table be copied across the DBs?



In the destination database the table doesn't exist. Please let me know,
if there is any way to do it.


CREATE TABLE DB2.tblname LIKE DB1.tblname;
INSERT INTO DB2.tblname SELECT * FROM DB1.tblname;

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: 
http://lists.mysql.com/[EMAIL PROTECTED]




** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with 
the authority of the Company. If you are not the intended recipient, an 
agent of the intended recipient or a  person responsible for delivering the 
information to the named recipient,  you are notified that any use, 
distribution, transmission, printing, copying or dissemination of this 
information in any way or in any manner is strictly prohibited. If you have 
received this communication in error, please delete this mail  notify us 
immediately at [EMAIL PROTECTED]



Watch the latest updates on Mumbai, with video coverage of news, events,
Bollywood, live darshan from Siddhivinayak temple and more, only on
www.mumbailive.in

Watch the hottest videos from Bollywood, Fashion, News and more only on
www.sifymax.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Can a table be copied across the DBs?

[Dilipkumar]

Hi,

Yes it can be done.

Hi,

Create table can be done across the database but please let me know what
version are us using  (MYSQL).


mysql create table test.tww  like broadbandnew.cds ;
Query OK, 0 rows affected (0.06 sec)


Thanks  Regards
Dilipkumar
- Original Message - 
From: [EMAIL PROTECTED]

To: mysql@lists.mysql.com
Sent: Friday, August 18, 2006 9:29 AM
Subject: Can a table be copied across the DBs?



Hi All,

   I want to copy a table (along with its contents) from one
database to another database.

In the destination database the table doesn't exist. Please let me know,
if there is any way to do it.



Regards,

Ravi K






The information contained in this electronic message and any attachments to 
this message are intended for the exclusive use of the addressee(s) and may 
contain proprietary, confidential or privileged information. If you are not 
the intended recipient, you should not disseminate, distribute or copy this 
e-mail. Please notify the sender immediately and destroy all copies of this 
message and any attachments.


WARNING: Computer viruses can be transmitted via email. The recipient should 
check this email and any attachments for the presence of viruses. The 
company accepts no liability for any damage caused by any virus transmitted 
by this email.


www.wipro.com 


** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with 
the authority of the Company. If you are not the intended recipient, an 
agent of the intended recipient or a  person responsible for delivering the 
information to the named recipient,  you are notified that any use, 
distribution, transmission, printing, copying or dissemination of this 
information in any way or in any manner is strictly prohibited. If you have 
received this communication in error, please delete this mail  notify us 
immediately at [EMAIL PROTECTED]



Watch the latest updates on Mumbai, with video coverage of news, events,
Bollywood, live darshan from Siddhivinayak temple and more, only on
www.mumbailive.in

Watch the hottest videos from Bollywood, Fashion, News and more only on
www.sifymax.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: One question about mysql_close

[Dilipkumar]

Hi,

Yes Aborted connects will start increasing than the connections.

Thanks  Regards
Dilipkumar
- Original Message - 
From: ��?��╁�� [EMAIL PROTECTED]

To: mysql@lists.mysql.com
Sent: Wednesday, August 02, 2006 11:34 AM
Subject: One question about mysql_close



Hi,

I have a question about Mysql C library function mysql_close. If my 
program doesn't invoke mysql_close before exiting, is there any side 
effect?


I don't know whether this is the proper list I should send email for this 
topic. If I should send my email to another topic, which list is better?


Thanks,
James

_
与联机的朋友进行交流，请使用 MSN Messenger:  http://messenger.msn.com/cn

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: 
http://lists.mysql.com/[EMAIL PROTECTED]




** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with 
the authority of the Company. If you are not the intended recipient, an 
agent of the intended recipient or a  person responsible for delivering the 
information to the named recipient,  you are notified that any use, 
distribution, transmission, printing, copying or dissemination of this 
information in any way or in any manner is strictly prohibited. If you have 
received this communication in error, please delete this mail  notify us 
immediately at [EMAIL PROTECTED]



Watch the latest updates on Mumbai, with video coverage of news, events,
Bollywood, live darshan from Siddhivinayak temple and more, only on
www.mumbailive.in

Watch the hottest videos from Bollywood, Fashion, News and more only on
www.sifymax.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Relay Log Lost on Slave

[Dilipkumar]

Hi,

First reset slave and then change master to script run it.

Thanks  Regards
Dilipkumar
- Original Message - 
From: Kenji HIROHAMA [EMAIL PROTECTED]

To: Dilipkumar [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Wednesday, August 02, 2006 3:29 PM
Subject: Re: Relay Log Lost on Slave



Hi Dilipkumar,

I checked the output of show slave status, and memorize;

RELAY_MASTER_LOG_FILE, and EXEC_MASTER_LOG_POS.

Then,

change master to
master_log_file='xx,
master_log_pos=xx;

However, still I get the same error message.

Umm.

Kenji


On 8/2/06, Dilipkumar [EMAIL PROTECTED] wrote:

Hi,

If you relay log is lost try out the this :-


Run the Change Master Position script, See the log output from where did 
the

replication stopped.
So you can start your replication.

Thanks  Regards
Dilipkumar
- Original Message -
From: Kenji HIROHAMA [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Wednesday, August 02, 2006 9:36 AM
Subject: Relay Log Lost on Slave


 Hi,

 Under my replication environment, what should I do if I lose the
 current relay-log file on slave side?

 1. one master and one slave replication is working
 2. stop the master and the slave
 3. remove the current relay log file manually
 4. I can't start replication with start slave command
 the error message is;
 ERROR 29 (HY000): File 'xxx-relay-bin.25' not found (Errcode: 2)

 Should I sync the data manually and start replication from the 
 beginning?


 Thanks,

 --
 [EMAIL PROTECTED]
 Kenji Hirohama

 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:
 http://lists.mysql.com/[EMAIL PROTECTED]


** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to
Sify Limited and is intended for use only by the individual or entity to
which it is addressed, and may contain information that is privileged,
confidential or exempt from disclosure under applicable law. If this is a
forwarded message, the content of this E-MAIL may not have been sent with
the authority of the Company. If you are not the intended recipient, an
agent of the intended recipient or a  person responsible for delivering 
the

information to the named recipient,  you are notified that any use,
distribution, transmission, printing, copying or dissemination of this
information in any way or in any manner is strictly prohibited. If you 
have

received this communication in error, please delete this mail  notify us
immediately at [EMAIL PROTECTED]


Watch the latest updates on Mumbai, with video coverage of news, events,
Bollywood, live darshan from Siddhivinayak temple and more, only on
www.mumbailive.in

Watch the hottest videos from Bollywood, Fashion, News and more only on
www.sifymax.com





--
[EMAIL PROTECTED]
Kenji Hirohama

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: 
http://lists.mysql.com/[EMAIL PROTECTED]





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Relay Log Lost on Slave

[Dilipkumar]

Hi,

If you relay log is lost try out the this :-


Run the Change Master Position script, See the log output from where did the 
replication stopped.

So you can start your replication.

Thanks  Regards
Dilipkumar
- Original Message - 
From: Kenji HIROHAMA [EMAIL PROTECTED]

To: mysql@lists.mysql.com
Sent: Wednesday, August 02, 2006 9:36 AM
Subject: Relay Log Lost on Slave



Hi,

Under my replication environment, what should I do if I lose the
current relay-log file on slave side?

1. one master and one slave replication is working
2. stop the master and the slave
3. remove the current relay log file manually
4. I can't start replication with start slave command
the error message is;
ERROR 29 (HY000): File 'xxx-relay-bin.25' not found (Errcode: 2)

Should I sync the data manually and start replication from the beginning?

Thanks,

--
[EMAIL PROTECTED]
Kenji Hirohama

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: 
http://lists.mysql.com/[EMAIL PROTECTED]




** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with 
the authority of the Company. If you are not the intended recipient, an 
agent of the intended recipient or a  person responsible for delivering the 
information to the named recipient,  you are notified that any use, 
distribution, transmission, printing, copying or dissemination of this 
information in any way or in any manner is strictly prohibited. If you have 
received this communication in error, please delete this mail  notify us 
immediately at [EMAIL PROTECTED]



Watch the latest updates on Mumbai, with video coverage of news, events,
Bollywood, live darshan from Siddhivinayak temple and more, only on
www.mumbailive.in

Watch the hottest videos from Bollywood, Fashion, News and more only on
www.sifymax.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: how to move datadir to a different file system

[Dilipkumar]

Hi,

If the tables are not in use you can tar -cvzf filename.tar.gz the datadir 
and move it to the new server, but you should use the same mysql version.


Thanks  Regards
Dilipkumar
- Original Message - 
From: Bhartia, Saurabh [EMAIL PROTECTED]

To: mysql@lists.mysql.com
Sent: Friday, July 28, 2006 3:16 AM
Subject: how to move datadir to a different file system


Everything was installed under / file system ( linux )
need to move all existing databases also to new file system ( say
/mysqldata )

Can I simply change in my.cnf and copy files to new location ?

Thanks
Saurabh


** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with 
the authority of the Company. If you are not the intended recipient, an 
agent of the intended recipient or a  person responsible for delivering the 
information to the named recipient,  you are notified that any use, 
distribution, transmission, printing, copying or dissemination of this 
information in any way or in any manner is strictly prohibited. If you have 
received this communication in error, please delete this mail  notify us 
immediately at [EMAIL PROTECTED]



Watch the latest updates on Mumbai, with video coverage of news, events,
Bollywood, live darshan from Siddhivinayak temple and more, only on
www.mumbailive.in

Watch the hottest videos from Bollywood, Fashion, News and more only on
www.sifymax.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysqlcheck issues

[Dilipkumar]

Hi,

Instead of mysqlcheck you can use myisamckh to recover the data's.
As myisamchk -r -o *.MY*

Thanks  Regards
Dilipkumar
- Original Message - 
From: Dirk Bremer [EMAIL PROTECTED]

To: mysql@lists.mysql.com
Sent: Thursday, July 27, 2006 8:32 PM
Subject: Mysqlcheck issues



I am using MySQL server 4.1.10 on Windows 2003 Server with MyISAM
tables. I have an issue where occasionally an index (MYI) file becomes
corrupted. I do not know why this occurs. To combat this issue, I tried
running the following command every half-hour:

mysqlcheck -Aamov --auto-repair --use-frm

This command runs on the host. For some reason, when this command
executes, the MySQL service aborts and the MYI for the main table is
corrupted. I must then restart the service and repair the affected
table.

I am at a loss here. I would really like to use the --auto-repair
option, but don't understand what is causing the service to abort.

Your thoughts?

Dirk Bremer - Senior Systems Engineer - ESS/AMS - NISC Lake St. Louis MO
- USA Central Time Zone
636-755-2652 fax 636-755-2503

[EMAIL PROTECTED]
www.nisc.coop

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: 
http://lists.mysql.com/[EMAIL PROTECTED]


** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with 
the authority of the Company. If you are not the intended recipient, an 
agent of the intended recipient or a  person responsible for delivering the 
information to the named recipient,  you are notified that any use, 
distribution, transmission, printing, copying or dissemination of this 
information in any way or in any manner is strictly prohibited. If you have 
received this communication in error, please delete this mail  notify us 
immediately at [EMAIL PROTECTED]



Watch the latest updates on Mumbai, with video coverage of news, events,
Bollywood, live darshan from Siddhivinayak temple and more, only on
www.mumbailive.in

Watch the hottest videos from Bollywood, Fashion, News and more only on
www.sifymax.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Need Restore Help

[Dilipkumar]

Hi,

This is because of the version conflict only

Try usinng this option as

Login into the mysql  :-

use databasename
\. filename.txt



Thanks  Regards
Dilipkumar


- Original Message - 
From: Jesse [EMAIL PROTECTED]

To: MySQL List mysql@lists.mysql.com
Sent: Monday, July 24, 2006 8:36 PM
Subject: Need Restore Help


I have a backup that was created by a MySQL 5 server using MySQLDump.  When 
I try to restore the database using the following command:


mysql -u root -p -D BPA  c:\backup\mydata.sql

I get the error:
ERROR 1064 (42000) at line 29765: 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 '/' at line 1


Here is what line 29765 says in the backup file:

/*!50003 CREATE TRIGGER `AlumniAddDate` BEFORE INSERT ON `alumni` FOR EACH 
ROW SET NEW.AddDate=Now() */;;


This is obviously one of the triggers that I've created.  I don't know why 
it's commented them out in the backup, but I don't seem to be able to 
overcome this.  I'd rather it ignore these lines anyway.  How do I get 
passed this?


Thanks,


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: 
http://lists.mysql.com/[EMAIL PROTECTED]




** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with 
the authority of the Company. If you are not the intended recipient, an 
agent of the intended recipient or a  person responsible for delivering the 
information to the named recipient,  you are notified that any use, 
distribution, transmission, printing, copying or dissemination of this 
information in any way or in any manner is strictly prohibited. If you have 
received this communication in error, please delete this mail  notify us 
immediately at [EMAIL PROTECTED]



Watch the latest updates on Mumbai, with video coverage of news, events,
Bollywood, live darshan from Siddhivinayak temple and more, only on
www.mumbailive.in

Watch the hottest videos from Bollywood, Fashion, News and more only on
www.sifymax.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL Cluster

[Dilipkumar]

Hi,

Try out this :-

http://dev.mysql.com/

Try the new MySQL 5.1 Beta!
 a.. Row-based Replication

 b.. Table and Index Partitioning

 c.. MySQL Cluster Disk-Based Tables

 d.. Dynamic Pluggable Storage Engine API

 e.. MySQL Cluster Replication

 f.. Learn About More Cool Features (pdf)  »


Thanks  Regards
Dilipkumar
- Original Message - 
From: Jimmy Guerrero [EMAIL PROTECTED]

To: 'Kaushal Shriyan' [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Tuesday, July 25, 2006 7:18 PM
Subject: RE: MySQL Cluster



Hello,

MySQL Cluster has been available since version 4.1.

For production purposes we recommend the GA version of 5.0.

For the testing of new features (Disk-Data, Replication, etc) take a look 
at

the latest 5.1 version.

Thanks,

Jimmy Guerrero
Sr Product Manager
MySQL, Inc


-Original Message-
From: Kaushal Shriyan [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 25, 2006 8:33 AM
To: mysql@lists.mysql.com
Subject: Re: MySQL Cluster

On 7/25/06, Kaushal Shriyan [EMAIL PROTECTED] wrote:
 On 7/25/06, Kaushal Shriyan [EMAIL PROTECTED] wrote:
  Hi ALL
 
  I want to implement MySQL Cluster, are there any step by
step guide
  to implement it
 
  Thanks and Regards
 
  Kaushal
 

 Hi

 Is cluster suite is available only in version of MySQL 5 and above.

 Regards


 Kaushal


Hi ALL

Is cluster suite is available only in version of MySQL 5 and above.

Regards

Kaushal

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: 
http://lists.mysql.com/[EMAIL PROTECTED]




** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with 
the authority of the Company. If you are not the intended recipient, an 
agent of the intended recipient or a  person responsible for delivering the 
information to the named recipient,  you are notified that any use, 
distribution, transmission, printing, copying or dissemination of this 
information in any way or in any manner is strictly prohibited. If you have 
received this communication in error, please delete this mail  notify us 
immediately at [EMAIL PROTECTED]



Watch the latest updates on Mumbai, with video coverage of news, events,
Bollywood, live darshan from Siddhivinayak temple and more, only on
www.mumbailive.in

Watch the hottest videos from Bollywood, Fashion, News and more only on
www.sifymax.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Slave Replication issues

[Dilipkumar]

Hi,

This is because direct inserts are being pointed to one of the slave (or) 
you have taken the dump from the master in which when you try to restore
it and start replication you will have to start from the master position 
what u have noted. In such case you might get this error to ignore this
you can start your mysql with skip-slave-error=1062  in such case these 
duplicates will not repeat.


Thanks  Regards
Dilipkumar
- Original Message - 
From: David Hillman [EMAIL PROTECTED]

To: mysql@lists.mysql.com
Sent: Wednesday, July 26, 2006 12:34 AM
Subject: Re: Slave Replication issues



On Jul 25, 2006, at 12:47 PM, David Nance wrote:

Hi, we have been losing slaves due to errors in replication. See error
message below. Would appreciate if anyone could share if they have
seen same
issues. It seems something may be getting corrupted in the binary log.
Thanks.

The error reads:

 Last_error: Error 'Duplicate entry '12312942' for key 1' on query
'INSERT
INTO permissions (user_id, journal_id, date_granted, start_date,
end_date,
type) VALUES ('1503443', '94', NOW(), '-00-00 00:00:00',
'-00-00
00:00:00', 'author')'. Default database: 'manuscript_central_1_1'


   One of the indexes on your 'permissions' table in defined to be
'unique', and your application is trying to insert a row with a
duplicate value.  This doesn't seem like a replication error, unless
there really isn't a unique index on permissions... but I bet there is.

--
David Hillman
LiveText, Inc
1.866.LiveText x235




** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with 
the authority of the Company. If you are not the intended recipient, an 
agent of the intended recipient or a  person responsible for delivering the 
information to the named recipient,  you are notified that any use, 
distribution, transmission, printing, copying or dissemination of this 
information in any way or in any manner is strictly prohibited. If you have 
received this communication in error, please delete this mail  notify us 
immediately at [EMAIL PROTECTED]



Watch the latest updates on Mumbai, with video coverage of news, events,
Bollywood, live darshan from Siddhivinayak temple and more, only on
www.mumbailive.in

Watch the hottest videos from Bollywood, Fashion, News and more only on
www.sifymax.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Row count discrepancy when converting from MyISAM to InnoDB

[Dilipkumar]

Hi,

Instead of using select count(*) from tablename

You can try with 
show table status like 'tablename' 
This doesn't takes much longer time.


Thanks  Regards
Dilipkumar
- Original Message - 
From: David Hillman [EMAIL PROTECTED]

To: mysql@lists.mysql.com
Sent: Tuesday, July 25, 2006 11:51 PM
Subject: Re: Row count discrepancy when converting from MyISAM to InnoDB



On Jul 25, 2006, at 11:55 AM, Frank wrote:

Why is the record count so low after conversion to InnoDB?
Who should I believe: InnoDB or MyISAM?
Any ideas as to what can be done to avoid loss of this many rows?


   InnoDB doesn't keep a count on number of rows, like MyISAM does.   
InnoDB only maintains an estimate of the number of rows in each  
table.  This is why select count(*) from table takes a long time on  
big InnoDB tables.  Usually the InnoDB count will be off by 50% or so.


http://dev.mysql.com/doc/refman/5.0/en/innodb-restrictions.html

--
David Hillman
LiveText, Inc
1.866.LiveText x235



** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with 
the authority of the Company. If you are not the intended recipient, an 
agent of the intended recipient or a  person responsible for delivering the 
information to the named recipient,  you are notified that any use, 
distribution, transmission, printing, copying or dissemination of this 
information in any way or in any manner is strictly prohibited. If you have 
received this communication in error, please delete this mail  notify us 
immediately at [EMAIL PROTECTED]



Watch the latest updates on Mumbai, with video coverage of news, events,
Bollywood, live darshan from Siddhivinayak temple and more, only on
www.mumbailive.in

Watch the hottest videos from Bollywood, Fashion, News and more only on
www.sifymax.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Adding Foreign Key Fails

[Dilipkumar]

Hi,

Is this a InnoDB table.

Thanks  Regards
Dilipkumar
- Original Message - 
From: Jesse [EMAIL PROTECTED]

To: MySQL List mysql@lists.mysql.com
Sent: Wednesday, July 26, 2006 6:28 PM
Subject: Adding Foreign Key Fails


I am trying to add a foreign key to one of my tables. When I execute the 
following SQL Code:


ALTER TABLE `bpa`.`confinvitems` ADD CONSTRAINT `FK_confinvitems_1` 
FOREIGN KEY `FK_confinvitems_1` (`InvDetID`)

REFERENCES `confinvdet` (`ID`)
ON DELETE CASCADE;

I get the error:

MySQL Error Number 1452
Cannot add or update a child row: a foreign key constraint fails 
(`bpa/#sql-162c_1b`, CONSTRAINT `FK_confinvitems_1` FOREIGN KEY 
(`InvDetID`) REFERENCES `confinvdet` (`ID`) ON DELETE CASCADE)


I have checked, and all the indexes seem to be in place, the data types 
are exactly the same.  There are no duplicate ID's in the ConfInvDet 
table.  Any idea what this error means, and how to fix it?


Thanks,
Jesse

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: 
http://lists.mysql.com/[EMAIL PROTECTED]




** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with 
the authority of the Company. If you are not the intended recipient, an 
agent of the intended recipient or a  person responsible for delivering the 
information to the named recipient,  you are notified that any use, 
distribution, transmission, printing, copying or dissemination of this 
information in any way or in any manner is strictly prohibited. If you have 
received this communication in error, please delete this mail  notify us 
immediately at [EMAIL PROTECTED]



Watch the latest updates on Mumbai, with video coverage of news, events,
Bollywood, live darshan from Siddhivinayak temple and more, only on
www.mumbailive.in

Watch the hottest videos from Bollywood, Fashion, News and more only on
www.sifymax.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Is a set current TIMESTAMP operation atomic when updating/inserting multiple rows?

[Dilipkumar]

Hi,

If u update this statment like what u have mentioned it will be updated for 
all the rows.


update tablename set field name='2006-07-07 00:00:00';

Thanks  Regards
Dilipkumar
- Original Message - 
From: Chris W [EMAIL PROTECTED]
To: Dan Jakubiec [EMAIL PROTECTED]; MYSQL General List 
mysql@lists.mysql.com

Sent: Monday, July 24, 2006 1:11 AM
Subject: Re: Is a set current TIMESTAMP operation atomic when 
updating/inserting multiple rows?




Dan Jakubiec wrote:


Hi.  I want to insert/update multiple rows into a table which has a
timestamp field, and I want to set the timestamp field in each row to the
current timestamp.  However, it is important to me that all the rows I
update actually end up with the same timestamp value.

My concern is: what happens if the SQL query take a long time and the
current timestamp crosses a second boundary?  For example, suppose I 
issue

the following request on a very large table:

 UPDATE ts SET my_timestamp=NULL;

Say that this query takes 3 seconds to complete.  My questions:

1) Will all the rows have the same timestamp value?  Or will some rows 
have

now, now+1, and now+2?

2) Will the behavior be different if I use my_timestamp=NOW()?

3) If the timestamps will be different, what's the best way to make them 
all

the same?



In the manual it says that all calls to now() in a query always return the 
same time regardless of how many there are and how long it takes the query 
to run so I am thinking that all records with an auto update time stamp 
column that get changed in a single query would all have the same time 
stamp.  It should be easy enough to test if you have a large set of data 
where an update would take a long time.  I'm pretty sure it will do what 
you need though and set them all the same.


--
Chris W
KE5GIX

Gift Giving Made Easy
Get the gifts you want  give the gifts they want
One stop wish list for any gift, from anywhere, for any occasion!
http://thewishzone.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: 
http://lists.mysql.com/[EMAIL PROTECTED]




** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with 
the authority of the Company. If you are not the intended recipient, an 
agent of the intended recipient or a  person responsible for delivering the 
information to the named recipient,  you are notified that any use, 
distribution, transmission, printing, copying or dissemination of this 
information in any way or in any manner is strictly prohibited. If you have 
received this communication in error, please delete this mail  notify us 
immediately at [EMAIL PROTECTED]



Watch the latest updates on Mumbai, with video coverage of news, events,
Bollywood, live darshan from Siddhivinayak temple and more, only on
www.mumbailive.in

Watch the hottest videos from Bollywood, Fashion, News and more only on
www.sifymax.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Replication Problem

[Dilipkumar]

Hi,

Did u mention what all databases has to be replicated in ur cnf file as 
(replicate-do-db=database-name).



Thanks  Regards
Dilipkumar
- Original Message - 
From: Brett Harvey [EMAIL PROTECTED]

To: mysql@lists.mysql.com
Sent: Monday, July 24, 2006 8:49 AM
Subject: Replication Problem



Well, I successfully setup replication for one server/slave. Now I'm
trying to do the same for another set.

I've tried both the tar method and load data from master and can't
seem to get either to work.

Nothing replicates to the slave.

I'm running Mysql 5.022.

===

My error log is showing this - note the error reading packet from server.

060723 21:01:01  InnoDB: Started; log sequence number 0 44044
060723 21:01:01 [Note] Slave SQL thread initialized, starting
replication in log 'FMSweb-bin.04' at position 349828, relay log
'.\FMSbuilding-relay-bin.06' position: 236
060723 21:01:01 [Note] Slave I/O thread: connected to master
'[EMAIL PROTECTED]:3306',  replication started in log
'FMSweb-bin.04' at position 349828
060723 21:01:01 [Note] C:\Program Files\MySQL\MySQL Server
5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.21-community-nt-log'  socket: ''  port: 3306  MySQL
Community Edition (GPL)
060723 21:01:11 [ERROR] Error reading packet from server: Lost
connection to MySQL server during query ( server_errno=2013)
060723 21:01:11 [Note] Slave I/O thread killed while reading event
060723 21:01:11 [Note] Slave I/O thread exiting, read up to log
'FMSweb-bin.04', position 349828
060723 21:01:11 [Note] Error reading relay log event: slave SQL
thread was killed
060723 21:01:41 [Note] Slave SQL thread initialized, starting
replication in log 'FMSweb-bin.04' at position 98, relay log
'.\FMSbuilding-relay-bin.01' position: 4
060723 21:01:41 [Note] Slave I/O thread: connected to master
'[EMAIL PROTECTED]:3306',  replication started in log
'FMSweb-bin.04' at position 98





After taring  my Master Status was this:
mysql SHOW MASTER STATUS;
+---+--+--+--+
| File  | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+---+--+--+--+
| FMSweb-bin.04 |   98 |  |  |
+---+--+--+--+
1 row in set (0.00 sec)



Upon doing a Start Slave I had his for Slave Status

show slave status\G
*** 1. row ***
Slave_IO_State: Waiting for master to send event
Master_Host: 206.103.218.36
Master_User: FMSReplicate
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: FMSweb-bin.04
Read_Master_Log_Pos: 349828
Relay_Log_File: FMSbuilding-relay-bin.02
Relay_Log_Pos: 349966
Relay_Master_Log_File: FMSweb-bin.04
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB: FMS
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 349828
Relay_Log_Space: 349966
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
1 row in set (0.00 sec)

My Master Status is
mysql show master status\g
+---+--+--+--+
| File  | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+---+--+--+--+
| FMSweb-bin.04 |   349828 |  |  |
+---+--+--+--+
1 row in set (0.00 sec)

===


My Master Config is
server-id=1

My Salve Config is
server-id=2
replicate-do-db=FMS
master-host=xxx.xxx.xxx.xxx
master-user=FMSReplicate
master-password=password
relay-log=FMSbuilding-relay-bin
log-bin=FMSbuilding-bin

I did:
CHANGE MASTER TO
- MASTER_HOST='xxx.xxx.xxx.xxx',
- MASTER_USER='TenenzReplicate',
- MASTER_PASSWORD='password',
- MASTER_LOG_FILE='FMSweb-bin.04',
- MASTER_LOG_POS=98;






any ideas?  how do I get it to replicate properly?


Thanks!




--

/Brett C. Harvey;
/Creative-Pages.Net, President;
/Facility Management Systems, CTO (www.fmsystems.biz);
/Lasso Partner Association Member ID #LPA135259
(www.omnipilot.com/www.lassopartner.com);


** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under

Re: mysql/syslog - 100,000s of log messages on restart

[Dilipkumar]

Hi,

In ur cnf file mention the log file path as
log=/mysql/logs/mysqllog/qry.log .
log-slow-queries=/mysql/logs/mysqllog/slowqry.log
and restart mysql.


Thanks  Regards
Dilipkumar
- Original Message - 
From: Adam Rosi-Kessel [EMAIL PROTECTED]

To: mysql@lists.mysql.com
Sent: Sunday, July 23, 2006 1:58 AM
Subject: mysql/syslog - 100,000s of log messages on restart



I'm running MySQL 4.0.23 on a Debian Sarge system.

Often, when I reboot twice in a short time period, MySQL doesn't seem to
shut down gracefully -- it takes a long time for it to come up fully, and
if I reboot before that, I get a lot of log messages.  I think it takes
about an hour to come up fully, although the system is an Athlon XP 2200+
CPU with 2G RAM and not a huge amount of other activity.

My first concern is figuring out how to avoid getting hundreds of
thousands of messages in syslog -- right now grep mysql /var/log/syslog |
wc -l gives 366635 and counting just for today. The log messages look
like this:

Jul 22 16:29:01 bostoncoop mysqld[1993]: mysql tables in use 1, locked 0
Jul 22 16:29:01 bostoncoop mysqld[1993]: MySQL thread id 252, query id 
8143 localhost tpryor statistics
Jul 22 16:29:01 bostoncoop mysqld[1993]: /* LinkCache::addLinkObj */ 
SELECT page_id  FROM `page`  WHERE page_namespace = '0' AND page_title = 
'Zwijnaarde'  LIMIT 1
Jul 22 16:29:01 bostoncoop mysqld[1993]: ---TRANSACTION 0 0, not started, 
process no 1992, OS thread id 2954361776 waiting in InnoDB queue


There's also a bunch of INNODB MONITOR OUTPUT.

I'd like these messages not to get logged at all -- it's far too many to
be useful.

Second, I'd like to have MySQL log to /var/log/mysql/mysql.log rather
than syslog. my.cnf seems to be very poorly documented on this issue. It
says it is a performance killer to log to a specific file --
presumably, using the syslog facility gives better performance. But I
can't find any way to filter the syslog logging back to a separate log
file -- for example, by setting the syslog facility for MySQL as you can
in PostgreSQL. The only documentation in MySQL relating to syslog
facility configuration is in the clustering section, which I don't
believe has anything to do with what I'm doing.

Third, I'd like to figure out why it's taking so long for MySQL to come
up; why it doesn't go down gracefully; and why there are so many log
messages generated as it is coming up.

My my.cnf is attached -- it's fairly standard.

Thanks for any tips.
--
Adam Rosi-Kessel
http://adam.rosi-kessel.org









--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: 
http://lists.mysql.com/[EMAIL PROTECTED] 


** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with 
the authority of the Company. If you are not the intended recipient, an 
agent of the intended recipient or a  person responsible for delivering the 
information to the named recipient,  you are notified that any use, 
distribution, transmission, printing, copying or dissemination of this 
information in any way or in any manner is strictly prohibited. If you have 
received this communication in error, please delete this mail  notify us 
immediately at [EMAIL PROTECTED]



Watch the latest updates on Mumbai, with video coverage of news, events,
Bollywood, live darshan from Siddhivinayak temple and more, only on
www.mumbailive.in

Watch the hottest videos from Bollywood, Fashion, News and more only on
www.sifymax.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Replication Problem

[Dilipkumar]

Hi,

Check whether u have starting with the correct master position from slave.

Thanks  Regards
Dilipkumar
- Original Message - 
From: Brett Harvey [EMAIL PROTECTED]

To: mysql@lists.mysql.com
Sent: Monday, July 24, 2006 9:36 AM
Subject: Re: Replication Problem



Hi,

Thanks for the response.

Yes - I have that in my config also.

replicate-do-db=FMS

Thanks

Brett


Hi,

Did u mention what all databases has to be replicated in ur cnf file as 
(replicate-do-db=database-name).



Thanks  Regards
Dilipkumar


--

/Brett C. Harvey;
/Creative-Pages.Net, President;
/Facility Management Systems, CTO (www.fmsystems.biz);
/Lasso Partner Association Member ID #LPA135259 
(www.omnipilot.com/www.lassopartner.com);



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: 
http://lists.mysql.com/[EMAIL PROTECTED]




** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with 
the authority of the Company. If you are not the intended recipient, an 
agent of the intended recipient or a  person responsible for delivering the 
information to the named recipient,  you are notified that any use, 
distribution, transmission, printing, copying or dissemination of this 
information in any way or in any manner is strictly prohibited. If you have 
received this communication in error, please delete this mail  notify us 
immediately at [EMAIL PROTECTED]



Watch the latest updates on Mumbai, with video coverage of news, events,
Bollywood, live darshan from Siddhivinayak temple and more, only on
www.mumbailive.in

Watch the hottest videos from Bollywood, Fashion, News and more only on
www.sifymax.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: load-file() doesn't work [SOLVED]

[Dilipkumar]

Hi,

If you have  like insert statments try using this as

login into mysql
mysql -u root -p
use database-name

\. /tmp/filename.txt


Thanks  Regards
Dilipkumar
- Original Message - 
From: Marc Alff [EMAIL PROTECTED]

To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Monday, July 17, 2006 11:21 PM
Subject: Re: load-file() doesn't work [SOLVED]




Hi Fleet


[EMAIL PROTECTED] wrote:

SHORT SYNOPSIS:
The statement
INSERT INTO table (blob_column) VALUES
(load_file('/home/somebody/image.jpg'));

Produces no error; but fails to load the image file.

SOLUTION:
The image file (or other binary file, I assume) MUST reside in / or /tmp,
ie /image.jpg or /tmp/image.jpg. (At least in MySQL 3.23.36)

I *hope* this is a bug!

- fleet -




Just to check, is the /home partition actually mounted on the server,
and at the same place ?

In other words, does /home/fleet/image.jpg exists :
- when seen from the host running mysql
- when seen from the host running mysqld

Marc.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: 
http://lists.mysql.com/[EMAIL PROTECTED]




** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with 
the authority of the Company. If you are not the intended recipient, an 
agent of the intended recipient or a  person responsible for delivering the 
information to the named recipient,  you are notified that any use, 
distribution, transmission, printing, copying or dissemination of this 
information in any way or in any manner is strictly prohibited. If you have 
received this communication in error, please delete this mail  notify us 
immediately at [EMAIL PROTECTED]


Watch India vs. England LIVE, Hot videos and more only on Sify Max! Click Here. 
www.sifymax.com

Get to see what's happening in your favourite City on Bangalore Live! 
www.bangalorelive.in


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problems with: MySQL 5.0.21 - 64bit

[Dilipkumar]

Hi,

Please let us know what all variables you have configured in your my.cnf 
files.

what is your total size of memory in box.

eg : max_connections
  key_buffer_size
  sort_buffer_size.

Gabriel PREDA wrote:


Hi list,

Since we bought a better hardware for our dedicated MySQL Server we
have been running into some problems.

We are using:
- Fedora Core 3 - 64bit version
- Kernel: 2.6.9-1.667smp - x86_64
- MySQL 5.0.21-standard - for 64bit

- RAM: 4 GB
- RAID 5 matrix with 3 SCSI disks at 15k rotations

We are using InnoDB tables (with one or 2 exceptions... for some
FullText indexes)...
We are not using transactions... yet !

I'll drop config. details lower...

Still at given moments MySQL hangs... it does not accept connections 
anymore...

We can't kill the process... with KILL command... the only thing we
can do is ask the hosting provider to do a HARDWARE reset... and
someone goes to the machine and pushes the reset button... this hppens
at least once a week...

Does this happened to someone else ?

What was the problem ?

Thanx in advance !




--
Thanks  Regards,
Dilipkumar
DBA Support

** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with 
the authority of the Company. If you are not the intended recipient, an 
agent of the intended recipient or a  person responsible for delivering the 
information to the named recipient,  you are notified that any use, 
distribution, transmission, printing, copying or dissemination of this 
information in any way or in any manner is strictly prohibited. If you have 
received this communication in error, please delete this mail  notify us 
immediately at [EMAIL PROTECTED]


Watch India vs. England LIVE, Hot videos and more only on Sify Max! Click Here. 
www.sifymax.com

Get to see what's happening in your favourite City on Bangalore Live! 
www.bangalorelive.in


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: About mysqldump

[Dilipkumar]

Hi,

Take the dump using --tab which will give you .txt and .sql file.
Move the dump to the new version of mysql and try using load data infile 
'/tmp/user.txt' into table user;



Jørn Dahl-Stamnes wrote:


On Thursday 22 June 2006 04:00, Daniel da Veiga wrote:
 


On 6/21/06, Jørn Dahl-Stamnes [EMAIL PROTECTED] wrote:
   


On Wednesday 21 June 2006 17:17, Barry wrote:
 


Jørn Dahl-Stamnes schrieb:
   


Is it possible to get mysqldump to include rights that has been
GRANTED to a database or to tables in the database that is being
dumped?
 


Dump the Grant tables?
   


I have though of it. Currently I am dumping the mysql database, but there
is a lot of tables that I probably don't need.

Based on a dump of the mysql database, I guess that the following tables
are the one I need to dump:

mysql.db
mysql.table_privs
mysql.user

Comments?
 


Isn't the hosts table needed too?!
   



Maybe, but it is empty on my sql-server.

BTW, I'm using an older version of MySQL:
-- MySQL dump 10.9
--
-- Host: localhostDatabase: mysql
-- --
-- Server version   4.1.8-standard


 




--
Thanks  Regards,
Dilipkumar
DBA Support


** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with 
the authority of the Company. If you are not the intended recipient, an 
agent of the intended recipient or a  person responsible for delivering the 
information to the named recipient,  you are notified that any use, 
distribution, transmission, printing, copying or dissemination of this 
information in any way or in any manner is strictly prohibited. If you have 
received this communication in error, please delete this mail  notify us 
immediately at [EMAIL PROTECTED]


Watch India vs. England LIVE, Hot videos and more only on Sify Max! Click Here. 
www.sifymax.com

Get to see what's happening in your favourite City on Bangalore Live! 
www.bangalorelive.in

Re: my.cnf / mysqld logging

[Dilipkumar]

Hi,

log-queries=/path/



Tom Ray [Lists] wrote:

How would I do that? I'm still a novice when it comes to many aspects 
of mysql.


[EMAIL PROTECTED] wrote:


Hi,

Try to enable query log.


Thanks  Regards
Dilipkumar

 [EMAIL PROTECTED]:

 


Hey there, I inherited a couple of servers that are in production but I

noticed that there\'s not active logging for mysql on any of them. I 
looked and they don\'t have an active my.cnf file any where on the 
machines. One machine is running mysql 4.1.5 and the other is 
running mysql 5.0.18


When I ran a ps -ef on the machines I saw this for both 
/usr/local/mysql/bin/mysqld 
defaults-extra-file=/usr/local/mysql/data/my.cnf so I went and I 
put


a my.cnf right where it was looking for it. Stopped/Started the 
mysql server and I\'m still not seeing any logging happening for the 
mysql servers. Perhaps I\'m messing this up? I want them to log 
everything to /var/log/mysqld.log and in the my.cnf I have the line:


log = /var/log/mysqld.log

Can anyone tell me where I\'m messing this up or what is wrong?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:   
http://lists.mysql.com/[EMAIL PROTECTED]







  






--
Thanks  Regards,
Dilipkumar
DBA Support

** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with 
the authority of the Company. If you are not the intended recipient, an 
agent of the intended recipient or a  person responsible for delivering the 
information to the named recipient,  you are notified that any use, 
distribution, transmission, printing, copying or dissemination of this 
information in any way or in any manner is strictly prohibited. If you have 
received this communication in error, please delete this mail  notify us 
immediately at [EMAIL PROTECTED]


Watch India vs. England LIVE, Hot videos and more only on Sify Max! Click Here. 
www.sifymax.com

Get to see what's happening in your favourite City on Bangalore Live! 
www.bangalorelive.in


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Access denied

[Dilipkumar]

Hi,

Please check the data directory where u have started your mysql has
permission ( mysql:mysql )
U would have started your ur mysql ar root user and when u create a 
database which has

no permission as (mysql) in data directory.

This might help you out.

Kaushal Shriyan wrote:


Hi ALL

I am faced with a issue of creating database , The issue is I am able
to enter to the MySQL Server with the password, but when i try to
create database I get Access Denied

Below are the details

[EMAIL PROTECTED] root]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 17 to server version: 3.23.54

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql exit
Bye
[EMAIL PROTECTED] root]# mysqladmin -u root -p create kaushal
Enter password:
mysqladmin: CREATE DATABASE failed; error: 'Access denied for user:
'[EMAIL PROTECTED]' to database 'kaushal''

Any Clue will be really appreciated

Thanks

Kaushal




--
Thanks  Regards,
Dilipkumar
DBA Support

** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with 
the authority of the Company. If you are not the intended recipient, an 
agent of the intended recipient or a  person responsible for delivering the 
information to the named recipient,  you are notified that any use, 
distribution, transmission, printing, copying or dissemination of this 
information in any way or in any manner is strictly prohibited. If you have 
received this communication in error, please delete this mail  notify us 
immediately at [EMAIL PROTECTED]


Watch India vs. England LIVE, Hot videos and more only on Sify Max! Click Here. 
www.sifymax.com

Get to see what's happening in your favourite City on Bangalore Live! 
www.bangalorelive.in


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL crashes

[Dilipkumar]

Hi,

This might be a bug try to create mysql stack trace file and find out 
what is causing for mysql
crash, this might be a query hitting mysql and also memory related 
issues.Try to upgrade your

mysql and report back.


Daniel da Veiga wrote:


On 6/7/06, Ian Collins [EMAIL PROTECTED] wrote:


I have a site running MySQL 4.1.19.
When I was first given the problem, the site only stayed up for a couple
of days - they then found they had to reboot (as opposed to just
restarting MySQL).
The error message they were getting is below (between the snip's).

After looking at the site, I altered some my.cnf parameters, and then
the site stayed up for 14 days before doing the same.

This site is identical to others I have seen - that are running with no
issues.
Could this be hardware (memory related)?

Regards,
Ian Collins.


 snip
===
Version: '4.1.9-standard'  socket: '/tmp/mysql.sock'  port: 3306
Official MySQL RPM
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this 
binary
or one of the libraries it was linked against is corrupt, improperly 
built,
or misconfigured. This error can also be caused by malfunctioning 
hardware.

We will try our best to scrape up some info that will hopefully help
diagnose
the problem, but since we have already crashed, something is definitely
wrong
and this may fail.

key_buffer_size=134217728
read_buffer_size=131072
max_used_connections=80
max_connections=400
threads_connected=68
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections
= 1001468 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd=0x8e6d0c0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Cannot determine thread, fp=0xbfb1f5d8, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x808e1b7
0x82e5a08
0x80b68f6
0x804c0bd
0x804bfb3
0x808473c
0x808ddb3
0x809b8e6
0x82e31bc
0x830ca8a
New value of fp=(nil) failed sanity check, terminating stack trace!
Please read http://dev.mysql.com/doc/mysql/en/Using_stack_trace.html and
follow instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd-query at (nil)  is invalid pointer
thd-thread_id=52266
The manual page at http://www.mysql.com/doc/en/Crashing.html contains
information that should help you find out what is causing the crash.

Number of processes running now: 0
 snip
===




You mean 4.1.9, not 4.1.19 right? Try upgrading your server to the
latest 4.1, I believe its 4.1.20, and report back... I`ve seen various
issues with versions below 4.1.12...




--
Thanks  Regards,
Dilipkumar
DBA Support

** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with 
the authority of the Company. If you are not the intended recipient, an 
agent of the intended recipient or a  person responsible for delivering the 
information to the named recipient,  you are notified that any use, 
distribution, transmission, printing, copying or dissemination of this 
information in any way or in any manner is strictly prohibited. If you have 
received this communication in error, please delete this mail  notify us 
immediately at [EMAIL PROTECTED]


Watch India vs. England LIVE, Hot videos and more only on Sify Max! Click Here. 
www.sifymax.com

Get to see what's happening in your favourite City on Bangalore Live! 
www.bangalorelive.in


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Copying tables sans data from one database to another

[Dilipkumar]

Hi,

It is

Rename table name to database.tablename.

db-1
db-2
rename db1.tablename to db2.tablename.

This might help you out.

murthy gandikota wrote:


How can I copy tables from one database to another on the same host?
  
 Thanks for your help

 Murthy

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
 




--
Thanks  Regards,
Dilipkumar
DBA Support

** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with 
the authority of the Company. If you are not the intended recipient, an 
agent of the intended recipient or a  person responsible for delivering the 
information to the named recipient,  you are notified that any use, 
distribution, transmission, printing, copying or dissemination of this 
information in any way or in any manner is strictly prohibited. If you have 
received this communication in error, please delete this mail  notify us 
immediately at [EMAIL PROTECTED]


Watch India vs. England LIVE, Hot videos and more only on Sify Max! Click Here. 
www.sifymax.com

Get to see what's happening in your favourite City on Bangalore Live! 
www.bangalorelive.in


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: grant modify, doc on grant.

[Dilipkumar]

Hi,

You can try this option by

grant file  on *.* to [EMAIL PROTECTED] identified by 'db123';
Query OK, 0 rows affected (0.03 sec)

For all the Databases.

Gilles MISSONNIER wrote:


Thank you Sheeri for answering,

I guess this syntax works for you, but
for me NO, this DO NOT work ( I run MySQL 4.21 , on Linux Debian sarge )


mysql GRANT FILE ON dr4.* to 'wr'@'localhost' IDENTIFIED BY 
'the_passwd';

ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES


the error code make no sense to me ( I tried various combination of ' )
# Error: 1221 SQLSTATE: HY000 (ER_WRONG_USAGE) Message: Incorrect 
usage of %s and %s



It make no sense because the SAME usage of %s works fine in one 
command, not in the other command (the one for file privilege).



I am running Mysql as root, I can create a new user, but not with the 
file (as you can read hereafter).




mysql GRANT SELECT, INSERT, UPDATE, CREATE , FILE ON dr4.* to 
'moi'@'localhost'  IDENTIFIED BY 'the_passwd';

ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES

mysql GRANT SELECT, INSERT, UPDATE, CREATE ON dr4.* to 
'moi'@'localhost' IDENTIFIED BY 'the_passwd';

Query OK, 0 rows affected (0.00 sec)

mysql GRANT FILE ON dr4.* to 'moi'@'localhost'  IDENTIFIED BY 
'the_passwd';

ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES


-

On Fri, 26 May 2006, sheeri kritzer wrote:


GRANT FILE ON dr4.* to 'wr'@'localhost' IDENTIFIED BY 'the_passwd';

It won't set up a new account, just add the privilege for you.

-Sheeri

On 5/26/06, Gilles MISSONNIER [EMAIL PROTECTED] wrote:


Hello
How to set  FILE privilege enable to an already defined user ?

It seems that I have to read the all manual for that.
I cannot find an example in the on line manual.


thanks.

- Gilles -

-

I will end up running mysql as root.







--
Thanks  Regards,
Dilipkumar
DBA Support

** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with 
the authority of the Company. If you are not the intended recipient, an 
agent of the intended recipient or a  person responsible for delivering the 
information to the named recipient,  you are notified that any use, 
distribution, transmission, printing, copying or dissemination of this 
information in any way or in any manner is strictly prohibited. If you have 
received this communication in error, please delete this mail  notify us 
immediately at [EMAIL PROTECTED]


Watch India vs. England LIVE, Hot videos and more only on Sify Max! Click Here. 
www.sifymax.com

Get to see what's happening in your favourite City on Bangalore Live! 
www.bangalorelive.in


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: grant modify, doc on grant.

[Dilipkumar]

Dude listen,

You can given file privileges to existing users  for all the Db's as

if you specify as
grant file on database.* to [EMAIL PROTECTED] identified by 'passwd'; [ 
*Error* ]


If you mention to all the DB for a user as:
grant file on *.* to [EMAIL PROTECTED] identified by 'passwd';

Try this, correct me if i am worng.This might help you out.

Michael Stassen wrote:


Gilles MISSONNIER wrote:
 Hello
 How to set  FILE privilege enable to an already defined user ?

 It seems that I have to read the all manual for that.
 I cannot find an example in the on line manual.
snip

sheeri kritzer wrote:
 GRANT FILE ON dr4.* to 'wr'@'localhost' IDENTIFIED BY 'the_passwd';

 It won't set up a new account, just add the privilege for you.

Gilles MISSONNIER wrote:
 Thank you Sheeri for answering,

 I guess this syntax works for you, but
 for me NO, this DO NOT work ( I run MySQL 4.21 , on Linux Debian 
sarge )


 mysql GRANT FILE ON dr4.* to 'wr'@'localhost' IDENTIFIED BY 
'the_passwd';

 ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES
snip

Dilipkumar wrote:


Hi,

You can try this option by

grant file  on *.* to [EMAIL PROTECTED] identified by 'db123';
Query OK, 0 rows affected (0.03 sec)

For all the Databases.



The FILE privilege is a global privilege 
http://dev.mysql.com/doc/refman/5.0/en/grant.html, so it can only be 
granted on *.*, as Dilipkumar suggests.  Also, once you've created a 
user and set a password, you only need the IDENTIFIED BY clause in 
your GRANT statements if you are *changing* the password.  Without 
that clause, the current password stays in effect.  Hence, you need


  GRANT FILE ON *.* TO [EMAIL PROTECTED];

Michael




--
Thanks  Regards,
Dilipkumar
DBA Support


** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with 
the authority of the Company. If you are not the intended recipient, an 
agent of the intended recipient or a  person responsible for delivering the 
information to the named recipient,  you are notified that any use, 
distribution, transmission, printing, copying or dissemination of this 
information in any way or in any manner is strictly prohibited. If you have 
received this communication in error, please delete this mail  notify us 
immediately at [EMAIL PROTECTED]


Watch India vs. England LIVE, Hot videos and more only on Sify Max! Click Here. 
www.sifymax.com

Get to see what's happening in your favourite City on Bangalore Live! 
www.bangalorelive.in

Re: hi how to merge data of various sql files

[Dilipkumar]

HI,

In this case if you want to import try to use force method.

mysqlimport -u root -p *-i* databasename filename.sql

_*(-i, --ignoreIf duplicate unique key was found, keep old row)*_

VenuGopal Papasani wrote:


hi all,
 I have got a problem.I have data entered in different machines in a
database now i have got all the data in different .sql files.Now i was
importing the same files in order to merge them in a same
database.Herethere was a problem in merging, There were some tables
which does´not change
those tables always remains constant such as areacode table.Now if i am
trying to merge these tables it was giving an error called

error::Duplicate entry 1 .


I dont know exactly how many tables does not change.Is there any 
procedure

to import and merge into a single database in these kind of suituations.


Thanks and Regards,
venu.





--
Thanks  Regards,
Dilipkumar
DBA Support


** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with 
the authority of the Company. If you are not the intended recipient, an 
agent of the intended recipient or a  person responsible for delivering the 
information to the named recipient,  you are notified that any use, 
distribution, transmission, printing, copying or dissemination of this 
information in any way or in any manner is strictly prohibited. If you have 
received this communication in error, please delete this mail  notify us 
immediately at [EMAIL PROTECTED]


Watch India vs. England LIVE, Hot videos and more only on Sify Max! Click Here. 
www.sifymax.com

Get to see what's happening in your favourite City on Bangalore Live! 
www.bangalorelive.in

Re: hi how to merge data of various sql files

[Dilipkumar]

Hi,


In backup directory
cat *.sql | mysql -u root -p database
*
and

*Use import which is given below*
*
Dilipkumar wrote:


HI,

In this case if you want to import try to use force method.

mysqlimport -u root -p *-i* databasename filename.sql

_*(-i, --ignoreIf duplicate unique key was found, keep old row)*_

VenuGopal Papasani wrote:


hi all,
 I have got a problem.I have data entered in different machines in a
database now i have got all the data in different .sql files.Now i was
importing the same files in order to merge them in a same
database.Herethere was a problem in merging, There were some tables
which does´not change
those tables always remains constant such as areacode table.Now if i am
trying to merge these tables it was giving an error called

error::Duplicate entry 1 .


I dont know exactly how many tables does not change.Is there any 
procedure

to import and merge into a single database in these kind of suituations.


Thanks and Regards,
venu.








--
Thanks  Regards,
Dilipkumar
DBA Support


** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with 
the authority of the Company. If you are not the intended recipient, an 
agent of the intended recipient or a  person responsible for delivering the 
information to the named recipient,  you are notified that any use, 
distribution, transmission, printing, copying or dissemination of this 
information in any way or in any manner is strictly prohibited. If you have 
received this communication in error, please delete this mail  notify us 
immediately at [EMAIL PROTECTED]


Watch India vs. England LIVE, Hot videos and more only on Sify Max! Click Here. 
www.sifymax.com

Get to see what's happening in your favourite City on Bangalore Live! 
www.bangalorelive.in

Re: Auto Install mySQL

[Dilipkumar]

Hi,

If you are installing in windows only thing you run the setup.exe ,after 
the installation
is completed it will prompt for you a default user password that is root 
(password).

and also to create anonymous user.

Jim wrote:




Hi All,



Does anybody have some advise on automating the install of mySQL and our DB
on a PC/Laptop with no user interaction required.

Does the SETUP.EXE take any paramaters to auto install without the user
dialogs?



Thanks,

Jim




 




--
Thanks  Regards,
Dilipkumar
DBA Support

** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with 
the authority of the Company. If you are not the intended recipient, an 
agent of the intended recipient or a  person responsible for delivering the 
information to the named recipient,  you are notified that any use, 
distribution, transmission, printing, copying or dissemination of this 
information in any way or in any manner is strictly prohibited. If you have 
received this communication in error, please delete this mail  notify us 
immediately at [EMAIL PROTECTED]


Watch India vs. England LIVE, Hot videos and more only on Sify Max! Click Here. 
www.sifymax.com

Get to see what's happening in your favourite City on Bangalore Live! 
www.bangalorelive.in


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: how to restart mysql and apache?

[Dilipkumar]

Hi,

If it is your default apache /usr/sbin/apachectl start

and mysql

/etc/init.d/mysql.server start


This might help you out.


Daniel da Veiga wrote:


On 5/9/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:


found this:
/etc/rc.d/init.d/mysqld restart
/etc/rc.d/init.d/httpd2 restart

I think it should work?



Yeah, different systems, different locations, but the same purpose...

--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
--END GEEK CODE BLOCK--




--
Thanks  Regards,
Dilipkumar
DBA Support

** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with 
the authority of the Company. If you are not the intended recipient, an 
agent of the intended recipient or a  person responsible for delivering the 
information to the named recipient,  you are notified that any use, 
distribution, transmission, printing, copying or dissemination of this 
information in any way or in any manner is strictly prohibited. If you have 
received this communication in error, please delete this mail  notify us 
immediately at [EMAIL PROTECTED]


Watch India vs. England LIVE, Hot videos and more only on Sify Max! Click Here. 
www.sifymax.com

Get to see what's happening in your favourite City on Bangalore Live! 
www.bangalorelive.in


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Need help in recreating .MYD files

[Dilipkumar]

Hi,

please tell me the server uptime and also the master logs as
show master logs;

in mysql prompt.

Yes u can restore data from the binlog if you have the binlogs.

balaraju mandala wrote:


Hi Dilip,

it means i loosed the data, correct Dilip. is there any other way to gain
that data, any binary logs etc?

regards,
bala





--
Thanks  Regards,
Dilipkumar
DBA Support

** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with 
the authority of the Company. If you are not the intended recipient, an 
agent of the intended recipient or a  person responsible for delivering the 
information to the named recipient,  you are notified that any use, 
distribution, transmission, printing, copying or dissemination of this 
information in any way or in any manner is strictly prohibited. If you have 
received this communication in error, please delete this mail  notify us 
immediately at [EMAIL PROTECTED]


Watch India vs. England LIVE, Hot videos and more only on Sify Max! Click Here. 
www.sifymax.com

Get to see what's happening in your favourite City on Bangalore Live! 
www.bangalorelive.in


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Outfile syntax and out of memory

[Dilipkumar]

Hi,

Increase max_allowed packet to 1.5 gb and then try to import your data .

eg ;

In mysql prompt run the file as

*use database   
\. /tmp/filename.txt

*
Johan Lundqvist wrote:


Hi,

I need to extract some data to a textfile from a big database.


If I try to do like this:
mysql  queryfile.sql  outfile.txt

outfile.txt it looks something like:
OrderID, Quant, OrdrDate, code1, code2...
10021, 12, 20060412, 23, 95...
10022, 5, 20060412, , 75...

But, I never get a complete file. I get a out of memory error after a 
hour or 2!!



If I instead insert the following code in queryfile.sql:
INTO OUTFILE 'outfile.txt'

Now my outfile.txt don't get the first row with the column names, and 
any NULL values are exported as \N.


This is a big problem, cause the import function that exist where I 
send the data only accept the format I get using mysql  
queryfile.sql  outfile.txt.


Any help??! Ideas??

Can I in any way format my output to print the column names and print 
NULL values as 'nothing'??


Regards,
/Johan Lundqvist




--
Thanks  Regards,
Dilipkumar
DBA Support


** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with 
the authority of the Company. If you are not the intended recipient, an 
agent of the intended recipient or a  person responsible for delivering the 
information to the named recipient,  you are notified that any use, 
distribution, transmission, printing, copying or dissemination of this 
information in any way or in any manner is strictly prohibited. If you have 
received this communication in error, please delete this mail  notify us 
immediately at [EMAIL PROTECTED]


Watch India vs. England LIVE, Hot videos and more only on Sify Max! Click Here. 
www.sifymax.com

Get to see what's happening in your favourite City on Bangalore Live! 
www.bangalorelive.in

Re: Need help in recreating .MYD files

[Dilipkumar]

Hi,

If you have deleted .MYD files then truncate the table and restore it 
from the backup if yu have.

MYD means  your precious data which contains.

balaraju mandala wrote:


Dear Comunity,

I need your help. I accidently deleted some '.MYD' files. I want to 
restore

them, without stopping the running server. how i can do this. i am using
Linux OS, i tried to create file using --- vi tablename.MYD(a blank 
file)

but it is not accepted by MySql.

regards,
bala





--
Thanks  Regards,
Dilipkumar
DBA Support

** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with 
the authority of the Company. If you are not the intended recipient, an 
agent of the intended recipient or a  person responsible for delivering the 
information to the named recipient,  you are notified that any use, 
distribution, transmission, printing, copying or dissemination of this 
information in any way or in any manner is strictly prohibited. If you have 
received this communication in error, please delete this mail  notify us 
immediately at [EMAIL PROTECTED]


Watch India vs. England LIVE, Hot videos and more only on Sify Max! Click Here. 
www.sifymax.com

Get to see what's happening in your favourite City on Bangalore Live! 
www.bangalorelive.in


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to repair a table,

[Dilipkumar]

Hi,

Yes it can be repaired using

myisamchk -u root -p  datadirectory the table name as tablename.* 
password

this will check the data and also the index file also.

Payne wrote:

hi, I got a table where the myi isn't able to re be read. I tried to 
run myisam but it give an error about the index.


Do I need to drop the table? Can it be repaired?


Payne




--
Thanks  Regards,
Dilipkumar
DBA Support

** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with 
the authority of the Company. If you are not the intended recipient, an 
agent of the intended recipient or a  person responsible for delivering the 
information to the named recipient,  you are notified that any use, 
distribution, transmission, printing, copying or dissemination of this 
information in any way or in any manner is strictly prohibited. If you have 
received this communication in error, please delete this mail  notify us 
immediately at [EMAIL PROTECTED]


Watch India vs. England LIVE, Hot videos and more only on Sify Max! Click Here. 
www.sifymax.com

Get to see what's happening in your favourite City on Bangalore Live! 
www.bangalorelive.in


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]