RE: Strange behaviour of mysqld after adding/dropping a column
Hello Sinisa, this has nothing to do with services. I have also tried this without creating a service and the result is the same. Normally the services are also stopped automatically when logging of, so I don't understand why I should stop it manually. Also I have tested this constantly by stopping and restarting the service without rebooting the PC (as I described in my bug report), with the same result. So this has nothing to do with services or with rebooting your PC (this was only how I found the bug). In my opinion this is a heavily bug, keeping in mind that restarting mysql after dropping/adding a column messes up your database ! Can you please check this ? Kind regards, Ismaël -Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 4:52 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Strange behaviour of mysqld after adding/dropping a column Cams Ismael writes: * I have indeed installed MySQL as a service. That's why I use 'net stop mysql' and 'net start mysql' to start and stop the MySQL server. * I have done nothing special before rebooting my PC. The problem doesn't seem to lay in rebooting the PC, but in stopping andstarting the MySQL service. Rebooting the PC causes this service to stop and to start. Kind regards, Ismaël Sorry, but this is not reliable enough on any Windows, including W2K. You have to stop a service before re-booting. Only then you will have no problems with MySQL. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - 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: root password
Hi, I'm still stuck. If anyone has time, please take a look at this session I had and any pointers would be great. I just went to mysql.com to search the problem, but no site there..Weird. thanks all, Shawn [root /root]# mysql -u root -p Enter password: ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) - 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: high level: enabling transactions in mysql-max with WebLogic TX datasource?
Hi again, I really think you should walk yourself through the InnoDB user manual at http://www.innodb.com/ibman.html There's a lot of usefull and explanory information in there. For your question: ib_arch and ib_logfileX are the logs that InnoDB uses to track committed transactions and perform recovery in case of an DataBase crash. Having all these files in the same directory is kinde messy, maybe you wanne use a config file like the one at the bottom of my reply. The kind of logging you need is the one indicated by the log parameter in the config file. The binary logging that we use is only usefull if you want to be able to do recovery for certain time spans. Also you can start your server manually at the command prompt with c:\yourmysqldir\bin\mysqld-max-nt --console This way you will be able to see any (error) messages directly in the console ... Have fun, I know I did ;) CB. = # The MySQL server [mysqld] # Activate binary logging for MySQL log-bin=C:/mysql/binlogs/localhost-bin # Only binary log queries for table TW binlog-do-db=tw # Prevent those stupid lower case table names when importing/exporting dumps set-variable = lower_case_table_names=0 # InnoDB logging file # log=log.txt # Default table type for new tables default-table-type=InnoDB # BDB home - mysqld-max will not start without this parameter # and the directory must exist bdb-home=../bdbhome # Data home dir of your InnoDB tables innodb_data_home_dir = c:\mysql\ibdata #Data files must be able to #hold your data and indexes innodb_data_file_path = ibdata1:500M #Set buffer pool size to 50 - 80 % #of your computer's memory set-variable = innodb_buffer_pool_size=200M set-variable = innodb_additional_mem_pool_size=15M # Logging innodb_log_group_home_dir = c:\mysql\iblogs #.._log_arch_dir must be the same #as .._log_group_home_dir innodb_log_arch_dir = c:\mysql\iblogs innodb_log_archive=0 set-variable = innodb_log_files_in_group=3 #Set the log file size to about #15 % of the buffer pool size set-variable = innodb_log_file_size=25M set-variable = innodb_log_buffer_size=10M #Set ..flush_log_at_trx_commit to #0 if you can afford losing #a few last transactions innodb_flush_log_at_trx_commit=1 set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 == -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 23:14 To: [EMAIL PROTECTED] Subject: Re: high level: enabling transactions in mysql-max with WebLogic TX datasource? Bert == Bert VdB [EMAIL PROTECTED] writes: Bert Hi, Bert all you have to do use a transaction enabled data-source and use the Bert Mm-MysqlDriver Bert for your JDBC connections. (http://mmmysql.sourceforge.net/) Bert Best is to read the InnoDB documentation carefully (http://www.innodb.com), Bert as you cannot choose from a wide Bert variety of transaction-levels ... in my experience, most of the detailed Bert transaction-handling Bert can only be done at mysql-query level. Bert To test wether your datasource supports the transactions, do a test and look Bert at the InnoDB-logfiles, it should Bert indicate some thing like SET AUTOCOMMIT=0 and COMMIT. Ok, I determined that innodb wasn't being initialized because I didn't have innodb_data_file_path set in my.ini. I added the following line to my.ini in mysqladmin: innodb_data_file_path = ibdata1:30M:autoextend After I restarted the service and created some tables (not adding any rows yet), I noticed the following files in the data subdirectory: --- total 41004 drwxr-xr-x2 dmkarr None 8192 Jul 1 15:01 mysql/ -rw-r--r--1 dmkarr None 2461 Jul 1 14:59 mysql.err -rw-r--r--1 dmkarr None 5242880 Jul 1 14:59 ib_logfile0 -rw-r--r--1 dmkarr None 31457280 Jul 1 14:59 ibdata1 drwxr-xr-x4 dmkarr None 4096 Jul 1 14:59 ./ -rw-r--r--1 dmkarr None25088 Jul 1 14:59 ib_arch_log_00 -rw-r--r--1 dmkarr None 5242880 Jul 1 14:59 ib_logfile1 drwxr-xr-x 11 dmkarr None 4096 Jun 29 11:30 ../ drwxr-xr-x2 dmkarr None0 Jun 29 11:07 test/ --- However, I don't know how to check the log files for those strings, as they appear to be binary. A simple grep didn't find anything. Is there a special viewer for mysql log files? --
database permission
Hi all, I have a problem about the access permission of mysql. I found that the mysql client will be denied by the mysql server even I have granted the permission already. The mysql client has already run and can connect to the mysql server before... I am not sure what the problem is and so I just run flush privileges again and everything work fine after that. I have repeated this action several times I tried to use myisamchk to check the mysql database or even delete and recreate it again But the problem still exist after I run the mysql server for a period of time... the mysql client will be denied to connect the server again... Did anyone faced that problem before?? Can anyone please give me some advices about that?? Many thanks. Kaming. - 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
compiling 4.0.2
Anyone know what this syntax error is about? trying to compile the 4.0.2 on a freebsd server... Making all in sql gmake[2]: Entering directory `/usr/home/oblo/xfer/mysql-4.0.2/sql' byacc -d sql_yacc.yy mv y.tab.c sql_yacc.cc byacc: e - line 75 of sql_yacc.yy, syntax error %pure_parser/* We have threads */ ^ gmake[2]: *** [sql_yacc.cc] Error 1 gmake[2]: Leaving directory `/usr/home/oblo/xfer/mysql-4.0.2/sql' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/usr/home/oblo/xfer/mysql-4.0.2' gmake: *** [all-recursive-am] Error 2 - 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_real_query, insert floats as binary
* Dave Beck [...] charinsert_format[] = INSERT INTO %s VALUES (%hhd%hhd%hhd%hhd, %hhd%hhd%hhd%hhd, %hhd%hhd%hhd%hhd, %hhd%hhd%hhd%hhd,%hhd%hhd%hhd%hhd); The values should be quoted... int build_real_insert(char *query, char *table, int frame, int atom, float x, float y, float z) { unsigned char *fbp = (unsigned char *)frame; unsigned char *abp = (unsigned char *)atom; unsigned char *xbp = (unsigned char *)x; unsigned char *ybp = (unsigned char *)y; unsigned char *zbp = (unsigned char *)z; return sprintf(query, insert_format, table, fbp[0], fbp[1], fbp[2], fbp[3], abp[0], abp[1], abp[2], abp[3], xbp[0], xbp[1], xbp[2], xbp[3], ybp[0], ybp[1], ybp[2], ybp[3], zbp[0], zbp[1], zbp[2], zbp[3]); } ...and some bytes may represent an 'illegal' character, and thus must be escaped by a backslash... this goes for the quote character you use ( or '), the backslash character itself, and null bytes. -- Roger sql - 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
AW: AW: mysql wont start on SUSE
I noticed that my Server works with [mysql] user = root and than start with mysqld but when I tried to start with the runlevel editor it doesn't works. Perhaps a other Person in this list no the answer? The mysql_install_db create two folders in the var/lib/mysql pfad. The folder are mysql and test. In mysql are the table definitions for passwords etc. If I solve the problem I will write you an Email John -Ursprungliche Nachricht- Von: Jacques Steyn [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 1. Juli 2002 18:54 An: John Macloy Betreff: Re: AW: mysql wont start on SUSE Thanks John I've added that line, but no luck. Yes, I've done the mysql_install_db, which worked OK. I am baffled. Stupid question: mysql_install_db is run only once to set up default DBs??? Jacques John Macloy wrote: Yes, I have go to my.cnf and write [mysqld] user=root then start the server with mysqld. This works on my computer, but I'm not sure if the right way cause the the server shouldn't use with the user root but for a test it's ok. Have you already started the script mysql_install_db? It's necessary. Macloy -Ursprungliche Nachricht- Von: Jacques Steyn [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 1. Juli 2002 15:28 An: Alexander Barkov Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Betreff: mysql wont start on SUSE Anybody had a problem with MySQL that does not start on SUSE 8 with default installation? If yes, what was the problem? Thanks Jacques ___ Jacques Steyn +27 (0)11 478-1259 http://www.knowsystems.com - 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 -- ___ Dr Jacques Steyn +27 (0)11 478-1259 http://www.knowsystems.com - 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: fulltext searching
I've never gotten the boolean features to work with version 4.0.1-alpha of MySQL. Also the database will crash with some queries where some of the search words are the same as words in the stopword list (myisam/ft_static.c in the sourcecode) Download the 4.0.2 source and compile it. Things seem to work a lot better with the 4.0.2. And it won't crash with special combinations of words :) Erlend Stromsvik -Original Message- From: Marko Djukic [mailto:[EMAIL PROTECTED]] Sent: 1. juli 2002 12:43 To: [EMAIL PROTECTED] Subject: Re: fulltext searching hi all... i can't seem to get the fulltext searching working perfectly... single search terms it works fine, multiple search terms it also seems to be ok - finding records with any of the search terms. however, if i try the boolean mode it gives out garbage all the time. i try for example an sql query like this: select * from mytable where match(file_text) against('+findthis +andthis -notthis' in boolean mode); various variants of this never find the records, or find ALL the records in the database... when such filters should throw out a couple of records at least. i'm running mysql 4.0.1-alpha on freebsd... and i've set up the tables for fulltext indexes. is this still heavy work-in-progress or should it work? does it work for anyone? thanks, marko - 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
Re: compiling 4.0.2
ok it worked... had to that setenv and in addition do a ./configure --with-low-memory... running 4.0.2!!! :) thanks! m. Quoting Lenz Grimmer [EMAIL PROTECTED]: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 02 July 2002 10:35, Marko Djukic wrote: ok thanks. trying that now... i just set the env: YACC='/usr/local/bison/bin/bison y' correct? Yes, I would think so. Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE9IWkASVDhKrJykfIRAvIYAJ4+Ziaj4opPtjQGzhTYCX410C3G+wCfejCp PyK/Lr8Hncx8QecVSkMpJWk= =ET6p -END PGP SIGNATURE- - 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 do we make this query work in 3.23.51
Hi I had written a query which executes in MySql 4.0.1 But this is not working in 3.23.51 coz i had used Union function in the query which is not supported by 3.23.51 So any idea how this can be made to work on 3.23.51. I need to have only one Column in the result as TYPENAME SELECT CT.Company_Type as TYPENAME FROM RFQ_Details RD, Company_Type CT WHERE RD.RFQID = 4 AND RD.SEARCH_Type = 'COMPANY' AND Company_TypeID = RD.TypeID UNION SELECT UT.USER_Type as TYPENAME FROM RFQ_Details RD, User_Type UT WHERE RD.RFQID = 4 AND RD.SEARCH_Type = 'USER' AND User_TypeID = RD.TypeID - 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: looking for sql gui application
Hi, the latest version of mysql supports ssl connections. 'phpMyAdmin' is a browser based gui written in php. If your apache has mod_ssl then you could connect securely. http://www.phpwizard.net/projects/phpMyAdmin/ Alternatively, you could also use something like 'mysqlgui' and set up ssh port forwarding. I would like to offer hyperlinks but i cannot fot the life of me get onto the mysql web site at the moment! cheers Rich Roma Gupta wrote: Hi Everybody, My organization is looking for some secure GUI tool for MYSql. If possible, something which use SSH. I am new to MySql. Can anybody highlight on this and suggest some tools. We use lynix with apache, tomcat installed on it and installed ver 3.23 of Mysql. Thanks in advance Roma - 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
Re: fulltext searching
Is there a tutorial or step-by-step introduction to fulltext searches with MySQL somewhere? Regards, Eivind :-o 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
Re: fulltext searching
section 6.8 in the manual i think... Quoting Eivind A. Sivertsen [EMAIL PROTECTED]: Is there a tutorial or step-by-step introduction to fulltext searches with MySQL somewhere? Regards, Eivind :-o 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
AW: How do we make this query work in 3.23.51
Hi Arul, maybe copying the columns into a temporary table might do the job. I don't know how big your tables are, if performance might be a problem. The following statements should create the query you wanted: /*creating temporary table*/ CREATE TABLE tmp_Information ( TYPENAME (any typ-definition varchar,int???) ); /*inserting rows for company information*/ INSERT INTO tmp_Information SELECT CT.Company_Type as TYPENAME FROM RFQ_Details RD, Company_Type CT WHERE RD.RFQID = 4 AND RD.SEARCH_Type = 'COMPANY' AND Company_TypeID = RD.TypeID; /*inserting rows for user information*/ INSERT INTO tmp_Information SELECT UT.USER_Type as TYPENAME FROMRFQ_Details RD, User_Type UT WHERE RD.RFQID = 4 AND RD.SEARCH_Type = 'USER' AND User_TypeID = RD.TypeID; /*do whatever you want with the rows of the union*/ SELECT TYPENAME FROM tmp_Information; /*erase the temporary table*/ DROP TABLE tmp_Information Hopes that helps. Take care Andreas -Ursprüngliche Nachricht- Von: Arul [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 2. Juli 2002 11:04 An: MySQL Betreff: How do we make this query work in 3.23.51 Hi I had written a query which executes in MySql 4.0.1 But this is not working in 3.23.51 coz i had used Union function in the query which is not supported by 3.23.51 So any idea how this can be made to work on 3.23.51. I need to have only one Column in the result as TYPENAME SELECT CT.Company_Type as TYPENAME FROM RFQ_Details RD, Company_Type CT WHERE RD.RFQID = 4 AND RD.SEARCH_Type = 'COMPANY' AND Company_TypeID = RD.TypeID UNION SELECT UT.USER_Type as TYPENAME FROM RFQ_Details RD, User_Type UT WHERE RD.RFQID = 4 AND RD.SEARCH_Type = 'USER' AND User_TypeID = RD.TypeID - 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: fulltext searching
Hi If anybody from mysql is listening / watching, www.mysql.com is down, and has been for a while. Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- - 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.com site down
I'm in the UK and I can get to it okay !!! Perhaps something has changed on your PC/Network ??? -Original Message- From: Peter Lovatt [mailto:[EMAIL PROTECTED]] Sent: 02 July 2002 10:45 To: [EMAIL PROTECTED] Subject: RE: fulltext searching Hi If anybody from mysql is listening / watching, www.mysql.com is down, and has been for a while. Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- - 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
Re: fulltext searching
section 6.8 in the manual i think... Hmm, no; that's about the access privilege system... I found it in section 24.2, but I feel this topic has gotten a bit scarce mention in the manual. Perhaps it deserves more than that...? I sure would appreciate something extra :-) Best regards, Eivind 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
Re: Re: fulltext searching
Eivind, Tuesday, July 02, 2002, 12:22:33 PM, you wrote: EAS Is there a tutorial or step-by-step introduction to fulltext searches with EAS MySQL somewhere? Sure. In the MySQL manual: http://www.mysql.com/doc/F/u/Fulltext_Search.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: innodb @ windows xp
Hytham, Tuesday, July 02, 2002, 1:54:32 AM, you wrote: HS i have installed mysql v 3.23.44-nt on my XP using *Binary* HS distribution, how can i now develop an InnoDB tables? You must specify InnoDB startup options in the my.cnf/my.ini file: http://www.mysql.com/doc/I/n/InnoDB_start.html To check if InnoDB is supported use command SHOW VARIABLES LIKE have%; have_innodb must be YES -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
Nigel, Monday, July 01, 2002, 6:32:53 PM, you wrote: NG I've tried to get MySQL to install and run from source. NG I configured and compiled without any errors. However when trying to start NG the service i get the following: NG ERROR 2002: Can't connect to local MySQL server through socket NG '/tmp/mysql.sock' (2) NG Can anyone help me please? I'm running SuSE Enterprise 7.3 Is your MySQL server running? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: database permission
Kaming, Tuesday, July 02, 2002, 10:00:00 AM, you wrote: K I have a problem about the access permission of mysql. I found that the K mysql client will be denied by the mysql server even I have granted the K permission already. The mysql client has already run and can connect to K the mysql server before... I am not sure what the problem is and so I K just run flush privileges again and everything work fine after that. I K have repeated this action several times I tried to use myisamchk to K check the mysql database or even delete and recreate it again But K the problem still exist after I run the mysql server for a period of K time... the mysql client will be denied to connect the server again... K Did anyone faced that problem before?? Can anyone please give me some K advices about that?? You gave not complete info... How did you set up permissions? (using GRANT statement or manually). What is your MySQL server version? What OS do you use? What are the permissions for your user? Is there any conflict entries in the privilege tables? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: Re: root password
Page, Tuesday, July 02, 2002, 9:23:16 AM, you wrote: PWWSI'm still stuck. If anyone has time, please take a look at this session PWWS I had and any pointers would be great. I just went to mysql.com to search PWWS the problem, but no site there..Weird. http://www.mysql.com/doc/A/c/Access_denied.html PWWS thanks all, PWWS Shawn PWWS [root /root]# mysql -u root -p PWWS Enter password: PWWS ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) Did you set up password for user 'root' after installation? If so, seems, entered password is not correct. If no, remove -p option. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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.com site down
On Tue, 2 Jul 2002, Darley, Terry wrote: I'm in the UK and I can get to it okay !!! Perhaps something has changed on your PC/Network ??? I've had problems reaching the MySQL web site too. I think it's to do with the fact I'm connecting through a UK academic site which relies in ebone for European connectivity. ebone have gone bust I think ... Andy -Original Message- From: Peter Lovatt [mailto:[EMAIL PROTECTED]] Sent: 02 July 2002 10:45 To: [EMAIL PROTECTED] Subject: RE: fulltext searching Hi If anybody from mysql is listening / watching, www.mysql.com is down, and has been for a while. Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- - 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
RE: Load problems with 3.23.51
Just an update: I installed a new fresh version of RedHat 7.3 (smp Athlon) and a new copy of MySQL 3.23.51, but the problem remains. Sincerely, Steven Roussey http://Network54.com/?pp=e - 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: fulltext searching
there's not a huge lot more to cover than what is in the manual... what exactly are you looking for? m. Quoting Eivind A. Sivertsen [EMAIL PROTECTED]: section 6.8 in the manual i think... Hmm, no; that's about the access privilege system... I found it in section 24.2, but I feel this topic has gotten a bit scarce mention in the manual. Perhaps it deserves more than that...? I sure would appreciate something extra :-) Best regards, Eivind 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
Re: fulltext searching
plus are you sure you're reading the latest manual? it is chapter 6.8. try this (google cache of the mysql.com/doc since mysql.com seems to be down): http://www.google.com/search?q=cache:yvsB86pbs5cC:www.mysql.com/doc/F/u/Fulltext_Search.html+full+text+mysqlhl=enie=UTF-8 ciao, m. Quoting Eivind A. Sivertsen [EMAIL PROTECTED]: section 6.8 in the manual i think... Hmm, no; that's about the access privilege system... I found it in section 24.2, but I feel this topic has gotten a bit scarce mention in the manual. Perhaps it deserves more than that...? I sure would appreciate something extra :-) Best regards, Eivind 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
Re: MySQL
Nigel, check that you are starting the mysqld properly. if you compiled it you may have selected different options with your ./configure, for example a different data directory location, so if you use the older start command it may be failing to start... that caught me out 30mins ago.. m. Quoting Egor Egorov [EMAIL PROTECTED]: Nigel, Monday, July 01, 2002, 6:32:53 PM, you wrote: NG I've tried to get MySQL to install and run from source. NG I configured and compiled without any errors. However when trying to start NG the service i get the following: NG ERROR 2002: Can't connect to local MySQL server through socket NG '/tmp/mysql.sock' (2) NG Can anyone help me please? I'm running SuSE Enterprise 7.3 Is your MySQL server running? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
Author of windows binary distribution
Hello, can you send me a conntact (e-mail) to author of windows binary distribution of mySQL server, please? I have one question to him (about charset conversion in czech language, specially in windows distribution)... Thank you very much! Tom Planka - 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 do we make this query work in 3.23.51
Yea Andreas I had that idea but i thought that would be a performance issue... So i thought of avoiding this temp table... I am looking into an option where i can do it in 1 single query... -Arul - Original Message - From: Oswald, Andreas [EMAIL PROTECTED] To: 'Arul' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 3:09 PM Subject: AW: How do we make this query work in 3.23.51 Hi Arul, maybe copying the columns into a temporary table might do the job. I don't know how big your tables are, if performance might be a problem. The following statements should create the query you wanted: /*creating temporary table*/ CREATE TABLE tmp_Information ( TYPENAME (any typ-definition varchar,int???) ); /*inserting rows for company information*/ INSERT INTO tmp_Information SELECT CT.Company_Type as TYPENAME FROM RFQ_Details RD, Company_Type CT WHERE RD.RFQID = 4 AND RD.SEARCH_Type = 'COMPANY' AND Company_TypeID = RD.TypeID; /*inserting rows for user information*/ INSERT INTO tmp_Information SELECT UT.USER_Type as TYPENAME FROMRFQ_Details RD, User_Type UT WHERE RD.RFQID = 4 AND RD.SEARCH_Type = 'USER' AND User_TypeID = RD.TypeID; /*do whatever you want with the rows of the union*/ SELECT TYPENAME FROM tmp_Information; /*erase the temporary table*/ DROP TABLE tmp_Information Hopes that helps. Take care Andreas -Ursprüngliche Nachricht- Von: Arul [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 2. Juli 2002 11:04 An: MySQL Betreff: How do we make this query work in 3.23.51 Hi I had written a query which executes in MySql 4.0.1 But this is not working in 3.23.51 coz i had used Union function in the query which is not supported by 3.23.51 So any idea how this can be made to work on 3.23.51. I need to have only one Column in the result as TYPENAME SELECT CT.Company_Type as TYPENAME FROM RFQ_Details RD, Company_Type CT WHERE RD.RFQID = 4 AND RD.SEARCH_Type = 'COMPANY' AND Company_TypeID = RD.TypeID UNION SELECT UT.USER_Type as TYPENAME FROM RFQ_Details RD, User_Type UT WHERE RD.RFQID = 4 AND RD.SEARCH_Type = 'USER' AND User_TypeID = RD.TypeID - 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
Re: blob versus file
Op maandag 1 juli 2002 14:18, schreef andy: Hi there, I am wondering if anybody has experiance in saving images to blob in mysql. I do save images with 1 K and 4 KB to blob fields while I used to save them to file. It seams to me that this is much slower accessing the files. The images take a bit (really short but absolutly noticable) to show up on the site. Is there a way to improve the performance, and why is this happening? I thought the performance might even boost after storing them to blobs. Thank you for any comments on that, Andy From the faq on http://www.bitbybit.dk/mysqlfaq/comments.html#ch7_2_0 Storing images and other binary data Many people ask how to store and retrieve images and other binary data in the database. The question usually pops up along with a statement a la how do I retrrieve and show an image on a web page? There are several reasons why you should consider not storing binary data in your database: * The whole point of storing stuff in a SQL database, is to put some kind of ordering and structure on your data, as well as being able to search on these data. But how do you search in the binary data of your picture? * For large data sets, storing binary data will quickly run up the size of your database files, making it harder to control the size of the database. * In order to store binary data in the database, you must continually escape and unescape the data to ensure that nothing breaks. You probably have several reasons why you would want to store your images in your database, despite all the statements above. Others have, before you. And they have all returned to the same solution: Store a link (e.g. a file path) to the image file in the database. Whenever you need the image, use the link in whatever program you use to retrieve the file containing the image. Besides keeping your sanity, you will often find that things work faster this way: You have less data to transfer between your application and MySQL, you don't need to worry about escaping funny characters. And especially for serving HTML pages, you're helping your server decide which data to keep cached for faster client retrieval. There is one good reason why you might want to store the binary data in the database: Replication. If you need to ensure that the binary data is available on several MySQL hosts, using replication might save your day. That said, you should always keep the statements above in mind. HTH Ray - 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: fulltext searching / BUG report
On Tue, 2 Jul 2002, Erlend Hopsø Strømsvik wrote: Download the 4.0.2 source and compile it. Things seem to work a lot better with the 4.0.2. And it won't crash with special combinations of words :) Hi, Some things with BOOLEAN MODE seem still broken. Especially the '*' jokers. I have 4.0.2 taken from the source tree yesterday. I'm querying against a table with 14579 documents containing 187621564 bytes of data and a fulltext index. Table structure is: CREATE TABLE `plaintext` ( `id` int(11) NOT NULL auto_increment, `doc` varchar(16) NOT NULL default '', `code` int(10) unsigned NOT NULL default '0', `part` tinyint(4) NOT NULL default '0', `bgetxt` text, PRIMARY KEY (`id`), KEY `doc` (`doc`), KEY `code` (`code`), FULLTEXT KEY `bgetxt` (`bgetxt`) ) TYPE=MyISAM Bug example: select doc from plaintext \ where match(bgetxt) against ('integrität'); yields: 171 rows in set (0.02 sec) and: SELECT doc FROM plaintext \ WHERE MATCH(BGETXT) AGAINST ('integrität adäquanz'); yields: 198 rows in set (0.02 sec) 6 of these rows contain both words: SELECT doc FROM plaintext \ WHERE MATCH(BGETXT) AGAINST ('+integrität +adäquanz' IN BOOLEAN MODE); yields: +---+ | doc | +---+ | 112 V 30 | | 115 V 133 | | 117 V 359 | | 117 V 369 | | 118 V 286 | | 119 V 335 | +---+ 6 rows in set (0.01 sec) but now look at this: There are lots of possible endings for my search words: integrität integritätsschaden adäquat adäquanz adäquate ... (many more) SELECT doc FROM plaintext \ WHERE MATCH (bgetxt) AGAINST ('integr*' IN BOOLEAN MODE); gives: 997 rows in set (0.11 sec) this looks is still good! Many additional hits are found. Therefore I do: SELECT doc FROM plaintext \ WHERE MATCH (bgetxt) AGAINST ('integr* adäqu*' IN BOOLEAN MODE); and I get: +--+ | doc | +--+ | 117 V 71 | +--+ 1 row in set (2.46 sec) The text which has been found contains text beginning with: quote-- 10. Urteil vom 11. Januar 1991 i.S. X gegen Bundesamt für Militärversicherung und Versicherungsgericht des Kantons Solothurn Regeste Art. 23 Abs. 1 und Art. 25 Abs. 1 MVG: Bemessung des Integritätsschadens und Beginn der Integritätsrente. - Bemessung des Integritätsschadens (Zusammenfassung der Rechtsprechung; Erw. 3a). - Die Beeinträchtigung der Integrität bemisst sich an den Folgen, welche die geschädigte Gesundheit auf primäre Lebensfunktionen hat (Erw. 3a/bb/aaa). - Der Integritätsschadensgrad kann 60% übersteigen, richtet sich jedoch weder direkt noch analogieweise nach den Ansätzen gemäss Anhang 3 zur UVV (Bestätigung der Rechtsprechung; Erw. 3c/aa). - Bemessung des Integritätsschadens bei mehreren körperlichen snip -unquote--- Conclusion: combinations of 2 words with asterisk joker IN BOOLEAN MODE do not work. Thomas Spahni -- 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
Re: fulltext searching
plus are you sure you're reading the latest manual? it is chapter 6.8. The location was correct for the onlien manual. I first tried my stored PDf version, since I could not reach http://www.mysql.com There, it was section 24.2. Now I printed then online section 6.8 and will go through it. My intention is to find out whether it would be feasible to try and build full-text search on my website. Thanks for your help! Eivind :-) - 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: Strange behaviour of mysqld after adding/dropping a column
Cams Ismael writes: Hello Sinisa, this has nothing to do with services. I have also tried this without creating a service and the result is the same. Normally the services are also stopped automatically when logging of, so I don't understand why I should stop it manually. Also I have tested this constantly by stopping and restarting the service without rebooting the PC (as I described in my bug report), with the same result. So this has nothing to do with services or with rebooting your PC (this was only how I found the bug). In my opinion this is a heavily bug, keeping in mind that restarting mysql after dropping/adding a column messes up your database ! Can you please check this ? Kind regards, Ismaël Yes, it looks like a bug. We shall inspect that. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - 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: blob versus file
There are several reasons why you should consider not storing binary data in your database: [snip] You probably have several reasons why you would want to store your images in your database, despite all the statements above. Others have, before you. And they have all returned to the same solution: Store a link (e.g. a file path) to the image file in the database. Whenever you need the image, use the link in whatever program you use to retrieve the file containing the image. Yes, but, this advice does *not* go on to describe how you cope with the deletion problem. If you store data in records in the database a DELETE will delete *all* the data for the set of rows. If some of the data is lying around in disk files these obviously don't get deleted by DELETE. So it seems to me that you need an image file garbage collection process, which every now and then scans the disk, scans the database and deletes disk files which no longer have a pointer to them from any reference field in any row in any table in the database. And of course as the file store and the database could both be changing under your feet whilst you're doing this it seems to be a good idea to shut down, or lock, the database server and the processes you've got adding disk files whilst you're doing the garbage collection. Doesn't sound to clever to me. Yes of course you could make your business logic layer clever enough to have a go at deleting the files when it deletes the database rows. But as you don't have transactions covering database operations *and* file system operations things will get out of step sooner or later so you'll still need the garbage collector. And some hints as to the viability of, say, hundreds of thousands of operating system files on the various platforms supported by MySQL would be helpful. For example many filing systems will lose *lots* of space through fragmentation like this, which one might hope would not happen with blobs. And what about the performance implications of lots of files in the same directory? - NT4 for example *will* handle half a million files in the same directory, 'cos I've tried it, but it's not terribly practical as some operations start taking tens of minutes instead of tens of milliseconds. Really one of the reasons for using a DBMS is to handle all this storage management crap for you, no? Tim Ward Brett Ward Limited - www.brettward.co.uk --- On August 5th ip.access will be moving to: CPC1 Telephone: +44 (0) 1223 219000 Capital Park Fax: +44 (0) 1223 219099 Fulbourn Cambridge CB1 5XE United Kingdom --- This e-mail and the information it contains are confidential and may be privileged. If you have received this e-mail in error please notify us immediately. You should not copy it for any purpose, or disclose its contents to any other person. All emails to and from ip.access may be monitored and stored for audit and other legal reasons. --- - 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: redudancy / high availability
On Mon, 2002-07-01 at 22:23, Jeremy Zawodny wrote: On Mon, Jul 01, 2002 at 06:24:45PM +0200, Mathieu DESPRIEE - NO SPAM wrote: Hi all, I want to setup (on linux systems) a pair of redundant mysql servers, working this way : * one master and one backup * the master handles all the requests, the backup updates its data frequently (and, if possible, CONSISTENTLY) from the master * on failure of the master, the backup comes and handles all the requests, as if it was the master. * when the master server comes back, it updates itself from the backup, and then restarts to work normally I think the slave/master system of MySQL is not sufficient (the master does not updates itself after coming back). What if you use a dual-master setup? Jeremy -- Does anybody have some documentation about dual-master setup ? Is there any limitation to mysql features due to dual-master system ? Mathieu - 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
InnoDB RAW devices under Solaris?
All: I am re-posting this in case someone may have an answer. RE: MySQL 4.01-max, InnoDB, Solaris, Raw device support Has anyone had any specific experience implementing a RAW DEVICE InnoDB tablespace under Sparc Solaris? A specific few lines in my.cnf would be very helpful... As we are using a SparcStorage Array, our device pathnames look something like: Innodb_data_file_path=/dev/rdsk/c1t4d0s7:1Gnewraw (OR) Innodb_data_file_path=/dev/dsk/c1t4d0s7:1Gnewraw Either of these options gives us an operating system error number 2 ... -- I have also tried things like: innodb_data_home_dir = /dev/ innodb_data_file_path = rdsk/c1t4d0s7:1Gnewraw Also with no luck. Are there specific Solaris slices we should be using?? Can't find any docs on this. Please note: using 'standard filesystem' InnoDB filespaces, everyting works AOK under this installation... Any help is appreciated. Lou - 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 On Solaris
Hi All Can anyone refer me to any document which speaks about Installing MySQL 3.23.51 on Solaris 2.8 Sparc -Arul 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
Re: MySQL On Solaris
The Document at www.mysql.com/manual is not clear for a Mysql beginner like me... Any Step by Step procedure... What should i do with the downloaded tar file .. I Had installed MySql in Windows.. But installing it in Solaris is not clear... -Arul - Original Message - From: Arul [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 6:43 PM Subject: MySQL On Solaris Hi All Can anyone refer me to any document which speaks about Installing MySQL 3.23.51 on Solaris 2.8 Sparc -Arul 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 - 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
Fiddling with myisam/ft_static.c
Hi, I am indexing texts in German, French or Italian language. I want to add words from these languages to the stopword list and need some more guidance: - case doesn't matter, right? - what should I do with words containing non ascii characters 'äöüéàè' ? Enter as is? - is there any performance issue when the list grows long? Any insight is appreciated Thomas Spahni -- 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
Re: fulltext searching / BUG report
Hi! On Jul 02, Thomas Spahni wrote: On Tue, 2 Jul 2002, Erlend Hops? Str?msvik wrote: Download the 4.0.2 source and compile it. Things seem to work a lot better with the 4.0.2. And it won't crash with special combinations of words :) Hi, Some things with BOOLEAN MODE seem still broken. Especially the '*' jokers. I have 4.0.2 taken from the source tree yesterday. I'm querying against a table with 14579 documents containing 187621564 bytes of data and a fulltext index. ... SELECT doc FROM plaintext \ WHERE MATCH (bgetxt) AGAINST ('integr* ad?qu*' IN BOOLEAN MODE); Conclusion: combinations of 2 words with asterisk joker IN BOOLEAN MODE do not work. Hmm... According to the mysql-test/t/fulltext.test it DOES work: select * from t1 where MATCH a,b AGAINST (+call* +coll* IN BOOLEAN MODE); I've also tried the same query w/o '+' (to make it similar to yours) - it worked also. Could you try to create a test case for the bug ? Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - 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: Left outer join
Arul, Monday, July 01, 2002, 3:58:48 PM, you wrote: A Can i use left outer join in MySQL. A Like i have one condition in Oracle A ex: A select * from user,company where u.companyid = c.companyid (+) A can i rephrase the query in mysql like this A select * from user left outer join company c using (companyid) In MySQL LEFT OUTER JOIN is a synonym for LEFT JOIN. Syntax for LEFT OUTER JOIN exists for compatibility with ODBC. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: MAX vs plain vanilla mysql
Petre, Monday, July 01, 2002, 9:26:49 AM, you wrote: PA Probably a stupid question, but which is best to have on ones server, PA the old mysql, or max. I.O.W, if you install MAX and never use innodb PA or berkeley tables, will it be equivalent to a normal mysql installation PA wrt performance and stability? PA I'm asking from an ISP's point of view, if that makes any difference ( PA obviously if from developer it will depend on the needs of the app..) MySQL-Max binary is larger. It takes a lot more memory and it is useless without usage of InnoDB and/or BDB. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: procedure analyze()
Jason, Tuesday, July 02, 2002, 1:14:29 AM, you wrote: J I ran this on several of my tables... I expected it to give me reccomendations on how to improve my tables performance... J SELECT * FROM `5323` PROCEDURE ANALYSE() J It returned no results ever am I doing something wrong? Or, is this feature simply not enabled on my system? J Running J MySQL 3.23.44 PROCEDURE ANALYSE() is supported since 3.23.0 .. Are you sure that table `5323` is not empty? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: Help?
Page, Monday, July 01, 2002, 7:48:00 PM, you wrote: PWWSanyone know why this error would come up. This is running on a Linux box PWWS [admin admin]$ scripts/mysql_install_db PWWS bash: scripts/mysql_install_db: No such file or directory Check where is your mysql_install_db located: whereis mysql_install_db -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: MAX vs plain vanilla mysql
Hi! I have to correct: if you put [mysqld] skip-innodb skip-bdb to your my.cnf, then -Max uses only about 1.5 MB more memory than plain MySQL, because of a larger executable. MyISAM tables in -Max are as reliable as in plain MySQL. It is the same source code. Best regards, Heikki Innobase Oy ... Petre, Monday, July 01, 2002, 9:26:49 AM, you wrote: PA Probably a stupid question, but which is best to have on ones server, PA the old mysql, or max. I.O.W, if you install MAX and never use innodb PA or berkeley tables, will it be equivalent to a normal mysql installation PA wrt performance and stability? PA I'm asking from an ISP's point of view, if that makes any difference ( PA obviously if from developer it will depend on the needs of the app..) MySQL-Max binary is larger. It takes a lot more memory and it is useless without usage of InnoDB and/or BDB. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
laptop configuration/replication
Is it practical to use the builtin MySQL replication to have a MySQL server on a laptop that syncs to the LAN Database Master when it is connected? Are there any configuration issues that I should be aware of? - 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
cascading, referential integrity
does mysql 3.23 support cascading and referential integrity or is this only part of 4.01? if so, how do i take advantage of it and where in the documenation (link) can I read about it? thanks, blue - 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
selected records retrieve
Hi to all. I'm new in the list and in mysql as well, so excuse me for anything that sounds novice or in wrong place.I'm facing the following situation: For some reason, i had to use a backup of the database.Because of the difference in time between my backup and the instance i had to use it,i want to retrieve from the database, i no longer use, some records BUT NOT ALL the database.Is there a way to do it?Thank you all in advance. - 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
Privileges
I would like to know what does mean the privilege References_priv on the table users?? Regards Alexander sql, query ___ Yahoo! Encontros O lugar certo para encontrar a sua alma gêmea. http://br.encontros.yahoo.com/ - 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
help me with this query
Hi All I have two tables User and Company User tables has userid , companyid and status Company table has companyid and companyname It's not necessary that all users should have company.There can be users without company also and for them the companyid is null. so i need all the users whose status are active and if they have companyid , i need the companyname of their company In Oracle i can write this as select u.userid , (select companyname from company where companyid = u.companyid) from users u where u.status = 'ACT' how do i get this in mysql i wrote one query select u.userid , c.companyname from users u , company c where u.companyid = c.companyid AND u.status = 'ACT' This returned only the users who have company...how do i take the users also who doesnt have a company Regards -Arul - 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
Stumped on this Report - HELP
Dear All, I am stumped on this report. I just need an idea and help to do this in MySQL. To simplify my actual database, I am using an example. Database fields - salesperson,date,visited company industry type salespersons - a,b,c,d,e (can be 10 salesperson or 20 salesperson) visited company industry type - type1, type2, type3 (can be from different industries e.g manufacturer, service, telco, etc - can be 30 or more types) How can I generate a report like this? Salesperson a b c d e .(etc) type1 x xx x x xx type2 xx x xxx x x type3 x xx x xx xx X - number of companies of the same type by the same salesperson. I have thought of a temp table but I was stumped with the potential variable in salesperson and industry types. Is this report possible? I need someone to trigger or point me to the direct me to the right place. Thanks in advance - 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: Privileges
At 11:54 -0300 7/2/02, Alexander Burbello wrote: I would like to know what does mean the privilege References_priv on the table users?? It's unused. Regards Alexander 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
Re: cascading, referential integrity
Blue, Tuesday, July 02, 2002, 5:54:32 PM, you wrote: BP does mysql 3.23 support cascading and referential integrity or is this only BP part of 4.01? if so, how do i take advantage of it and where in the BP documenation (link) can I read about it? Yes, MySQL supports foreign key constraints for referential integrity and foreign keys present since in 3.23.43b. CASCADE DELETE is supported since 3.23.50: http://www.mysql.com/doc/S/E/SEC446.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: Privileges
Alexander, Tuesday, July 02, 2002, 5:54:48 PM, you wrote: AB I would like to know what does mean the privilege AB References_priv on the table users?? It's for future features... If you will grant references_priv, user can create foreign keys. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: help me with this query
select u.userid , c.companyname from users u left join company c on (u.companyid = c.companyid) where u.status = 'ACT' Best regards, Mikhail. - Original Message - From: Arul [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 5:15 PM Subject: help me with this query Hi All I have two tables User and Company User tables has userid , companyid and status Company table has companyid and companyname It's not necessary that all users should have company.There can be users without company also and for them the companyid is null. so i need all the users whose status are active and if they have companyid , i need the companyname of their company In Oracle i can write this as select u.userid , (select companyname from company where companyid = u.companyid) from users u where u.status = 'ACT' how do i get this in mysql i wrote one query select u.userid , c.companyname from users u , company c where u.companyid = c.companyid AND u.status = 'ACT' This returned only the users who have company...how do i take the users also who doesnt have a company Regards -Arul - 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
Multiple masters to 1 slave??
I'm trying to find a way to set up an off-site replication (slave 3). In house I have several MySQL 4.0 servers that are using replication. They consist of 1 master (master1) for all data, 1 slave (slave 1) for optimized web access and 1 slave (slave 2) for the internal database app. Both slaves' databases have additional tables not on the master and the replication is using replicate-do-table=DBanme.Tablename in the /etc/my.cnf files. Here's the question. In the my.cnf file on the off-site slave, can there be multiple masters specified where it will replicate all 3 in-house servers to different databases on itself? Master1 -- Slave1 (same db name) Master2 -- Slave2 (same db name) Master1 -- Slave3 (diff db name) Slave1 -- Slave3 (diff db name) Slave2 -- Slave3 (diff db name) Thanks, Jim - 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: AW: mysql wont start on SUSE
In SuSE you should be able to start the MySQL server by: rcmysql start or rcmysql restart rcmysql is a symlink to the /etc/init.d directory -Original Message- From: John Macloy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 2:26 AM To: [EMAIL PROTECTED] Subject: AW: AW: mysql wont start on SUSE I noticed that my Server works with [mysql] user = root and than start with mysqld but when I tried to start with the runlevel editor it doesn't works. Perhaps a other Person in this list no the answer? The mysql_install_db create two folders in the var/lib/mysql pfad. The folder are mysql and test. In mysql are the table definitions for passwords etc. If I solve the problem I will write you an Email John -Ursprungliche Nachricht- Von: Jacques Steyn [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 1. Juli 2002 18:54 An: John Macloy Betreff: Re: AW: mysql wont start on SUSE Thanks John I've added that line, but no luck. Yes, I've done the mysql_install_db, which worked OK. I am baffled. Stupid question: mysql_install_db is run only once to set up default DBs??? Jacques John Macloy wrote: Yes, I have go to my.cnf and write [mysqld] user=root then start the server with mysqld. This works on my computer, but I'm not sure if the right way cause the the server shouldn't use with the user root but for a test it's ok. Have you already started the script mysql_install_db? It's necessary. Macloy -Ursprungliche Nachricht- Von: Jacques Steyn [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 1. Juli 2002 15:28 An: Alexander Barkov Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Betreff: mysql wont start on SUSE Anybody had a problem with MySQL that does not start on SUSE 8 with default installation? If yes, what was the problem? Thanks Jacques ___ Jacques Steyn +27 (0)11 478-1259 http://www.knowsystems.com - 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 -- ___ Dr Jacques Steyn +27 (0)11 478-1259 http://www.knowsystems.com - 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
Re: Multiple masters to 1 slave??
On Tue, Jul 02, 2002 at 10:54:44AM -0500, Jim Crippen wrote: In the my.cnf file on the off-site slave, can there be multiple masters specified where it will replicate all 3 in-house servers to different databases on itself? No. A slave can only have one master. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.51: up 33 days, processed 739,487,628 queries (254/sec. avg) - 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
Debian (Woody/Testing) version of MySql
Hi We have just moved out test server from RedHat to Debian. We have used the backup tapes to recover the data, and all went well to until we tried to connect via a host name. For example mysql test -utest_user -ptest_passwd works fine, but mysql -hserver -utest_user -ptest_passwd reports the error ERROR 2003: Can't connect to MySQL server on 'server' (111) The grants in the user/db tables are all ok, and worked on the RedHat box (3.23-49). Any ideas what is happening with Debian version, also (3.23-49) Simon - 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: cascading, referential integrity
okay, so my tables have to be of type InnoDB. Is there a configuration file somewhere where i can specify that all my tables be InnoDB so I don't have to keep manually specifying the type? blue - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 11:45 AM Subject: Re: cascading, referential integrity Blue, Tuesday, July 02, 2002, 5:54:32 PM, you wrote: BP does mysql 3.23 support cascading and referential integrity or is this only BP part of 4.01? if so, how do i take advantage of it and where in the BP documenation (link) can I read about it? Yes, MySQL supports foreign key constraints for referential integrity and foreign keys present since in 3.23.43b. CASCADE DELETE is supported since 3.23.50: http://www.mysql.com/doc/S/E/SEC446.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
RE: RE: Multiple masters to 1 slave??
A slave can only have one master. You obviously don't work around here. :-) -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Subject: Re: Multiple masters to 1 slave?? On Tue, Jul 02, 2002 at 10:54:44AM -0500, Jim Crippen wrote: In the my.cnf file on the off-site slave, can there be multiple masters specified where it will replicate all 3 in-house servers to different databases on itself? No. A slave can only have one master. Jeremy 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
Re: Debian (Woody/Testing) version of MySql
On Tue, Jul 02, 2002 at 05:56:37PM +0100, Simon Windsor wrote: Hi We have just moved out test server from RedHat to Debian. We have used the backup tapes to recover the data, and all went well to until we tried to connect via a host name. For example mysql test -utest_user -ptest_passwd works fine, but mysql -hserver -utest_user -ptest_passwd reports the error ERROR 2003: Can't connect to MySQL server on 'server' (111) The grants in the user/db tables are all ok, and worked on the RedHat box (3.23-49). Any ideas what is happening with Debian version, also (3.23-49) Remove the skip-networking option from the my.cnf file on your server. It's documented in the Debian MySQL docs. :-) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.51: up 33 days, processed 740,610,078 queries (254/sec. avg) - 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
changing coulmn
in my table a column has enties my_1 my_4 my_5 i wnat to change it to my_file_1 my_file_4 my_file_5 can someone please tell me the query for that. thanx anil - 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: MAX vs plain vanilla mysql
Thanks, So, if you install MySQL MAX, you can use either myisam OR innodb / bdb tables, ie, if I install ONE mysql max server, then different users on the server can use different types of tables(innodb/myisam) as they choose?, also, if you create one db, can you have different types of tables in one db? Sorry if I'm asking stupid questions, just want to know what is possible and what not, was thinking the other day if it wouldn't be etter if one had different types of tables in one relation db ; myisam types for the normal static data, and innodb or bdb tables for the tables that need to commit/rollback. Heikki Tuuri wrote: Hi! I have to correct: if you put [mysqld] skip-innodb skip-bdb to your my.cnf, then -Max uses only about 1.5 MB more memory than plain MySQL, because of a larger executable. MyISAM tables in -Max are as reliable as in plain MySQL. It is the same source code. Best regards, Heikki Innobase Oy ... Petre, Monday, July 01, 2002, 9:26:49 AM, you wrote: PA Probably a stupid question, but which is best to have on ones server, PA the old mysql, or max. I.O.W, if you install MAX and never use innodb PA or berkeley tables, will it be equivalent to a normal mysql installation PA wrt performance and stability? PA I'm asking from an ISP's point of view, if that makes any difference ( PA obviously if from developer it will depend on the needs of the app..) MySQL-Max binary is larger. It takes a lot more memory and it is useless without usage of InnoDB and/or BDB. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
Re: Fiddling with myisam/ft_static.c
Hi! On Jul 02, Thomas Spahni wrote: Hi, I am indexing texts in German, French or Italian language. I want to add words from these languages to the stopword list and need some more guidance: - case doesn't matter, right? yes. - what should I do with words containing non ascii characters '??' ? Enter as is? yes. - is there any performance issue when the list grows long? nothing that I know of. stopwords are stored in the balanced binary tree, so lookup should be fast. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - 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: cascading, referential integrity
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Blue Presley wrote: | okay, so my tables have to be of type InnoDB. Is there a configuration file | somewhere where i can specify that all my tables be InnoDB so I don't have | to keep manually specifying the type? | Add set-variable= default-table-type=InnoDB to the [mysqld] section in your my.cnf file which will either be in /etc or in the data directory of your MySQL server installation. -Mark - -- For technical support contracts, visit https://order.mysql.com/?ref=mmma ~__ ___ ___ __ ~ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] ~ / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java ~ /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ~___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6-2 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAj0h5w4ACgkQtvXNTca6JD9WYwCdEyanhqt3K5kJMkQTTn3h1vru QnAAoJ2rA+8NsDZUWCu2Pbvu2dRocrgy =qCsF -END PGP SIGNATURE- - 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: Author of windows binary distribution
At 12:32 2/7/2002 +0200, =?iso-8859-2?Q?Planka_Tom=E1=B9?= wrote: Hi, Hello, can you send me a conntact (e-mail) to author of windows binary distribution of mySQL server, please? I have one question to him (about charset conversion in czech language, specially in windows distribution)... Thank you very much! I am who build the Windows binaries, so I am waiting your questions. Regards, -- For technical support contracts, visit https//order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ São Paulo - Brazil ___/ www.mysql.com - 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
Recreating an MS-SQL database in MySQL: redux
No response from the first post, so here goes for one more try... My employer recently acquired an existing web site that uses a MicroSoft SQL database and I've been directed to get it running on an in-house server. As we don't have any Windows servers, I need to recreate the database in MySQL. The site's developer has supplied me with the schema of the MS-SQL database and I'm hoping to be able to turn it into a file that I can run in batch mode through the mysql client to create the database structure. I'm relatively new to SQL in general and MySQL specifically, so I'm a little over my head at this point. I will, I'm sure, be learning all I need to know over time, but I need to get this one project going now and I would appreciate some guidance to at least tell me if I'm headed in the right direction. Anyway, the MS-SQL schema file consists of CREATE TABLE commands for each table, followed by a series of ALTER TABLE commands. I've been able to get the CREATE TABLE commands to run by changing, e.g.: CREATE TABLE [dbo].[clients] ( [login] [varchar] (50) NOT NULL , [password] [varchar] (50) NULL ) ON [PRIMARY] GO to: CREATE TABLE clients ( login VARCHAR(50) NOT NULL , password VARCHAR(50) NULL ); So far, so good. There are a couple of column types that I've had to guess at, but I think I've found reasonable equivalents ([money] becomes DECIMAL(6,2) and [phone] becomes VARCHAR(20) ). I'm getting stuck on the ALTER TABLE commands, though. I'm afraid I don't know quite enough MySQL (or SQL in general) to confidently figure out which MS-SQL bits are server-specific and can be ignored, and which need to be changed into equivalent MySQL commands. If I change: ALTER TABLE [dbo].[dining_cat] WITH NOCHECK ADD CONSTRAINT [PK__dining_cat__07C12930] PRIMARY KEY CLUSTERED ( [cat_id] ) WITH FILLFACTOR = 90 ON [PRIMARY] GO to: ALTER TABLE dining_cat ADD CONSTRAINT PK__dining_cat__07C12930 PRIMARY KEY CLUSTERED ( cat_id ); it works, although I'm not sure what, if anything, is being lost by getting rid of 'WITH NOCHECK' and 'WITH FILLFACTOR = 90'. Then there are commands that look like: ALTER TABLE [dbo].[dining_loc] WITH NOCHECK ADD CONSTRAINT [DF_dining_loc_loc_venue] DEFAULT (0) FOR [loc_venue], CONSTRAINT [PK_dining_loc] PRIMARY KEY NONCLUSTERED ( [loc_id] ) WITH FILLFACTOR = 90 ON [PRIMARY] GO MySQL gives an error 1064 at 'DEFAULT (0) FOR loc_venue' and I'm not sure what to do with it. If I knew what the intended effect is, I'm sure I could figure out the equivalent MySQL syntax. At this point, though, it's still a bit opaque to me. Any gentle nudge in the right direction would be greatly appreciated. TIA! -- Christopher Bort | [EMAIL PROTECTED] Webmaster, Global Homes | [EMAIL PROTECTED] http://www.globalhomes.com/ - 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
help on update
Hello, I am having some issues inserting and updating with mySQL. Database: asdf Table: test field: idfield (int, autoincrement) field: test (char) the query: insert into test set test = 'test' ; used in mascon or DBvisualizer correctly inserts the record. however, when used on the webserver, using apache: ? if(!MYSQL_CONNECT($hostname,$user,$pword)){ echo Connection Problem.; exit(); } $dbNamec = asdf; if(!MYSQL_select_db( $dbNamec)){ echo Connection Problem.; exit(); } //Insert Information into Customer Table $query = Insert into test set test = 'work' ; ; $test = MYSQL_QUERY($query); $query = select * from test order by idfield desc limit 1; $result = MYSQL_QUERY($query); $number = MYSQL_NUM_ROWS($result); echo br . MYSQL_result($result,0,test) ; ? it produces no error of any kind, however does not insert the record. the second query sucessfully returns whatever i have manually inserted into the database. both mascon and the web use the same username : webuser why is it that mascon can update the table, but apache cannot ? Thanks for the help, Matthew - 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: configure won't configure
Thanks for the response. I set LDFLAGS and CCFLAGS for compiles and then it configured OK, I am out of practice porting compiled software. ./configure --prefix=/export/home/mysql --with-unix-socket-path=/var/tmp/mysql.sock --enable-thread-safe-client --with-berkeley-db --enable-local-infile --with-innodb CC=gcc CXX=gcc LDFLAGS=-R/usr/local/lib CCFLAGS=-I/usr/local/include seems to me this should be hinted in the instructions for solaris because zlib is often in /usr/local/lib Still trying to build Thanks again Gerald Clark wrote: With linux you would: Add /usr/local/lib to your /etc/ld.so.conf file and run ldconfig. Sun should have something similar. [EMAIL PROTECTED] wrote: Description: what do I have to do to get configure to use correct gcc options like: -I/usr/local/include -R/usr/local/lib ??? I use following options: ./configure --prefix=/home/mysql --with-unix-socket-path=/var/tmp/mysql.sock --with-low-memory --with-mit-threads=yes --enable-thread-safe-client --with-berkeley-db --enable-local-infile --with-innodb CC=gcc CXX=gcc Tried These, nothing works.. --libdir=/usr/local/lib --includedir=/usr/local/include '--with-lib-ccflags=-I/usr/local/include -R/usr/local/lib' Results: configure:8285: gcc -o conftest -DHAVE_CURSES_H -I/export/home/mysql/src/mysql-3.23.51/include -DHAVE_RWLOCK_T conftest.c -lz -lcrypt -lgen -lsocket -lnsl -lm 5 configure:8288: $? = 0 configure:8290: ./conftest ld.so.1: ./conftest: fatal: libz.so: open failed: No such file or directory Killed libz is in /usr/local/lib so without -R/usr/local/lib this will fail of course. And again configure:8920: checking size of char configure:9084: gcc -o conftest -O3 -DDBUG_OFF -DHAVE_CURSES_H -I/export/home/mysql/src/mysql-3.23.51/include -DHAVE_RWLOCK_T conftest.c -lz -lcrypt -lgen -lsocket -lnsl -lm 5 configure:9087: $? = 0 configure:9089: ./conftest ld.so.1: ./conftest: fatal: libz.so: open failed: No such file or directory Killed ... configure: exit 1 How-To-Repeat: See above Fix: none Submitter-Id: [EMAIL PROTECTED] Originator: Organization: ATT Michael Matthews UNIX mail mailto:[EMAIL PROTECTED] Corporate mail mailto:[EMAIL PROTECTED] MySQL support: none Synopsis: configure won't configure Severity: non-critical Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.51 (Source distribution) Server: /usr/local/mysql/bin/mysqladmin Ver 8.12 Distrib 3.23.28-gamma, for sun-solaris2.7 on sparc Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.28-gamma-log Protocol version 10 Connection Localhost via UNIX socket UNIX socket/tmp/mysql.sock Uptime:18 days 13 min 33 sec Threads: 1 Questions: 258266 Slow queries: 5 Opens: 127 Flush tables: 1 Open tables: 98 Queries per second avg: 0.166 Environment: System: SunOS webnsf 5.7 Generic_106541-09 sun4u sparc SUNW,Ultra-60 Architecture: sun4 Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gmake /usr/local/bin/gcc /opt/tools/SUNWspro/bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/3.1/specs Configured with: ../configure --with-as=/usr/ccs/bin/as --with-ld=/usr/ccs/bin/ld --disable-nls Thread model: posix gcc version 3.1 Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' LIBC: -rw-r--r-- 1 bin bin 1696732 Feb 25 2000 /lib/libc.a lrwxrwxrwx 1 root root 11 Mar 9 1999 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1115336 Feb 25 2000 /lib/libc.so.1 -rw-r--r-- 1 bin bin 1696732 Feb 25 2000 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Mar 9 1999 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1115336 Feb 25 2000 /usr/lib/libc.so.1 Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock --with-low-memory --with-mit-threads=yes --without-perl --enable-thread-safe-client --with-berkeley-db --enable-local-infile --with-innodb CC=gcc CXX=gcc -- Michael Matthews UNIX mail mailto:[EMAIL PROTECTED] Corporate mail mailto:[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: help on update
Hi, Matthew, Have you tried: insert into test (test) values ('work') Or update test set test='test' I liked it when Matthew Hajda wrote this to me: Hello, I am having some issues inserting and updating with mySQL. Database: asdf Table: test field: idfield (int, autoincrement) field: test (char) the query: insert into test set test = 'test' ; used in mascon or DBvisualizer correctly inserts the record. however, when used on the webserver, using apache: ? if(!MYSQL_CONNECT($hostname,$user,$pword)){ echo Connection Problem.; exit(); } $dbNamec = asdf; if(!MYSQL_select_db( $dbNamec)){ echo Connection Problem.; exit(); } //Insert Information into Customer Table $query = Insert into test set test = 'work' ; ; $test = MYSQL_QUERY($query); $query = select * from test order by idfield desc limit 1; $result = MYSQL_QUERY($query); $number = MYSQL_NUM_ROWS($result); echo br . MYSQL_result($result,0,test) ; ? it produces no error of any kind, however does not insert the record. the second query sucessfully returns whatever i have manually inserted into the database. both mascon and the web use the same username : webuser why is it that mascon can update the table, but apache cannot ? Thanks for the help, Matthew - 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
Re: changing coulmn
I wasn't entirely sure what you wanted - do you want to change the table's column names? If so, then do what the message below suggests. And yes, you can do it all in one query: alter table mytest change my_1 my_file_1 varchar(5), change my_2 my_file_2 varchar(5), ...and so on See http://www.mysql.com/doc/A/L/ALTER_TABLE.html for more info. If my_1, etc are VALUES in a column, and you want to modify them, you can do this: update your_table_name set your_column_name = concat('my_file_', substring(your_column_name, 4)) See http://www.mysql.com/doc/S/t/String_functions.html for more info. -steve At 2:32 PM -0400 7/2/02, Anil Garg wrote: thanx for ur mail, m sorry in dint mention that infact its a big table... Is there a way i can do it in all the columns using only one query ?? thanx anil - Original Message - From: nellA hciR [EMAIL PROTECTED] To: Anil Garg [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 2:14 PM Subject: Re: changing coulmn mysql create table mytest ( - my_1 varchar(5) - ); Query OK, 0 rows affected (0.32 sec) mysql alter table mytest change my_1 my_file_1 varchar(5); Query OK, 0 rows affected (0.23 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql show columns from mytest; +---++--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---++--+-+-+---+ | my_file_1 | varchar(5) | YES | | NULL| | +---++--+-+-+---+ On Tuesday, July 2, 2002, at 09:36 , Anil Garg wrote: in my table a column has enties my_1 my_4 my_5 i wnat to change it to my_file_1 my_file_4 my_file_5 -- ++ | Steve Edberg [EMAIL PROTECTED] | | University of California, Davis (530)754-9127 | | Programming/Database/SysAdmin http://pgfsun.ucdavis.edu/ | ++ | The end to politics as usual: | | The Monster Raving Loony Party (http://www.omrlp.com/) | ++ - 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
Can't find file ./mysql/host.frm
Description: When starting safe_mysqld mysqld shutsdown immediately with no error message. However looking at /var/lib/mysql/matrix.err gives the following error messages:- mysqld started /usr/libexec/mysqld: can't find file: './mysql/host.frm' errno: 13 mysqld ended /var/lib/mysql/mysql/host.frm exists, and I've tried linking it to various places, with no success. How-To-Repeat: Not sure, system is zipslack 8.0, with binary packages of apache, mysql, and mod_php installed from the zipslack site. Fix: Don't know Submitter-Id: submitter ID Originator:Richard Kirkcaldy [EMAIL PROTECTED] Organization: MySQL support: none Synopsis: Can't find ./mysql/host.frm Severity: critical Priority: high Category: mysql Class: support Release: mysql-3.23.39 (Source distribution) Environment: 486, zipslack 8.0 System: Linux matrix 2.2.19 #115 Thu Jun 21 14:07:22 PDT 2001 i486 unknown Architecture: i486 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-slackware-linux/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Jun 25 17:18 /lib/libc.so.6 - libc- 2.2.3.so -rwxr-xr-x1 root root 1159296 Jun 26 2001 /lib/libc-2.2.3.so -rw-r--r--1 root root 178 May 25 2001 /usr/lib/libc.so Configure command: ./configure --prefix=/usr --with-mysqld-user=mysql --with- unix-socket-path=/var/run/mysql/mysql.sock --localstatedir=/var/lib/mysql -- with-pthread --enable-thread-safe-client --enable-assembler --with-raid --with- libwrap --without-bench i386-slackware-linux -- Richard Kirkcaldy - This mail sent through IMP: webmail.brad.ac.uk - 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't find file ./mysql/host.frm
chown -R mysql /var/lib/mysql [EMAIL PROTECTED] wrote: Description: When starting safe_mysqld mysqld shutsdown immediately with no error message. However looking at /var/lib/mysql/matrix.err gives the following error messages:- mysqld started /usr/libexec/mysqld: can't find file: './mysql/host.frm' errno: 13 mysqld ended /var/lib/mysql/mysql/host.frm exists, and I've tried linking it to various places, with no success. How-To-Repeat: Not sure, system is zipslack 8.0, with binary packages of apache, mysql, and mod_php installed from the zipslack site. Fix: Don't know Submitter-Id: submitter ID Originator: Richard Kirkcaldy [EMAIL PROTECTED] Organization: MySQL support: none Synopsis: Can't find ./mysql/host.frm Severity: critical Priority: high Category: mysql Class:support Release: mysql-3.23.39 (Source distribution) Environment: 486, zipslack 8.0 System: Linux matrix 2.2.19 #115 Thu Jun 21 14:07:22 PDT 2001 i486 unknown Architecture: i486 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-slackware-linux/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Jun 25 17:18 /lib/libc.so.6 - libc- 2.2.3.so -rwxr-xr-x1 root root 1159296 Jun 26 2001 /lib/libc-2.2.3.so -rw-r--r--1 root root 178 May 25 2001 /usr/lib/libc.so Configure command: ./configure --prefix=/usr --with-mysqld-user=mysql --with- unix-socket-path=/var/run/mysql/mysql.sock --localstatedir=/var/lib/mysql -- with-pthread --enable-thread-safe-client --enable-assembler --with-raid --with- libwrap --without-bench i386-slackware-linux - 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: Recreating an MS-SQL database in MySQL: redux
There are commercial packages that do the conversion quickly and easily. The best one is obscenely expensive (the price isn't on the website, you have to write and request a quote, and a sales rep get back. I think it was around $3000. I don't remember the name of the software, because it was so expensive. But the demo worked perfectly). The solution I used, which was a bit more work, was to use an Access-to-MySQL program, which was about $39 ($75, I think for both directions). I export the SQL-Server to Access, then use Access-to-MySQL. We need to do this monthly for a newsletter (ODBC over the network drags the newsletter delivery out from 24 hours to 56 hours!), and it works fine. Unfortunately, it doesn't preserve indices, so they need to be recreated by hand. The company with the low-cost converters is Intelligent Converters. Of course, you're going to lose some of the constraints just using MySQL, but the converter may make your life a bit simpler. Or, if you have the $3k, do a google search for SQL MySQL converter Tac - Original Message - From: Christopher Bort [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 1:59 PM Subject: Recreating an MS-SQL database in MySQL: redux No response from the first post, so here goes for one more try... My employer recently acquired an existing web site that uses a MicroSoft SQL database and I've been directed to get it running on an in-house server. As we don't have any Windows servers, I need to recreate the database in MySQL. The site's developer has supplied me with the schema of the MS-SQL database and I'm hoping to be able to turn it into a file that I can run in batch mode through the mysql client to create the database structure. I'm relatively new to SQL in general and MySQL specifically, so I'm a little over my head at this point. I will, I'm sure, be learning all I need to know over time, but I need to get this one project going now and I would appreciate some guidance to at least tell me if I'm headed in the right direction. Anyway, the MS-SQL schema file consists of CREATE TABLE commands for each table, followed by a series of ALTER TABLE commands. I've been able to get the CREATE TABLE commands to run by changing, e.g.: CREATE TABLE [dbo].[clients] ( [login] [varchar] (50) NOT NULL , [password] [varchar] (50) NULL ) ON [PRIMARY] GO to: CREATE TABLE clients ( login VARCHAR(50) NOT NULL , password VARCHAR(50) NULL ); So far, so good. There are a couple of column types that I've had to guess at, but I think I've found reasonable equivalents ([money] becomes DECIMAL(6,2) and [phone] becomes VARCHAR(20) ). I'm getting stuck on the ALTER TABLE commands, though. I'm afraid I don't know quite enough MySQL (or SQL in general) to confidently figure out which MS-SQL bits are server-specific and can be ignored, and which need to be changed into equivalent MySQL commands. If I change: ALTER TABLE [dbo].[dining_cat] WITH NOCHECK ADD CONSTRAINT [PK__dining_cat__07C12930] PRIMARY KEY CLUSTERED ( [cat_id] ) WITH FILLFACTOR = 90 ON [PRIMARY] GO to: ALTER TABLE dining_cat ADD CONSTRAINT PK__dining_cat__07C12930 PRIMARY KEY CLUSTERED ( cat_id ); it works, although I'm not sure what, if anything, is being lost by getting rid of 'WITH NOCHECK' and 'WITH FILLFACTOR = 90'. Then there are commands that look like: ALTER TABLE [dbo].[dining_loc] WITH NOCHECK ADD CONSTRAINT [DF_dining_loc_loc_venue] DEFAULT (0) FOR [loc_venue], CONSTRAINT [PK_dining_loc] PRIMARY KEY NONCLUSTERED ( [loc_id] ) WITH FILLFACTOR = 90 ON [PRIMARY] GO MySQL gives an error 1064 at 'DEFAULT (0) FOR loc_venue' and I'm not sure what to do with it. If I knew what the intended effect is, I'm sure I could figure out the equivalent MySQL syntax. At this point, though, it's still a bit opaque to me. Any gentle nudge in the right direction would be greatly appreciated. TIA! -- Christopher Bort | [EMAIL PROTECTED] Webmaster, Global Homes | [EMAIL PROTECTED] http://www.globalhomes.com/ - 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
installing 3.23.49 on solaris 5.8 fails
I used gnu's make as recommended, make was successful, however gmake install gives the foll. error: /usr/local/gnu/bin/install -c copy-db /rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench/copy-db /usr/local/gnu/bin/install: `copy-db' and `/rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench/copy-db' are the same file gmake[2]: *** [install-benchSCRIPTS] Error 1 gmake[2]: Leaving directory `/rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench' gmake[1]: *** [install-am] Error 2 gmake[1]: Leaving directory `/rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench' gmake: *** [install-recursive] Error 1 I searched google, documentation but couldn't find any such errors reported? Does anybody know the problem, config. options: ./configure --prefix=/rstc/user1/erc/pushkar/mysql-3.23.49 -Pushkar S. Pradhan - 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
problems on solaris machine
We have mySQL running on a Sun Solaris machine and we are starting to have some problems. We just put a new 40GB drive into the machine which was expressly for mySQL. We then tar'd the whole mysql over to this new drive and then checked all the references.. everything looks good and it does in fact work (ie. we can start mysql, load data, and query the database). However, the system keeps dying due to an OS error. I'm a sysadmin, not the person who actually uses the db, but the one thing I know from the past is that sometimes mysql used to get screwy when there are a large number of rows (ie. 1MM) in a table, and the person who uses the db, now that she has all this space has been putting in millions of records into the mysql db, whereas before it was less than 300,000. I suppose the error could be some kind of bad drive, but I want to eliminate the possibility that it's a configuration error or a problem with the size of this database. Any ideas?? Thanks, Kristen - 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: problems on solaris machine
-Original Message- From: Kristen J. McFadden [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 10:25 PM To: [EMAIL PROTECTED] Subject: problems on solaris machine [sql] However, the system keeps dying due to an OS error. problem with the size of this database. Any ideas?? Yes. Let us know what the OS error exactly is. Maciek - 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: installing 3.23.49 on solaris 5.8 fails
It looks like you configured it to install in the source directory. Pushkar Pradhan wrote: I used gnu's make as recommended, make was successful, however gmake install gives the foll. error: /usr/local/gnu/bin/install -c copy-db /rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench/copy-db /usr/local/gnu/bin/install: `copy-db' and `/rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench/copy-db' are the same file gmake[2]: *** [install-benchSCRIPTS] Error 1 gmake[2]: Leaving directory `/rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench' gmake[1]: *** [install-am] Error 2 gmake[1]: Leaving directory `/rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench' gmake: *** [install-recursive] Error 1 I searched google, documentation but couldn't find any such errors reported? Does anybody know the problem, config. options: ./configure --prefix=/rstc/user1/erc/pushkar/mysql-3.23.49 -Pushkar S. Pradhan - 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
innodb is disabled, how can i make it yes?
hi guys, i use mysql 3.23.44-max-nt server, i edit c:\windows\my.ini and c:\my.cnf and c:\mysql\data\my.cnf to include the manadatorey line to be : innodb_data_file_path=c:/mysql/data/ibdata:300M then, when i restart the server and start the client, i type: show variables like have_%; --- variable_name | value --- have_bdb| yes have_innodb| disabled have_openssl | no ... --- why the innodb is disabled ? thanks in advance sql -- Hytham Shehab --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.372 / Virus Database: 207 - Release Date: 20/06/2002 - 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: installing 3.23.49 on solaris 5.8 fails
That's right, I install all other stuff the same way. I also forgot to mention I am not an admin, so I install everything in my own disk space on the n/w. Isn't that okay? It looks like you configured it to install in the source directory. Pushkar Pradhan wrote: I used gnu's make as recommended, make was successful, however gmake install gives the foll. error: /usr/local/gnu/bin/install -c copy-db /rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench/copy-db /usr/local/gnu/bin/install: `copy-db' and `/rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench/copy-db' are the same file gmake[2]: *** [install-benchSCRIPTS] Error 1 gmake[2]: Leaving directory `/rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench' gmake[1]: *** [install-am] Error 2 gmake[1]: Leaving directory `/rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench' gmake: *** [install-recursive] Error 1 I searched google, documentation but couldn't find any such errors reported? Does anybody know the problem, config. options: ./configure --prefix=/rstc/user1/erc/pushkar/mysql-3.23.49 -Pushkar S. Pradhan - 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 -Pushkar S. Pradhan - 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_real_query, insert floats as binary
...and some bytes may represent an 'illegal' character, and thus must be escaped by a backslash... this goes for the quote character you use ( or '), the backslash character itself, and null bytes. Thanks, if I use mysql_real_query is this still the case? -- David A. C. Beck [EMAIL PROTECTED] Valerie Daggett Laboratory Biomolecular Structure and Design Program Department of Medicinal Chemistry University of Washington, Seattle On Tue, 2 Jul 2002, Roger Baklund wrote: * Dave Beck [...] char insert_format[] = INSERT INTO %s VALUES (%hhd%hhd%hhd%hhd, %hhd%hhd%hhd%hhd, %hhd%hhd%hhd%hhd, %hhd%hhd%hhd%hhd,%hhd%hhd%hhd%hhd); The values should be quoted... int build_real_insert(char *query, char *table, int frame, int atom, float x, float y, float z) { unsigned char *fbp = (unsigned char *)frame; unsigned char *abp = (unsigned char *)atom; unsigned char *xbp = (unsigned char *)x; unsigned char *ybp = (unsigned char *)y; unsigned char *zbp = (unsigned char *)z; return sprintf(query, insert_format, table, fbp[0], fbp[1], fbp[2], fbp[3], abp[0], abp[1], abp[2], abp[3], xbp[0], xbp[1], xbp[2], xbp[3], ybp[0], ybp[1], ybp[2], ybp[3], zbp[0], zbp[1], zbp[2], zbp[3]); } ...and some bytes may represent an 'illegal' character, and thus must be escaped by a backslash... this goes for the quote character you use ( or '), the backslash character itself, and null bytes. -- Roger sql - 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: changing coulmn
mysql create table mytest ( - my_1 varchar(5) - ); Query OK, 0 rows affected (0.32 sec) mysql alter table mytest change my_1 my_file_1 varchar(5); Query OK, 0 rows affected (0.23 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql show columns from mytest; +---++--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---++--+-+-+---+ | my_file_1 | varchar(5) | YES | | NULL| | +---++--+-+-+---+ On Tuesday, July 2, 2002, at 09:36 , Anil Garg wrote: in my table a column has enties my_1 my_4 my_5 i wnat to change it to my_file_1 my_file_4 my_file_5 - 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: MAX vs plain vanilla mysql
At 19:31 +0200 7/2/02, Petre Agenbag wrote: Thanks, So, if you install MySQL MAX, you can use either myisam OR innodb / bdb tables, ie, if I install ONE mysql max server, then different users on the server can use different types of tables(innodb/myisam) as they choose?, also, if you create one db, can you have different types of tables in one db? Sorry if I'm asking stupid questions, just want to know what is possible and what not, was thinking the other day if it wouldn't be etter if one had different types of tables in one relation db ; myisam types for the normal static data, and innodb or bdb tables for the tables that need to commit/rollback. Yes, yes, yes, and yes. :-) - 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: innodb is disabled, how can i make it yes?
At 23:52 +0300 7/2/02, Hytham Shehab wrote: hi guys, i use mysql 3.23.44-max-nt server, i edit c:\windows\my.ini and c:\my.cnf and c:\mysql\data\my.cnf to include the manadatorey line to be : innodb_data_file_path=c:/mysql/data/ibdata:300M then, when i restart the server and start the client, i type: show variables like have_%; --- variable_name | value --- have_bdb| yes have_innodb| disabled have_openssl | no ... --- why the innodb is disabled ? Make sure it's not being started with --skip-innodb. thanks in advance sql -- Hytham Shehab - 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: installing 3.23.49 on solaris 5.8 fails
At 15:55 -0500 7/2/02, Pushkar Pradhan wrote: That's right, I install all other stuff the same way. I also forgot to mention I am not an admin, so I install everything in my own disk space on the n/w. Isn't that okay? From the error that you're getting, pretty clearly it's not okay the way you're doing it. It's okay to install in your own disk space, but you'll have to choose a different directory. It looks like you configured it to install in the source directory. Pushkar Pradhan wrote: I used gnu's make as recommended, make was successful, however gmake install gives the foll. error: /usr/local/gnu/bin/install -c copy-db /rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench/copy-db /usr/local/gnu/bin/install: `copy-db' and `/rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench/copy-db' are the same file gmake[2]: *** [install-benchSCRIPTS] Error 1 gmake[2]: Leaving directory `/rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench' gmake[1]: *** [install-am] Error 2 gmake[1]: Leaving directory `/rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench' gmake: *** [install-recursive] Error 1 I searched google, documentation but couldn't find any such errors reported? Does anybody know the problem, config. options: ./configure --prefix=/rstc/user1/erc/pushkar/mysql-3.23.49 -Pushkar S. Pradhan - 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: help on update
At 18:54 + 7/2/02, Matthew Hajda wrote: Hello, I am having some issues inserting and updating with mySQL. You're not testing the result from mysql_query() to see whether not it succeeds. Do so, and they print the result from mysql_error() in the event of failure to see what it says. Database: asdf Table: test field: idfield (int, autoincrement) field: test (char) the query: insert into test set test = 'test' ; used in mascon or DBvisualizer correctly inserts the record. however, when used on the webserver, using apache: Using PHP, you mean. ? if(!MYSQL_CONNECT($hostname,$user,$pword)){ echo Connection Problem.; exit(); } $dbNamec = asdf; if(!MYSQL_select_db( $dbNamec)){ echo Connection Problem.; exit(); } //Insert Information into Customer Table $query = Insert into test set test = 'work' ; ; $test = MYSQL_QUERY($query); $query = select * from test order by idfield desc limit 1; $result = MYSQL_QUERY($query); $number = MYSQL_NUM_ROWS($result); echo br . MYSQL_result($result,0,test) ; ? it produces no error of any kind, however does not insert the record. the second query sucessfully returns whatever i have manually inserted into the database. both mascon and the web use the same username : webuser why is it that mascon can update the table, but apache cannot ? Thanks for the help, Matthew - 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: InnoDB RAW devices under Solaris?
Lou, I tested this on our SunOS-5.8 Sparc computer with 3.23.49: bash-2.03$ df / (/dev/dsk/c0t0d0s0 ): 7499474 blocks 2033414 files /proc (/proc ): 0 blocks 5861 files /dev/fd(fd): 0 blocks0 files /etc/mnttab(mnttab): 0 blocks0 files /var/run (swap ): 1698576 blocks40153 files /tmp (swap ): 1698576 blocks40153 files ... innodb_data_file_path = /dev/dsk/c0t0d0s0:1Gnewraw innodb_data_home_dir = ... bash-2.03$ ./mysqld InnoDB: Operating system error number 13 in a file operation. InnoDB: See http://www.innodb.com/ibman.html for installation help. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name /dev/dsk/c0t0d0s0 InnoDB: Cannot continue operation. bash-2.03$ It seems to find the path but naturally the OS does not allow it to write over the file system. In your case the question is why it does not find the path (errno 2)? Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB - Original Message - From: Lou Picciano / Essex Systems [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, July 02, 2002 4:11 PM Subject: InnoDB RAW devices under Solaris? All: I am re-posting this in case someone may have an answer. RE: MySQL 4.01-max, InnoDB, Solaris, Raw device support Has anyone had any specific experience implementing a RAW DEVICE InnoDB tablespace under Sparc Solaris? A specific few lines in my.cnf would be very helpful... As we are using a SparcStorage Array, our device pathnames look something like: Innodb_data_file_path=/dev/rdsk/c1t4d0s7:1Gnewraw (OR) Innodb_data_file_path=/dev/dsk/c1t4d0s7:1Gnewraw Either of these options gives us an operating system error number 2 ... -- I have also tried things like: innodb_data_home_dir = /dev/ innodb_data_file_path = rdsk/c1t4d0s7:1Gnewraw Also with no luck. Are there specific Solaris slices we should be using?? Can't find any docs on this. Please note: using 'standard filesystem' InnoDB filespaces, everyting works AOK under this installation... Any help is appreciated. Lou - 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
problems installing 3.23.51 on BSDI 4.0.1
Hi. I am trying to install MySQL on BSDI BSD/OS 4.0.1 Kernel #3. Processor: Cpu-1 = Pentium III (448 MHz) GenuineIntel mdl 7 step 2 type 0, feat 387fbff Ram: 128M I configured using: CC=gcc CXX=gcc CXXFLAGS=-O ./configure --prefix=/usr/local/mysql --with-extra- charsets=complex and ran make. My compiler is GNU gcc. My error is as follows: gcc -DUNDEF_THREADS_HACK -I./../include -I../include -I./.. - I..-I..-O3 -DDBUG_OFF -O -fno-implicit-templates -fno- exceptions -fno-rtti -c mysql.cc cc1plus: Invalid option `-fno-exceptions' In file included from client_priv.h:19, from mysql.cc:28: ../include/global.h:686: warning: abstract declarator used as declaration *** Error code 1 Stop. *** Error code 1 Stop. *** Error code 1 Stop. Exit 1 Any suggestions? -- Jesse Guardiani, Systems Administrator WingNET Internet Services - 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_real_query, insert floats as binary
* Dave Beck ...and some bytes may represent an 'illegal' character, and thus must be escaped by a backslash... this goes for the quote character you use ( or '), the backslash character itself, and null bytes. Thanks, if I use mysql_real_query is this still the case? The doc's only mention null bytes (referred to as the '\0' character): URL: http://www.mysql.com/doc/n/o/node_686.html -- Roger - 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
two mysql questions
1. If all I want to do is use InnoDB tables for declarative referential integrity and nothing else, do I need mysql-max or can I just use the standard build of mysql 3.23.51? (Wondering about both Windows and Linus, though the answer should be the same in both places) 2. What's the best Windows based MySQL GUI out there, without regard to price? Thanks, -billb - 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: two mysql questions
As long as you need to create InnoDB table you have to use MAX binary... Check out phpmyadmin, it is totally free and operating system-independent since it runs from the server and can be used through the web browser.. Take a look at it at : http://www.phpmyadmin.net/ Gurhan - Original Message - From: Bill Bernat [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 6:14 PM Subject: two mysql questions 1. If all I want to do is use InnoDB tables for declarative referential integrity and nothing else, do I need mysql-max or can I just use the standard build of mysql 3.23.51? (Wondering about both Windows and Linus, though the answer should be the same in both places) 2. What's the best Windows based MySQL GUI out there, without regard to price? Thanks, -billb - 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
Fw: innodb is disabled, how can i make it yes?
hi guys, i use mysql 3.23.44-max-nt server, i edit c:\windows\my.ini and c:\my.cnf and c:\mysql\data\my.cnf to include the manadatorey line to be : innodb_data_file_path=c:/mysql/data/ibdata:300M then, when i restart the server and start the client, i type: show variables like have_%; --- variable_name | value --- have_bdb| yes have_innodb| disabled have_openssl | no ... --- why the innodb is disabled ? thanks in advance sql -- Hytham Shehab --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.372 / Virus Database: 207 - Release Date: 20/06/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.372 / Virus Database: 207 - Release Date: 20/06/2002 - 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: innodb is disabled, how can i make it yes?
hi Paul: Make sure it's not being started with --skip-innodb. i am sure that the --skip-innodb is not in any of my configuration files. sql -- Hytham Shehab --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.372 / Virus Database: 207 - Release Date: 20/06/2002 - 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: changing coulmn
thanx for ur mail, m sorry in dint mention that infact its a big table... Is there a way i can do it in all the columns using only one query ?? thanx anil - Original Message - From: nellA hciR [EMAIL PROTECTED] To: Anil Garg [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 2:14 PM Subject: Re: changing coulmn mysql create table mytest ( - my_1 varchar(5) - ); Query OK, 0 rows affected (0.32 sec) mysql alter table mytest change my_1 my_file_1 varchar(5); Query OK, 0 rows affected (0.23 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql show columns from mytest; +---++--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---++--+-+-+---+ | my_file_1 | varchar(5) | YES | | NULL| | +---++--+-+-+---+ On Tuesday, July 2, 2002, at 09:36 , Anil Garg wrote: in my table a column has enties my_1 my_4 my_5 i wnat to change it to my_file_1 my_file_4 my_file_5 - 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: blob versus file
Yes, but, this advice does *not* go on to describe how you cope with the deletion problem. If you store data in records in the database a DELETE will delete *all* the data for the set of rows. If some of the data is lying around in disk files these obviously don't get deleted by DELETE. So it seems to me that you need an image file garbage collection process, which every now and then scans the disk, scans the database and deletes disk files which no longer have a pointer to them from any reference field in any row in any table in the database. And of course as the file store and the database could both be changing under your feet whilst you're doing this it seems to be a good idea to shut down, or lock, the database server and the processes you've got adding disk files whilst you're doing the garbage collection. Doesn't sound to clever to me. Yes of course you could make your business logic layer clever enough to have a go at deleting the files when it deletes the database rows. But as you don't have transactions covering database operations *and* file system operations things will get out of step sooner or later so you'll still need the garbage collector. And some hints as to the viability of, say, hundreds of thousands of operating system files on the various platforms supported by MySQL would be helpful. For example many filing systems will lose *lots* of space through fragmentation like this, which one might hope would not happen with blobs. And what about the performance implications of lots of files in the same directory? - NT4 for example *will* handle half a million files in the same directory, 'cos I've tried it, but it's not terribly practical as some operations start taking tens of minutes instead of tens of milliseconds. Really one of the reasons for using a DBMS is to handle all this storage management crap for you, no? Well, sort of, yes, but only when the RDBMS can actually *help*. Storing large amounts of data is the job of a filesystem, not a database manager. RDBMS products work when : * Each item of data is relatively small * That data needs to be broken into pieces, some of which should be individually identifiable * Similar fragments from different items need to be 'related' together Bulk storage isn't really part of the metaphor. I'm building a multi-media database which references anything from names and addresses to 500 Mb video segments. The database stores the smaller items internally (names and addresses as said, small chunks of text and URLs primarily), and references everything else via a unique id. The main table relates the id, item type and location, where for the videos, the location is an external file. There are two issues in particular, one (as you said above) is the 'how do I delete something', and the other is 'how do I add a new item'. Deletion is more than the usual RDBMS delete. I mark a record to be deleted as I don't want this any more, and an external garbage collector looks for rows with this marker set and removes any external data, then deletes the row itself. You don't have relational integrity for the whole transaction, but this method handles that well (in my experience anyway) by having the delete process as a multi-stage event (the '(T)' shows the areas where transactions guarantee atomicity) : * mark all associated database entries as to be deleted (T) * delete external data referenced by database rows waiting to be deleted * delete all related database rows (T) Insertion involves looking for new files inside a recognised directory tree, the structure of which is controlled by either the user or other software modules. Anything found that the database doesn't currently know about goes into a Waiting table. A human then tells the system about the newly found file(s). For smaller items where there's no external data, the standard insert into table values (.) works. You're quite right about the dangers of huge numbers of files in a directory - most OSs these days will cope, but few cope well when the number exceeds a couple of thousand. UNIX visibly degrades at about that point. Performance is an issue with large blocks of data where ever it comes from. I'd argue that these days filesystems are better designed to cope with bulk data transfer than (most) RDBMSs. Grabbing a half-gig video segment out of any database would put a strain on the servers ability to respond well to other queries while the transfer is in progress - deleting it could prove intensive too (depends on what's indexed of course). After all, database servers also have garbage collection functions even if they are invisible. Hope this helps some (or invokes more discussion !). Regards, Paul Wilson Chime Communications - Before posting, please check: http://www.mysql.com/manual.php (the
Re: innodb is disabled, how can i make it yes?
Hytham, start mysqld-max-nt from the MS-DOS prompt: yourpathtomysqlbindir mysqld-max-nt --console What does InnoDB print? Regards, Heikki - Original Message - From: Hytham Shehab [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, July 03, 2002 2:24 AM Subject: Re: innodb is disabled, how can i make it yes? hi Paul: Make sure it's not being started with --skip-innodb. i am sure that the --skip-innodb is not in any of my configuration files. sql -- Hytham Shehab --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.372 / Virus Database: 207 - Release Date: 20/06/2002 - 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
BUG: SHOW TABLE STATUS InnoDB Tables
Hi, I have just noticed that SHOW TABLE STATUS is returning different number of rows each time you execute the query. This seams to affect only InnoDB Tables (Although I have tested only with ISAM/MyISAM/InnoDB Tables). I'm using MySQL 3.23.49Max on WIN2K. How to repeat the problem: Execute the statement SHOW TABLE STATUS many times. In some times (not all) it will return different number of rows for the same table. Have anyone else experienced this with other versions? PS: SELECT COUNT(*) FROM table is working just fine, but on InnoDB tables with large number of rows (my tables have -+ 30 records each) it take a few seconds to get the results. This is not a big issue for me, but I'd like to confirm that. Thanks, []'s Crercio O. Silva - 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: SHOW TABLE STATUS InnoDB Tables
Crecrio, - Original Message - From: Crercio O. Silva [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, July 03, 2002 3:49 AM Subject: BUG: SHOW TABLE STATUS InnoDB Tables Hi, I have just noticed that SHOW TABLE STATUS is returning different number of rows each time you execute the query. This seams to affect only InnoDB Tables (Although I have tested only with ISAM/MyISAM/InnoDB Tables). I'm using MySQL 3.23.49Max on WIN2K. How to repeat the problem: Execute the statement SHOW TABLE STATUS many times. In some times (not all) it will return different number of rows for the same table. Have anyone else experienced this with other versions? this is the documented behavior. For InnoDB tables it returns an estimate of the row count, based on 8 random dives into the clustered index tree. For MyISAM it returns the accurate number, because MyISAM separately keeps and stores the row count of a table. PS: SELECT COUNT(*) FROM table is working just fine, but on InnoDB tables with large number of rows (my tables have -+ 30 records each) it take a few seconds to get the results. This is not a big issue for me, but I'd like to confirm that. Thanks, []'s Crercio O. Silva Best regards, Heikki Innobase Oy (sql database) - 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 install on W2K server running Apache ver2.0.39
Hello all... I'm new to the list and to MySql and would like to get some advice on approaching my first mysql install. I've just installed Apache ver2.0.39 onto my W2K server and I'm currently attempting to get PHP4 going. Can anyone provide me with some ideas on how to approach the mysql install? Is it anything like installing SQL 2000? Or should I treat it like Apache and approach it with a Linux Unix mentality? Which version should I choose? Let me say that I am still navigating my way through the mysql site, so I'm pretty sure that I'll eventually come across the answer to some of these questions. I'm mainly looking for hands on experience. Thanks in advance. - 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