RE: MySQL Authors Needed
Subject: MySQL Authors Needed Hi, I am looking for experienced writers who would like to write a complete and authoritative reference on MySQL. Thanks, Chris Johnson Paul DuBois has already done a bang-up job. His book, MySQL (New Riders), is the bible as far as I'm concerned, and I think alot of people here would agree. Jay Fesco Magical Mystery Words: database,sql,query,table - 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: A space is contained in colum??
When I create a table, one colum contains a space, how can I caeate it correctly? like: CREATE TABLE mytable( name CHAR(60) NOT NULL, Email VARCHAR(50) NOT NULL, Thrid colum CHAR(60), ///Here there is a space? PRIMARY KEY (Email) ); MySQL does not allow spaces in column names. Try: ThridColum CHAR(60), - 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: general sql question
select count(distinct(email)) from subscribes; But that's not legal. Any thoughts/ideas you all could send in would be great. TIA! Chris Blessing [EMAIL PROTECTED] http://www.330i.net Try: select count(distinct email) from subscribes; Jay Fesco Magical Mystery Words: database,sql,query,table - 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: How to Dump only Data
From page 620 in MySQL... * -t or --no-create-info Does not write CREATE TABLE statements Since DROPs are off by default, this should give you just the insert statements. The other option (as already suggested) is SELECT INTO OUTFILE. Jay Fesco -Original Message- From: fi-claudemir [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 12:55 PM To: mysql Subject: How to Dump only Data Hi How to Dump only the data from a Table. I took a look at the mysqldump options, but I didn't find something that works fine ! Regards Claudemir F. Martins - 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 - 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: need for strength
Hi We have a sophisticated Underwiting management system written in MS Access. The programs and the data are in separate mdb's. The time has come to improve the product's client/server and web strengths. We came across mysql whilst investigating MS SQL server. Can we upsize our Access database to mysql easily and continue to use the Access programs to work with the mysql data? Thank you Chris Needs Peter Jacobsohn Telek Systems Chris Peter, The code will work with slight modifications AS LONG AS the database doesn't use subselects, stored procedures, stored queries, or (I just learned - thanks, Will!) joins in updates or deletes. I had to convert a 'sophisticated' website from Access to MySQL about a year ago, and there are many times that I felt I'd be better off recreating the database from scratch. The sheer volume of data (and the extremely denormalized structure of the original db) kept me from doing just that. There is no clear-cut yes or no here. You will have to look closely at the code and the original database. Yes, it can be done, but there is the possibility of a major rewrite of your code. Good Luck! Jay Fesco - 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: Update problem
imho, the fact that mysql does not support joins in UPDATE and DELETE statements is by far its greatest weakness. I have posted a couple of messages to this group to see what creative work-arounds others have used to fill this gaping hole in functionality. Alas, no one has felt like sharing their thoughts on this subject. Will (and Phil) I think no-one's replied because the answer is really simple - create a recordset using Select for the records you are interested in (using your joins), then use that recordset to perform your UPDATE or DELETE. I have to deal with the same situation Phil describes quite often, but I've never missed the 'join in update' function. Not that it wouldn't be nice, but the workaround is not rocket surgery. Jay Fesco - 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: Update problem
Will, First of all, if I sounded condescending, it was not my intent. I apologize if that's how you (or anyone else) took it. I will, however, respond to your smoking response to mine: I think no-one's replied because the answer is really simple Oh I don't know Jay, I've seen some threads 4-5 responses deep to issues far simpler than this. That does not make those questions and answers on-topic and appropriate or your question any more complex. I understand that you could use REPLACE with this newly created recordset to simulate the UPDATE w/JOIN, but your it's so simple response glosses over the details of what to do with the delete. The only way I've conceived is to carry an isdeleted... Perhaps you're using the wrong scripting language. Just because you have a hammer does not make everything a nail. Well I'm happy for you but did you ever stop and consider that what you do with your database may not necessarily be representative of what everyone does? Let's see - I read records, I do something with them, I update and delete them... No, I never stopped to think that you (or anyone) might be doing something different. In my situation, one that is certainly not unique, I have tables with 100+ fields and many million rows. The SELECT INTO/REPLACE FROM and SELECT INTO/REPLACE FROM/DELETE WHERE approaches to UPDATE FROM and DELETE FROM are an order of magnitude less efficient. This inefficiency coupled with the need (using myisam) to lock the entire table during updates makes for some not-so-simple design challenges. So you feel that forcing a lock while you do a huge join/delete is more efficient than: * Doing a select (using joins) against your properly indexed table (which should NOT require a lock in that you only want the record ID's) * Using the method of your choosing, deleting or updating the records so identified? I don't know the benchmarking which compares a WHERE IN() versus issuing individual updates/deletes while the table is open, but it would be easy enough to test. In closing, I offer a couple rhetorical questions: 1. Who is the bigger idiot... The person who asks a naive question or the person who, upon hearing a question he knows the answer to, assumes the asker is an idiot? Never did I assume that you were an idiot. What I assumed (and still do) is that you are overcomplicating the question. 2. Does your condescending attitude win you as many points with your users as it did with me? Will French I haven't had a complaint from my users yet. Again, If I sounded condescending, it was not my intent. Jay Fesco - 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: I'm sure this should be simple but I can't get it
Hi all, I'm trying to create a query that returns a set of data based on two tables. A basic description is that If Column A in Table 1 is Equal to Column A in table 2 then it returns the data from Column B in Table 2. However, Column A in Table 1 may contain a list of words that need to be matched not just one single entry. If someone could point me in the right direction for some code or a solution I would be very appreciative. select Table2.ColumnB from Table1, Table2 WHERE Table1.ColumnA = Table2.ColumnA Jay Fesco Magical Mystery Words: database,sql,query,table - 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: I'm sure this should be simple but I can't get it
A basic description is that If Column A in Table 1 is Equal to Column A in table 2 then it returns the data from Column B in Table 2. However, Column A in Table 1 may contain a list of words that need to be matched not just one single entry. If someone could point me in the right direction for some code or a solution I would be very appreciative. select Table2.ColumnB from Table1, Table2 WHERE Table1.ColumnA = Table2.ColumnA And just in case I misunderstood the intent: If 'Column A in Table 1' has space-delimited words in each record such as: abc def ghi I believe you could use a combination of CONCAT and REPLACE. The WHERE clause would look something like: WHERE Table2.ColumnA IN (CONCAT('',REPLACE(Table1.ColumnA,' ',','),'')) I haven't tested this at all and it may fail miserably, but it's where I would start. Jay Fesco Magical Mystery Words: database,sql,query,table - 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: Semi colons in text fields in update statement
There is no need for such an escape sequence because semicolons in strings are not special. Maybe it's an ADO bug. Paul et al - I think his problem is with quotes, not semicolons. The line Update tblCompany SET CoName='quot\;testerquot\;' WHERE CoID=109 is what leads me to believe this. Try double-escaping your quotes. A single escape usually only works until the first time it's referenced in code, at which time it is unescaped and becomes a straight quote again. I've had problems with this as well, but \\ seems to work well. A RegExp replace on the fly just before the update is how I usually handle it in ASP. Jay Fesco Confusing issues since 1963 Magical Mystery Words: database,sql,query,table - 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: Help!
I try the following command, and get that error every time: mysql select company, tele, contact, mariacust.comments - from - customers where tele = mariacust.tele GROUP BY company; ERROR 1109: Unknown table 'mariacust' in field list mysql I don't quite understand why this happens since everything exists Armando Everything may exist, but you didn't reference mariacust in your _from_ statement. select customers.company, customers.tele, customers.contact, mariacust.comments from customers, mariacust where custmers.tele = mariacust.tele GROUP BY customers.company; Or something like that... Jay Fesco Magical Mystery Words: database,sql,query,table - 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: reset auto_increment?
Can someone tell me how to reset a column's auto_increment starting point back to 0 in mysql ? Thanks Paul According to Paul DuBois on page 169 of MySQL by New Riders (which you should buy): ALTER TABLE t DROP i, ADD i INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY Jay - 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: copying information
Dear Sirs, I have a database with a lot of information. Can I copy that information to another server??? It's because I'm gonna change of hosting company!!! (I use PHP and Perl) Thanking in advance, Nuno Lopes MySQLDump is what you need, and is quite well documented (many examples exist in the list archives as well.) Good luck! Jay Fesco - 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: Size of DB
I'm new to MySQL and I was wondering if there was a command that you can issue to see the current size of a mysql database (in kb or MB)? If your intent is to get the size 'on the fly' from within a web page, you can use the filesystem object. I use ChiliSoft ASP but the solution is the approximately the same for IIS ASP: Syntax for a function to return filesize (in JScript/ASP) is: function ShowFileSize(filespec) { var fs, f, s; fs = new ActiveXObject(Scripting.FileSystemObject); f = fs.GetFile(filespec); s = f.Name + uses + f.size + bytes.; Response.Write(s); } Jay Fesco Magical Mystery Words: database,sql,query,table - 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: errors 2006 and 2000
create table saveMovie ( - id int not null auto_increment, You attempted to create a table without telling MySQL which database to use (or without creating a database in the first place). Either: \u MyDatabaseName -OR- create database MyDatabaseName; \u MyDatabaseName; before trying to create a table. Jay Fesco Magical Mystery Words: database,sql,query,table - 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: mysqldump question (very basic)
Hi. I'm trying to run a mysqldump. I enter mysqldump -databases in order to backup all the databases. For some reason all I'm getting back is a help on the mysqldump. What am I doing wrong? thanks = It returns help whenever it doesn't understand what you're asking it to do (or if your command is incomplete.) The following line works to backup a remote database to a local PC - Running the same version of MySQL both places, and a user is setup on the MySQL server that allows remote read (IP-restricted in my case, but I have a fixed IP): c:/mysql/bin/mysqldump -h www.mydomain.com -u UserID -pPassword --add-drop-table MyDBName c:/ServerDumps/MyDBName.sql I run a batch job with one of these for every database every day. Hope that gets you started! Jay Fesco - 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: Licensing terms for an Intranet site
-- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 Is anyone else getting a strange flag associated with Jeremy's email, or is it just me? Every one of his posts comes in flagged in Outlook, and the headers have a line which reads: X-message-flag: Mailbox corrupt. Please upgrade your mail software. This is definitely OT for this forum, but this forum is the only place where I see the problem. Jay database,sql,query,table - 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: Licensing terms for an Intranet site (way beyond OT)
i think this is jeremy's not-so-subtle way of bashing your choice of email client. check this link: http://www.rodos.net/outlook/#messageflag -ravi. Yeah, yeah - I got it. Only problem is that I DON'T have a choice (company policy et al)... \:^{ Jay Fesco Magical Mystery Words: database,sql,query,table - 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: COUNTNULL function
Calvin, Maybe I'm just confused (fairly likely), but it appears that you are confusing 'null' with zero. If you actually want to count all values including nulls, COUNT(*) will do it. If you want to count NON nulls, COUNT(a_field_name) does it. SUM(a_field_name) returns the sum of all non-null values for a_field_name. Appropriate WHERE, IN, or NOT IN clauses combined with a version of the COUNT and/or SUM functions should give you the results you need. Jay Evening Gurus, I have a small problem that I've beaten to death the past 2 days. I am trying to get the value of a row, and update another table accordingly. The data within the row is either a 1 or 0. My issue is in trying to increment a count for both 1's and 0's. In other words, I want to SUM up all the 1's and update a table with this sum. I also want to sum up all the 0's and add this total count to the table as well. This can be accomplished in a long query, or in through a language..what I am trying to accomplish is to get the total sum of each value without using a WHERE clause. Something akin to: SELECT ... SUM(bool_was_connected), COUNTNULL(bool_was_connected), etc... the SUM will sum up all non-null values. The COUNTNULL would sum up all rows which have a value of 0. Does anyone have a UDF for this function? I currently don't have room on my laptop to download the mysql source code in order to write this up. ( Also have not written a udf for mysql up to this point either) Thankyou kindly for any reply, Calvin - 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: selecting what is not in something
Jeff, If the result table from the inner select is not huge, I usually issue the inner query by itself first, then build (in my scripting language of choice) a comma-delimited text field containing the results that I don't want in my final table. I then expand that text field into the 'NOT IN' clause, quoted as appropriate. It works reasonably well, but I haven't benchmarked the speed issues with large results from the inner query. Hope that helps. If MySQL asks me, my TOP priority is INNER SELECTs. But that's probably just me... Jay Fesco -Original Message- From: Jeff Shipman - SysProg [mailto:[EMAIL PROTECTED]] Sent: Monday, August 27, 2001 11:38 AM To: [EMAIL PROTECTED] Subject: selecting what is not in something I have two tables and that have a couple of identical columns. I would like to find out what of a certain column is in one table and not in another. I've tried the following, but I get errors: select col1 from tab1 where col1 not in (select col1 from tab2); select tab1.col1 from tab1,tab2 where tab1.col1 not in tab2; Please tell me how I can do this type of query. Jeff Shipman E-Mail: [EMAIL PROTECTED] Systems Programmer Phone: (505) 835-5748 NMIMT Computer Center http://www.nmt.edu/~jeff - 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 - 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: Import from Access to MySql
snip Anyone can tell me how can i import an access db to mysql. /snip Go to http://www.mysql.com/downloads/contrib.html. Many contributed tools plus a couple of macros that are run from within Access. Jay Fesco - 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: aggressive dolphin?
snip ...I am somewhat disappointed that you chose the dolphin for your logo because of the good nature of this animal. ...dolphins seem to have murderous urges unrelated to the need for food. /snip Theo, are you still irritated that the rest of us got our 'So Long and Thanks For All The Fish' fishbowls and you didn't? I think Douglas Adams had it right on the mark... (If you don't get the reference, you will need to read the inappropriately named Hitchhikers Guide to the Galaxy trilogy) \:^) (We need a 'Sorry for the emoticon' emoticon) Jay Fesco database,sql,query,table - 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: WANTED: Utility to reverse engineer existing database II
...Some of my tables have thousands of records and I may only want the first 200 or so. I did not see an option on mysqldump that would limit the number of records. Any ideas without writing a program? Kevin Try the WhereClause option in mysqldump. Syntax is: -w 'where_clause' -or- --where='where_clause'. Of course, 'where_clause' would be something like 'id200' or whatever's appropriate. It's on page 620 of 'MySQL' by Paul DuBois (New Riders). Invaluable book, btw. Jay Fesco - 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: WANTED: Utility to reverse engineer existing database
Or you can just use the whereclause option in MySQLDump. (i.e. -w'RecordID200') http://www.mysql.com/doc/m/y/mysqldump.html Jay -Original Message- From: Stefan Hinz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 11:47 AM To: Kevin; [EMAIL PROTECTED] Subject: Re: WANTED: Utility to reverse engineer existing database Dear Kevin, index, etc.) needed to recreate the database. Does such a utility exist? Yes. It's called PhpMyAdmin, and the recent version supports everything you asked for. You can get it at www.sourceforge.net - look for PhpMyAdmin there. Note: You need to have PHP installed in order to run this toolset. Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - From: Kevin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 06, 2001 10:57 PM Subject: WANTED: Utility to reverse engineer existing database I need a utility that will probe my existing mysql database, analyze the 90+ tables and spit out the data definition language (create table, create index, etc.) needed to recreate the database. Does such a utility exist? Kevin - 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 - 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 - 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: client/server
Hello! I'm a newbie at mysql and i'm looking for a client program for win23 that can accsess a mysql database and create and alter tables. The mysql database is placed on a linux box in my lan, and im not too keen of sitting in console. The linux box also holds the apache server,with php but i edit all my code on the win2k box. Thanks in advance Lasse Lasse - Go to www.mysql.com and get the Win32 version of MySQL and MyODBC. There are numerous GUI tools available for Windoze, but I find myself just using the command line version most of the time. I fully emulate my Linux MySQL environment on my Win2k machine for development, which is what I believe you want to do. Good Luck! Jay F. - 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: MySql Server creating problem
hi, I am working on linux. my mysql server is creating problems. when i do ./mysqld start, i get server started ok. But i am not abel to login the message i get is ERROR 2002: Can't connect to local MySQL server through socket' /var/lib/mysql/mysql.sock' (2) and when i try to stop the server, i get the mesage failed. what couldbe the problem? -- K.S.Selva Prakash Tachyon Technologies Pvt Ltd. Selva - this can indicate that either mysql.sock is owned by the wrong user (it should either be root or mysql on most machines) or that it is not located in the correct place. The mysql.sock that you refer to is PROBABLY a link to the 'real' mysql.sock located in another directory. It could be a recursive link, or just linked to a non-existant file. FIND for mysql.sock on your machine and see how many places it lives, then verify that the one giving the error (/var/lib/mysql/mysql.sock) is linked to the 'real' one. This may NOT be your issue, but it happened on our box after a reload of MySQL. Good luck! Jay Fesco - 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