Re: MY SQL Slave Server
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 remove options > > You said that we can install any number of setups in a same system. > > Is there any other way to install? > > Please help me > > thank you > > > > ------ > *From:* Thiyaghu CK > *To:* Vikram A > *Sent:* Sat, 6 February, 2010 3:05:25 PM > > *Subject:* Re: MY SQL Slave Server > > Hi Vikram, > > Ya sure, slave can be in vista. Yes, you can install 2 or more setups in > same system but port has to be different, and if its linux platform change > the sock name too. > > Regards, > Thiyaghu CK > www.mafiree.com > > On Sat, Feb 6, 2010 at 2:09 PM, Vikram A wrote: > >> Dear Thiyagu! >> >> Thank you for the information. I will do the experiment. and let you know >> the further details. >> >> Is it possible making slave at windows vista? As per your information, th >> emysql has to be installed once again another port; Is it possible to >> install 2 setups in a same system? >> >> Thank you >> >> VIKRAM A >> >> >> -- >> *From:* Thiyaghu CK >> *To:* Vikram A >> *Cc:* mysql@lists.mysql.com >> *Sent:* Sat, 6 February, 2010 1:03:34 PM >> *Subject:* Re: MY SQL Slave Server >> >> Hi Vikram, >> >> So as my understanding you need to have a master slave setup in a single >> machine(FEDORA 11). >> >> 1. Make the already running mysql instance as Master >> 2. Install a new mysql in the same machine in different port which will be >> your slave >> 3. Replicate >> 4.You can also add more slave in same 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 Sat, Feb 6, 2010 at 12:33 PM, Vikram A wrote: >> >> > Dear Experts, >> > >> > I would like to configure the slave for my main server. My server is >> > running in the FEDORA 11. >> > I would like to make another mirror of the DB in the same server/ The >> copy >> > of the DB can be kept at win server / another Fedora server. >> > >> > Can you suggest how to do the above? >> > >> > Thank you >> > >> > VIKKI A >> > >> > >> > The INTERNET now has a personality. YOURS! See your Yahoo! >> Homepage. >> > http://in.yahoo.com/ >> >> -- >> The INTERNET now has a personality. YOURS! See your Yahoo! >> Homepage<http://in.rd.yahoo.com/tagline_yyi_1/*http://in.yahoo.com/> >> . >> > > > -- > Your Mail works best with the New Yahoo Optimized IE8. Get it > NOW!<http://in.rd.yahoo.com/tagline_ie8_new/*http://downloads.yahoo.com/in/internetexplorer/> > . >
Re: dumping error
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.com On Sat, Feb 6, 2010 at 4:30 PM, MuraliKrishna < murali_kris...@arthaoptions.com> wrote: > D:\>mysqldump -u root -pdbadmin murali > murali.sql > > 'mysqldump' is not recognized as an internal or external command, > > operable program or batch file. > > > > > >
Re: hi.. is it possible
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 as server and client. please help me > regarding this. > >
Re: MY SQL Slave Server
Hi Vikram, So as my understanding you need to have a master slave setup in a single machine(FEDORA 11). 1. Make the already running mysql instance as Master 2. Install a new mysql in the same machine in different port which will be your slave 3. Replicate 4.You can also add more slave in same 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 Sat, Feb 6, 2010 at 12:33 PM, Vikram A wrote: > Dear Experts, > > I would like to configure the slave for my main server. My server is > running in the FEDORA 11. > I would like to make another mirror of the DB in the same server/ The copy > of the DB can be kept at win server / another Fedora server. > > Can you suggest how to do the above? > > Thank you > > VIKKI A > > > The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. > http://in.yahoo.com/
Re: help about the charset
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 Wed, Feb 3, 2010 at 2:26 PM, wrote: > Hello, > > I have a strange problem on the charset on mysql. > I'm using mysql-5.0.45, compiled from the source, and enabled: > '--with-charset=utf8' '--with-extral-charsets=all' > when compiling it. > > My default charset in my.cnf is utf8: > character-set-server=utf8 > > OK I logined into mysql and run: > > mysql> set names 'gbk'; > ERROR 1115 (42000): Unknown character set: 'gbk' > > The error shows as above. > > These were the 'show' command's output: > > mysql> show variables like 'character%'; > +--++ > | Variable_name| Value | > +--++ > | character_set_client | utf8 | > | character_set_connection | utf8 | > | character_set_database | utf8 | > | character_set_filesystem | binary | > | character_set_results| utf8 | > | character_set_server | utf8 | > | character_set_system | utf8 | > | character_sets_dir | /var/mysql5.0.45/share/mysql/charsets/ | > +--++ > 8 rows in set (0.00 sec) > > mysql> show charset like 'utf8'; > +-+---+---++ > | Charset | Description | Default collation | Maxlen | > +-+---+---++ > | utf8| UTF-8 Unicode | utf8_general_ci | 3 | > +-+---+---++ > 1 row in set (0.01 sec) > > mysql> show charset like 'gbk'; > Empty set (0.00 sec) > > > Since I have enabled --with-extral-charsets=all why can't I use gbk > charset? > How to resolve it? > > Thanks. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=theyaho...@gmail.com > >
Re: how to get the name of primary key ?
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 or constants could instead of the PK? > > for example: > > there is a table "game_log", and now I have the last inserted_id but don't > know what its primary_id is, > how can I "SELECT * FROM game_log WHERE this_table's_PK = > last_inserted_id"? > > > > _ > 约会说不清地方？来试试微软地图最新msn互动功能！ > http://ditu.live.com/?form=TL&swm=1
Re: Another Inserting Multiple Values with Set Problem
Hi Victor,
Take out the double quotes from[ "('Small,Medium,XSmall')",
"('teal_E2725B,black_FF,yellow_9ACD32')"]. Its working fine for me.
mysql> insert into products (sizes, colorsShadesNumbersShort)
values(('Small,Medium,XSmall'), ('teal_E2725B,black_FF,yellow_9ACD32'));
Query OK, 1 row affected (0.05 sec)
mysql> select * from products;
+-++
| sizes | colorsShadesNumbersShort |
+-++
| 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, Thiyaghu CK wrote:
>
>> 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)
>>
>
> insert into products (SKU, Category, Name, Title, Description, Price,
> SortFactor, Availability, OutOfStock, Weight, ShipFlatFee, ShipPercentPrice,
> ShipPercentWeight, sizes, colorsShadesNumbersShort) values("prodSKU1",
> "prodCat1", "name1", "title1", "descr", "123.45", "500", "1", "0", "2.5",
> "10.00", "5", "2", "('Small,Medium,XSmall')",
> "('teal_E2725B,black_FF,yellow_9ACD32')");
>
> mysql> select sizes from products;
> ++
> | sizes |
> ++
> | Medium |
> ++
>
> 1 row in set (0.00 sec)
>
> mysql> select colorsShadesNumbersShort from products;
> +--+
> | colorsShadesNumbersShort |
> +--+
> | black_FF |
> +--+
>
> 1 row in set (0.00 sec)
>
>
> It only entered one of each!! Please help.
> V
>
Re: Another Inserting Multiple Values with Set Problem
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
www.mafiree.com
On Fri, Jan 8, 2010 at 12:26 PM, Victor Subervi wrote:
> OK, guys, I'm totally confused:
>
> mysql> insert into products (SKU, Category, Name, Title, Description,
> Price,
> SortFactor, Availability, OutOfStock, Weight, ShipFlatFee,
> ShipPercentPrice,
> ShipPercentWeight, sizes, colorsShadesNumbersShort) values ("prodSKU1",
> "prodCat1", "name1", "title1", "descr", "12.34", "500", "1", "0", "2.5",
> "10", "5", "2", "('Small, Medium, XSmall')", "('teal_E2725B, black_FF,
> olive_6B8E23, yellow_9ACD32')");
> Query OK, 1 row affected, 2 warnings (0.00 sec)
>
> mysql> show warnings;
>
> +-+--+---+
> | Level | Code |
> Message |
>
> +-+--+---+
> | Warning | 1265 | Data truncated for column 'sizes' at row
> 1|
> | Warning | 1265 | Data truncated for column 'colorsShadesNumbersShort' at
> row 1 |
>
> +-+--+---+
> 2 rows in set (0.00 sec)
>
> mysql> truncate products;
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> insert into products (SKU, Category, Name, Title, Description,
> Price,
> SortFactor, Availability, OutOfStock, Weight, ShipFlatFee,
> ShipPercentPrice,
> ShipPercentWeight, sizes, colorsShadesNumbersShort) values ("prodSKU1",
> "prodCat1", "name1", "title1", "descr", "12.34", "500", "1", "0", "2.5",
> "10", "5", "2", "('Small', 'Medium', 'XSmall')", "('teal_E2725B',
> 'black_FF', 'olive_6B8E23', 'yellow_9ACD32')");
> Query OK, 1 row affected, 2 warnings (0.00 sec)
>
> mysql> truncate products;
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> insert into products (SKU, Category, Name, Title, Description,
> Price,
> SortFactor, Availability, OutOfStock, Weight, ShipFlatFee,
> ShipPercentPrice,
> ShipPercentWeight, sizes, colorsShadesNumbersShort) values ("prodSKU1",
> "prodCat1", "name1", "title1", "descr", "12.34", "500", "1", "0", "2.5",
> "10", "5", "2", "Small, Medium, XSmall", "teal_E2725B, black_FF,
> olive_6B8E23, yellow_9ACD32");
> Query OK, 1 row affected, 2 warnings (0.00 sec)
>
> mysql> insert into products (sizes, colorsShadesNumbersShort) values
> ('Large, Small','aqua_7FFFD4, fuchsia_FF77FF');
> Query OK, 1 row affected, 6 warnings (0.01 sec)
>
> mysql> show warnings;
>
> +-+--+---+
> | Level | Code |
> Message |
>
> +-+--+---+
> | Warning | 1364 | Field 'SKU' doesn't have a default
> value |
> | Warning | 1364 | Field 'Name' doesn't have a default
> value |
> | Warning | 1364 | Field 'Title' doesn't have a default
> value|
> | Warning | 1364 | Field 'Description' doesn't have a default
> value |
> | Warning | 1265 | Data truncated for column 'sizes' at row
> 1|
> | Warning | 1265 | Data truncated for column 'colorsShadesNumbersShort' at
> row 1 |
>
> +-+--+---+
> 6 rows in set (0.00 sec)
>
> mysql> describe products sizes;
>
> +---+--+--+-+-+---+
> | Field |
> Type | Null
> | Key | Default | Extra |
>
> +---+--+--+-+-+---+
> | siz
