Re: Renaming a Database

2009-08-17 Thread Paul DuBois
On Aug 17, 2009, at 4:22 PM, Matt Neimeyer wrote: I know the "best" way to rename a database is to use mysqldump, extract the database and then reload to the new database. (At least based on what I can find in the "12.1.32. RENAME DATABASE Syntax" section of the documentation) That said... Is

Renaming a Database

2009-08-17 Thread Matt Neimeyer
I know the "best" way to rename a database is to use mysqldump, extract the database and then reload to the new database. (At least based on what I can find in the "12.1.32. RENAME DATABASE Syntax" section of the documentation) That said... Is there anything "wrong" (dangerous, disasterous, etc) w

Fulltext query expansion query

2009-08-17 Thread Mark Goodge
Hi, I'm currently working on a project which uses fuulltext searching. The "with query expansion" feature is useful, but I was wondering if there's any way to obtain the list of terms that the expanded query uses (other than those originally input, of course). Is that possible, and, if so, how

Re: Is there a way ?

2009-08-17 Thread Martijn Tonies
Hello Miles, I'm a little rusty in my SQL statements, and I'm not all that certain that this can be done. IF I have a field with the contents like: "http://beta.somedomain.com/url/url/url=2"; where 2 is the record ID value. And I need to change the contents of That is rather "unfortuna