RE: MySQL 3.23.55 is released
Hi, all Does MySQL support Japanese database name and Japanese table name? How to enable it? Thanks and regards Robert -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
get MySQL db size
Hi, all MySQL team How can we get MySQL database size? Robert Li Computer Associates RD Centre Beijing , China Tel:+86 10 6561 1136 ext 852 (O) Fax:+86 10 8529 8979 E-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to know MySQL instance(all daemons) really startup?
Hi, all mysql team As we know, use safe_mysqld or mysql.server we can startup Mysql instance. But how can i know when all the mysqld daemons really startup except use command ps? Thanks in advance. Robert Li Computer Associates - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to restore all databases in one instance?
Hi, all As we know, we can backup all dbs in one instance using mysqldump --alldatabases all_db.sql, so can we restore all of these dbs from all_db.sql in one time? Mysql client program mysql can only restore one database per time---mysql sample_db sample_db.sql. Thanks in advance. Best regards Robert Li Computer Associates RD Centre Beijing , China Tel:+86 10 6561 1136 ext 852 (O) +86 10 6731 1652 (H) Fax:+86 10 8529 8979 E-mail: [EMAIL PROTECTED] -Original Message- From: Sammy Lau [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 29, 2001 6:06 PM To: Li, Robert; [EMAIL PROTECTED] Subject: Re: how to setup Mysql multiple instances http://www.mysql.com/documentation/mysql/bychapter/manual_MySQ L_Database_Adm inistration.html#Multiple_servers - Original Message - From: Li, Robert [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, December 29, 2001 5:58 PM Subject: how to setup Mysql multiple instances Hi,all MySQL teams: First let me wish you all happy new year! Wish Mysql win more victories in DB area. I am a programmer in CA. I know Mysql supports multiple instances. One way is to install different servers, on each server, runs an instance. The other way is to use one server, one installation to run multi instances. Now i can setup the environment in the first way. I want to know how to setup in the second way. Would you pls kindly help me to solve this problem? Thank you very much! Regards Robert Li Computer Associates Programmer, RD Beijing (China) Tel: +86 10 65611136 ext 852 Fax: +86 10 85298979 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
get instance variable
Hi, all MySQL team Here is another question. I want to get individual MySQL instance's variable(like datadir, tmpdir etc) using C API. Is there any function can do this? I know that use mysqladmin and use query show variables can do this. Thanks and regards Robert Li Computer Associates RD Centre Beijing , China Tel:+86 10 6561 1136 ext 852 (O) Fax:+86 10 8529 8979 E-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
get instance variable
Hi, all MySQL team Here is another question. I want to get individual MySQL instance's variable(like datadir, tmpdir etc) using C API. Is there any function can do this? I know that use mysqladmin and use query show variables can do this. Thanks and regards Robert Li Computer Associates RD Centre Beijing , China Tel:+86 10 6561 1136 ext 852 (O) Fax:+86 10 8529 8979 E-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
get instance variable
Hi, all MySQL team Here is another question. I want to get individual MySQL instance's variable(like datadir, tmpdir etc) using C API. Is there any function can do this? I know that use mysqladmin and use query show variables can do this. Thanks and regards Robert Li Computer Associates RD Centre Beijing , China Tel:+86 10 6561 1136 ext 852 (O) Fax:+86 10 8529 8979 E-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Programming with C API question
Hi, all MySQL team Thanks for your former help. Here is another question: As MySQL support multiple instances, each instance will run with different socket file and tcp/unix port number. I want to know when using MySQL client programs like mysqladmin to connect different instances, are both socket file and port number parameter necessary(without any Option file)? For example: we have 2 instances running on one machine Instance West runs with /var/lib/mysql/west.sock and port: 3307 Instance East runs with /var/lib/mysql/east.sock and port: 3308 So if we want to connect to instance East using mysqladmin, is following safety enough (not specify port number)? /usr/bin/mysqladmin -u root -p -S /var/lib/mysql/east.sock status In addition, how about with C API like mysql_real_connect()? Thanks for your help and best wishes Robert Li Computer Associates RD Centre Beijing , China Tel:+86 10 6561 1136 ext 852 (O) +86 10 6731 1652 (H) Fax:+86 10 8529 8979 E-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to setup Mysql multiple instances
Hi,all MySQL teams: First let me wish you all happy new year! Wish Mysql win more victories in DB area. I am a programmer in CA. I know Mysql supports multiple instances. One way is to install different servers, on each server, runs an instance. The other way is to use one server, one installation to run multi instances. Now i can setup the environment in the first way. I want to know how to setup in the second way. Would you pls kindly help me to solve this problem? Thank you very much! Regards Robert Li Computer Associates Programmer, RD Beijing (China) Tel: +86 10 65611136 ext 852 Fax: +86 10 85298979 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: how to setup Mysql multiple instances
Thanks for your reply. I have read the mysql manual, but i can only found how to setup multiple servers not multiple instances in one server. BTW, can you tell me can different mysql instances share one dictionary --mysql database? Thanks. Robert Li Computer Associates Programmer, RD Beijing (China) Tel: +86 10 65611136 ext 852 Fax: +86 10 85298979 [EMAIL PROTECTED] -Original Message- From: Sammy Lau [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 29, 2001 6:06 PM To: Li, Robert; [EMAIL PROTECTED] Subject: Re: how to setup Mysql multiple instances http://www.mysql.com/documentation/mysql/bychapter/manual_MySQ L_Database_Adm inistration.html#Multiple_servers - Original Message - From: Li, Robert [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, December 29, 2001 5:58 PM Subject: how to setup Mysql multiple instances Hi,all MySQL teams: First let me wish you all happy new year! Wish Mysql win more victories in DB area. I am a programmer in CA. I know Mysql supports multiple instances. One way is to install different servers, on each server, runs an instance. The other way is to use one server, one installation to run multi instances. Now i can setup the environment in the first way. I want to know how to setup in the second way. Would you pls kindly help me to solve this problem? Thank you very much! Regards Robert Li Computer Associates Programmer, RD Beijing (China) Tel: +86 10 65611136 ext 852 Fax: +86 10 85298979 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php