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 --- - 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
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]> > Date: Tue, 21 Jan 2003 09:05:52 -0500 > Reply-To: "FlashGuy" <[EMAIL PROTECTED]> > Priority: Normal > X-Mailer: PMMail 2000 Standard (2.20.2502) For Windows 2000 (5.1.2600;1) > MIME-Version: 1.0 > Content-Type: text/plain; charset="iso-8859-1" > Content-Transfer-Encoding: 7bit > Subject: 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 install it on a "fresh" pc (never had it installed before) it works OK. --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ===END FORWARDED MESSAGE=== --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- - 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 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 install it on a "fresh" pc (never had it installed before) it works OK. --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- - 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: 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 Access into MySQL? > If so how? > I have a huge amount of data that will take weeks to input and I've > convinced my boss to use MySQL rather than any other DB because of it's > compatibility with PHP. However I (probably hastily) *assumed* that > there would be a way to export the data. > Any ideas? > > Steve Jackson > Web Developer > Viola Systems Ltd. > http://www.violasystems.com > [EMAIL PROTECTED] > Mobile +358 50 343 5159 > > > - > 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 > --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- - 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
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 = '' strOmit = 'D:\test\dir2,D:\test\dir4 My 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
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 [ ] dir3 [ ] dir4 [ ] dir5 [ UPDATE ] Preferences: (Click to add directories to listing) No directories selected. [ UPDATE ] So if the user checked on boxes dir2 and dir4 and clicks on the "update" I then want the screen to appear like: [ ] dir1 [ ] dir3 [ ] dir5 [ UPDATE ] Preferences: (Click to add directories to listing) [ ] dir2 [ ] dir4 [ UPDATE ] I'm not how to make this happen using my queries? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- - 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
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.txt" So in my query I want to just display the match of "D:\mywork" and nothing else. Can this be done in SQL? SELECT * FROMprofiles WHERE strUsername = '#auth#' --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- - 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
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 --- - 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
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 delimiters separating each field. MySQl fields and settings: ID (Type: TinyINT(3), Primary Key, autoincrement) var (longtext) destination (longtext) Access fields: ID (generated automatically by Access) var destination When I import the text file anf go into data I should have 841 entries but I only see 127? I see no text in the fields other than (Memo). What am I doing wrong? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- - 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 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. 1045 - Access denied for user administrator@sevenofnine/ (Using password: YES). What am I doing wrong. The username/password are correct. The mySQL service is started... --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- - 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
