Re: MY SQL Slave Server

2010-02-07 Thread Thiyaghu CK
Hi Vikram, Download some other version and install. Use the higher version as slave. Regards, Thiyaghu CK On Sat, Feb 6, 2010 at 10:08 PM, Vikram A wrote: > I tried to install once again mysql at vista? but deducts the previous > installation. and it is ask for the modify , repire and

Re: dumping error

2010-02-06 Thread Thiyaghu CK
I hope you are executing the command from 'D:\', mysqldump has to be executed for the directory bin where you have installed the mysql. eg:D:\mysql\mysql5.0\bin\>mysqldump -u root -pdbadmin murali > "c:\murali.sql" This will help you. Regards, Thiyaghu CK www.mafiree.c

Re: hi.. is it possible

2010-02-06 Thread Thiyaghu CK
Yes you can, but port has to be different. Regards, Thiyaghu CK www.mafiree.com On Sat, Feb 6, 2010 at 2:50 PM, MuraliKrishna < murali_kris...@arthaoptions.com> wrote: > Hi is it possible to have two instances of mysql over single windows xp. > because I want to workout with those a

Re: MY SQL Slave Server

2010-02-05 Thread Thiyaghu CK
machine or in different machine and make more copy. Note: Slave should be of same version or higher. For replication steps you can refer http://www.mafiree.com/docs.html or http://www.howtoforge.com/mysql_database_replication Let me know for more details. Regards, Thiyaghu CK www.mafiree.com On

Re: help about the charset

2010-02-03 Thread Thiyaghu CK
Hi Moli, I hope this is because there is spelling mistake. It should be * '--with-extra-charsets=all'*, but you have given '--with-*extral*-charsets=all'. That's why only the utf8 has been installed and not the other charsets. Regards, Thiyaghu CK www.mafiree.com On We

Re: how to get the name of primary key ?

2010-02-01 Thread Thiyaghu CK
Hi, Use *SELECT * FROM game_log WHERE this_table's_PK = last_insert_id()* It will help you. Regards, Thiyaghu CK, MySQL DBA www.mafiree.com 2010/2/1 曹凯 > > Hi all, > > if we just know the table name but don't know the name of primary key, is > there any variables o

Re: Another Inserting Multiple Values with Set Problem

2010-01-08 Thread Thiyaghu CK
--+ | XSmall,Small,Medium | black_FF,yellow_9ACD32,teal_E2725B | +-+----+ 5 rows in set (0.01 sec) Regards, Thiyaghu CK www.mafiree.com On Fri, Jan 8, 2010 at 2:27 PM, Victor Subervi wrote: > On Fri, Jan 8, 2010 at 2:26 AM,

Re: Another Inserting Multiple Values with Set Problem

2010-01-07 Thread Thiyaghu CK
Hi Victor, You have given space after the comma(shown here: ('Small, Medium, XSmall')). Take out the space and try, it will work. Example: mysql> insert into products(sizes) values ('Small,Medium,small,medium'); Query OK, 1 row affected (0.05 sec) Regards, Thiyaghu CK

LOCK problem with SELECT table alias

2003-01-05 Thread ck
>Description: A SELECT statement fails if you have table aliases and use table locking with the LOCK command >How-To-Repeat: DROP TABLE IF EXISTS CK1; CREATE TABLE CK1 ( ID INT UNSIGNED NOT NULL, PRIMARY KEY(ID) ); LOCK TABLES CK1

mysql query error

2002-11-20 Thread ck nuke
Hi I have a problem about : mysql query I need help for this. Sever: mysql Version: 4.0.4-bata SELECT p.pid, p.dateline, t.tid, t.replies FROM cdb_threads t, cdb_posts p WHERE p.tid=t.tid AND t.fid='24' ORDER BY p.dateline DESC LIMIT 0,1 When use this command, no result ---

Re: Help required MySql + PHP

2001-12-06 Thread CK Raju
Check on the file extensions. If you are using .html or .htm, probably you cant unless you make changes in the /etc/httpd/conf/httpd.conf file. (use .phtml or .php instead) CK Raju - Before posting, please check: http://w

Re: Beginner - Updating a Table from a File

2001-11-27 Thread CK Raju
Elaborate, please. Raju On Tuesday 27 November 2001 16:47, raezor wrote: > Can you update a table from a file? if so where can I find some syntax? > > - > Before posting, please check: >http://www.mysql.com/manual.php (the

Evil LNK2001 Errors, Grr...

2001-09-20 Thread CK Hill
s@D@std@@V?$allocator@D@2 @@0@0@Z) mysql++.lib(field_names.obj) : error LNK2001: unresolved external symbol "__declspec(dllimport) public: char & __thiscall std::basic_string,class std::allocator >::operator[](unsigned int)" (__imp_??A?$basic_ string@DU?$char_traits@D@std@@V?$al

Re: Re:org

2001-07-14 Thread CK Raju
Friends, Wouldn't it be better if we kept the issues to be taken up by lawyers, once they have already been hired and keep this discussion forum to serve the larger purpose for which it was meant to ? As a simple user of services, I am feeling very disappointed at the sight of some of my

Re: "configure" question

2001-06-24 Thread CK Raju
avoid rejection - Webmasters please note. > - Original Message - > From: "Trond Eivind Glomsrød" <[EMAIL PROTECTED]> > To: "CK Raju" <[EMAIL PROTECTED]> > Cc: "mysql" <[EMAIL PROTECTED]> > Sent: Sunday, June 24, 2001 11:31 PM &g

Re: "configure" question

2001-06-24 Thread CK Raju
But the INSTALL-SOURCE file you get after unzipping the tarred file says you can. And I have been using it the same way as listed there with success on a Red Hat 6.2 machine. Raju > This is _not_ a recommended way to use it on a Red Hat Linux > system. Get the srpm and do a "rpm --rebuild" of it

Re: "configure" question

2001-06-23 Thread CK Raju
Trond Eivind Glomsrød wrote: > William Clifford <[EMAIL PROTECTED]> writes: > >> Hi all. I recently downloaded the source distribution of MySQL version 3.23.39 >> and am trying to compile it so that it installs it's files in the same manner >> as the binary RPM version does. > > > Just downloa

More examples of very large organisations using mysql

2001-03-30 Thread CK Raju
> want to know is a few examples of medium to large > companies using mysql for mission critical stuff. I too am in a similar situation, needing links to large organisations on mySQL. This would help me to replace the largest-ever (proposed) deployment of MSSQL (as per the official release of Micr

Re: rpm requires perl5 on redhat 7.0

2001-01-11 Thread CK Raju
Try building from source from the mirror site http://mysql.hjc.edu.sg if u are in India. Cheers. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list a

Re: Lazy

2001-01-10 Thread CK Raju
> I didn't wanted to make you upset. We still try to answer questions and > value your time. Just some questions are repeating up to 3 times per That's great coming from a great team. Who knows ? There might be people who are tasked to frustrate you and this group. For the benefit of the open-sour