Re: Thoughts on MySQL training?
Hi Rachel, I attended the week long training last year and I found it to be very helpful. Even if you know the basics this will cover some advanced material and also provide better ways to do the things you already know. Bhavin. - Original Message - From: Rachel Rodriguez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 4:30 PM Subject: Re: Thoughts on MySQL training? I should have been more specific: we're looking at the Using and Managing MySQL training. Opinions appreciated. ~RR --- Rachel Rodriguez [EMAIL PROTECTED] wrote: I was wondering if anyone on the list has attended any of the training listed on the mysql.com site. If yes, was it worth the costs in your opinion? I'm trying to justify the costs to my management. Thank you, Rachel = __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Help With Default Value
First option, I don't think, is possible. Reg. 2, You can get MAX(Id) before inserting, increment it by 1 in your script and then Insert 'gcId' as the invoice_id value. Bhavin. - Original Message - From: MySQL List [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, March 30, 2003 7:23 PM Subject: Help With Default Value I am trying to do one of two things. First I'd rather do this, but if not possible, then the other way that I'll describe will suffice. 1) I need to have a default value of a column named invoice_id be this: Column names of importance: idinvoice_id id is auto_increment and BIGINT unsigned. invoice_id needs to be gc+ id How can I have invoice_id have that as default? in other words if it's inserting data into that table, and it's the first record, then id would = 1. So I need invoice_id to be gc1 Is that possible? 2) If 1 is not possible, then how can I get the value of id of the one I just inserted? Is it possible to get that at the same time as I insert it, so I can then UPDATE that invoice_id with the correct data? If I need to clarify this, please by all means do let me know. Thank you, kindly, Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Validations
I don't think Validation is possible. Look up ENUM, which is very different, but just might help you a little. - Original Message - From: warm-fusion [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, March 30, 2003 5:25 PM Subject: Validations Hi, I'm a newbie to MySQL, and I'm wondering whether there is any way to set validations on acceptable field values when using the 'create table()' etc. statements? I've performed a (most cursory) search of the documentation, but that didn't turn up anything useful. Any suggestions? Many thanks! Marc On two occasions I have been asked [by members of Parliament!], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question. ~Charles Babbage -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql.sock
Specify the location in my.conf or ...create a sym link in /tmp. - Original Message - From: Joseph Bannon [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 28, 2003 8:50 PM Subject: mysql.sock The mysql.sock file is being saved at the location below /var/lib/mysql/mysql.sock ...which causes me to get this error... ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) How can I fix this? Thanks, Joseph __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql.sock
My mistake. my.cnf. It should be in /etc or /var/lib/mysql. If not, you can create one. - Original Message - From: Joseph Bannon [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, March 28, 2003 10:28 PM Subject: Re: mysql.sock Specify the location in my.conf or ...create a sym link in /tmp. Where is the my.conf file? J. __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1130
restart the server with the --skip-grant-tables option and then add users. - Original Message - From: Anthon Tagor [EMAIL PROTECTED] To: Bhavin Vyas [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, March 24, 2003 11:31 PM Subject: Re: ERROR 1130 Mr. Vyas But sir, i cannot log in to mysql server. How can i apply GRANT command..? On Mon, 24 Mar 2003 23:05:27 -0500 Bhavin Vyas [EMAIL PROTECTED] wrote: You don't have permissions. Look up GRANT on www.mysql.com. - Original Message - From: Anthon Tagor [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 24, 2003 10:30 PM Subject: ERROR 1130 Hi all.. I am beginner in mysql. I had install mysql in winnt4. I accidently delete all users in mysql database so i cannot connect to mysql server, the message is : ERROR 1130: Host 'localhost' is not allowed to connect to this MySQL server Does anybody give solution to my problem regards Anthon === = === Malas antri buat mendapatkan print-out tagihan telepon ? Klik aja http://billinfo2.plasa.com Gratis Perpanjangan dan Pendaftaran Nama Domain http://idc.plasa.com khusus di bulan Maret ! === = === -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] === Malas antri buat mendapatkan print-out tagihan telepon ? Klik aja http://billinfo2.plasa.com Gratis Perpanjangan dan Pendaftaran Nama Domain http://idc.plasa.com khusus di bulan Maret ! === -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Warning: mysql_select_db() [function.mysql-select-db]: Can'tconnect to local MySQL
It is probably looking for a socket file that doesn't exist. Check to see if it does. Also check to see if DB server is running. Bhavin. - Original Message - From: Jose [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 15, 2003 3:03 PM Subject: Warning: mysql_select_db() [function.mysql-select-db]: Can't connect to local MySQL I get this error after upgrade my server aix 4.3.3.10 to 4.3.3.11: Warning: mysql_select_db() [function.mysql-select-db]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock Any one can tell me what could be the problem ? Thanks. Tu portal de Aix en EspaƱol http://aixpanish.com - 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: MyISAM Database on multiple partitons
In my.cnf you can configure the Data dir path. Else, symlinks might work. - Original Message - From: Anirudha Kukreti [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, February 23, 2003 11:36 PM Subject: MyISAM Database on multiple partitons hi, i have MyISAM database on my root pattition which is now getting full, however i have an empty 5Gb partion, how configure MySQL to now start storing my DB on to the new partition. In nut shell my question is how can we have a MyIsam database on multiple partions? thanks anirudh mysql, query - 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
Help with default NULL
Hi, I have a table Log described as such: +--+---+--+-+-+---+ | Field| Type | Null | Key | Default | Extra | +--+---+--+-+-+---+ | rec | int(1)| YES | | NULL| | | time | int(10) | | | 0 | | | ct | char(100) | YES | | NULL| | +--+---+--+-+-+---+ Notice that default for ct is NULL. Now I have a ^ separated line in my file which I am loading via LOAD FILE. This line MAY or MAY NOT have the corresponding ct value. So, it could either be ^www.yahoo.com^(ct value) or .^^.(no ct value). I would like that when there is no ct value present in the line, the ct value in Log table should stay as the default NULLbut it is not. The value becomes '' i.e. a zero length string. Any ideas on how can I keep it as NULL? Any help is much appreciated. Thanks in advance, Bhavin. sql, mysql, query.
Help with default NULL
Hi, I have a table Log described as such: +--+---+--+-+-+---+ | Field| Type | Null | Key | Default | Extra | +--+---+--+-+-+---+ | rec | int(1)| YES | | NULL| | | time | int(10) | | | 0 | | | ct | char(100) | YES | | NULL| | +--+---+--+-+-+---+ Notice that default for ct is NULL. Now I have a ^ separated line in my file which I am loading via LOAD FILE. This line MAY or MAY NOT have the corresponding ct value. So, it could either be ^www.yahoo.com^(ct value) or .^^.(no ct value). I would like that when there is no ct value present in the line, the ct value in Log table should stay as the default NULLbut it is not. The value becomes '' i.e. a zero length string. Any ideas on how can I keep it as NULL? Any help is much appreciated. Thanks in advance, Bhavin. sql, mysql, query. - 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: Problem with a query - help!!?
Are you sure u have journoNatOpt.journoid = '' records? select count(*) where journoNatOpt.journoid = '' If not, maybe IS NULL instead of = '' will help. - Original Message - From: David Phipps [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Monday, February 03, 2003 8:46 AM Subject: Problem with a query - help!!? Hi, I am new to this list so I apologise if this is not the place to post this message. I am in the final stages of completing a project and I have one query that is causing problems. I need the query to get a story or stories from the story table and journalists from the journalist table where their respective id is not present in a table which links the journoid to a national option table and the storyid to the national option table. So far I have: SELECT storySub.storyid, storySub.headline, journoDetails.journoid, journoDetails.journoName, journoNatOpt.journoid AS natJid FROM releaseManager, journoDetails LEFT JOIN journoNatOpt ON journoDetails.journoid = journoNatOpt.journoid, storySub WHERE storySub.isNational = 1 AND journoDetails.isNational = 1 AND journoDetails.isApproved = 1 AND journoNatOpt.journoid = '' AND releaseManager.storyid = storySub.storyid AND releaseManager.isReleased = 1 AND releaseManager.immediateRelease = 0 AND releaseManager.releaseTime BETWEEN #CreateODBCTime(Now())# AND #CreateODBCTime(DateAdd(n, 30, Now()))# AND releaseManager.releaseDate BETWEEN #CreateODBCDateTime(Now())# AND #CreateODBCDateTime(DateAdd(h, 24,Now()))# The above query seems to have trouble when I insert the following: AND journoNatOpt.journoid = '' If I remove this line then I see all the of national stories and any national journalists which is fine except that some of the stories and journalists are actually linked to a national option. What I want to have is all stories and journalists that are national but where they are not linked to a national option. If this makes any sense and you can see what I am doing wrong then please help!! Thanks in advance Dave Phipps MySQL new guy!! - 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: FreeBSD bin-log rotation script
I think flush logs should do it. http://www.mysql.com/doc/en/FLUSH.html Bhavin. - Original Message - From: Matthias Trevarthan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 30, 2003 2:31 PM Subject: FreeBSD bin-log rotation script Howdy list, Does anyone have a FreeBSD/MySQL bin-log rotation script that I could use? I'm not sure how to go about rotating the binary logs. Doesn't the index have to stay in sync? Thanks! Matthias - 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: setting auto increment start value
From postings at: http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html ALTER TABLE tbl_name AUTO_INCREMENT = 1000 will start your records at 1000 Bhavin. - Original Message - From: Mike Doanh Tran [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 30, 2003 2:15 PM Subject: setting auto increment start value Hi all, I am creating a new table with an auto_increment primary key. How do i tell mysql to start incrementing at a certain value, let say 1000 instead of 1? Thanks, MT -- - 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: How to speed things up in MySQL ?
Sounds weird. Can you e-mail us a 'mysqldump' of the table defination with the data? Thanks, Bhavin. - Original Message - From: Thomas Kvamme [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, January 25, 2003 7:36 AM Subject: How to speed things up in MySQL ? Hello, While reading this you may think this is off-topic... but please read on.. I'll get on-topic in the end :-)) First of all I have Web Server on which I have a Paradox table with 320 records. I also have a CGI Script (or program if you like) I made in Borland Delphi which I use to access the Table... When I enter the address of my CGI-script in my Internet Browser the following happens: The CGI script on the Web Server is starting. The CGI script reads the SQL command to execute passed on to the script through the HTTP protocol. The CGI script establish connection with the Borland Database Engine (Loading BDE dll's etc..) The CGI script opens/initialize the Paradox Table. The CGI script execute the SQL command sent to it. The CGI script sends back the result of the SQL command to the Browser (HTTP protocol). The CGI script closes down (shutting down db connection etc..). My PC and my Web Server is connected on the same LAN (switched 100 MBit/s) All of the above is completed in 1.5 seconds. ** here the fun begins ** I have now successfully installed MySQL (on the same WebServer) and converted the Paradox Table to MySQL Table type: MyISAM. Database Name: TDD Table Name: DVD This new Table contains the same 320 records using the same field definition as in the Paradox Table. On my Web Server I go into \MySQL\bin\ and start mysql -uroot -p and execute the same SQL command as sent to the Paradox table through the CGI script. see screen dump below for result. SCREEN DUMP ** F:\MySQL\binmysql -uroot -p Enter password: ** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3726 to server version: 4.0.9-gamma-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql use tdd Database changed mysql select count(id) as Films, ProductionYear from DVD - group by ProductionYear - order by ProductionYear desc; +---++ | Films | ProductionYear | +---++ |19 | 2002 | |44 | 2001 | |58 | 2000 | |41 | 1999 | |27 | 1998 | |16 | 1997 | |11 | 1996 | | 9 | 1995 | |12 | 1994 | | 8 | 1993 | | 7 | 1992 | | 3 | 1991 | | 7 | 1990 | | 6 | 1989 | | 2 | 1988 | | 6 | 1987 | | 2 | 1986 | | 2 | 1985 | | 6 | 1984 | | 4 | 1983 | | 3 | 1982 | | 3 | 1981 | | 2 | 1980 | | 3 | 1979 | | 2 | 1978 | | 1 | 1976 | | 1 | 1975 | | 2 | 1974 | | 2 | 1973 | | 1 | 1972 | | 1 | 1971 | | 1 | 1970 | | 1 | 1969 | | 1 | 1968 | | 2 | 1965 | | 1 | 1964 | | 1 | 1959 | | 1 | 1940 | | 1 | 1937 | +---++ 39 rows in set (13.32 sec) mysql *** How is this possible ?? 13.32 seconds ??? And this was when I was directly logged on to the Database (via Localhost)! When Using my Paradox table this took 1.5 second through my CGI script over the Intranet. I have another function in my CGI script sending 2 different SQL commands to the Paradox table.. this entire job completes in less than 3 seconds. In MySQL these 2 job takes more than 30 seconds to complete. What can I do to speed this up ? PS: The DVD table containing the 320 records is the only table on the server. (except from the MySQL database and the empy Test Database). Both the Paradox Table and the MySQL server is installed on the same Harddrive so harddisk speed shouldn't be a factor. Appreciate any help to solve the above :-))) Kind Regards Thomas Kvamme [EMAIL PROTECTED] - 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
Re: remote database
I think it's allowing 'root@localhost' but not '[EMAIL PROTECTED]'. Select * from user (in mysql db) will show you all the access privileges. Add '[EMAIL PROTECTED]' to that as a user. Bhavin. - Original Message - From: Bob Lockie [EMAIL PROTECTED] To: MySQL Mailing List [EMAIL PROTECTED] Sent: Wednesday, January 22, 2003 5:07 PM Subject: remote database I am trying to remotely connect to a MySQL database but I'm having problems so I tried this on the same machine as the database. It doesn't work when I give it -h but it works without. # mysql -h 10.0.0.5 -D visitor ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) but # mysql -D visitor works. -- Sent from Mozilla and GNU/Linux. Powered by an AMD processor. - 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: SQL optimization problem
You might have to tweak the following a bit for syntax: SELECT a.name, COUNT(b.id) as votes FROM poll_options as a LEFT JOIN poll_votes as b ON a.id=b.oid WHERE b.pid='poll_id' GROUP BY b.oid Also, you can refer to: http://www.mysql.com/doc/en/JOIN.html Bhavin. - Original Message - From: Blaster [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, January 11, 2003 12:35 PM Subject: SQL optimization problem Hey, (this post is pretty long, a short version of the problem is listed at the bottom if you don't like reading long emails :P) I'm currently going through all my SQL queries for my webpage to see if there is anything I can do to optimize them. On my webpage, i have this poll where people can give their opinion in various subjects by casting a vote. To begin with, I'd like to tell you how I created my tables for this task, the poll uses in total 3 different tables as following: poll_list (this table contains the actual question of each poll) === id (int) | stamp (datetime) | question (varchar 255) | active (tinyint) Id is simply an autoincrementing ID for each poll, Stamp is the creation date of the poll, Question holds the actual question (duh :P) If Active is 1, it means that this is the active poll right now. Only one poll can be active at the same time. poll_options (this table holds the valid answers for each poll. You may use any number of answers in your poll) id (int) | pid (int) | name (varchar 255) id is again, autoinc field for this answer pid is a pointer to which poll this particular answer belongs to, i.e pid = poll_list.id name holds the actual answer string poll_votes (this table holds all the casted votes, one row is one vote) = id (int) | pid (int) | oid (int) | uid (int) id, autoinc pid, pointer to poll_list.id, tells me which poll this vote belongs to oid, pointer to poll_options.id, tells me which option this user voted uid, pointer to user account. I won't include the user table, just think of this as a unique identifier for the users, prevents the same user from voting twice in a poll.. AND now! to the problem! Prior to my optimzation checking began, the code to display the results of a poll was something like this: 1) Fetch the active poll: SELECT * FROM poll_list WHERE (active 0) ORDER BY stamp DESC LIMIT 1 2) Fetch the answers for the poll ID we received from the prior query: SELECT * FROM poll_options WHERE pid='id_from_prior_query' 3) For each option received in step 2, I did: SELECT * FROM poll_votes WHERE pid='poll_id' AND oid='option_id' 4) Output HTML formated code to web visitor. Now, I thought, it MUST be possible to make step 2 and 3 using 1 single query, because using this old system (as shown above), it requires 1 + n queries, where n is number of answers in that particular poll. So, I simply replaced it with: 1) Fetch the active poll: SELECT * FROM poll_list WHERE (active 0) ORDER BY stamp DESC LIMIT 1 2) Fetch the answers votes in the same query: SELECT a.name, COUNT(b.id) as votes FROM poll_options as a, poll_votes as b WHERE b.pid='poll_id' AND b.oid=a.id GROUP BY b.oid 3) Print the results. PROBLEM BEGINS HERE ## However! Here comes the problem, if no vote is cast on an option, it will not show up in the list! I want it to print 0% for any options that havn't received a vote, like it would with my old query system. This is basically what I want to do: Select all options from poll_options and, in the same query, count the number of rows in poll_votes which has that particular options id as oid. Pretty hard to explain, but ideally, I'd like to do SELECT a.name, COUNT(b.id) as votes FROM poll_options as a, poll_votes as b WHERE b.pid='poll_id' AND b.oid=a.id GROUP BY b.oid With one exception, if votes = 0, it should be listed in the result aswell! - 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/doc/ (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: I'm new in Mysql
Hi Beogradjanin As Paul mentioned yesterday, the final column defination does not require a comma because it is the final defination. Bhavin. - Original Message - From: Beogradjanin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 06, 2003 7:38 PM Subject: I'm new in Mysql Hello mysql, I want to learn MySQL and PHP I've installed Apache , PHP and MySql Whan I try to make tables create table guestbook ( name varchar( 40 ) null, location varchar( 40 ) null. email varchar( 40 ) null, url varchar( 40 ) null, comments text null, ) ; I get this mysql create table guestbook - ( - name varchar( 40 ) null, - location varchar( 40 ) null, - email varchar( 40 ) null, - url varchar( 40 ) null, - comments text null, - ) - ; ERROR 1064: You have an error in your SQL syntax near ')' at line 8 mysql Whats wrong here -- Best regards, Beogradjanin mailto:[EMAIL PROTECTED] - 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: Load local data infile problem
Hi Prathmesh, What is the behaviour that you see when you try to LOAD DATA. Any messages? Regards, Bhavin. - Original Message - From: Prathmesh J. Mahidharia [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 06, 2003 11:22 PM Subject: Load local data infile problem hello there, I have just installed mysql and am facing problems with the Load data local infile problem. I went through the manual and did all that was said like including the command --enable-local-infile and --local-infile[=1], but it does not seem to work. I have the version 4.0.6-gamma-max-nt. If u could plz, help me out with that, that would be very nice of u! I m developing a project at the moment and have got to make large entries into mysql tables, but this command is not working properly and i m stuck! Could u plz help me out with that..? Thank u in advance. Regards: Prathmesh Mahidharia PRATHMESH J. MAHIDHARIA B.E. (Electrical) M.Sc.Information Technology (Murdoch Uni, Australia) Phone no: (+61) 0421167375 - 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: Alter table error
It might be a permissions problem. Mysql is trying to create a temporary file to do the ALTER but cannot. Check for the write permissions/ownership on the data directory. Regard, Bhavin. - Original Message - From: Nick Stuart [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Wednesday, January 08, 2003 2:15 PM Subject: Alter table error Got another problem with 4.0.7 when trying to alter the table. Trying to run: ALTER TABLE `call_information` CHANGE `close_date` `close_date` TIMESTAMP DEFAULT '' NOT NULL and it returns a: ERROR 7: Error on rename of '.\helpdesk\call_information.MYI' to '.\helpdesk\#sql2-b90-81.MYI' (Errcode: 13) Any ideas on why I would get this?? I think it has something to do with my case problem that I posted before because if you look it says helpdesk instead of HelpDesk. -- -Nick Stuart USM Computer Science Major Visit us at http://csforum.newtsplace.com (run with LAMP) - 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: Update Year of Date Field using sql statement
I don't think there is a way to do that. Unless some one says there is(and tells us how to do it), I guess your only option is to write a script to do that. Regards, Bhavin. - Original Message - From: Hakkan Lui [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, January 05, 2003 10:12 PM Subject: Update Year of Date Field using sql statement Dear all, How can I change the year of the date field using sql statement? It means something like: update table1 set year(f1) = '2002' where year(f1) = '2003'; Thanks for anyone's help. Regards, Hakkan Lui - 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: host.frm
Check to see the existence/permissions of this file in the data directory. Regards, Bhavin. - Original Message - From: Jason Steig [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, January 01, 2003 11:43 PM Subject: host.frm ./myqld: Can't find file : './mysql/host.frm' (errno:13) does anyone know how to solve this problem? - 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: failing to connect to /tmp/mysql.sock
You are missing the socket file. Make sure 'mysqld' is up. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 26, 2002 9:57 AM Subject: failing to connect to /tmp/mysql.sock I am failing to connect to the mysql database, the error is failing to connect to /tmp/mysql.sock What should i do? Harry ___ NOCC, http://nocc.sourceforge.net - 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: Finding out the number of days from a month in MySQL
I don't think there is since MySql is a db and not so much of a scripting language. Perl or PHP have functions that could do something like that. Regards, Bhavin. - Original Message - From: Octavian Rasnita [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 26, 2002 5:44 AM Subject: Finding out the number of days from a month in MySQL Hi all, I want to find out the number of days in MySQL for the current month and I found that I need to use something like: - getting the current date. - Finding the first date of the current month. - Finding the first date of the next month. - Substracting a day for finding the last day of the current month. - Getting the day of month for the last day of the current month. Isn't there a more simple method, or a function for finding this? Thank you. Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [EMAIL PROTECTED] - 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: Problem doing Select * from table
The indexes are probably corrupt, you will need to run 'myisamchk' on the table. - Original Message - From: Jason Hall [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 03, 2002 3:04 PM Subject: Problem doing Select * from table I am using mysql 3.23.41 The tables are set to MyISAM. Table A i having problem with has 1.4 million records. When i perform a mysqldump it hangs on this table but dumps other tables. Also when i do a select * from table it hangs. But if i do select count(*) from table a get a result. The fields include BLOB, Number types. A total of 3 columns. I performed a test on a different box and created my own table B with 7.3 million records and file size is 1.4 Gigs. I was able to successfully query and dump this table. Can you help me with this problem for table A? Thanks _ - 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: mysql.sock error
ps -wef | grep mysqld should show if the daemon is actually running or not. Check to make sure. Then, ls /tmp/mysql.sock will show you if the mysql file was created or not. Bhavin. - Original Message - From: Jeff Hollingshead [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 03, 2002 4:16 PM Subject: mysql.sock error at first when trying to run mysql it did this: [root@shadow mysql]# bin/safe_mysqld --user=mysql [1] 3124 [root@shadow mysql]# Starting mysqld daemon with databases from /var/lib/mysql 021121 02:27:42 mysqld ended [1]+ Donebin/safe_mysqld --user=mysql then, i stopped mysql and gave the command again and it seemed to work: [root@shadow mysql]# bin/safe_mysqld --user=mysql [1] 5456 [root@shadow mysql]# Starting mysqld daemon with databases from /var/lib/mysql however, when trying to connect to mysql it does this still: Enter password: /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! any help appreciated - 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: Problems changing password following installation
I am not sure where it my reside but a 'find' for mysqladmin might yeild something. Bhavin. - Original Message - From: Ken Morley [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 03, 2002 4:21 PM Subject: Problems changing password following installation I downloaded MySQL 3.23 for my Linux server and installed it using rpm -Uvh *.rpm. The installation went OK and at the end, I was given a Don't set the root password reminder. Specifically, it tells you to set the password using two commands: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h mail.jmtg.com password 'new-password' I tried to follow directions, but there is no mysqladmin utility in /usr/bin. There are plenty of mysql files in the directory, but no mysqladmin utility itself. What did I do wrong? How do I fix it? Thanks! Ken Morley - 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: Connecting to mysql
Your 'root' password was probably not set hence, you didn't need a password. Bhavin. - Original Message - From: Pikasz Gyorgy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 17, 2002 7:46 AM Subject: Connecting to mysql I'm logged in to RedHat Linux as an user and I'd like to connect to mysql with mysql -uroot -p (and then must type the passw), but I could'nt in this way, only whit this: mysql -uroot, without passw. Why? picas - 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: Calculation question
I am guessing a default value of NULL should do it. Bhavin. - Original Message - From: Chris Kay [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, December 01, 2002 4:54 PM Subject: Calculation question I have a few fields in a table that I need to calculate, yesterday I find out that they don't want it to display as 0.00 if nothing was entered into the database. I currently have the fields set to decimal(10,2) Would any1 suggest a better way to do this to not display the 0.00 if nothing was entered into a field, the fields need to calculate. Not to fuzzy if they see 1000 instead of 1000.00. Thanks in advance Mysql,query - Chris Kay (Systems Development) Techex Communications Website: www.techex.com.au Email: [EMAIL PROTECTED] Telephone: 1300 88 111 2 - Fax: (02) 9970 5788 - - 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: MySQL secure access
You can create separate databases (database directories) and then grant privileges to users on table only within a specific database. So if you have a separate database (create database name is the syntax to create a new database), you can do that. Bhavin. - Original Message - From: Alice Tan [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Wednesday, November 27, 2002 10:24 PM Subject: MySQL secure access Hi, all, I am now using MySQL with MySQL Front, where i knew that it can access ALL the databases that store remotely. My company is doing hosting services. And we are using MySQL as our database system. Currently, we have our own databases + customer's databases store in our hosting server. But our customer requested to have their own access on their databases, which i don't want them to see those databases that not belongs to them. Can i do that ? Thanx in advance for anyhelp. regards, alice /--- \ Confidential and/ or privileged information may be contained in this e-mail and any attachments transmitted with it ('Message'). If you are not the addressee indicated in this Message (or responsible for delivery of this Message to such person),you are hereby notified that any dissemination, distribution, printing or copying of this Message or any part thereof is prohibited. Please delete this Message if received in error and advise the sender by return e-mail. Opinions, conclusions and other information in this Message that do not relate to the official business of this company shall be understood as neither given nor endorsed by this company. This mail is certified Virus Free by *ProtectNow! (InternetNow Sdn Bhd) *Scanner Engine powered by Norman Virus Control \--/ - 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: Table Handler Errors
possible table corruption. Run myisamchk on the table to check it and then, if needed, repair it. Bhavin. - Original Message - From: Amit Lonkar [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 22, 2002 10:52 PM Subject: Table Handler Errors Hi All! I am using mysql-.3.23.49 on windows. It generates the following error:- General error: Incorrect key file for table: 'lotjob'. Try to repair it . or some times it generates a table handler error. why do these errors occur? Regards Amit Lonkar __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - 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: starting Mysql on linux
Make sure that your mysql daemon is running, if not, start it. Also, make sure the mysql.sock file is present in /var/lib/mysql. Bhavin. - Original Message - From: Stick Dragon [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, November 10, 2002 3:44 PM Subject: starting Mysql on linux i have installed redhat 8 and slackware linux and been trying to get mysql to run. when i get to the console and type 'mysql' i get, error 2002; cant connect to local mysql server through socket '/var/lib/mysql/mysql.sock' i have tried to run mysqld through the console but says it cant find the command. i'm not really linux or mysql savy. any help on getting it to run would be great. _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail - 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: Installing mysql in redhat linux 7.1
If this is the first time u r installing mysql, then, rpm -i mysql.rpm. If u r updating, then rpm -u mysqlxxx.rpm should do it. The binary install is more optimized and hence is the best way to install mysql, however, rpm's work fine too. Regards, Bhavin. - Original Message - From: Peter Goggin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 03, 2002 5:12 PM Subject: Installing mysql in redhat linux 7.1 I have just installed redhat linux 7.1 and now need to install Mysql. with innodb support. I downloaded the rpm (3.23.51) from the mysql site and tried to install it. The process appeared to stop mysql and then complained it could not find a file: /etc/rc.d/mysql A query on rpm -qa | grep mysql showed no changes had taken place. How do I install the latest version of mysql? Should I be using the rpm ? Regards Peter Goggin Regards Peter Goggin - 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: changing a slave to a master in mysql replication
bin-log in 'needed' for a server to act as a master. This will make the server log all it's queries for the slave to follow. Don't know of a faster way. Regards, Bhavin. - Original Message - From: Vicky Gonzalez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 03, 2002 4:54 PM Subject: changing a slave to a master in mysql replication Currently to make a slave a master, the docs say you need to set the bin-log option in my.cnf on the slave, and that will make the transition to master quicker. I know I can manually change a slave to a master by stopping the slave process, stop mysql, take a snapshot of the databases, copy over a new master my.cnf, make sure I have granted rights to a user for the old master to return as a slave, and restart. My question is how does having the bin-log option on the slave actually help this process? Or is there an easier way to convert a slave to master using the log position that I missed? Thanks in advance for any help. ~Vicky - 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: changing a slave to a master in mysql replication
As far I know, it would help to leave it set. All the queries executed by the slave to follow the master have the master's server id associated with them. The one's which don't have that id will be replicated by the new slave(old master), there by making the process easier and faster. Regards, Bhavin. - Original Message - From: Vicky Gonzalez [EMAIL PROTECTED] To: Bhavin Vyas [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, September 03, 2002 6:16 PM Subject: RE: changing a slave to a master in mysql replication Bhavin Vyas wrote Tuesday, September 03, 2002 9:02 PM in response to: To: Vicky Gonzalez; [EMAIL PROTECTED] Subject: Re: changing a slave to a master in mysql replication bin-log in 'needed' for a server to act as a master. This will make the server log all it's queries for the slave to follow. Don't know of a faster way. Thanks for the prompt reply, I understand why bin-log is needed for a master, but I was questioning the usefulness of having the bin-log setting for a slave while it's running as a slave. When the slave becomes a master, doesn't it need a new my.cnf (which would have the bin-log set) or can it become a master with its slave my.cnf? If it can become a master using the slave my.cnf (which has the bin-log set) what commands would I need to call to make it a master now, and no longer a slave to its old master? Thanks again! ~Vicky - 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: Some Broad Help Before I Get Started
You should be able to acheive all of that via a web interface using PHP-MySql. It will only be a matter of designing the user interface correctly (eg: check boxes for all categories a book can belong to). Bhavin. - Original Message - From: David Powell (PeakCare QLD) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 28, 2002 5:26 PM Subject: Some Broad Help Before I Get Started Hi All, I'm looking towards using MySQL to setup a couple of databases for the organisation I work for (specifically a Library DB and another for recording our 'outputs'). Before I get to the question, some background ... We currently use Ms Access, but my interest in MySQL is that we would be able to give what I develop away for free (we are a Peak Body in the non-profit community services sector in Aust.), which would be beneficial for our members. However, I'm wondering which way to go with the 'interface' side of things - Web-based or Java or some other I'm not aware of (the key is cross-platform usability). My preference is for web-based as I've already got a working knowledge of PHP, rather than JAVA. However, I'd like to make the interface as easy to use as and fast as possible, and my question is: can a PHP-MySQL combination via a browser allow you to input data into related tables via a single form? For instance, consider a library DB that has two tables, Books Categories, with a one-to-many relationship from Books to Categories (one book can belong to many categories). Would it be possible to build a form in a web-environment to input data about a book (Title, Author blurb etc) and the categories it belongs to? This might seem like a dumb question, but my only previous experience of data-driven web sites is with Filemaker Pro (ugh, don't go there!), where such an action was not possible. If anyone has broader advice about how to develop DB's for cross-platform use, I'd be interested - this isn't my main role here by any means, I'm just weekend hacker who happens to have learnt a bit of programming and relational DB theory via electives at uni. Please feel free to CC your responses to me directly. TIA, David - 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: Mysql Problem Query
Also, see what errors you are getting in mysql hostname.err file Regards, Bhavin. - Original Message - From: [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Sunday, August 11, 2002 3:30 AM Subject: Re: Mysql Problem Query did you also install the databases that are part of the mysql installation? -Ll on 8/11/02 5:59 AM, Anish Mathew, typed: my sqlserver is not running when i issue the command mysql the response i got was cant connect to local mysql server through socket /var/lib/mysql.sock (111) when i issued the command mysql.server start i got starting mysql daemon with databases from /var/lib/mysql mysqld ended and the daemon ended abruptly without starting the server. - 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: ERROR 2002: Can't connect to local MySQL server through socket'/var/lib/mysql/mysql.sock' (111)
mysql.sock file doesn't exist in the /var/lib/mysql directory. Stop and restart mysql server. Regards, Bhavin. - Original Message - From: samratsam [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, August 10, 2002 4:28 AM Subject: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) why do i get an erro like ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) what could be wrong with this error please send me the reason for it and also how do i overcome this problem regards samratsam Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com Buy Music, Video, CD-ROM, Audio-Books and Music Accessories from http://www.planetm.co.in Change the way you talk. Indiatimes presents Valufon, Your PC to Phone service with clear voice at rates far less than the normal ISD rates. Go to http://www.valufon.indiatimes.com. Choose your plan. BUY NOW. - 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: MySQL database design, one column, 10 entries?
I am not very sure I understand the questionbut maybe column type 'enum' is what you are looking for. - Original Message - From: david [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, August 10, 2002 9:43 PM Subject: MySQL database design, one column, 10 entries? I am creating several tables in MySQL and linking via primary keys. I am held up on one issue, for one row in one table i have a column 'favorites' where i want to hold up to 10 unique entries, how do i implement this? userTable userId varchar(20) name varchar(30) email varchar(40) preferences userId varchar(20) styles varchar(20) favorites preferences userId styles favorites rating 01 'modern''#1 sleek' 15 '#2 ultra-sleek'20 '#3 un-sleek' 12 '#4 plain' 9 etc, up to 10 or so. 02 'gothic''#1 dark' 21 '#2 tall' 4 '#3 scary' 2 etc, etc,... I can't just make it a really long varchar(1000) because of the other columns that act on the same data. I hope that this is an appropriate question for this MySQL list. TIA -david - 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: mysql crashes after adding memory.
If it is saying that it cannot bind to port 3306, then maybe the port is still locked by another process, mysqld or otherwise. netstat -na | grep 3306 should show you that. Kill that process and try again. Regards, Bhavin. - Original Message - From: Johannes Ullrich [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 08, 2002 11:31 AM Subject: mysql crashes after adding memory. Yesterday, I increased the memory in my mysql server from 2 GByte to 4 GByte. Here the log file as it died: Number of processes running now: 1 mysqld process hanging, pid 1015 - killed 020808 09:40:12 mysqld restarted 020808 9:40:12 Can't start server: Bind on TCP/IP port: Address already in use020808 9:40:12 Do you already have another mysqld server running on port: 3306 ? 020808 9:40:12 Aborting 020808 9:40:12 /usr/local/mysql/bin/mysqld: Shutdown Complete 020808 09:40:12 mysqld ended The database was under heavy load at the time. The machine is a 'vanilla' dual 1 GHz P-III running RedHat Linux and a 2.4.17 kernel Server version: 3.23.49a-max-log After doing the memory upgrade, I also adjusted some of the parameters, in particular, I increased the key buffer to 2 Gig. The database has a very large (100,000,000 row, 30 GigByte) MyISAM table, and a few smaller myisam and innodb tables. It ran ok for at least half a year (last machine reboot). So far, it does not look like any data was corrupted. Usually, only a small number of client (10 or so) is connected. Here my my.cnf file: set-variable=max_connections=200 set-variable=max_allowed_packet=10M set-variable=key_buffer=2000M set-variable=join_buffer_size=200M set-variable=sort_buffer=150M set-variable=record_buffer=50M set-variable=record_rnd_buffer=50M set-variable=table_cache=200 set-variable=thread_concurrency=4 set-variable=long_query_time=5 innodb_data_home_dir=/usr/local/mysql/innodb innodb_data_file_path=data1/ibdata1:1M;data2/ibdata1:1M set-variable=innodb_buffer_pool_size=50M set-variable=innodb_additional_mem_pool_size=10M innodb_log_group_home_dir=/opt/innodb_logs innodb_log_arch_dir=/opt/innodb_logs innodb_log_archive=1 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=3M set-variable = innodb_log_buffer_size=100 innodb_flush_log_at_trx_commit=1 set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 - 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: Using unix mysql db files under windows mysql
If you have 'root' privileges to the server itself, then shutdown mysql and restart it with --skip-grant-tables. This should allow you to log in as root without being prompted for a password. Regards, Bhavin. - Original Message - From: Norris, Joseph [EMAIL PROTECTED] To: 'Kevin Bednar' [EMAIL PROTECTED]; Norris, Joseph [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, August 08, 2002 9:56 AM Subject: RE: Using unix mysql db files under windows mysql Do you have any user for the db? If so you might have the permissions to do the dump. Its worth a try. -Original Message- From: Kevin Bednar [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 9:50 AM To: 'Norris, Joseph'; [EMAIL PROTECTED] Subject: RE: Using unix mysql db files under windows mysql I don't have the root login password for mysql Joe. This was a machine we inhertited and has 1 site on it. This is why we want to move everything off of it. Can you do a mysqldump without the root mysql login? Kevin Bednar Network Engineer Dedicated Access Support 1-888-TELLURIAN (973) 300-9211 Ext. 126 Tellurian Networks - Le Package Totale http://www.tellurian.net -Original Message- From: Norris, Joseph [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 12:48 PM To: 'Kevin Bednar'; [EMAIL PROTECTED] Subject: RE: Using unix mysql db files under windows mysql You can not do mysqldump on unix, rebuild on windows? -Original Message- From: Kevin Bednar [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 9:42 AM To: [EMAIL PROTECTED] Subject: Using unix mysql db files under windows mysql Hello all, I have access to the database files themselves from a linux installation of mysql, but not the root login priveleges under mysql itself. I know that if I could connect via mysql itself I could just copy the databases from one server to another but I cant. I copied the db files over via ftp onto a windows server running mysql and it sees the 2 databases but if I try to actually access the colums, etc. I get errors. I also noticed the file extensions on the unix files are different, except for the .frm files. Is there an import tool or something else I can run to import these files into the windows version of mysql so that I can start using them again? The web site these are used for is being migrated off unix onto windows. TIA! Kevin Bednar Network Engineer Dedicated Access Support 1-888-TELLURIAN (973) 300-9211 Ext. 126 Tellurian Networks - Le Package Totale http://www.tellurian.net - 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: problems enabling local-infile
Yes, LOCAL is when client and server are on different boxes and the file is LOCAL to the client. You don't need that keyword otherwise. Regards, Bhavin. - Original Message - From: David Sammons [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 08, 2002 10:20 AM Subject: RE: problems enabling local-infile I've got it. I was using the LOCAL attribute in my LOAD DATA command and it wouldn't work. After getting rid of LOCAL, it works. ds -Original Message- From: David Sammons [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 11:03 AM To: [EMAIL PROTECTED] Subject: RE: problems enabling local-infile Yes, I've checked the manual and have tried several applicable commands. I'm running both the server and client on this pc. I've tried: \mysql\bin mysql --enable-local-infile; [unrecognized option error] \mysql\bin mysql --local-infile=1; [no error, but LOAD DATA LOCAL INFILE command not enabled] I'm just testing to use this command to populate some tables. For testing purposes I've created a simple table (3 fields: field1, field2, field3) and a simple text file with 3 tab-delimited records. Help?! ds -Original Message- From: DL Neil [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 10:47 AM To: David Sammons; [EMAIL PROTECTED] Subject: Re: problems enabling local-infile Hi David, Help?! I'm new to mySQL and am having a heck of a time enabling local-infile to populate a table. I'm running v3.23.51 on win200pro. Any ideas? I've tried several different command-line options with no luck. Help?! So you've checked the manual and performed whatever is necessary version-wise. Is the Win2000 running both server and client, or are there two physical machines here? Please post your current command, and the errmsg received. I have 3.23.51-nt too. If it is not sensitive, and also post the schema/CREATE TABLE and a few data records, I'll try it here for you. Regards, =dn - 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: hey
Are you using InnoDB type tables? The default table type is MyIsam which does not support foreign keys. Regards, Bhavin. - Original Message - From: muad [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, August 03, 2002 5:52 AM Subject: hey hope its okey for me too ask you an question regarding linking of tables... i have been building the tables that are in the manual http://www.mysql.com/doc/en/example-Foreign_keys.html Still i cant understand why i can add and new shirt for an person that isnt there, i am using the mysql 3.23.49 I can even delete a person that has an shirt, any pointers on howto solve this ?? - 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: help with a simple query..
SELECT * from hwu_articles WHERE id = '$id' and price is not null and name is not null and ratings is not null; Bhavin. - Original Message - From: Alex Behrens [EMAIL PROTECTED] To: MYSQL [EMAIL PROTECTED] Sent: Friday, August 02, 2002 4:49 PM Subject: help with a simple query.. Hi Guys, I'm still new to this and I'm trying to get back into and I need help with a simple query. I have a list of info about a product for an article on my website and I'm pulling all this info from a mysql db and displaying it byway of php but don't know how to do the query. Right now I have this: SELECT manufacturer from hwu_articles WHERE id = '$id' and manufacturer is not null this query works fine, however I want to be able to use this same type of query but for different columns (such as price, name, rating, etc) how can I do this? I want it to be structured liek this: SELECT * from hwu_articles WHERE id = '$id' and * is not null, but I don't think you can use two *'s in the same query, how can I do this? Thanks! -Alex Big Al Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [EMAIL PROTECTED] - 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: Basic MySQL setup question
Yes, Install mysql on a local box (same OS as your provider and preferably the same MySql version), create and populate your tables and then FTP the files that reside in the mysql data directory. There will be 3 files associated with each table .MYD (Data file) .MYI (Index file) .frm (schema/description file). Regards, Bhavin. - Original Message - From: Kenneth Gomez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 01, 2002 7:41 PM Subject: Basic MySQL setup question Dear All, My web host provider says that he cannot allow me to have a MySQL account on the server. However, he asks me to set up my tables offline and ftp them across and asses them using Php. Can this be done? Thank you. Kindest regards, Kenneth Gomez, Engineering Analyst, Compumod Sdn Bhd (Malaysia Office of MSC.Software Corporation), Suite 35C, 35th Floor, Empire Tower, 182, Jalan Tun Razak, 50400 Kuala Lumpur, Malaysia. Tel : +603-7490 1022 Fax: +603-7490 1033 http://www.mscsoftware.com.my Stock : http://www.nyse.com/marketinfo/marketinfo.html?sym=mnsx=10y=7 ** This email and any files transmitted with it may contain privileged and confidential information intended solely for the use of the individual to which they are addressed. If you are not the intended recipient, do not read, disseminate, distribute or copy this message or attached files. If you have received this message in error please notify the sender immediately and destroy this email. *** - 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
Replication Circle
Hello, Is there a way to have DB-A and DB-B such that DB-A is the master and DB-B is the slave. However, I also want to make DB-B the master and DB-A it's slave so that if I have to fail over to DB-B then DB-A is automatically following the changes. It doesn't seem probable that this is possible, but I wanted to know if there was a way to do this, that I don't know of. Thanks, Bhavin. sql, mysql, query. - 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: error running
check for ur permissions and ownership on that file. - Original Message - From: Bob Lockie [EMAIL PROTECTED] To: mysql mailing list [EMAIL PROTECTED] Sent: Tuesday, July 30, 2002 7:49 PM Subject: error running I haven't used mysql yet. How do I fix this error when starting it? #/d2/usr2/local/mysql-3.23.51/bin/safe_mysqld Starting mysqld daemon with databases from /d2/mysql_db 020730 21:36:23 mysqld ended # more /d2/mysql_db/host.err 020730 21:36:23 mysqld started 020730 21:36:23 /d2/usr2/local/mysql-3.23.51/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020730 21:36:23 mysqld ended My datadir is NOT relative to my INSTALLATIONDIR. - 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: Starting on Windows 2000 Server
Andrew, I assume that basedir and datadir are set to the *actual* paths specific to your install and not 'the_install_path' and 'the _data_path'. If not, you will need to set those. Bhavin. - Original Message - From: Wheeler, Andrew [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 9:42 AM Subject: Starting on Windows 2000 Server Hi, I just downloaded the binaries. I have followed the installation instructions. Have run the command mysqld-max-nt --install-manual and checked the service panel and MySql is installed as a service. However when I either try to start the service in the service panel or issue the command net start mysql I get the following error message Could not start the MySQL service in local computer. Error 3 The System cannot find the path specified. Per the documentation my.ini file is in the WINNT directory and reads: [mysqld] # set basedir to installation path, e.g., c:/mysql basedir=the_install_path # set datadir to location of data directory, # e.g., c:/mysql/data or d:/mydata/data datadir=the_data_path Thanks for any help. Andrew Wheeler Phone 415-627-2054 email [EMAIL PROTECTED] _ IMPORTANT NOTICES: This message is intended only for the addressee. Please notify the sender by e-mail if you are not the intended recipient. If you are not the intended recipient, you may not copy, disclose, or distribute this message or its contents to any other person and any such actions may be unlawful. Banc of America Securities LLC(BAS) does not accept time sensitive, action-oriented messages or transaction orders, including orders to purchase or sell securities, via e-mail. BAS reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the BAS e-mail system. - 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: Do you run multiple servers on WIndows?
From what little I know of MySql on Windows, it runs as a service and you can't run multiple services on the same Win Server. Bhavin. - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 9:35 AM Subject: Do you run multiple servers on WIndows? It's not uncommon to run multiple MySQL servers on a given Unix system. I'm wondering: Does anyone do this on Windows, and if so, what particular configuration issues did you have to solve to keep them from interfering with each other? - 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: Do you run multiple servers on WIndows?
clarification: can't run multiple instances of the same service on Windows. - Original Message - From: Bhavin Vyas [EMAIL PROTECTED] To: Paul DuBois [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 7:07 PM Subject: Re: Do you run multiple servers on WIndows? From what little I know of MySql on Windows, it runs as a service and you can't run multiple services on the same Win Server. Bhavin. - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 9:35 AM Subject: Do you run multiple servers on WIndows? It's not uncommon to run multiple MySQL servers on a given Unix system. I'm wondering: Does anyone do this on Windows, and if so, what particular configuration issues did you have to solve to keep them from interfering with each other? - 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: Slow queries
Thanks Mike! Yes, the query is certainly using tmp tables for the longest of times. I will try and implement the solution you provided and see how it goes. If I do, I will update you with the results. Regards, Bhavin. - Original Message - From: mos [EMAIL PROTECTED] To: Bhavin Vyas [EMAIL PROTECTED] Sent: Friday, July 26, 2002 2:21 PM Subject: Re: Slow queries At 05:53 PM 7/24/2002, you wrote: Hello, I am running mysql in our production environment, which have a few reporting tables with millions of rows. Certain queries cascade 2 such tables that have millions of rows and there by, there are extremely slow, sometimes taking over 10 minutes. However, we are ok with that since the size of the data is extremely large. However, the problem that we are facing is that when these queries are running, other queries, *unrelated to the 2 large tables* are also put on hold, so they can't be executed either and basically mysql becomes unresponsive until I kill the SLOW query and then everything is back to normal. Anybody knows why this happens and if there is a solution for this (like maybe, reprioritizing the slow query to a very low priority or something). I would think that mysql would independently try to execute the other queries but that does not seem to be happening. Thanks, Bhavin. Bhavin, If MySQL has to create temporary tables to do the join, then of course things are going to slow down quite a bit. I've been thinking about a solution and this may help (I haven't tried it). Why not create a RAM disk and have your MySQL TmpDir point to that? RAM is pretty cheap and a 30-100MB RAM drive would speed up table joins quite a bit because it can be written to 10x faster than a hard drive. There are a lot of 3rd party software RAM drives out there for Windows and Linux. You would have to specify a RAM drive large enough to hold all your temporary files. There are also RAM drive PCI cards and external RAM drive devices but these cost a lot more than a software RAM drive. These devices also let you have a RAM drive of 4g or more without taking memory away from the OS. Their data is persistent between reboots via an external battery. MONTY: It would be nice if TmpDir could accept more than 1 directory, like a delimited string of directories as in o:\RAM;m:\MySQLTmp1;o:\MySQLTmp2 so when one runs out of disk space, it looks for another directory in the path. Mike - 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 me out here guys... you gotta have a primary key
Desmond, A primary key is needed to maintain a unique identity of each record and there by help in linking it to other records in other tables. However, we have certain tables which link one table to another (needed because of absence of foreign keys in mysql) which don't necessarily have primary keys. If you know that a column can have only unique records you are better off describing it as unique or primary key, not depending upon your code to always do that because there is a good chance that your code can have bugs and then all your data might turn out to be invalid. So the bottom line is that you don't *need* a primary key but if u know that a column will be unique then, do define it as unique or primary. Primary keys will certainly help in reducing redundant data as long as they have some meaning (Social security number, telephone number, etc). Bhavin. - Original Message - From: Desmond Lee [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, July 27, 2002 7:26 PM Subject: help me out here guys... you gotta have a primary key k This is seems ridiculous to me,.. but i'll let you tell me if i'm just being stubborn. So, one of my associates has made a linking table (some people also call it intersection table, cross tab table, but i believe that the propper way to model a many to many relationship is via a linking table). in the linking table, there is no primary key defined. I believe that every table must have a primary key. It is absolutely essential, otherwise you'll get tons of problems including redundancy, and inconsistency. However, my associate believes that our coding will ensure that such problems will be avoided and that it's okay for a table to have no primary key defined. I totally disagree. Even if our code is perfect, a primary key must be defined. So, am i correct in being concerned, or am i just being close minded? If, i'm totally wrong, in what situations is it a good idea, okay, or benificial to not have a primary key defined for a table? Thanks Desmond (sql) _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - 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: MySQL - Ecommerce problem
Check you users table under 'mysql' database. This is what controls access. Here, check the 'hosts' column. Update the old IP/DSN to the new ones and then do a 'flush privileges' and you should be fine. If you don't want to update but add a new record that should be fine to. Do a GRANT . for the new 'user'@'host'. Regards, Bhavin. - Original Message - From: Ingrid Kast Fuller [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 4:58 AM Subject: MySQL - Ecommerce problem I just moved my servers and have new DNS names and IP addresses. I need to update my MySQL databases because our Ecommerce sites are giving Internal Server Errors in Apache, see this link: http://www.toyotaworld.com/cart/toyotaecommerce.cgi?store=toyotaecommerceac tion=filefile=home.tmpl I used PhpAdmin to make some changes in the Shopping Cart main database (from cs1.cityscope.net to ns1.cityscope.net), but I am still getting the errors. Can anyone tell me where I need to change the server info and what are the commands to do it? I appreciate your help, thanks. Ingrid Kast Fuller CityScope Net 3910 Fairmont Parkway #264 Pasadena, TX 77504-3066 (713) 477-6161 - 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: MySql 3.23 to version 4 upgrade
Question is, can you connect via the mysql client. This looks like an authentication issue as opposed to something specific to PHP. Bhavin. - Original Message - From: Ingrid Kast Fuller [EMAIL PROTECTED] To: chuck amadi [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 5:59 AM Subject: RE: MySql 3.23 to version 4 upgrade Well I have FreeBSD 4.2 and MySQL 3.23.33 running on localhost. I use PhpMyAdmin to do any modifications. I did make the nameserver changes in: Database ShoppingCart - table stores Database mysql - table db Database mysql - table host Database mysql - table user I reset mysql and apache and still get Internal Server errors and here's whats in the logs: DBI-connect(toyotaecommerce:ns1.cityscope.net) failed: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) at /usr/local/www/data/cart/toyotaecommerce.cgi line 33 [Wed Jul 24 07:44:37 2002] [error] Can't call method prepare on an undefined value at /usr/local/lib/perl5/site_perl/5.005/CityScope/ShoppingCart.pm line 267. this is line 33... my $dbh = DBI-connect(DBI:mysql:$toyotaecommerce{dbname}:$toyotaecommerce{dbhostname }, $toyotaecommerce{dbuser}, $toyotaecomm this is line 267 sub getIDdb { my ($self, $dbh, $id, $store) = @_; my ($check, $sth, @cart); $check = 'select * from carts where(id = ' . $id . ');'; $sth = $dbh-prepare($check) or $self-Error('Could not prepare select statement in sub getIDdb(); ' . $dbh-errstr); Ingrid Kast Fuller CityScope Net 3910 Fairmont Parkway #264 Pasadena, TX 77504-3066 (713) 477-6161 -Original Message- From: chuck amadi [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 7:14 AM To: Ingrid Kast Fuller Subject: Re: MySql 3.23 to version 4 upgrade Ingrid Kast Fuller wrote: Hey Chuck, since you're up at this time, could I ask you for some MySQL help? I changed my name server names and IP addresses and having trouble getting them put in the database and my ecommerce sites are currently down. I have phpAdmin and went into one file and changed all the cs1.cityscope.net to ns1.cityscope.net but that didn't help. Where else would I change the info so the database will work. I keep getting Internal Server Error's? Your help is appreciated. Ingrid Kast Fuller CityScope Net 3910 Fairmont Parkway #264 Pasadena, TX 77504-3066 (713) 477-6161 -Original Message- From: chuck amadi [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 3:33 AM To: mysql Subject: MySql 3.23 to version 4 upgrade Hi all , i'm about to upgrade from MySql 3.23 to version 4 are there any issues that should be addressed ie uninstall v3 prior to installing v4 or can i just install over v3. Any suggested sites' ,FAQ regarding my question. -- Regards Chuck Amadi ICT Dept Systems Programmer Rhaglenydd Systemau Adran ICT - 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 Hi There Plz could explain what O/s and Server as I'm currently running Apache v1 with PhpMyAdmin (maintenace purposes only) running on my Win Box 98 for testing development etc. Work stuff is linux based environment System Administrator sorts that stuff out. Thus i edited C:\Program Files \ Apache Group\Apache\Conf\httpd.conf and look for # ServerName new.host.name and add your ipAddress thus if your'e running virutally hosts go to the bottom - #NameVirtualHost VirtualHost ServerName DocumentRoot ServerName Also check your'e WebAppConnection Conn Warp yourHost:8008 (your port) Best thing to do is C P to list altering of cause your ipAddress details. I hope this helps or someone with more exp continue's the thread. -- Regards Chuck Amadi ICT Dept Systems Programmer Rhaglenydd Systemau Adran ICT - 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
Slow queries
Hello, I am running mysql in our production environment, which have a few reporting tables with millions of rows. Certain queries cascade 2 such tables that have millions of rows and there by, there are extremely slow, sometimes taking over 10 minutes. However, we are ok with that since the size of the data is extremely large. However, the problem that we are facing is that when these queries are running, other queries, *unrelated to the 2 large tables* are also put on hold, so they can't be executed either and basically mysql becomes unresponsive until I kill the SLOW query and then everything is back to normal. Anybody knows why this happens and if there is a solution for this (like maybe, reprioritizing the slow query to a very low priority or something). I would think that mysql would independently try to execute the other queries but that does not seem to be happening. Thanks, Bhavin. - 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: Grant question
Another grant command for the existing privileges + index privs. should work Bhavin. - Original Message - From: Paul Maine [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 5:33 PM Subject: RE: Grant question I have an existing mysql user that I wish to add the INDEX privilege. Is there a command that I can use to add a privilege without first deleting the user and then recreating with the GRANT command? Thank You -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 6:27 PM To: Paul Maine Subject: Re: Grant question Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: I have an existing user that I wish to add the INDEX privilege. Is there a command that I can use to add a privilege without first deleting the user and then recreating with the GRANT command? Thank You - 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: Merge records from multiple tables???
create table abc as (select * from xyz1); insert into abc values (select * from xyz2); The above 2 commands should do it. You might need to change them a bit, if so www.mysql.com/doc should be very helpful. Regards, Bhavin. - Original Message - From: Ollie Acheson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 18, 2002 6:24 PM Subject: Merge records from multiple tables??? Hi, I am a newcomer to mysql (and pretty much to sql in general). I have a question that is probably pretty simple to answer, but it is escaping me at present. I want to select records from two separate tables and put the results into a result table. Seems pretty simple, but I don't want to join the records from the two tables into combined records in the result table but rather keep them as separate records in the result table. Perhaps an example would clarify what I want to do. Suppose I have two tables of data, such as a current invoice file and an invoice history file. Suppose I need to do a report that would include all records from both files. For the life of me, I don't see how to accomplish this. For the old-timers out there, this was called a merge in an earlier era of data processing. Thanks for any pointers. Ollie -- |---| | Ollie Acheson | | Morristown, NJ| |---| - 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: Bash to remote MySql Server
yes. You will need to install a mysql client on your box though. Then, look up how to grant access to yourself from that server, here: http://www.mysql.com/doc/G/R/GRANT.html finally, you will connect as such: ...path/mysql -h remotehostname -u user -ppassword Bhavin. - Original Message - From: Terence [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 18, 2002 6:14 PM Subject: Bash to remote MySql Server Hi List, Wondering if anyone knows whether it's possible from bash, to connect to a remote mysql database? And if so, where I can find some help. All I require is to connect to another mysql database and get a list of users. (I am trying to avoid running another mysql db for just one table) If not, what do I need to look into? perl? Thanks Terence - 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
Interesting
I did a select * as such: mysql select * from Sqs; +-+-++ | RecordState | Sqs | SqsKey | +-+-++ | L | unknown | 1 | +-+-++ 1 row in set (0.00 sec) Then, look at the message that delete from gives me '0 rows affected' mysql delete from Sqs; Query OK, 0 rows affected (0.02 sec) However, it did indeed delete one row, since now I get an empty set when I do a select *. mysql select * from Sqs; Empty set (0.00 sec) Anybody knows why, then, delete gave me a '0 rows affected' message instead of saying '1 row affected'? Mysql version 3.23.49 Regards, Bhavin. - 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 db - rsync
If you are on the same OS and rsync happens fine, then you should not loose any data. A more graceful way might be too look into setting up a slave server which will be in sync with the master. Regards, Bhavin. - Original Message - From: Charitha [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, July 13, 2002 12:44 AM Subject: mysql db - rsync Hello all, Can i do rsync with the mysql db as a whole from one machine to other. If i can do then will there be any loss of data while doing rsync. Thanks in advance. -- Regards, Charitha - 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: Help - query suggestion needed - interesting case
How about: SELECT event_id, time, count(DISTINCT time) AS Ranges FROM events GROUP BY event_id HAVING Ranges 1 - Original Message - From: Mihail Manolov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 11, 2002 2:58 PM Subject: Help - query suggestion needed - interesting case Greetings, I am stuck with this problem: I have the following table: event_id time 1002000-10-23 1002000-10-23 1012000-10-24 1012000-10-25 I need to know all event_id's that have multiple times + time columns. Is it possible to get that result in just one query? The result should be something like this: event_id time 1012000-10-24 1012000-10-25 I managed to get all event_id's that have multiple times, but I don't know how to get the time column in the same query. Here is my current query: SELECT event_id, count(DISTINCT time) AS Ranges FROM events GROUP BY event_id HAVING Ranges 1 Please help me to find a single query that will return the time column as well. Mihail - 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: can't connect
running the script 'safe_mysqld ' should start the server. - Original Message - From: Alex Jarvis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 10, 2002 3:21 PM Subject: can't connect So, I had mysql up and running a week ago, but at some point the system on which it was installed was rebooted. Now when I try to connect I get a Cannot connect through socket 'var/lib/mysql/mysql.sock' error message. I've read some of the archives and found similar problems. The common suggestion seems to be that the server is not running. And I think that may be the case. But apparently I don't know how to start the server again. Any help would be appreciated, -Alex - 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: help me please with mysqlgui
You might have your socket files in /var/lib/mysql/. Search for the socket file and create a symlink in the /tmp directory as such: ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock Regards, Bhavin. - Original Message - From: Bas Mooyman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 04, 2002 11:43 AM Subject: help me please with mysqlgui When I start mysqlgui on my mandrake 8.2 machine the program starts, but I get an error message: Can't connect to local MySQL server through socket'/tmp/mysql.sock'(2) I don't know what to do and I cannot acces the help file or find documentation on MySQLserver. Please tell me how I can solve this and/or where I can find documentation on MySQLGui Kind regards, Bas Mooyman - 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: Audit - Log
You will need to create my.cnf and turn ON the loggin option. Bhavin. - Original Message - From: Jorge Ceballos [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 04, 2002 12:30 PM Subject: Audit - Log Hi, After reading about the audit log (http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:95588), which I need; I looked for the my.cnf and mysql.log file but didn't find any nor any other related file. Are these created by default or should I create them ? Please advise. TIA. Jorge Ceballos Mexico - 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: Mysql : Problems to make a file dump /n and br
If 'text' is stored in the HTML format in the db, the only solution I can think of is writing a perl/shell script to parse out the br and recreate the files without it, that ways, the data in the DB is not disturbed and Excel should be able to read it to (unless someone knows of a setting in Excel which will make it ignore br) Regards, Bhavin. - Original Message - From: Walter D. Funk [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 03, 2002 2:34 PM Subject: Mysql : Problems to make a file dump /n and br Hi, I'm making a CSV from a Mysql table, in which text is stored as is, with all br to keep format etc (I need to keep line breaks because the same text has to be printed out in a page taking care of the original fomatting); The problem comes actually when Excell tries to read the CSV (; separates columns and ;; is a new row) all br inside the text are parsed as a Carriage return causing Excel to display a new Row in the middle of a text field; I've been looking up the mysql manual but I couldn't find a workaround for this, can someone help me, please? thanks in advance to everybody - 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: How to On DELETE CASCADE
You can use the InnoDB table type which supports foreign keys. http://www.mysql.com/doc/S/E/SEC446.html If you want to use MyIsam table types, the only solution is to send a specific request to delete records in both the tables. Regards, Bhavin. - Original Message - From: multivac [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Wednesday, July 03, 2002 2:22 PM Subject: How to On DELETE CASCADE Hello, I'm quite new in MySQL and PHP, so I guess my question is stupide. Sorry for that but I really need the solution... I have 2 tables table Client : --- |ClientID | ClientName| --- |1| Eric | |2| Mark | |3| Simon | --- and table Command : --- | CommandID | ClentID | Price | --- | 2 |1| 32 | | 1 |1| 12 | | 3 |2| 38 | | 4 |2| 65 | | 5 |3| 81 | --- The primary Keys are ClientID on table Client and CommandID on table Command. I'm looking for a way to be sure that when deleting an entry in Client table, all the corresponding entries in Command table are deleted without sending a specific request for that. It seems that in SQL a froreign key is the solution but the MySQL documentation says that foreign keys aren't implemented in MySQL, so how to solve this elementary issue ? Thank you in advance for your replies or suggestions, @+ Carl - 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
Mysql List bug?
Mysql list serve manager, Could this be a bug in the mysql listserv. Tedd Richards tried to unsubscribe and I am getting the confirmation e-mail to confirm that I really want to un-subscribe, when, I haven't emailed an unsubscribe request in the frist place. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, June 29, 2002 8:04 AM Subject: confirm unsubscribe from [EMAIL PROTECTED] Hi! This is the ezmlm program. I'm managing the [EMAIL PROTECTED] mailing list. To confirm that you would like [EMAIL PROTECTED] removed from the mysql mailing list, please send an empty reply to this address: Usually, this happens when you just hit the reply button. If this does not work, simply copy the address and paste it into the To: field of a new message. I haven't checked whether your address is currently on the mailing list. To see what address you used to subscribe, look at the messages you are receiving from the mailing list. Each message has your address hidden inside its return path; for example, [EMAIL PROTECTED] receives messages with return path: mysql-return-number[EMAIL PROTECTED] Some mail programs are broken and cannot handle long addresses. If you cannot reply to this request, instead send a message to [EMAIL PROTECTED] and put the entire address listed above into the Subject: line. --- Administrative commands for the mysql list --- I can handle administrative requests automatically. Please do not send them to the list address! Instead, send your message to the correct command address: To subscribe to the list, send a message to: [EMAIL PROTECTED] To remove your address from the list, send a message to the address in the List-Unsubscribe header of messages from the list. If you don't know how to display headers and haven't changed E-mail addresses since subscribing, you'll be successful with an e-mail to: [EMAIL PROTECTED] Send mail to the following for info and FAQ for this list: [EMAIL PROTECTED] [EMAIL PROTECTED] Similar addresses exist for the digest list: [EMAIL PROTECTED] [EMAIL PROTECTED] To get messages 123 through 145 (a maximum of 100 per request), mail: [EMAIL PROTECTED] To get an index with subject and author for messages 123-456 , mail: [EMAIL PROTECTED] They are always returned as sets of 100, max 2000 per request, so you'll actually get 100-499. To receive all messages with the same subject as message 12345, send an empty message to: [EMAIL PROTECTED] The messages do not really need to be empty, but I will ignore their content. Only the ADDRESS you send to is important. You can start a subscription for an alternate address, for example [EMAIL PROTECTED], just add a hyphen and your address (with '=' instead of '@') after the command word: [EMAIL PROTECTED] To stop subscription for this address, mail: [EMAIL PROTECTED] In both cases, I'll send a confirmation message to that address. When you receive it, simply reply to it to complete your subscription. If despite following these instructions, you do not get the desired results, please contact my owner at [EMAIL PROTECTED] Please be patient, my owner is a lot slower than I am ;-) --- Enclosed is a copy of the request I received. Return-Path: [EMAIL PROTECTED] Received: (qmail 25046 invoked from network); 29 Jun 2002 15:04:54 - Received: from mtiwmhc22.worldnet.att.net (204.127.131.47) by www.mysql.com with SMTP; 29 Jun 2002 15:04:54 - Received: from dell866 ([12.77.147.176]) by mtiwmhc22.worldnet.att.net (InterMail vM.4.01.03.27 201-229-121-127-20010626) with ESMTP id 20020629151310.JATW20395.mtiwmhc22.worldnet.att.net@dell866 for [EMAIL PROTECTED]; Sat, 29 Jun 2002 15:13:10 + Message-ID: 01ee01c21f7f$84589260$1300a8c0@dell866 From: Teddy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Date: Sat, 29 Jun 2002 11:13:22 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary==_NextPart_000_01EB_01C21F5D.FB47C700 X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6600 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 This is a multi-part message in MIME format. --=_NextPart_000_01EB_01C21F5D.FB47C700 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable --=_NextPart_000_01EB_01C21F5D.FB47C700 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=3DContent-Type content=3Dtext/html; = charset=3Diso-8859-1 META content=3DMSHTML 5.50.4522.1800 name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVnbsp;/DIV/BODY/HTML --=_NextPart_000_01EB_01C21F5D.FB47C700-- - Before posting, please check:
Re: Max_data_length question...
The default at table creation is 4GB. You can change the default vaule via an ALTER TABLE. You will need to alter AVG_ROW_LENGTH and MAX_ROWS. MAX_DATA_LENGTH is the product of the two. http://www.mysql.com/doc/T/a/Table_size.html Regards, Bhavin. - Original Message - From: Henry Hank [EMAIL PROTECTED] To: mysql mailing list [EMAIL PROTECTED] Sent: Sunday, June 30, 2002 7:05 AM Subject: Max_data_length question... Hello, While looking at SHOW TABLE STATUS, I noticed that all my dynamic tables seem to have a Max_data_length of 4,294,967,295 bytes. Is this true - that any dynamic tables are limited to 4GB in size? My fixed tables do not show this problem, and report that their Max_data_length is 4+ billion records times their record length (as expected). I'm using mysql version 3.23.41 on Red Hat Linux 7.2. Thanks, -Hank __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com - 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 you expertise
you will need to give it the password flag and then type in the password when prompted for one. mysql -u hasv -p Regards, Bhavin. - Original Message - From: Hugo Veiga [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 30, 2002 9:54 AM Subject: need you expertise Hi again, first of all thx for the precious help given to me. Well it seems i have problems again. Everytime i try to access mysql it returns: ERROR 1045: Access denied for user:'hasv@localhost' (Using password: NO) How can i put it to work? Any clue? I'm new to this so i apollogize if this is a very basci thing. Thxs in advance Hugo Veiga - 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: I can login to mysql as root but not as any other user...
Are u doing a user@hostname or user@%? The hostname part is needed, % means from anywhere. A better way to write this to prevent any errors is enclosing user host in single quotes as such: 'user'@'host'. Regards, Bhavin. - Original Message - From: Michael Knauf/Niles [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 26, 2002 6:31 AM Subject: I can login to mysql as root but not as any other user... mysql is running on an i386 box with Red Hat Linux 7.0 this works: mysql -u root -p --it askes for the root password, and lets me into the mysql monitor. I can create databases and tables, life seems good. than I try something like: Grant all on *.* to user identified by 'password'; where user and password make sense. It seems to work. So, I logout \q and try mysql -u user -p and I get an access denied error. Whare am I going wrong? Michael - 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: Is mySQL support replication ??
Yes it does. http://www.mysql.com/doc/R/e/Replication_Implementation.html - Original Message - From: Alice [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 24, 2002 6:52 PM Subject: Is mySQL support replication ?? Hi, all, May i know is mySQL support replication regards, alice /--- \ Confidential and/ or privileged information may be contained in this e-mail and any attachments transmitted with it ('Message'). If you are not the addressee indicated in this Message (or responsible for delivery of this Message to such person),you are hereby notified that any dissemination, distribution, printing or copying of this Message or any part thereof is prohibited. Please delete this Message if received in error and advise the sender by return e-mail. Opinions, conclusions and other information in this Message that do not relate to the official business of this company shall be understood as neither given nor endorsed by this company. This mail is certified Virus Free by *ProtectNow! (InternetNow Sdn Bhd) *Scanner Engine powered by Norman Virus Control \--/ - 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: file size limit hitting when LOAD DATA INFILE
Yes, MERGE Tables is useful for getting around the file size limit problem. However, Linux 7.2(Kernel 2.4.x), MySql 3.23.47 supports file sizes greater than 4GB. Mysql 3.23 by defaul will create tables that can grow only upto 4G but these can be altered using ALTER TABLE. You willl need to alter AVG_ROW_LENGTH and MAX_ROWS, the product of which is the file size that will be supported. http://www.mysql.com/doc/T/a/Table_size.html Also, if you do not want to go that route, you can use MERGE tables which will merge 2 or more underlying tables, say, AAA1 AAA2 into AAA. so you can either refer to AAA or indivually to AAA1 and AAA2. Generally, you want to refer to AAA while quering and the indiviudal tables while inserting/updating data. Regards, Bhavin. - Original Message - From: Buding Chen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 24, 2002 7:23 PM Subject: file size limit hitting when LOAD DATA INFILE Hi, all: I use MySQL 3.23.47, RH linux 7.2, file size limit is 4G. When LOAD DATA INFILE to a table whose file size is 4G, it fails and mysql_error(...) reports Lost connection to MySQL server during query. How can I clearly know the failed reason is just hit the 4G file size limit? If the 4G file size limit is hit, I have two ways to resolve it: (1) create a new table and LOAD DATA INFILE into this new table. (2) backup this table and clear it and reload. However, these two ways are troubled and not good. Dose some one have a effective way that just LOAD DATA INFILE without hitting file size limit? Dose MERGE Table help it here? Thanks in advance. B.R. Buding - 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
11G .err file
Hi, My mysql error file (hostname.err) had grown to 11G on Red Hat 7.0, kernel 2.4.3, file system type ext2. As I understand it, file size in Terrabytes can be supported under this kernel version, however, mysql semi-crashed at this point, meaning I could not connect to it remotely (I could connect locally but that didnn't help much). I had to kill -9 the process, a simple kill wouldn't work and even after that one mysql process was left hanging which a 'kill -9' wouldn't kill either. When I tried to bring mysql back up it complained about the error file being too large. I had to reboot the server finally to get everything to work. Has anybody seen this before and can explain why it happened? The other question is, Before I brought down the server and after I brought it up, I have been seeing the following message in my .err file: 020625 0:08:13 Error in accept: Invalid argument for probably every single query that gets executed. This is what is filling up my *.err file to 11GB in the first place. The results of the query seem to look fine but I get these errors in the error file...anyone know what they mean? Thanks, Bhavin. Thanks a lot, Bhavin. - 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: Problem under Solaris
Yes, it looks like the permissions are skewed. YOu might just want to do a chown -R mysql:mysql /usr/local/mysql The out-of-the-package permissions should be correct, ownership could be the issue. Regards, Bhavin. - Original Message - From: Emiliano Marmonti [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 21, 2002 7:36 AM Subject: Fw: Problem under Solaris Dear people I have a problem installing under Solaris. I've downloaded a compiled mysql, installed under /usr/local, create mysql group and mysql user, the owner of mysql/data is the group mysql and everything looks well. But when I try: bin/safe_mysqld --user=mysql The mysql starts and inmediatly ends. Looking the log file I can see that it says: 020621 20:49:05 mysqld started 020621 20:49:05 /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/l ocal/mysql/data/bdu.pid' (Errcode: 13) 020621 20:49:05 /usr/local/mysql/bin/mysqld: Can't find file: './mysql/host.frm ' (errno: 13) 020621 20:49:05 /usr/local/mysql/bin/mysqld: Error on delete of '/usr/local/mys ql/data/bdu.pid' (Errcode: 13) 020621 20:49:05 mysqld ended it looks like has no rights to write the file, isnĀ“t it. I tried to use scripts/mysql_install_db but It says that could not find mysqld and I 've seen that my.cnf does not exists. Is there a way to put it working or must I download source code and compile it from scratch? Thanks a lot in advance Emiliano H.Marmonti - 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: replication error
Also, if you are doing any 'LOAD DATA INFILE' where the master has access to the file but the slave does not, then this could happen. On most errors, the slave stop replicating and slave status will be turned to OFF. The error file, hostname.err might tell you some thing too. Regards, Bhavin. - Original Message - From: Cal Evans [EMAIL PROTECTED] To: Kannan R [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, June 22, 2002 9:26 AM Subject: RE: replication error I think somewhere in the manual it warns against running slave and master as different versions. =C= -Original Message- From: Kannan R [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 22, 2002 7:15 AM To: [EMAIL PROTECTED] Subject: replication error Placed At : Hi.. I run a replicated mysql server set up..The version i use on the master is 3.23.49 and on the slave is 3.23.46. following is the problem I'm facing.. the binlog postion on the master and the slave are always in sync with each other..whenever the master has an update then the change in the binlog pos happens fine and the slave also picks up from the master. and the log positions are in sync..but the data never gets copied to the slave.. in short the log positions are always in sync with each other but the data is never replicated to the server. has anybody com across this wierd error..? any help would be greatly appreciated regards kannan ** Quality Policy To be the best-in-class service provider by practising international standards in providing world-class services and end-to-end network solutions. ** - 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: here we go again
Does the error file (hostname.err) have any messages? Regards, Bhavin. - Original Message - From: Cindy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 21, 2002 4:34 PM Subject: here we go again mysql_st /usr/local/mysql/bin/mysql -u root -p Text Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) OK. The background is that mysql was started at the end of April and then not touched since. (not used to access anything, etc). The hostmachine was not restarted, either. The sticky bit in /tmp is set. I don't set up some other socket file in my.cnf. A careful perusal of ps -elf shows nothing named mysql or subset thereof seems to be running. This is sun solaris ultra 450. What I'm thinking is that mysqld shut down for some random reason and with it the socket vamooses as well? I'm trying to figure out what is going *on* here. I update some stuff about once a quarter with mysql but every single time I come back to it, despite having carefully set it up to work last time, I get this crap, try to restart mysqld, have a hell of a time doing so, and end up reinstalling the whole damn thing, only to start over again next time. Well this time, I'm yapping for help before touching a single thing, because I don't want to do this *again*. What is happening? --Cindy -- [EMAIL PROTECTED] - 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: undefined symbol: _dig_vec
use .bash_profile. - Original Message - From: Hoa Doan [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, June 14, 2002 10:13 AM Subject: Re: undefined symbol: _dig_vec I'm sorry for bugging you, but I don't have the .profile file. I have the .bashrc, .bash_profile, .bash_logout files. My shell is bash. What do I do now? Hoa From: Bhavin Vyas [EMAIL PROTECTED] To: Hoa Doan [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: undefined symbol: _dig_vec Date: Thu, 13 Jun 2002 16:09:40 -0700 LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib. Put this in your .profile file or the global .profile file so that it's executed evertime you log in. - Original Message - From: Hoa Doan [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, June 13, 2002 11:34 AM Subject: Re: undefined symbol: _dig_vec Thanks for you help so far. I do have the libodbcinst.so.1. It's located in the directory /usr/local/lib, but the program doesn't know that. How do I make it see that libodbcinst.so.1 is in /usr/local/lib? -Hoa From: Bhavin Vyas [EMAIL PROTECTED] To: Hoa Doan [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: undefined symbol: _dig_vec Date: Wed, 12 Jun 2002 21:54:08 -0700 You will have to get libodbcinst.so.1. This library file is needed by libmyodbc.so. You should be able to download it from the net. Here is one link that might help http://www.slac.stanford.edu/grp/eg/minos/external/installation/lib/libodbc i nst.so.1 - Original Message - From: Hoa Doan [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, June 12, 2002 6:38 PM Subject: Re: undefined symbol: _dig_vec So I ldd /usr/local/MyODBC/lib/libmyodbc.so and this is the result: libodbcinst.so.1 = not found libz.so.1 = /usr/lib etc... I did a find on libodbcinst.so.1 and found it in /usr/local/lib. What do I do from here? Hoa From: Bhavin Vyas [EMAIL PROTECTED] To: Hoa Doan [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: undefined symbol: _dig_vec Date: Wed, 12 Jun 2002 18:15:53 -0700 if you have the file /usr/local/MyODBC/lib/libmyodbc.so, then do ldd /usr/local/MyODBC/lib/libmyodbc.so and see if all the dependencies are satisfied. Regards, Bhavin. - Original Message - From: Hoa Doan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 12, 2002 11:52 AM Subject: undefined symbol: _dig_vec Hi, I'm using the unixODBC driver manager and MyODBC driver and trying to connect to my clients database on the MySQL server. But it can't connect. This is the message I get: Can't open lib /usr/local/MyODBC/lib/libmyodbc.so : undefined symbol: _dig_vec How do I fix this? -Hoa _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com - 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 _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - 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 _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - Before posting, please check: http://www.mysql.com/manual.php
Re: replication
The master information should be present in my.cnf on the slave. What does your my.cnf look like? Regards, Bhavin. - Original Message - From: Pierre Baridon [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 14, 2002 7:07 AM Subject: replication i am trying to setup a slave server (3.23.50) on solaris 2.7 i follow the manual to set it up but when i start this slave server, i have the following error message from mysqld : bin/mysqld: option `--master' is ambiguous where does this --master come from thanks, Pierre -- sql, query - 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
Multi-table deletes
Just wanted to make sure before I proceed to write a script, Muti-table deletes as such: delete from Keyname_Keyvalue,Keyvalue WHERE Keyvalue.KeyvalueKey=Keyname_Keyvalue.KeyvalueKey AND Keyname_Keyvalue.KeynameKey='100'; ERROR 1064: You have an error in your SQL syntax near 'Keyvalue WHERE Keyvalue.KeyvalueKey=Keyname_Keyvalue.KeyvalueKey AND Keyname_Key' at line 1 Are not supported in 3.23 but supported in 4.x. Is that correct? Any other options besides writing a script? Regards, Bhavin Vyas. - 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 port # ?
'status' will show that. - Original Message - From: Laura Findley [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Friday, June 14, 2002 1:44 PM Subject: MySQL port # ? Does anyone know how to determine what port MySQL is using? I need to know the port so that I can use it in a JDBC connection URL. Any suggestions on how to get this info? Thanks, in advance- Laura - 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: Mysql Replication
Stop master and slave remove binary logs (hostname.001, hostname.002...) from master remove log index (hostname.index) from master remove master.info from the slave tar data on master untar on slave start master and slave The directories of where the files reside would depend on the method of installation (binary, rpm, source) but if you can do a find or if you are on linux, locate would help. Regards, Bhavin. - Original Message - From: David McInnis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 14, 2002 3:09 PM Subject: Mysql Replication I am having a problem with replication. I had a master / slave environment set up and running successfully. I then took the slave offline for a while and made substantial changes to the master. Then I master copied the new database environment to the slave server by taring the tables and copying them to the slave server. Then I restarted the slave and now my slave database is not working. Is there something that I need to do in order to resync the slave with the new master? David McInnis Not really an SQL or query question, but ... - 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: varchar to char ...
Mysql optimizes the column type while creating the table. Regards, Bhavn. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 14, 2002 2:26 PM Subject: varchar to char ... Hi guys, I have a query.I am not sure if this is a bug or a feature (ha ha ha...). Table - abc name varchar(30), address varchar(50) Then I run this sql. create table temp_abc as select * from abc; datatypes of the columns changes: Table - temp_abc name char(30), address char(50) any clues, Vivek - 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: varchar to char ...
well, no, a Char field certainly won't take less space than Varchar but it helps in optimizing space since mysql can manage space better when it knows the exact length of the row. Hence, if you delete a record, instead of leaving a hole on the disk (in Varchar), it will fill it up with another record (when all the fields are Char) and leave no holes. Another benefit is during recovery. If a certain sector is bad, mysql can easily calculate where the record began, ended and move on to recover the good records. Regards, Bhavin. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, June 14, 2002 3:55 PM Subject: RE: varchar to char ... What do you mean by optimization of the column? Are you saying that char takes less space than varchar or the performance on char is better in queries compared with varchar ? The whole concept of CREATE AS is that you want target table to inherit all the properties with the data of the source tables and the columns. So I don't understand why should/would it change the data types of columns. thanks Vivek -Original Message- From: bvyas3 [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 6:36 PM To: CHAUDHARY, Vivek; mysql Cc: bvyas3 Subject: Re: varchar to char ... Mysql optimizes the column type while creating the table. Regards, Bhavn. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 14, 2002 2:26 PM Subject: varchar to char ... Hi guys, I have a query.I am not sure if this is a bug or a feature (ha ha ha...). Table - abc name varchar(30), address varchar(50) Then I run this sql. create table temp_abc as select * from abc; datatypes of the columns changes: Table - temp_abc name char(30), address char(50) any clues, Vivek - 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 - 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: undefined symbol: _dig_vec
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib. Put this in your .profile file or the global .profile file so that it's executed evertime you log in. - Original Message - From: Hoa Doan [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, June 13, 2002 11:34 AM Subject: Re: undefined symbol: _dig_vec Thanks for you help so far. I do have the libodbcinst.so.1. It's located in the directory /usr/local/lib, but the program doesn't know that. How do I make it see that libodbcinst.so.1 is in /usr/local/lib? -Hoa From: Bhavin Vyas [EMAIL PROTECTED] To: Hoa Doan [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: undefined symbol: _dig_vec Date: Wed, 12 Jun 2002 21:54:08 -0700 You will have to get libodbcinst.so.1. This library file is needed by libmyodbc.so. You should be able to download it from the net. Here is one link that might help http://www.slac.stanford.edu/grp/eg/minos/external/installation/lib/libodbc i nst.so.1 - Original Message - From: Hoa Doan [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, June 12, 2002 6:38 PM Subject: Re: undefined symbol: _dig_vec So I ldd /usr/local/MyODBC/lib/libmyodbc.so and this is the result: libodbcinst.so.1 = not found libz.so.1 = /usr/lib etc... I did a find on libodbcinst.so.1 and found it in /usr/local/lib. What do I do from here? Hoa From: Bhavin Vyas [EMAIL PROTECTED] To: Hoa Doan [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: undefined symbol: _dig_vec Date: Wed, 12 Jun 2002 18:15:53 -0700 if you have the file /usr/local/MyODBC/lib/libmyodbc.so, then do ldd /usr/local/MyODBC/lib/libmyodbc.so and see if all the dependencies are satisfied. Regards, Bhavin. - Original Message - From: Hoa Doan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 12, 2002 11:52 AM Subject: undefined symbol: _dig_vec Hi, I'm using the unixODBC driver manager and MyODBC driver and trying to connect to my clients database on the MySQL server. But it can't connect. This is the message I get: Can't open lib /usr/local/MyODBC/lib/libmyodbc.so : undefined symbol: _dig_vec How do I fix this? -Hoa _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com - 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 _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - 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 _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - 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: How can I get a top ten total count from a table?
I guess this is what you want: SELECT count(*) as syscount FROM events WHERE alert='1' GROUP BY sysid ORDER BY syscount LIMIT 10; - Original Message - From: Jason Lane [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 13, 2002 6:54 PM Subject: How can I get a top ten total count from a table? I'm trying to retrieve the top ten entries of a total count from a table. If I use the following select statement without the 'ORDER BY' clause it returns the totals but not in any sort of order. But when I add the 'ORDER BY' clause in it returns nothing. Is there a way to structure the query to do the total and return the total list in descending or ascending order? Example: SELECT count(*) FROM events WHERE alert='1' GROUP BY sysid ORDER BY sysid LIMIT 10 - 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: max_connections
If you are just doing a port scan, that shouldn't be a problem. However, if you are going to the DB server, you will need to grant at least 'usage' permissions to user@host via the GRANT statement. Regards, Bhavin. - Original Message - From: [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Wednesday, June 12, 2002 1:29 PM Subject: max_connections I've written a small port monitor in perl, just to check and make sure something is responding on the port. I don't want to do anything fancy, but it appears that MySQL doesn't like this. It doesnt block connections from localhost (thank goodness), but my remote port monitor gets locked out. I'm not sending any data, I'm just establishing and then closing the connection to the port. Is there any way to exempt a specific host(s)? Or is there an easy way in perl to tell the server that I'm just checking, so go ahead and disconnect me? Mark R. Andrachek, Jr. Analyst I Federal Reserve Bank of Richmond [EMAIL PROTECTED] (804) 697-7971 - 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: Sort search results by relevance
Are you using FULLTEXT indexes on the search coloumns? They will sort results according to relevance (depending upon the algorithm, that might not be what you want). It will index most of the relevant words in your column (which should be a TEXT or a VARCHAR field) and then search on those words. - Original Message - From: Nick Boldt [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 12, 2002 12:49 PM Subject: Sort search results by relevance I have created a search page which shows all records from a table that include one or more words of the search string. Is there a way I can have MySQL sort the results according to relevance, and only display each recordset once? I am using ASP with IIS 5 txtSearch = Request(txtSearch) arrSearch = split(txtSearch, ) tmpSearch = For x = 0 To UBound(arrSearch) If x 0 Then tmpSearch = tmpSearch or End If tmpSearch = tmpSearch us_desc LIKE '% arrSearch(x) %' Next searchString = SELECT * FROM consign WHERE consign_num = 'prodRs(consign_num)' AND ( tmpSearch ) ORDER BY consign_num ASC Thanks in advance for any help you can provide. Sincerely, Nick Boldt Computer Network Administrator Track of the Wolf Elk River, MN 55330 Tel: 763-633-2500 Fax: 763-633-2550 www.trackofthewolf.com [EMAIL PROTECTED] - 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: Sort search results by relevance
Also, this might help http://www.mysql.com/doc/F/u/Fulltext_Search.html - Original Message - From: Nick Boldt [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 12, 2002 12:49 PM Subject: Sort search results by relevance I have created a search page which shows all records from a table that include one or more words of the search string. Is there a way I can have MySQL sort the results according to relevance, and only display each recordset once? I am using ASP with IIS 5 txtSearch = Request(txtSearch) arrSearch = split(txtSearch, ) tmpSearch = For x = 0 To UBound(arrSearch) If x 0 Then tmpSearch = tmpSearch or End If tmpSearch = tmpSearch us_desc LIKE '% arrSearch(x) %' Next searchString = SELECT * FROM consign WHERE consign_num = 'prodRs(consign_num)' AND ( tmpSearch ) ORDER BY consign_num ASC Thanks in advance for any help you can provide. Sincerely, Nick Boldt Computer Network Administrator Track of the Wolf Elk River, MN 55330 Tel: 763-633-2500 Fax: 763-633-2550 www.trackofthewolf.com [EMAIL PROTECTED] - 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: undefined symbol: _dig_vec
if you have the file /usr/local/MyODBC/lib/libmyodbc.so, then do ldd /usr/local/MyODBC/lib/libmyodbc.so and see if all the dependencies are satisfied. Regards, Bhavin. - Original Message - From: Hoa Doan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 12, 2002 11:52 AM Subject: undefined symbol: _dig_vec Hi, I'm using the unixODBC driver manager and MyODBC driver and trying to connect to my clients database on the MySQL server. But it can't connect. This is the message I get: Can't open lib /usr/local/MyODBC/lib/libmyodbc.so : undefined symbol: _dig_vec How do I fix this? -Hoa _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com - 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: undefined symbol: _dig_vec
You will have to get libodbcinst.so.1. This library file is needed by libmyodbc.so. You should be able to download it from the net. Here is one link that might help http://www.slac.stanford.edu/grp/eg/minos/external/installation/lib/libodbci nst.so.1 - Original Message - From: Hoa Doan [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, June 12, 2002 6:38 PM Subject: Re: undefined symbol: _dig_vec So I ldd /usr/local/MyODBC/lib/libmyodbc.so and this is the result: libodbcinst.so.1 = not found libz.so.1 = /usr/lib etc... I did a find on libodbcinst.so.1 and found it in /usr/local/lib. What do I do from here? Hoa From: Bhavin Vyas [EMAIL PROTECTED] To: Hoa Doan [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: undefined symbol: _dig_vec Date: Wed, 12 Jun 2002 18:15:53 -0700 if you have the file /usr/local/MyODBC/lib/libmyodbc.so, then do ldd /usr/local/MyODBC/lib/libmyodbc.so and see if all the dependencies are satisfied. Regards, Bhavin. - Original Message - From: Hoa Doan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 12, 2002 11:52 AM Subject: undefined symbol: _dig_vec Hi, I'm using the unixODBC driver manager and MyODBC driver and trying to connect to my clients database on the MySQL server. But it can't connect. This is the message I get: Can't open lib /usr/local/MyODBC/lib/libmyodbc.so : undefined symbol: _dig_vec How do I fix this? -Hoa _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com - 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 _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - 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: newbie backup restore question
Once mysql is installed on the new system, you should be able to copy the old data directory onto the new and you should be good to go(make sure the permissions and the ownership are preserved) . Regards, Bhavin. - Original Message - From: Scott [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 11, 2002 5:06 PM Subject: newbie backup restore question I have a mysql database that I backed up by copying my /var directory to a cd before I installed a new release of linux. How do I restore it on the new system? Do I need to create the database in the new version of mysql first, or just copy some files from the old data directory into the new one? Thanks, SW - 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: sql query(group by + order by)
do a select patient_id,treatment_date from patient_treatment_history order by treatment_date desc limit 1; I am not sure but max(treatmen_date) might work too as such: select patient_id, max(treatment_date) from patient_treatment_history group by treatment_date; In your original query the group by clause is causing undesired results. - Original Message - From: lorenzo.kh [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 10, 2002 6:53 PM Subject: sql query(group by + order by) Hi, I got a table named patient_treatment_history Below is some of the records inside the table. patient_id,treatment_date,charges 1014,2002-01-28,20 1001,2002-02-02,100 1026,2002-04-08,74 1001,2002-04-15,85 1014,2002-05-05,50 1030,2002-05-16,125 1030,2002-06-18,180 1001,2002-06-25,125 I try to retrieve the last visit date for each patient using this query: select patient_id,treatment_date from patient_treatment_history group by(patient_id) order by treatment_date desc. But the result is not what i expected. Can anybody assist me on this? Thanks. - 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: LOAD DATA LOCAl
You can put it in any directory and then provide the FULL path to the file in the LOAD command. Regards, Bhavin. - Original Message - From: Hoa Doan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 09, 2002 12:26 AM Subject: Re: LOAD DATA LOCAl Hi, I've created a mysql database named clients with a client table. I want to load a text file using the LOAD DATA LOCAL command, but I don't know where I have to place the text file. I know that using the LOCAL keyword the text file will be read from the client host, but in what directory? -Hoa _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - 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: Can I override the auto-increment setting?
Alter tablemodfiy column command should do it. Regards, Bhavin. - Original Message - From: Jason Lane [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 09, 2002 2:50 PM Subject: RE: Can I override the auto-increment setting? I have a mysql table that has the primary key set to auto-increment. For a very strange reason we have a row with the primary key value of 0. This is like a default value for the application. I didn't want to do it this way, but it's too late now. If the 0 value doesn't exist we have to create it. The problem is that if I try to INSERT or REPLACE and the 0 value doesn't exist, it inserts the record with an auto-increment value, not 0. IS there a way to temporarily turn off Auto-Increment on the table? Just long enough for me to do my REPLACE and then turn it back on? - 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: Newbie MySQL installation problems (specific)
Have you tried .../bin/safe_mysqld start to start the DB first? This is what will create /tmp/mysql.sock socket file start the DB server. Then you can use the 'mysql' client for connecting to the DB. Also, if you don't want to use transactional database, meaning, if you don't want support for rollback and stuff, which I am guessing you might not, then you can download the 3.23.49 binary or rpm (not max) from the mysql.com site (instead of Marc Liyanage's site). Since it's giving errors regarding innodb, my guess is that the server is configured to create inno db tables and not myisam tables, which is what the default binaries/rpm are configured to do (i.e. create myisam tables, but they are non-transactional). Regards, Bhavin. - Original Message - From: Colin Cooler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 09, 2002 3:55 PM Subject: Newbie MySQL installation problems (specific) Buying Paul DuBois' most excellent book MySQL has made me more comfortable with Mysql and Unix, so I thought I would try to use Mysql/PHP combo as the web database for a redesigneed site at Right Moves For Youth (trying to keep at risk kids in school). After running his cleanup instructions and then downloading and installing the mysql package from Marc Liyanage's site, I tried to run the following command (as per instructions): sudo ./scripts/mysql_install_db; I then get the following results: Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ERROR: 1062 Duplicate entry 'localhost-root' for key 1 ERROR: 1062 Duplicate entry 'localhost-root' for key 1 020609 0:35:05 ./bin/mysqld: Shutdown Complete When I try to start mysql from the command line, I then get the ubiquitous error message: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) I also discovered a localhost.err file in my data directory which yields the following information: 020609 01:09:50 mysqld started Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add for example, innodb_data_file_path = ibdata1:30M But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 2 at http://www.innodb.com/ibman.html 020609 1:09:51 /usr/local/mysql-3.23.49/bin/mysqld: Can't create/write to file '/usr/local/mysql-3.23.49/data/localhost.pid' (Errcode: 13) 020609 1:09:51 /usr/local/mysql-3.23.49/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020609 1:09:51 /usr/local/mysql-3.23.49/bin/mysqld: Error on delete of '/usr/local/mysql-3.23.49/data/localhost.pid' (Errcode: 13) 020609 01:09:52 mysqld ended Finally, when I try the following: mysqladmin -u root status I also get the can't connect through /tmp/myssql.sock error message. No matter what I try, I can't seem to connect to mysql so that I can even BEGIN to figure out how to correct the 1062 problem! Can anyone tell me how to what the ERROR: 1062 message means and how to resolve this mess? I've searched the archives, and this error appears to have occurred occasionally, but being a newbie to MySQL, I can't understand the solutions to the problem. Usually this problem has occurred AFTER someone has been able to successfully connect to mysql. Oh Woe is me, Colin - 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: Newbie MySQL installation problems (specific)
Ah...give up not for we have been using mysql for quite a long time and it is pretty stable. Try this... instead of trouble shooting this install and getting it work... go to www.mysql.com, download an rpm if you are on Red hat linux (or Mandrake) and do an rpm -i mysql...rpm and rpm -i mysq..client..rpm (this file is for insalling the client). If not, just download the binary and follow the instructions. We haven't had any trouble at all installing mysql and this might be a system specific problem. Let me know how it works out. Regards, Bhavin. - Original Message - From: Colin Cooler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 09, 2002 6:42 PM Subject: Re: Newbie MySQL installation problems (specific) Thanks Bhavin, I tried your suggestion (safe_mysqld start) and get a lot of Permission denied errors. So, I su to root and try it, and it appears that it does start (Starting mysqld daemon with databases from /usr/local/mysql/data). However, when I try to connect, either as root (which I understand is not a good idea) or under my normal login, I get the same error, i.e., that the socket can't be found. Very puzzling and I'm quickly approaching the point of concluding that the amount of time trying to troubleshoot this mess not warranting the potential benefits. Colin Have you tried .../bin/safe_mysqld start to start the DB first? This is what will create /tmp/mysql.sock socket file start the DB server. Then you can use the 'mysql' client for connecting to the DB. Also, if you don't want to use transactional database, meaning, if you don't want support for rollback and stuff, which I am guessing you might not, then you can download the 3.23.49 binary or rpm (not max) from the mysql.com site (instead of Marc Liyanage's site). Since it's giving errors regarding innodb, my guess is that the server is configured to create inno db tables and not myisam tables, which is what the default binaries/rpm are configured to do (i.e. create myisam tables, but they are non-transactional). Regards, Bhavin. - Original Message - From: Colin Cooler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 09, 2002 3:55 PM Subject: Newbie MySQL installation problems (specific) Buying Paul DuBois' most excellent book MySQL has made me more comfortable with Mysql and Unix, so I thought I would try to use Mysql/PHP combo as the web database for a redesigneed site at Right Moves For Youth (trying to keep at risk kids in school). After running his cleanup instructions and then downloading and installing the mysql package from Marc Liyanage's site, I tried to run the following command (as per instructions): sudo ./scripts/mysql_install_db; I then get the following results: Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ERROR: 1062 Duplicate entry 'localhost-root' for key 1 ERROR: 1062 Duplicate entry 'localhost-root' for key 1 020609 0:35:05 ./bin/mysqld: Shutdown Complete When I try to start mysql from the command line, I then get the ubiquitous error message: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) I also discovered a localhost.err file in my data directory which yields the following information: 020609 01:09:50 mysqld started Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add for example, innodb_data_file_path = ibdata1:30M But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 2 at http://www.innodb.com/ibman.html 020609 1:09:51 /usr/local/mysql-3.23.49/bin/mysqld: Can't create/write to file '/usr/local/mysql-3.23.49/data/localhost.pid' (Errcode: 13) 020609 1:09:51 /usr/local/mysql-3.23.49/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020609 1:09:51 /usr/local/mysql-3.23.49/bin/mysqld: Error on delete of '/usr/local/mysql-3.23.49/data/localhost.pid' (Errcode: 13) 020609 01:09:52 mysqld ended Finally, when I try the following: mysqladmin -u root status I also get the can't connect through /tmp/myssql.sock error message. No matter what I try, I can't seem to connect to mysql so that I can even BEGIN to figure out how to correct the 1062 problem! Can anyone tell me how to what the ERROR: 1062 message means and how to resolve this mess? I've searched the archives, and this error appears to have occurred occasionally, but being a newbie to MySQL, I can't understand the solutions to the problem. Usually this problem has occurred AFTER someone has been able to
Re: How many MySQL tables can we open paralel
10, 000 files open at the same time...maybe the OS itself is getting flustered, you want to make sure that your OS can handle it, on *nix, u can do a ulimit -a and see the open files parameter Beyond that, the system level limit on Linux can be found as cat /proc/sys/fs/file-max - Original Message - From: Shoshi Iphtach Cohen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, June 08, 2002 2:00 PM Subject: How many MySQL tables can we open paralel Hi experts, I appreciate if you could tell me how many MySQL tables we can open in parallel. In our application (BuildaGate Suite Technology) which is based on PHP MySQL, there are strange situations of data loss, and we are looking for information on what are the limitations of an MySQL database. We suspect that it is because we open more than 10,000 different tables in the same application, but we would like to receive professional technical suggestions. You can see and check the application at www.buildagate.com. Best regards, Shoshi Cohen - BuildaGate Suite Technology - General Manager e-Mail: [EMAIL PROTECTED] - 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