RE: text records and cross referencing
Gavin Towey wrote: > Hi Pol, > > MySQL support FULLTEXT indexes, and natural language searches, including > Boolean conditions. This may help you; however, you will have to adjust > the default behavior of the index, but changing server settings. By > default there is a minimum word length which you will have to adjust, and > a list of stopwords (words to ignore.) Both of these will prevent you > from indexing each and every word, and even still words that show up in > most or all records will be ignored (and I don't know if you can change > that behavior.) The alternative, is using unindexed lookups, which would > be very slow for any non-trivial application. > Thank you for you references. I am not an expert, so i hope to find a smart interface to mysql to set up the server. > > In all honesty, if this really is a "personal" application, you may be > better off using another, simpler method. What are your suggestions? Thank you --Pol -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Inquiry:MySql table data missing problem
In the last episode (Aug 20), hadi motamedi said: > Can you please do me favor and let me know what is wrong with my MySql db > installed on Linux server that causes to get the following error message : > "Fail to insert cdr:Can't open file: 'cdrFromMSC_06.MYD'. (errno: 145)" $ perror 145 MySQL error code 145: Table was marked as crashed and should be repaired $ You need to repair your table: http://dev.mysql.com/doc/refman/5.1/en/repair.html -- Dan Nelson dnel...@allantgroup.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Inquiry:MySql table data missing problem
Dear All Can you please do me favor and let me know what is wrong with my MySql db installed on Linux server that causes to get the following error message : "Fail to insert cdr:Can't open file: 'cdrFromMSC_06.MYD'. (errno: 145)" Your reply is highly appreciated Regards H.Motamedi
Re: Renaming a Database
No... I've pretty much avoided those. This WAS a Visual FoxPro app so we're still at the stage where we really aren't "leveraging" MySQL specific features. We're still pretty much just eliminating VFP specific things. Hence the one time nature of this renaming. Now that we're 5-10 customers in to upgrading we decided to actually define a naming convention for the databases themselves so I've got to fix the 5-10 that are already out there (I could not change it... but then we have to "remember" that these are special cases) On Wed, Aug 19, 2009 at 10:28 AM, Rolando Edwards wrote: > If you have stored procedures, don't forget to update the db column with the > new db in mysql.proc as that does not automatically change. > > Rolando A. Edwards > MySQL DBA (CMDBA) > > 155 Avenue of the Americas, Fifth Floor > New York, NY 10013 > 212-625-5307 (Work) > 201-660-3221 (Cell) > AIM & Skype : RolandoLogicWorx > redwa...@logicworks.net > > -Original Message- > From: Matt Neimeyer [mailto:m...@neimeyer.org] > Sent: Wednesday, August 19, 2009 9:27 AM > To: Paul DuBois > Cc: mysql@lists.mysql.com > Subject: Re: Renaming a Database > >>> That said... Is there anything "wrong" (dangerous, disasterous, etc) >>> with stopping the MySQL service and renaming the folder in the MySQL >>> data folder? By my logic (if I'm right) this should preserve any >>> permissions on the folder and since the service is stopped it should >>> simply find the new instance. > >> If you have InnoDB tables, there will be a problem. InnoDB maintains the >> database name in the shared tablespace, and it will no longer be able to >> find those tables. > > Nope. These are entirely MyISAM tables... So I will probably give this > a try then. > > Matt > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=redwa...@logicworks.net > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: text records and cross referencing
Hi Pol, MySQL support FULLTEXT indexes, and natural language searches, including Boolean conditions. This may help you; however, you will have to adjust the default behavior of the index, but changing server settings. By default there is a minimum word length which you will have to adjust, and a list of stopwords (words to ignore.) Both of these will prevent you from indexing each and every word, and even still words that show up in most or all records will be ignored (and I don't know if you can change that behavior.) The alternative, is using unindexed lookups, which would be very slow for any non-trivial application. See: http://dev.mysql.com/doc/refman/5.0/en/tutorial.html http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html The highlighting and switching behavior is up to your application. MySQL just stores data, it's up to you to write programs that manipulate it. In all honesty, if this really is a "personal" application, you may be better off using another, simpler method. Regards, Gavin Towey -Original Message- From: news [mailto:n...@ger.gmane.org] On Behalf Of Pol Sent: Wednesday, August 19, 2009 2:38 AM To: mysql@lists.mysql.com Subject: text records and cross referencing Hi i am very new to mysql. I am playing around with it to test it as a personal vocabulary and language expression manager. Main field would be a passage from a text work, where each word is searchable. Any experience and reports about such use? A further questions is about the possibility to make cross references, that is 1) highlighting all records that have been connected (by the user) to the displayed record 2) switching from a record to another one, within the same database. Thank you ---Pol -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=gto...@ffn.com The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Renaming a Database
If you have stored procedures, don't forget to update the db column with the new db in mysql.proc as that does not automatically change. Rolando A. Edwards MySQL DBA (CMDBA) 155 Avenue of the Americas, Fifth Floor New York, NY 10013 212-625-5307 (Work) 201-660-3221 (Cell) AIM & Skype : RolandoLogicWorx redwa...@logicworks.net -Original Message- From: Matt Neimeyer [mailto:m...@neimeyer.org] Sent: Wednesday, August 19, 2009 9:27 AM To: Paul DuBois Cc: mysql@lists.mysql.com Subject: Re: Renaming a Database >> That said... Is there anything "wrong" (dangerous, disasterous, etc) >> with stopping the MySQL service and renaming the folder in the MySQL >> data folder? By my logic (if I'm right) this should preserve any >> permissions on the folder and since the service is stopped it should >> simply find the new instance. > If you have InnoDB tables, there will be a problem. InnoDB maintains the > database name in the shared tablespace, and it will no longer be able to > find those tables. Nope. These are entirely MyISAM tables... So I will probably give this a try then. Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=redwa...@logicworks.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Renaming a Database
>> That said... Is there anything "wrong" (dangerous, disasterous, etc) >> with stopping the MySQL service and renaming the folder in the MySQL >> data folder? By my logic (if I'm right) this should preserve any >> permissions on the folder and since the service is stopped it should >> simply find the new instance. > If you have InnoDB tables, there will be a problem. InnoDB maintains the > database name in the shared tablespace, and it will no longer be able to > find those tables. Nope. These are entirely MyISAM tables... So I will probably give this a try then. Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
text records and cross referencing
Hi i am very new to mysql. I am playing around with it to test it as a personal vocabulary and language expression manager. Main field would be a passage from a text work, where each word is searchable. Any experience and reports about such use? A further questions is about the possibility to make cross references, that is 1) highlighting all records that have been connected (by the user) to the displayed record 2) switching from a record to another one, within the same database. Thank you ---Pol -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org