Re: How to delete all rows....

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

Re: replication breaks

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 ser

Backup Errors in MySQL Cluster (5.0.24)

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 in

Re: MySQL Cluster 5.0.24 (Import) Slow

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: Sent: Sunday, August 20, 2006 2:06 AM Subject: Re: MySQL Cluster 5.0.24 (Import

MySQL Cluster 5.0.24 (Import) Slow

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 Dilipk

Re: Can a table be copied across the DBs?

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

Re: Can a table be copied across the DBs?

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 Kl

Re: Relay Log Lost on Slave

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: Sent: Wednesday, August 02, 2006 3:29 PM Subjec

Re: One question about mysql_close

Hi, Yes Aborted connects will start increasing than the connections. Thanks & Regards Dilipkumar - Original Message - From: "��?��╁��" <[EMAIL PROTECTED]> To: Sent: Wednesday, August 02, 2006 11:34 AM Subject: One question about mysql_close Hi, I have a qu

Re: Relay Log Lost on Slave

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

Re: Mysqlcheck issues

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: Sent: Thursday, July 27, 2006 8:32 PM Subject: Mysqlcheck issues

Re: how to move datadir to a different file system

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: Sent: Fri

Re: Adding Foreign Key Fails

Hi, Is this a InnoDB table. Thanks & Regards Dilipkumar - Original Message - From: "Jesse" <[EMAIL PROTECTED]> To: "MySQL List" Sent: Wednesday, July 26, 2006 6:28 PM Subject: Adding Foreign Key Fails I am trying to add a foreign key to one of

Re: Row count discrepancy when converting from MyISAM to InnoDB

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

Re: Slave Replication issues

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: Sent: Wednesday, July 26, 2006 12:34 AM Subject: Re: Slave Replicat

Re: MySQL Cluster

) » Thanks & Regards Dilipkumar - Original Message - From: "Jimmy Guerrero" <[EMAIL PROTECTED]> To: "'Kaushal Shriyan'" <[EMAIL PROTECTED]>; Sent: Tuesday, July 25, 2006 7:18 PM Subject: RE: MySQL Cluster Hello, MySQL Cluster has been availab

Re: Need Restore Help

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" Sent: Monday,

Re: Replication Problem

Hi, Check whether u have starting with the correct master position from slave. Thanks & Regards Dilipkumar - Original Message - From: "Brett Harvey" <[EMAIL PROTECTED]> To: Sent: Monday, July 24, 2006 9:36 AM Subject: Re: Replication Problem Hi, Thanks for th

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

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: Sent: Sunday

Re: Replication Problem

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: Sent: Monday, July 24, 2006 8:49 AM Subject: Replicatio

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

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 Ja

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

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: Sent: Mond

Re: About mysqldump

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

Re: Problems with: MySQL 5.0.21 - 64bit

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

Re: my.cnf / mysqld logging

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 ser

Re: Access denied

'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

Re: Copying tables sans data from one database to another

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

Re: MySQL crashes

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 individua

Re: grant modify, doc on grant.

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

Re: grant modify, doc on grant.

D]> 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 runn

Re: hi how to merge data of various sql files

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

Re: hi how to merge data of various sql files

ards, 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 ex

Re: Auto Install mySQL

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 transmitte

Re: how to restart mysql and apache?

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

Re: Need help in recreating .MYD files

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 con

Re: How to repair a table,

t 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

Re: Need help in recreating .MYD files

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

Re: Outfile syntax and out of memory

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