text records and cross referencing

2009-08-19 Thread Pol
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

Re: Renaming a Database

2009-08-19 Thread Matt Neimeyer
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

RE: Renaming a Database

2009-08-19 Thread Rolando Edwards
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 :

RE: text records and cross referencing

2009-08-19 Thread Gavin Towey
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,

Re: Renaming a Database

2009-08-19 Thread Matt Neimeyer
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

Inquiry:MySql table data missing problem

2009-08-19 Thread hadi motamedi
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: Inquiry:MySql table data missing problem

2009-08-19 Thread Dan Nelson
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