MySQL admin

When I go into the "Database" tab of my SQL Admin I don't see any databases? Should I not see the ones that are in the datadir path? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba ---

Fwd: MYsql won't run

Well...I uninstalled mysql and installed it again and I still can't get the service to run!!!??? ==BEGIN FORWARDED MESSAGE== > From: "FlashGuy" <[EMAIL PROTECTED]> > To: "FlashMX" <[EMAIL PROTECTED]> > Da

MYsql won't run

Hi, I had MYsql running on a nt4 server and w2k server. I uninstalled it a few weeks ago and just recently tried installing it again. The install went fine but when I start the service I keep getting an error no maater what I try. Using localhost and administrator. Whats going on? If I instal

Re: Is it possible to export data from access to MySQL?

Download MySQL-Font v2.5 This is what I used when I switched from Access to MySQL. Once installed just load MySQL-Front and click on "Im-/Export" on the toolbar. Select ODBC Import. Viola! On Tue, 26 Nov 2002 16:37:45 +0200, Steve Jackson wrote: > Is it possible to export data from MS Acce

Deleting matches from one field into another???

Hi, I'm hoping I can explain this better so here it goes. I'm using ColdFusion and MySQL. My database has the following fields and what they contain: strUser_ID (auto-generated) strUsername = 'Bill' strSelect = 'D:\test\dir1,D:\test\dir2,D:\test\dir3,D:\test\dir4,D:\test\dir5' strSelectFlag = '

SQL statements howto

Hi, What SQL statements do I have to use to get the following results? I have a preferences page that lists directories with check boxes. This is displaying by querying my database. It looks something like this: Preferences: (Click to omit directories from listing) [ ] dir1 [ ] dir2 [ ] d

ColdFusion and mySQL

Hi, How can I display only certain occurences from my database based on a certain critieria. In the filed "strSelect" I could have a long string which would contain: strSelect = "D:\temp\file.txt,D:\temp\file2.txt,D:\mywork\file.txt,D:\mywork\file.txt,D:\documents\file.txt,D:\documents\file.t

Identical entries

Hi, I have a database which has identical entries. Is there a way to tell mySQL to throw out duplicate entires when un insert/update is done via ColdFusion? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba -

OT: CF and mySQL - cont'd thread

I don't know what I'm doing wrong. I've check the DOC but I can't seem to import a comma-delimited text file exported from Access into mySQL. I've created the database, table and fields. WHen I do a Import texfile everything looks OK via MySQL-Front. My text file contains only commas as delimit

MySQL for W2K

Hi, I'm having a little trouble. I've installed mySQL. I've started the service via WinMySQL admin. I was able to create my databases. I also installed MySQL-Front and DBTools. The problem is when I startup any of the tools and try to create a connection I get a MySQL Error - COnnection failed