MySQL 4.1
Hello, can anyone tell me estimated production release for mysql 4.1? We are now testing it in development enviroment, and it looks like we will be utilizing its variable charsets per table, column etc. :). -- Martin Hudec -- :@: [EMAIL PROTECTED] :w: http://www.corwin.sk :m: +421.907.303.393 In google non est, ergo non est. - unknown IRC operator -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
processlist
Hello all at mysql list, can anyone tell me, please, what kind of format is Time in PROCESSLIST? thanks -- Martin Hudec -- :@: [EMAIL PROTECTED] :w: http://www.corwin.sk :m: +421.907.303.393 In google non est, ergo non est. - unknown IRC operator -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: remote login
Hmmm, what about GRANTs on user 'username@machine_name'? On Thu February 13 2003 18:44, Branko Kaucic wrote: Hi all, I have similar problems as Kris posted on 12/17/2002. I didn't find any solution, so I write this e-mail. If I connect to mysql in console with: mysql -u username -p then everything works fine. MySQL is 3.23.53-max-nt running on WinXP and on the same machine I am trying to connect to database. When I use mysql -u username -p -h 127.0.0.1 it also works fine. But, when I use mysql -u username -p -h XXX.XXX.XXX.XXX then I got message Error 1045: Access denied for user: 'username@machine_name' (Using password: YES) What should I do?? Thanks, Branko sql, mysql -- Martin Hudec === :m:+421 907 303 393 :@:[EMAIL PROTECTED] :w: http://www.corwin.sk In google non est, ergo non est. - unknown IRC operator - 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: Can MySQL work on Windows XP?
I was using Mysql on win XP downloaded from www.mysql.com site. All was working good. Hmmm from that error message I assume you don't have Mysql running...did u start it? Hmm sorry i don't remember right exe file to execute in windows to start mysql...i am working on linux mandrake now :(.. Martin On Thu February 6 2003 17:30, Marg Brazil wrote: Hello, Can anyone tell me if MySQL will work on Windows XP Home Ed.? I have MySQL installed according to the instructions on the CreateASite web page. I tried contacted CreateASite with this description of the problem: The start up looks good: when I use the Run function C:\mysql\bin\mysqld-shareware.exe, the black DOS box comes and goes, but I'm getting this error when using the MySQL test script (See below): Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'localhost' (10061) in c:\usr\htdocs\mysql_test.php on line 7 Couldn't Connect I have followed the instructions for installing IndigoPerl, CreateASite, PHP, and for MySQL on www.createafreewebsite.net/mysql.html. Apache was running well at the time, and the perl and php test scripts were A-OK. Should MySQL show in WindowsXP task manager? I can only see 2 Apache.exe' s and HTMel30.exe. There's no C:\mysql\bin\mysqld-shareware.exe listed. CreateASite response was: I worked with a guy from Germany for 2 days trying to get the mysql package you are using to work on XP. No luck. I should probably put that on the site. I'm not saying you can't get the present package to work. Just saying I didn't on XP. Has anyone in this discussion group had success getting MySQL to work on Windows XP? Thanks! MB MySQL test script: html head titleMySQL Test/title /head body ? $link = mysql_connect(localhost); if (! $link) die (Couldn't Connect); $db_res = mysql_list_dbs($link); $num = mysql_num_rows($db_res); for($x=0;$x $num; $x++) print mysql_tablename( $db_res,$x).br; mysql_close($link); ? /body /html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) sql -- Martin Hudec === :m:+421 907 303 393 :@:[EMAIL PROTECTED] :w: http://www.corwin.sk In google non est, ergo non est. - unknown IRC operator - 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: mysql limitations
Oh yes thank you Jerry this is what i was looking for. Hmmm as far as for maximum number of rows, it can be defined it seems by MAX_ROWS parameter while CREATE TABLE :). Thanks On Fri February 7 2003 14:38, Jerry wrote: http://www.mysql.com/doc/en/Table_size.html More lightly to be file system than dB I think depending on the version. Jerry Apps-RD Cable and Wireless -- Martin Hudec === :m:+421 907 303 393 :@:[EMAIL PROTECTED] :w: http://www.corwin.sk In google non est, ergo non est. - unknown IRC operator - 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
mysql limitations
Hello, I would like to know what are limitations for mysql in number of records, size of records, size of tables etc. Can anyone help me please? -- Martin Hudec === :m:+421 907 303 393 :@:[EMAIL PROTECTED] :w: http://www.corwin.sk In google non est, ergo non est. - unknown IRC operator - 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
phpmyadmin and mysql
Hello MySQL, we have this problem: when using phpmyadmin if we select database to view and we put SQL command to ENTER SQL QUERY/QUERIES TO DATABASE field and submit it, it will display NO SQL QUERYwhat is wrong? please help me...thank you -- Best regards, Martin mail [EMAIL PROTECTED] mobile +421.907.303.393 icq34358414 wwwhttp://www.corwin.sk PGP key fingerprint 21365ca05ecfd8aeb1cf19c838fff033 In those days spirits were brave, the stakes were high, men were real men, women were real women and small furry creatures from Alpha Centauri were real small furry creatures from Alpha Centauri. by Douglas Adams - 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
order results by count of searched expression
Hello mysql, I am trying to figure out sql command for ordering results descending by counts of searched expressions found in result. like this: $search=some; TEXT | COUNTS | - Something has..| 4| Some have..| 3| Some take..| 1| Can anyone help me please? -- Best regards, Martin mail [EMAIL PROTECTED] mobile +421.907.303.393 icq34358414 wwwhttp://www.corwin.sk PGP key fingerprint 21365ca05ecfd8aeb1cf19c838fff033 In those days spirits were brave, the stakes were high, men were real men, women were real women and small furry creatures from Alpha Centauri were real small furry creatures from Alpha Centauri. by Douglas Adams - 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: Unable to Start the Server
Hello Jason, just pasting you something what appeared whiles ago... If you have Redhat, a GLIBC upgrade might have broken your MySQL installation. (Look in the mailing list archives). What happens when you telnet to port 3306 on your Linux database server from the machine Tomcat is running on? You should get a MySQL server answering and waiting for input from the client (which it won't get)If it disconnects right away, you have the GLIBC problem, and you either need to install _our_ binaries for 3.23.53a (preferred), or downgrade your GLIBC. -Mark -- Best regards, Martinmailto:corwin;corwin.sk sql,query - 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
Database sync
Hello Peter, okay :)))so far I understand...buthmmm let me explain I have server of travel agencies records (we need to update this, so it is slave) with stable IPand then bunch of other computers (from these we are updating...so they are all masters) in various travel agencies...but not all of them have stable IP (some joins using dialup...some have stable line)...some girl there updates database...and they may not be on net:). So in this case i have one slave and many masters. solution one: My server (slave) has to periodically check for updateswhen masters have stable IP I can make list of IPs and then connect to each server and take binary update log...and use itbut what can i do when master has dynamic IP? So i discard this solution solution two...better...from my point of view ;): Masters with stable IP will update in period of for example 4 hoursmasters with dynamic IP will update when they are online (girl browsing on chatting sites ;)))that puts the question if there is possible to make remote update (sending binlog from master to slave and automatically updating slave)(but if i understood your previous mail...synchronization (replication) is done automaticaly the question two is what if this master is running Windows 98 with MySQL-win for example? Is that possible to make also in windows? I will try to post this also to mysql list -- Best regards, Martinmailto:corwin;corwin.sk - 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[4]: [PHP-DB] database synchronization
Hello Peter, okay :)))so far I understand...buthmmm let me explain I have server of travel agencies records (we need to update this, so it is slave) with stable IPand then bunch of other computers (from these we are updating...so they are all masters) in various travel agencies...but not all of them have stable IP (some joins using dialup...some have stable line)...some girl there updates database...and they may not be on net:). So in this case i have one slave and many masters. solution one: My server (slave) has to periodically check for updateswhen masters have stable IP I can make list of IPs and then connect to each server and take binary update log...and use itbut what can i do when master has dynamic IP? So i discard this solution solution two...better...from my point of view ;): Masters with stable IP will update in period of for example 4 hoursmasters with dynamic IP will update when they are online (girl browsing on chatting sites ;)))that puts the question if there is possible to make remote update (sending binlog from master to slave and automatically updating slave)(but if i understood your previous mail...synchronization (replication) is done automaticaly the question two is what if this master is running Windows 98 with MySQL-win for example? Is that possible to make also in windows? I will try to post this also to mysql list -- Best regards, Martinmailto:corwin;corwin.sk Tuesday, October 29, 2002, 10:05:00 AM, you wrote: PL Hi PL Replication works continuously when the two databases are in contact with PL each other, unless you specify otherwise. Likewise, if you connect PL periodically, MySql will synchronise the two databases itself. PL With replication, MySql logs everything the master does. When a slave logs PL in (you can have any number of slaves) it checks the master logs to see how PL up to date it is, and 'catches up' with the master. PL Once it is set up correctly you don't need to do anything yourself. PL HTH PL Peter PL --- PL Excellence in internet and open source software PL --- PL Sunmaia PL www.sunmaia.net PL tel. 0121-242-1473 PL --- - 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[6]: [PHP-DB] database synchronization
Hello, see below... -- Best regards, Martinmailto:corwin;corwin.sk Tuesday, October 29, 2002, 10:51:17 AM, you wrote: PL Hi PL If the records are all independant - ie travel agent (TA) A has their own PL records and so does TA B then REPLACE INTO MainDB SELECT * FROM PL Travel_agent_A_DB so the main database is just receiveing updated records PL from the TAs. Yes they are independenteach record has column named originTA where i will put ID of TA which is originator of record PL Travel agent logs in to master php driven site . PL master php driven site logs TA IP PL master php driven site makes connection to TA mysql using IP Looks like i will have to write script which will monitor connection to MySQL port on master php driven site... PL master php driven site gets new/updated records PL master php driven site writes new/updated records to master DB okay understand ;) PL If more than one travel agent can update the same record then you risk PL corrupting the data. If they do not have a live connection to the master PL then the record they update may itself be out of date. The only way I can PL see of doing this is soem system that locks a record for the period that TA PL might take updating it. so on MainDB (our slave server :)i will create database for each partner with designated unique name for ex. Travel_agent_A_DB...here will i put all updated info..or I will put it to mainDBthat risk of corruption is out of talk, because each record will have its id of origin (Travel_agent_A_DB).at least I hope...:) and each travel agent will update only their records(...WHERE idorigin=Travel_agent_A)... I think with this i can forget about that riskthey are updating only their recordsnot anyone else's...in example Travel_agent_A offers Greece in 10 days from 19.6.2003 to 29.6.2003...same destination Travel_agent_B offers Greece in 10 days from 19.6.2003 to 29.6.2003...same destination Travel_agent_A sells out all he can in to this days...but agent_B still has few places ;)) update will work as followsagent_A will update his set of records...setting them all sold outagent_B will update his set of records setting ten places left to be sold PL Perhaps PL TA A login PL TA grab record, mark as locked PL TA B gets 'locked record' message PL TA A updates record and writes back to master PL record marked as not locked Looks good...if my upper solution will not work i will try to use this... - 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
getting name of columns
Hello, How can i extract names of columns from table? I am doing select * from table, then i want to get name of columnsis it possible? -- Best regards, Martin mailto:corwin;corwin.sk for filter - sql and query - 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