Re: 5.1.51 Database Replica Slows Down Suddenly, Lags For Days, and Recovers Without Intervention
Luis, How large is your database? Have you checked for an increase in write activity on the master leading up to this? Are you running a backup against the replica? Thank you, Tyler Sent from my Droid Bionic On Oct 23, 2011 5:40 AM, Luis Motta Campos luismottacam...@yahoo.co.uk wrote: Fellow DBAs and MySQL Users [apologies for eventual duplicates - I've posted this to percona-discuss...@googlegroups.com also] I've been hunting an issue with my database cluster for several months now without much success. Maybe I'm overlooking something here. I've been observing the database slowing down and lagging behind for thousands of seconds (sometimes over the course of several days) even without any query load besides replication itself. I am running Percona MySQL 5.1.51 (InnoDB plug-in version 1.12) on Dell R710 (6 x 3.5 inch 15K RPM disks in RAID10; 24GB RAM; 2x Quad-core Intel processors) running Debian Lenny. MySQL data, binary logs, relay logs, innodb log files are on separated partitions from each other, on a RAID system separated from the operating system disks. Default Storage Engine is InnoDB, and the usual InnoDB memory structures are stable and look healthy. I have about 500 (read) queries per second on average, and about 10% of this as writes on the master. I've been observing something that looks like between 6 and 10 pending reads per second uniformly on my cacti graphs. The issue is characterized by the server suddenly slowing down writes without any previous warning or change, and lagging behind for several thousand seconds (triggering all sorts of alerts on my monitoring system). I don't observe extra CPU activity, just a reduced disk access ratio (from about 5-6MB/s to 500KB/s) and replication lagging. I could correlate it neither InnoDB hashing activity, nor with long-running-queries, nor with background read/write thread activities. I don't have any clues of what is causing this behavior, and I'm unable to reproduce it under controlled conditions. I've observed the issue both on severs with and without workload (apart from the usual replication load). I am sure no changes were applied to the server or to the cluster. I'm looking forward for suggestions and theories on the issue - all ideas are welcome. Thank you for your time and attention, Kind regards, -- Luis Motta Campos is a DBA, Foodie, and Photographer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=tpol...@engineyard.com
Re: select ... into local outfile ... ???
Dennis, The following closely simulates the default INTO OUTFILE, you'll have to modify it slightly for your purposes: mysql --delimiter=comma -N select_statement.sql \ | sed 's/\/\\\/g' \ | sed 's/\t/\,\/g' \ | sed 's/$/\/g' \ | sed 's/^/\/g' \ | sed 's/\NULL\/\\N/g' \ | sed 's/\\t/\t/g' ' output.txt Tyler * *On 9/2/11 3:40 PM, Dennis wrote: hi, there, the following is my sql statement: SELECT HIGH_PRIORITY SQL_BIG_RESULT SQL_NO_CACHE tb.url_sign, m_url,m_title, m_weightINTO OUTFILE '/tmp/a.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '\' LINES TERMINATED BY '\n' STARTING BY '=' FROM d_local.ta, d_news.tbWHERE ta.url_sign = tb.url_sign Before, the server and the client were on the same machine; now, I need to generate the output file on client (which is on a different machine from the server). But it seams that there is no select ... into LOCAL file statement.Any suggestion is appreciated. Dennis
Re: MySQL replication server
Additionally, if a user has the SUPER privilege (eg. all privileges on *.*) they can write to a database running in read-only mode. Yet another reason to never allow this privilege for general purpose users. Tyler On 11/22/10 8:08 AM, John Daisley wrote: The replicated database should not be accepting writes, if it is then you haven't set it up correctly On 22 November 2010 13:03,a.sm...@ukgrid.net wrote: Hi, I think you are wrong, slaves will always accept writes unless you set readonly in the mysql config. Due to this, and if you dont specifically set readonly on the slave you have to be very careful in order to maintain data integrity on the slave and also not to break repliacton. Tools like Maatkit are designed to check data integrity on the slave due to exactly this issue, thanks Andy. Quoting John Daisleydaisleyj...@googlemail.com: You are correct, in a master slave setup the slave does not accept writes. John On 22 November 2010 11:06, Machiel Richardsmachi...@rdc.co.za wrote: -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Changing database tables to different storage engine.
Machiel, Each table will be write locked while it is being altered so this will most likely impact the application. In addition to the write lock, the conversion causes each table to be completely rewritten in the new format so this will have a high impact on IO write activity and so it will impact overall IO throughput. If your application is mostly reads, is well cached in memory, and the tables are small this should be pretty fast and relatively pain free. If you aren't sure about the impact and conversion time you may want to restore a backup of the database to another location and run through the conversion while monitoring performance numbers. Tyler On 11/22/10 5:55 AM, Machiel Richards wrote: Thank you John I have in the meantime fond this to be the case (** someone changed config files without my knowledge it seems as this was setup properly and working**) Anyhow, in order for the innodb to be active again I need to restart the database, however aftewards I assume the tables will still be MyIsam. In this event I will need to manually alter each table, and I am concerned about the impact of this on the system performance. Regards Machiel -Original Message- From: John Daisleydaisleyj...@googlemail.com To: Machiel Richardsmachiel.richa...@gmail.com Cc: mysql mailing listmysql@lists.mysql.com Subject: Re: Changing database tables to different storage engine. Date: Mon, 22 Nov 2010 10:51:23 + I have frequently seen Innodb 'silently' disabled if the innodb_log_file_size is different to the files size on disk (quite common when moving systems about). You wont be able to use innodb until you resolve this either by deleting the log files and restarting mysqld so they get recreated or changing the innodb_log_file_size to match the size of the files on disk. If the Innodb engine is not available then MySQL will use the default (usually MyISAM) storage engine even if Innodb was specified. You can stop this behaviour by setting sql-mode=NO_ENGINE_SUBSTITUTION Regards John On 22 November 2010 10:12, Machiel Richardsmachiel.richa...@gmail.com wrote: Hi All Sorry but things have now changed, and I found the following. The tables was in fact restored as Innodb, however someone seems to have gone and changed something causing innodb to be disabled, this caused the tables to be defaulted back to MyIsam. Should this not rather have just resulted in an error allowing to fix the problem in the first place instead of changing the storage engines? Anyone have some thoughts on the best solution to fix this? I will look into the innodb not working soon. Machiel -Original Message- From: Machiel Richardsmachi...@rdc.co.za To: mysql mailing listmysql@lists.mysql.com Subject: Changing database tables to different storage engine. Date: Mon, 22 Nov 2010 11:59:03 +0200 Good day all Hope all is well. I have something to ask as someone might have done this as well and may have a good solution on how to fix this. During a database migration this weekend to move a MySQL database from windows to linux, we created a backup and restore of the database. However, form my part I made a mistake by overlooking the fact that the windows database was configured to use default storage engine as Innodb. On the new server, the default was set to MyIsam. This resulted in all the tables being restored to the new system as MyIsam instead of Innodb. In order to fix this, I know you can use alter table to change the storage engine, however I need to know the following: 1. this is a production system and can't afford any downtime or as little performance degration as possible. What is the best way to do this in order to have the least amount of effect on the database and it's performance? Regards Machiel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: uninstall/reinstall
Tammie, You might just try resetting the root password http://dev.mysql.com/doc/refman/5.1/en/resetting-permissions.html#resetting-permissions-windows. Hope this helps, Tyler On 10/19/10 12:38 PM, Montgomery, Tammie wrote: I had an old version of mySQL on my computer but never used it. I thought I knew the root password but it wouldn't let me in. I went ahead and uninstalled it thinking I would get a newer version anyway. I used the Windows interface to uninstall the previous version. It appeared to be gone but when I installed the new version, it asked me what the previous root password was and then give new one. I left previous blank and gave it the new password. Now it has been sitting at the screen in the configuration wizard for Apply security settings for about 20 minutes. How should I recover from this? Barracuda 400 vers 3.5.12 Checked - Virus Free -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL crashes
Charlene, You should check the mysql error log and if there isn't a message about the cause there you may want to check /var/log/syslog for mysql being killed by oomkiller. Tyler On 6/21/10 11:11 AM, Charlene wrote: Anybody have any idea why MySQL would start to have this error message every 4 or so days at midnight: Connection error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) This just started happening a little more than 2 weeks ago. The server has been running fine for almost two years. MySQL is on a Linux system. There are about 750 dbs and accessed by approximately half that number websites (375). Half of the websites are on a different server than the MySQL server. Charlene -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Trouble compiling C on OS X
First off, I apologize for the fact that I'm not more versed in the inner workings of GCC and linking libraries and etc, I'm a web developer and I'm just using C to try to cut down on some speed problems. This is my little test program: #include stdio.h #include stdlib.h #include math.h #include mysql.h MYSQL mysql; MYSQL_RES *res; MYSQL_ROW row; void exiterr(int exitcode) { fprintf( stderr, %s\n, mysql_error(mysql) ); } int main( int argc, char *argv[] ) { uint i = 0; if(!(mysql_connect(mysql,localhost,root,password))) exiterr(1); if (mysql_select_db(mysql,hallow)) exiterr(2); if(mysql_query(mysql,SELECT * FROM sections)) exiterr(3); if(!(res = mysql_store_result(mysql))) exiterr(4); while((row = mysql_fetch_row(res))) { for(i=0; i mysql_num_fields(res); i++) printf(%s|,row[i]); printf(br); } mysql_free_result(res); mysql_close(mysql); return 0; } and I'm attempting to compile it with this command: gcc -I/usr/include concept.c -L/usr/lib/mysql -lmysqlclient -lm -o concept -lz I'm quite certain that the header files are in /usr/include. And, what I assume to be the libraries are in /usr/lib/mysql. (libdbug.a,libmygcc.a, libmysql.imp, etc...) This is the error I get when trying to compile: /usr/bin/ld: Undefined symbols: _mysql_connect collect2: ld returned 1 exit status Any thoughts on why this might be happening? Is there any other information that I can provide which will help to determine whats wrong? Thanks in advance for the help, Tyler McMullen
A little help with this select?
Hi, I'm baffled. Been lookin at this for the last hour now. SELECT worker.fname,worker.lname,worker.workerid FROM worker,webprojectassign WHERE worker.workerid!=webprojectassign.workerid ORDER BY worker.lname ASC; That's the SQL in question. There's currently nothing in the webprojectassign table. So shouldn't this SQL just return the fname,lname,workerid from the workers table? Could someone just explain to me why this doesn't work the way I expected it to? Maybe I'm doing something wrong. THANKS! Best Regards, -- Tyler Longren J.D. Web Services, L.C. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: A little help with this select?
Rory, that's awesome. Exactly what I needed. After reading your first reply I wrote a query that was very similar to the one you just posted (included below). It didn't quite work right however. It was still a lot closer than I was before. Thanks again! SELECT worker.fname,worker.lname,worker.workerid FROM worker LEFT JOIN webprojectassign ON worker.workerid = webprojectassign.workerid WHERE webprojectassign.workerid IS NULL ORDER BY worker.lname ASC Tyler On Tue, 2004-01-06 at 02:22, Rory McKinley wrote: On 6 Jan 2004 at 9:31, Noamn wrote: Rory wrote: The query is behaving exactly as it should. Your query asks it to return only those workers that are listed in the webprojectassign table. Seeing as there are no entries in the webprojectassign table, no workers match and hence no results are produced. No'am adds: I think that Tyler wanted the workers who aren't listed in the webprojectassign table - his query contains WHERE worker.workerid!=webprojectassign.workerid Is != a different way of writing ? If he wants the unassigned workers, then he needs what I've seen referred to as a 'theta join', and I too would be interested to see how to do this in mySQL. When I've needed such a query, to find 'childless' records, I've always done it with a looped query in the client program. -Original Message- From: Rory McKinley [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 9:19 AM To: Tyler Longren; [EMAIL PROTECTED] Subject: Re: A little help with this select? On 6 Jan 2004 at 1:00, Tyler Longren wrote: Hi, I'm baffled. Been lookin at this for the last hour now. SELECT worker.fname,worker.lname,worker.workerid FROM worker,webprojectassign WHERE worker.workerid!=webprojectassign.workerid ORDER BY worker.lname ASC; That's the SQL in question. There's currently nothing in the webprojectassign table. So shouldn't this SQL just return the fname,lname,workerid from the workers table? Could someone just explain to me why this doesn't work the way I expected it to? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Oooops...my apologies to all...I guess it helps if one actually reads properly. In this case, the solution to Tyler's problem will be a left join. The query should look something like this : SELECT worker.fname,worker.lname,worker.workerid FROM worker LEFT JOIN webprojectassign ON worker.workerid = webprojectassign.workerid WHERE webprojectassign.workerid IS NULL ORDER BY worker.lname ASC This will retrieve all the worker details where there are no matching entries in the webprojectassign table. Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] There are 10 kinds of people in this world, those who understand binary and those who don't (Unknown) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problems with MySQL on Linux (Linux Newbie)
Hi, I am just learning to use Linux and I am having some problems with getting MySQL to load. I have successfully installed tested both Apache PHP, so I am pretty comfortable with the whole configure and make processes. I followed the MySQL installation docs to the letter, however when I try to load the MySQL daemon as instructed, the program just quits after a few seconds. Here is the terminal output: [EMAIL PROTECTED] mysql]# ./bin/mysqld_safe --user=mysql [1] 30010 [EMAIL PROTECTED] mysql]# Starting mysqld daemon with databases from /var/lib/mysql 030923 09:30:18 mysqld ended Anyone know what I am doing wrong? Thanks
RE: [PHP] Lost Connection to MySQL server during query
I am using mysql_connect. But I just changed it to mysql_pconnect and it did exactly the same thing. -Original Message- From: Marek Kilimajer [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 10:48 AM To: Donald Tyler Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Lost Connection to MySQL server during query Are you using mysql_pconnect or just mysql_connect? Donald Tyler wrote: I have a script that is processing data from a single table and splitting it into smaller normalized tables. The script takes anywhere between 5-10 minutes to complete, and as it runs it constantly outputs a report on its progress. The script seems to run fine the first time I run it, but with subsequent runs (To see if it incorrectly creates duplicates of records etc), after a couple of minutes the script ends with an error message saying Lost connection to MySQL server during query. During the first run, the script is mostly just chopping up the data and placing it in the new tables, and doing a little comparing. But during subsequent runs, all of the records in the new tables should already exist, so the script see's this, and instead of creating new records, it compares them to see if its correct. Does anyone have any idea why it would be losing connection all the time? This is just being run on a test server at the moment. Being used as the server and also the client, configured as follows: Windows XP Tablet Edition PHP 4.3.3 PHP Extensions: XmlRPC MySQL 4.0.14 Apache 2.0.47 Please help, this has been making my life hell for a week now! Thanks Donald -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Lost Connection to MySQL server during query
I have a script that is processing data from a single table and splitting it into smaller normalized tables. The script takes anywhere between 5-10 minutes to complete, and as it runs it constantly outputs a report on its progress. The script seems to run fine the first time I run it, but with subsequent runs (To see if it incorrectly creates duplicates of records etc), after a couple of minutes the script ends with an error message saying Lost connection to MySQL server during query. During the first run, the script is mostly just chopping up the data and placing it in the new tables, and doing a little comparing. But during subsequent runs, all of the records in the new tables should already exist, so the script see's this, and instead of creating new records, it compares them to see if its correct. Does anyone have any idea why it would be losing connection all the time? This is just being run on a test server at the moment. Being used as the server and also the client, configured as follows: Windows XP Tablet Edition PHP 4.3.3 PHP Extensions: XmlRPC MySQL 4.0.14 Apache 2.0.47 Please help, this has been making my life hell for a week now! Thanks Donald
FW: Can MySQL 4.0.14 store HTML? Among other things....
Yes it can. But you should understand the three distinct levels of that situation. You need the following: Database Web Server Server-Side Scripting Language I would suggest using AMP (Apache, MySQL PHP). If you want to know more about how these work in conjunction I would suggest the excellent book: Web Database Applications by Oreilly. It is the perfect beginners guide for this area. Good luck. -Original Message- From: Machiste' N. Quintana [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 3:29 PM To: [EMAIL PROTECTED] Subject: Can MySQL 4.0.14 store HTML? Among other things Hey. I'm New (as you probably can tell), and I was wondering if MySQL 4.0.14 can store HTML, PHP, JavaScript and/or Flash. Can it? I'm assuming it would be stored as a string, and if outputted by PHP, would it output as HTML? (Or JavaScript, PHP, or Flash) Thanks! --Machiste' N. Quintana -- 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]
FW: mysql LOAD DATA INFILE
I see you still have the word LOCAL in there. Did you try and remove it? To do that in PHPMyAdmin you will need to run the import so you get the error message and then copy and paste it into the SQL section of the PHPMyadmin tool. Delete the world LOCAL and then run the query. It should work. -Original Message- From: Mike At Spy [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 2:59 PM To: Donald Tyler; [EMAIL PROTECTED] Subject: RE: mysql LOAD DATA INFILE Sorry, that is the error - my mistake. I am getting this: LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE `this_one` FIELDS TERMINATED BY ';' LINES TERMINATED BY '\r\n' I am using phpMyAdmin 2.3.3 - would an upgrade to the latest version remedy the issue? Thanks, -Mike -Original Message- From: Donald Tyler [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 3:42 PM To: [EMAIL PROTECTED] Subject: RE: mysql LOAD DATA INFILE PHPMyAdmin uses the LOAD DATA LOCAL INFILE command. Just remove the word LOCAL and it should work fine. -Original Message- From: Mike At Spy [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 2:35 PM To: [EMAIL PROTECTED] Subject: mysql LOAD DATA INFILE When I come across this error: The used command is not allowed with this MySQL version Does this mean that I need a whole different verison of MySQL, or just a different compile? The command was 'LOAD DATA INFILE' and I was doing it through phpMyAdmin. Thanks, -Mike -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
FW: mysql LOAD DATA INFILE
Then the only way you can do it that I can think of is to write a PHP script to do basically what PHPMyAdmin is trying to do but without the LOCAL in there. However to do that you would need to be able to place the PHP file on the server, and I guess you probably can't do that either. Talk about catch 22... The only other way I can think of is to install MySQL on a machine you control, then import the data there using the method I suggested earlier. Once you have done that, you can use PHPMyAdmin to export the database from your machine. It should give you a SQL command that will create the data on another machine. Just copy and paste that into the SQL window on the main server and that will insert it. It's a little messy but that's the only other way I can think of doing it. Sorry. -Original Message- From: Mike At Spy [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 3:24 PM To: Donald Tyler; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: mysql LOAD DATA INFILE Ah. No wonder it dinna work. Neither did specifying the columns as Jay suggested. I also have no choice but to do it through the browser - I don't have command line access on the server. :\ -Mike -Original Message- From: Donald Tyler [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 4:08 PM To: [EMAIL PROTECTED] Subject: RE: mysql LOAD DATA INFILE Oh and just a note. This solution won't work if you are uploading the file to the server through the browser. You will need to put the file on the server and adjust the commands PATH accordingly. -Original Message- From: Donald Tyler [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 3:07 PM To: '[EMAIL PROTECTED]' Subject: FW: mysql LOAD DATA INFILE I see you still have the word LOCAL in there. Did you try and remove it? To do that in PHPMyAdmin you will need to run the import so you get the error message and then copy and paste it into the SQL section of the PHPMyadmin tool. Delete the world LOCAL and then run the query. It should work. -Original Message- From: Mike At Spy [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 2:59 PM To: Donald Tyler; [EMAIL PROTECTED] Subject: RE: mysql LOAD DATA INFILE Sorry, that is the error - my mistake. I am getting this: LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE `this_one` FIELDS TERMINATED BY ';' LINES TERMINATED BY '\r\n' I am using phpMyAdmin 2.3.3 - would an upgrade to the latest version remedy the issue? Thanks, -Mike -Original Message- From: Donald Tyler [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 3:42 PM To: [EMAIL PROTECTED] Subject: RE: mysql LOAD DATA INFILE PHPMyAdmin uses the LOAD DATA LOCAL INFILE command. Just remove the word LOCAL and it should work fine. -Original Message- From: Mike At Spy [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 2:35 PM To: [EMAIL PROTECTED] Subject: mysql LOAD DATA INFILE When I come across this error: The used command is not allowed with this MySQL version Does this mean that I need a whole different verison of MySQL, or just a different compile? The command was 'LOAD DATA INFILE' and I was doing it through phpMyAdmin. Thanks, -Mike -- 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] -- 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 LOAD DATA INFILE
PHPMyAdmin uses the LOAD DATA LOCAL INFILE command. Just remove the word LOCAL and it should work fine. -Original Message- From: Mike At Spy [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 2:35 PM To: [EMAIL PROTECTED] Subject: mysql LOAD DATA INFILE When I come across this error: The used command is not allowed with this MySQL version Does this mean that I need a whole different verison of MySQL, or just a different compile? The command was 'LOAD DATA INFILE' and I was doing it through phpMyAdmin. Thanks, -Mike -- 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 LOAD DATA INFILE
Oh and just a note. This solution won't work if you are uploading the file to the server through the browser. You will need to put the file on the server and adjust the commands PATH accordingly. -Original Message- From: Donald Tyler [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 3:07 PM To: '[EMAIL PROTECTED]' Subject: FW: mysql LOAD DATA INFILE I see you still have the word LOCAL in there. Did you try and remove it? To do that in PHPMyAdmin you will need to run the import so you get the error message and then copy and paste it into the SQL section of the PHPMyadmin tool. Delete the world LOCAL and then run the query. It should work. -Original Message- From: Mike At Spy [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 2:59 PM To: Donald Tyler; [EMAIL PROTECTED] Subject: RE: mysql LOAD DATA INFILE Sorry, that is the error - my mistake. I am getting this: LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE `this_one` FIELDS TERMINATED BY ';' LINES TERMINATED BY '\r\n' I am using phpMyAdmin 2.3.3 - would an upgrade to the latest version remedy the issue? Thanks, -Mike -Original Message- From: Donald Tyler [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 3:42 PM To: [EMAIL PROTECTED] Subject: RE: mysql LOAD DATA INFILE PHPMyAdmin uses the LOAD DATA LOCAL INFILE command. Just remove the word LOCAL and it should work fine. -Original Message- From: Mike At Spy [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 2:35 PM To: [EMAIL PROTECTED] Subject: mysql LOAD DATA INFILE When I come across this error: The used command is not allowed with this MySQL version Does this mean that I need a whole different verison of MySQL, or just a different compile? The command was 'LOAD DATA INFILE' and I was doing it through phpMyAdmin. Thanks, -Mike -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Advice wanted on Data Structure
I have a question that I hope I can explain well enough: I am trying to figure out a data structure for an inventory system. The system contains: Items Kits(Made from a collection of Items and/or other Kits) Now my question is: Is there any way to structure this in a database so that I could run a single query to get the contents of a kit, even though it contains other kits? My problems occur when I try to create the tables as so: ITEMS: KIT_CONTENTSKITS KIT_IDKIT_ID ITEM_ID-ITEM_ID Description Description Price Etc The only way I could think of to allow a kit to be contained within a kit: Add another field to KIT_CONTENTS called Sub_Kit Which seems like a dumb way of doing it, because first of all, most kits don't have sub kits, so that would be a wasted field in most cases. Secondly, as far as I know the application logic would have to do multiple queries's to get the sub_kits. I really hope there is a simple and more logical way to do this, preferably allowing me to run a SINGLE query that will show a kit with all its sub kits. Otherwise I would need to have repeated queries from the application logic, and I really want to avoid that. Please help, thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problems setting up Priveleges
Greetings, I have installed MySQL 4.0.13 in a Windows 2000 machine. I am new to this and originally did the install on a box that was secure from the internet and ran some tests. I ran a forum software program and also created a few databases on my own, all successfully (although some troubleshooting was generally required here and there=) Now, I am preparing to move this to a production server and am running into problems. I followed the instructions on 'securing' the database and now continually have problems with connecting to the database. In general, it does not seem to like [EMAIL PROTECTED] I have gone into the user table in mysql db and placed both 'localhost' and '%' into the host entry. It was my understanding that '%' would allow access from any host for that particular username. Comically enough, most of the time that I go in and do this editing, I subsequently get out of MySQL, stop and restart the service and then, of course, it will not even let me log in. The error always revolves around the 127.0.0.1. Here are some of the things which I do to supposedly secure the MySQL install : delete from user where User=''; update user set User='NewRootName', Password=password('NewPassword') where User='root'; update user set host='%' where user='NewRootName'; flush privileges; I have searched the internet for an answer to my problem and seen where users are pointed to http://www.mysql.com/doc/en/Access_denied.html But, quite frankly, these instructions must not be for a Windows OS and simply do not work (or they assume that the reader has other knowledge that I do not have.) Any assistance on this issue will be much appreciated. Thanks! JT -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems setting up Priveleges
- Original Message - From: J.A. Jones Tyler III [EMAIL PROTECTED] I have gone into the user table in mysql db and placed both 'localhost' and '%' into the host entry. It was my understanding that '%' would allow access from any host for that particular username. Well, I finally specifically granted all priv's to username@127.0.0.1' and was able to get it to work. Can someone give me the syntax for giving a user the right to access a dB or all dB's from any domain? I must be inputing it wrong. To recap, I was writing this : grant all privileges to dbname.* to username@% identified by 'password'; It took it and when I looked into the table, it showed it in there. But, whenever I tried to use php to connect, I'd get the error about access denied to [EMAIL PROTECTED] Only when I specifically entered the local host defaul ip as a host that username could connect from did it work. Thanks again for any help! jt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems setting up Priveleges
- Original Message - From: Paul DuBois [EMAIL PROTECTED] Where are these instructions found? Got em here : http://www.analysisandsolutions.com/code/mybasic.htm#installation snip Yes, unless some other user table matches first, which may be what is happening in your case. Cool. Ok, that's new info for me. What is the table order that MySQL uses to grant authentication? On that same note, if I understand your response, does it stop the minute it finds a suitable entry (I guess it matches the user name) or does it grab info from all tables for that username? If the latter, does it grant the privileges inclusively (i.e. does it get everything that they all grant individually (so you get different rights from different tables) or does it only grant what all of the tables allow (only those privileges that are granted on each table are granted)? SNIP Stopping and starting the service should be unnecessary. The FLUSH PRIVILEGES statement you're using causes the server to reload the grant tables. Excellent. Thanks for the info! Here are some of the things which I do to supposedly secure the MySQL install : delete from user where User=''; update user set User='NewRootName', Password=password('NewPassword') where User='root'; update user set host='%' where user='NewRootName'; flush privileges; What is the output of the following statement after you issue the preceding statements: SELECT Host, User, Password FROM user; I get two entries, both for the same username (I've actually already uninstalled MySQL for the umpteenth time, but I did what you asked before to be sure it was there). The first instance of the username is matched to 'localhost' and the second instance is matched to '%'. In both cases the password is the same (in this case it was 'lwtest'). Thanks a TON for your assistance...I've spent quite a bit of time working on this daggone thing (as a side, I am 100% sure that I am doing something wrong, I just can't figure out what the heck it is!) JT -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems setting up Priveleges
- Original Message - From: Paul DuBois [EMAIL PROTECTED] I have gone into the user table in mysql db and placed both 'localhost' and '%' into the host entry. It was my understanding that '%' would allow access from any host for that particular username. Yes, unless some other user table matches first, which may be what is happening in your case. These comments you made have gotten me to thinking. When I was having problems, per the original query, I actually had two incidents of the same username in my user table. They were the only users in fact. Each was tied to a different domain. I continued to get errors. Perhaps it was grabbing the first entry (which was simply defined as 'localhost' for the host) and not going further? The reason I ask is that I had no problems when I put in a NEW username (and also tied it directly to the local host ip instead of the dns/host name.) I at first thought it was because I tied it directly to the ip, but it was also the only incident of that new username, so it could not get busted out like my original username. None of the above probably makes much senseand I probably am not using the right lingo...so, I apologize for that. But, I am learning slowly=) JT -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mySQL GUI
MySQL CC from www.mysql.com is pretty good. Tyler - Original Message - From: Neil Tompkins [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 04, 2003 1:49 PM Subject: mySQL GUI I have recently purchased the lease of a dedicated mySQL server running on linux. I normally use a GUI tool to modify databases etc. But now I need to create them aswell. Can anyone recommend a free tool to do this to run on Windows and connection to a mySQL server running on linux. Thanks Neil _ Overloaded with spam? With MSN 8, you can filter it out http://join.msn.com/?page=features/junkmailpgmarket=en-gbXAPID=32DI=1059 -- 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]
BUG: NT service account and defaults file
I've been trying to install MySQL (3.23.55) as a named NT service and using a specified defaults file and I can't get it to work. The source code has the example: mysqld --install-manual mysqldopt --defaults-file=c:\miguel\my.ini in it. The results in a service ImagePath of C:\mysql\bin\mysqld-nt --defaults-file=c:\miguel\my.ini mysqldopt However with this configuration the service refuses to start. Looking at the code (3.23, 4.0 and 4.1) it looks as if it is getting confused in the main (in mysqld.cpp) and just calls Service.Init without loading the default file. Doing the above without a service name works OK, doing it without over-riding the default-file is OK. Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Running as a user account on W2K
I've discovered what causes this issue. The file nt_serv.cpp has a method called IsService. This requests SERVICE_ALL_ACCESS permission from the service control manager. Changing this to SERVICE_QUERY_STATUS fixes the issue whilist achieving the same effect/ Simon Message from Simont Tyler [EMAIL PROTECTED] at 12-Mar-2003 12:58:35 -- Hi, I've installed MySQL 3.23.55 on Windows 2000 and I am trying to run the mysqld service as a user account rather than the local system account. This worked fine in 3.23.43 but has stopped working since the upgrade. The error I get is 2186, which seems to be service failing to respond to control function. Any ideas? Simon - 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
Running as a user account on W2K
Hi, I've installed MySQL 3.23.55 on Windows 2000 and I am trying to run the mysqld service as a user account rather than the local system account. This worked fine in 3.23.43 but has stopped working since the upgrade. The error I get is 2186, which seems to be service failing to respond to control function. Any ideas? Simon Due to high demand and an increasing takeup of the Gordano Messaging Suite as a complete email solution, Gordano are pleased to announce the availability of a comprehensive Gordano Training Programme. The Programme offers a logical and structured approach to GMS with an emphasis on ease of administration and high return on investment. For further information please see: http://www.gordano.com/Training/Courses.htm Alternatively, contact the Gordano Sales department on: +44 1275 345 100, or, 877 292 1142 (USA) Email: [EMAIL PROTECTED] NB: This email and any attachments have been checked for the presence of computer viruses using Gordano Messaging Suite Anti-Virus technology. None were found. - Gordano Ltd Tel UK: +44 1275 345100 Fax UK: +44 1275 340056 Tel USA: +1 877 292 1142 http://www.gordano.com Sales EMail: [EMAIL PROTECTED] Support EMail: [EMAIL PROTECTED] This message is confidential and intended solely for the use of the addressee. Quotations are subject to contract and valid for 28 days. - - 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
Code explaination
Just saw the following code in the MySQL 2.23.55 source code. The semi-colon after the if renders the if statement useless. Could someone explain if it is intentional. The comment indicates that it is. Simon /* the following 'if', thought conceptually wrong, is a useful optimization nevertheless. */ if (file-state != file-s-state.state); file-s-state.state = *file-state; Due to high demand and an increasing takeup of the Gordano Messaging Suite as a complete email solution, Gordano are pleased to announce the availability of a comprehensive Gordano Training Programme. The Programme offers a logical and structured approach to GMS with an emphasis on ease of administration and high return on investment. For further information please see: http://www.gordano.com/Training/Courses.htm Alternatively, contact the Gordano Sales department on: +44 1275 345 100, or, 877 292 1142 (USA) Email: [EMAIL PROTECTED] NB: This email and any attachments have been checked for the presence of computer viruses using Gordano Messaging Suite Anti-Virus technology. None were found. - Gordano Ltd Tel UK: +44 1275 345100 Fax UK: +44 1275 340056 Tel USA: +1 877 292 1142 http://www.gordano.com Sales EMail: [EMAIL PROTECTED] Support EMail: [EMAIL PROTECTED] This message is confidential and intended solely for the use of the addressee. Quotations are subject to contract and valid for 28 days. - - 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 3.23.55 Install Issues
Hi, I've been trying to get the 3.23.55 version of mysqld-nt.exe working with our product (GMS Mail) and I'm running into install\service related issues. I've read through the various threads on this list and nothing seems to solve my problem. The situation is that we include MySQL with our product and manage the starting\stopping of the service ourselves (don't ask why). We currenlly use 3.23.43 and are looking to upgrade to 3.23.55. We don't ship the full MySQL install dues to size but just ship those parts we need. Using 3.23.43 this is fine and we are able to run mysqld-nt as a service under our own service name with no problems. With 3.23.55 this does not work. It seems that the executable requires itself to be installed as the MySQL service. If I do this then all is fine and good. However we don't need to install the service as we have it installed ourselves under a different name and we don't wish to do this as it may interfer with a customer who potentially has a different version of MySQL installed on the same machine. The startup options we use are: mysqld-nt -default-file=file -basedir=dir -datadir=dir --port=non-std port -bind-address=127.0.0.1 -socket= The cnf file is generally empty. With these options the service starts but querying it's status fails and the port\ip that it is listening on are incorrect - the defaults are used. Any ideas? Simon - 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
Cant change anything via web?
Hey.. I've got a promblem. I use PHP, and I cant seem to be able to change anything in the MySQL db via the webpage. I know the scripts are correct, but nothing happens when I change somethign via web. I've even installed PhpMyAdmin to moniter the DB via the web, and that doesn't work either. I dont knwo whats wrong.. but the only way I can edit my DB is to do it via mysqladmin ON the linux box -Thanks oin advance Tyler - 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: Compiling error 3.23.54a (src)
Oh.. I see. I dont know about Linux, all I knew was that I wanted it so I burned the necissary CD's and installed linux on my other machine. So, you're saying I should use a mandrake-linux forum, instead of mysql? - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Tyler [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, January 14, 2003 10:32 PM Subject: Re: Compiling error 3.23.54a (src) On Tue, Jan 14, 2003 at 08:58:07PM -0700, Tyler wrote: what appropriate forums? I'm not a Mandrake user, but every Linux distribution I've tried has had various e-mail and web-base forums in which you can ask questions. Furthermore, they have official support channels and ways of filing bug reports if you've found a but. Surely the Madrake documentation mentinons *some* of them. And odds are that Google could find a few more of them. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 31 days, processed 1,015,781,700 queries (379/sec. avg) - 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
Uninstall MySQL?
Can someone please guide me in uninstalling all the failed installs of MySQL I've got? I've installed like 2 binaries, and 1 source.. none work :( - 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: Compiling error 3.23.54a (src)
what appropriate forums? - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, January 14, 2003 7:21 PM Subject: Re: Compiling error 3.23.54a (src) On Tue, Jan 14, 2003 at 05:56:07PM -0700, [EMAIL PROTECTED] wrote: Does this mean I wont get a reply? this is the 3rd post regarding this matter, and I've been trying to install MySQL for a month :(. It seems to be Mandrake-specific issue. Have you asked in the appropriate forums for that? Tried Google? -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 30 days, processed 1,013,680,258 queries (379/sec. avg) - 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
Compiling MySQL
This is wierd. When I run make on mysql 3.23.54 (Source Distro), using ./configure --prefix=/usr/local/mysql, --oh, and I'm running Mandrake Linux 9.0--I always get this: libmysql.c:1340: warning: passing arg 5 of 'gethostbyname_r' from incompatible pointer type libmysql.c:1340: to few arguments to function 'gethostbyname_r' libmysql.c:1340: warning: assignment makes pointer from integer without a cast make[2]: *** [libmysql.lo] Error 1 make[2]: Leaving directory '/usr/local/mysql-3.23.54a/libmysql' make[1]: *** [all-recursive] Error 1 make[1] Leaving directory '/usr/local/mysql-3.23.54a' make: *** [all] Error 2 Then the script closes and i get my command prompt. Thanks in advance, Tyler - 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
Unistall Source
Hi. How do I unstall a source tarball (tar.gz) of mySQL? (or any prog for that, I need to uninstall Emacs too) I installed Mysql-3.23.51, but the install docs dont seem to work for that, and I finally found a working src for .54, so I wanna take out the old one. Thanks in advance Tyler - 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 Source tar.gz files
Ok, I've got gunzip and tar, and every time I try (multiple versions) of your source .tar.gz file, I get: (when running 'tar -zxf mysql-3.23.54a.tar.gz') gzip: stdin: not in gzip format (when running 'gunzip mysql-3.23.54a.tar.gz') gunzip: mysql-3.23.54a.tar.gz: not in gzip format It seems NOTHING has worked for the last 2 days. I've tried the binaries, and then I dont have the top-level installation directory that all the docs refer to, and mysql isn't in /usr/local/. I really just want to be able to use MySQL.. -Tyler - 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-PHP-Apache2
Hey.. I've got a wierd problem. I'm following the guide as per WebMonkey which has worked for me before, when I ran my servers on a Win32 box, but now I've got this problem (running linux)... I cant seem to do any editing to my DB from the webpage. I've used a couple different scripts, confirmed the right user/pass/sock but everytime I try the script, nothing happens in my DB, I cant delete, add, nor edit via the page. p.s. if anyone knows about the 'configure' command to most progs, before you comple, coudl you email me in private? Im trying to re-configure my PHP to have mysql support, however I'm not sure how to do it. I've already built it. could this be the problem? heres a script I used to enter data, to no avail: ?php if ($submit) { // process form $db = mysql_connect(localhost, root); mysql_select_db(mydb,$db); $sql = INSERT INTO employees (first,last,address,position) VALUES ('$first','$last','$address','$position'); $result = mysql_query($sql); echo Thank you! Information entered.\n; } else{ // display form ? - 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
Configure error: no curses/termcap library found
Can anyone help me? I get this whenever I run ./configure --prefix=/usr/local/mysql checking for termcap functions library... configure: error: No curses/termcap library found then configure quits. I'm really new to linux, so please give me the lamans version of it ;) _ MSN 8: advanced junk mail protection and 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
how I can get a handle for controlling longblob field?
hi: I will use Mysql 4.0 to store RTP data stream. How I can get a handle for controlling longblob field? I will put the received real-time data into the longblob field by the handle continually.Would you like to write a demo for me? Thanks for you help. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fwd: RE: Newbie With a Question
Well, that's strike one for me! I sent my first post to the list and accidently ONLY sent it to one member of the list (who was kind enough to respond anyway!) My problem is that I am unable to change data in an existing table. I use the UPDATE function and it continues to tell me that I am using an Unknown Column. When I do a DESCRIBE on the table, I clearly see the column. Since I can see the column in the describe (named 'Field'), I must be doing something else wrong. Any help would be appreciated. (Thanks to Oscar, but his link seems to be for actually changing the format of a table, which is not my goal...yet=) --- Oscar Rylin [EMAIL PROTECTED] wrote: From: Oscar Rylin [EMAIL PROTECTED] To: 'Jones Tyler' [EMAIL PROTECTED] Subject: RE: Newbie With a Question Date: Wed, 14 Aug 2002 22:36:05 +0200 http://www.mysql.com/doc/A/L/ALTER_TABLE.html -Original Message- From: Jones Tyler [mailto:[EMAIL PROTECTED]] Sent: den 14 augusti 2002 22:33 To: Oscar Rylin Subject: Newbie With a Question Greetings, To begin with, if this is an inappropriate question for this list, let me appologize now. In that case, if you could direct me to an appropriate venu for my question, I would appreciate it. The question? I downloaded a free program on the internet to have some fun. After the download, I noticed a problem that I subsequently did a search on and found the answer. The problem is that I am having problems implementing the fix. The fix is to change the entry in a row of a table for a particular horizontal entry (or field, if you will). After I select the dB, I then typed SHOW TABLES and identified the table in question (HUNT_CONFIG). Looking at the Table, I then find the The first column is FIELD and the table entry I am interested in has a FIELD value of regtype. I want to change the entry in the third column for regtype, which is titled VAR. The current value is enum('0','1','2') and I need this value to be enum('0','1','2','3') So, I typed the following: UPDATE HUNT_CONFIG SET VAR='enum('0','1','2','3') WHERE FIELD='regtype'; But, it keeps giving me an error, acting as if there is not such Column by the name of 'FIELD'. I have double checked this many times and am certain that the name fo the column is FIELD. If you have any suggestions, they would be appreciated. __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.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
Re: Bank details
UmI don't think anyone (or hope noone) on this list is stupid enough to get sucked in by a piece of spam. -- Tyler Longren Captain Jack Communications [EMAIL PROTECTED] www.captainjack.com On Thu, 11 Jul 2002 15:39:33 +0100 Kevin Passey [EMAIL PROTECTED] wrote: Do not give your bank details to anyone offering large amounts of money for nothing. What normally happens is that you give your details over - then you are sucked dry - watch out. Regards Watch out mysql list - 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
a very odd benchmark question
ok - this might seem unbelieveable but: why are the benchmarks: shell cd sql-benchmarks #or whatever it is shel perl run-all-tests --user=root --password=password and then on another screen i have mysql up - and a \s say queries per sond 1.792 or something around there. what is up? - 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: Does MySQL support subqueries?
Hi Amaury, R.B. Roa would be correct in saying that subqueries are in the 4.x branch of MySQL. I'm not sure when 4.xx will be the stable branch though. Instead of using subqueries, you could try using some JOIN statments. Tyler Longren Captain Jack Communications www.captainjack.com [EMAIL PROTECTED] - Original Message - From: Amaury Cabarcas Alvarez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 15, 2002 12:14 PM Subject: Does MySQL support subqueries? I have mysql 3.23.49a, and i wish know if does version support subqueries? - 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: Authentication messed up?
did you FLUSH (reload) your mysql server? Tyler Longren Captain Jack Communications [EMAIL PROTECTED] www.captainjack.com - Original Message - From: Dan Egli [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 04, 2002 6:21 PM Subject: Authentication messed up? I tried to add a user to my mysql system for the MTA (exim) but am having a hard time making it work. I used grant to give exim permissions: grant ALL PRIVILEGES on exim.* to exim@localhost IDENTIFIED BY PASSWORD exim pw; and the exim database does exist, BUT. [root@shortcircuit root]# mysql exim -u exim -p Enter password: exim pw ERROR 1045: Access denied for user: 'exim@localhost' (Using password: YES) [root@shortcircuit root]# Any ideas? Why can user exim not access the exim database? 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: Subqueries
It can't, try using JOIN. Tyler Longren Captain Jack Communications [EMAIL PROTECTED] www.captainjack.com - Original Message - From: Leo Przybylski [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 03, 2002 1:35 PM Subject: Subqueries Hello all, Does anyone know if MySQL can do subqueries? I am trying to provide a SELECT subquery to an IN clause and I am getting errors. Is this possible? -Leo - 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: Beginners Question
MySQL will be good for this type of stuff. Tyler - Original Message - From: Zhao, Charles [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 01, 2002 3:53 PM Subject: Beginners Question Hello there, I am trying to find which database to use. I will have text and image data. Lots of image data. Most of the time I am doing data retrieving, but when updating, it will be text almost always. No enterprise use, but very busy database hits. Could any one please educate me if mysql is a good database for this purpose? Or anything else? Many thanks. -- charles - 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: LIMIT, ORDER Dilema
You have to have the LIMIT clause after the ORDER clause. Tyler Longren Captain Jack Communications [EMAIL PROTECTED] www.captainjack.com - Original Message - From: destr0 [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 30, 2002 1:32 PM Subject: LIMIT, ORDER Dilema Can you not have the LIMIT clause before the ORDER Clause in a select query? SELECT * FROM myTable LIMIT 30, 45 ORDER BY someField ASC; This query ^ fails with the error: Error 1064: You have an error in your SQL syntax near ' ORDER BY someField ASC' at line 1 I just want to make sure that the case is that you can't have your LIMIT clause before your order clause. - 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
Visual Basic and Visual C++ are 2 completely different things, so no, visual basic will not work. There might be some free C++ compilers for you to use for windows. You could always buy a copy of an older version of Visual C++. Older versions probably won't be too horribly expensive. Tyler - Original Message - From: Harry Rorarius [EMAIL PROTECTED] To: Mysql list [EMAIL PROTECTED] Sent: Friday, March 29, 2002 4:10 PM Subject: sql I am working with the php and when using php.net the documentation requires compileing with Visual C++ I am in win32. I do not have this program. I have Visual basics 5 will this work? If not it there a C++ complier I can download that would get me through this? for sql - 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: select a certain num of items in sql query
This worked for me: SELECT * FROM table ORDER BY id ASC LIMIT 9,21; There's probably a better way to do that though. tyler - Original Message - From: Aman Raheja [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 28, 2002 2:04 PM Subject: select a certain num of items in sql query Suppose I want to select items 10 to 30 from a table tab, which has 36 rows. What could be the sql query ? Thank you. Aman PS: I am using cgi-perl. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - 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 permissions
Do what Paul DuBois just suggested a few minutes ago on this very list: Delete the records from the user table that have blank User fields: DELETE FROM mysql.user WHERE User = ''; FLUSH PRIVILEGES; Then try again. That might help. Is your mysql server box behind a firewall? If it is, you might want to open port 3306 on the firewall. Tyler Longren Captain Jack Communications [EMAIL PROTECTED] www.captainjack.com - Original Message - From: Paul Rose [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 27, 2002 11:07 PM Subject: Host permissions I have read the mail archives and am still confuessed. mysql version 3.23.49-5 running under debian kernel 2.4.12 I cannot connect to the mysql server from the outside world. I have added a host permission to allow anyone to any database. Can someone assist ? Regards Paul - 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: NuSphere v. MySQL 4
I suggest you use MySQL from MySQL AB. Progress Software (parent of NuSphere), is having some legal troubles. http://www.newsforge.com/article.pl?sid=02/02/26/1825200 Tyler - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 26, 2002 1:01 PM Subject: NuSphere v. MySQL 4 Hello, I'm not sure if this list is appropriate for this issue but I'll go ahead ask for your input anyway. We're trying to decide to choose DBMS as a backend of our web portal. The portal will take online orders and other requests from end users and this is going to be available enterprise wide (WAN) for approx. 19,000 employees. As Oracle license cost is getting too high for this purpose, I'm thinking of using MySQL instead. However, I saw two different versions here (NuSphere vs. MySQL AB) and cannot decide which one is better to use. Now, my questions are: 1. What would be your recommendation for me to use, what are the advantages / disadvantages of using NuSphere's (or MySQL AB's) products other than the different pricing here? 2. Is it true that Gemini type table from NuSphere is much better than other types (e.g. InnoDB). How about the installation and config themselves, any issues I should know about from each product? We're going to install it on a W2000 server on the same box as the web portal. 3. Is it safe enough to use MySQL v.4.0.1 instead of 3.23.49. How about the MAX 4.0.1., is this better? Although reliability is important this application is not mission critical. Sorry for the many questions, but I'm really new to MySQL and I want to feel comfortable with it before I decide to use this. I'd greatly appreciate any input from all of you. Thanks, Martin **Disclaimer** This Memo and any attachments, may be confidential and legally privileged. If you are not the intended recipient and have received this in error, kindly destroy this message and notify the sender. Thank you for your assistance. - 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: SET field=field+1 no longer works?
Nope, privs are the same. Tyler - Original Message - From: Daniel Rosher [EMAIL PROTECTED] To: Tyler Longren [EMAIL PROTECTED] Cc: MySQL List [EMAIL PROTECTED]; DL Neil [EMAIL PROTECTED] Sent: Tuesday, February 26, 2002 5:19 PM Subject: RE: SET field=field+1 no longer works? Have privileges changed? Dan -Original Message- From: Tyler Longren [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 27 February 2002 11:55 a.m. To: DL Neil Cc: MySQL List Subject: Re: SET field=field+1 no longer works? Well, here's the query that PHP is generating: UPDATE users SET board_posts=board_posts+1 WHERE username='tyler' AND password='myfakepassword' If I copy and paste that exactly into the mysql client, it's executed correctly. If I use phpMyAdmin to execute it, it IS NOT executed correctly (same as in my PHP code). I really don't think this is a problem with my coding since it worked with previous versions of mysql. Could PHP just be screwing up while sending the query to MySQL? Also, if I use MySQL Front (www.mysqlfront.de), the query doesn't get executed properly. It only works correctly when issuing the query from the mysql command line client. :) Tyler - Original Message - From: DL Neil [EMAIL PROTECTED] To: Tyler Longren [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, February 26, 2002 8:52 AM Subject: Re: SET field=field+1 no longer works? Hi Tyler, [back on-list so that others can offer their wisdom!] OK, so it's not a problem with the MySQL client, then it's likely the PHP. Most likely that the username and password data values are strings and need to be properly contained with single- or double-quotation marks. If you need further assistance, first try some debug ECHOs on the three fields used in the query, and ECHO the query itself immediately prior to the call to MySQL. (is the last how you posted (copy-pasted) the query into the MySQL client, or did you type it into MySQL by hand?) If lights still don't go off, please post the PHP code snippet. Regards, =dn I tried it in PHP first, and it doesn't work in that. But, when I use the mysql client, it works as expected. Any ideas? Hello Tyler, Did someone pick up this question - haven't spotted a response on the list? I haven't spotted any such mis-behavior under either Win2000 or WinNT. Are you entering the query at the command line or into some tool? Have you tried another client? If it is still unresolved, send me (NOT the whole list) the actual query, and a short table with sample data, and I'll try it on my two Win boxes here. Regards, =dn I'm running MySQL on a Windows 2000 box. I was running 3.23.47 until 3.23.49 was released. After upgrading to 3.23.49, queries like this don't work: UPDATE test_table SET board_posts=board_posts+1 WHERE username='blah' AND password='blah'; Normally, that would increment the value in board_posts by 1, this no longer happens. Is there a different way I should do this now? Thanks, Tyler - 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: SET field=field+1 no longer works?
Hi Everyone, This was my bad. I forgot that I had encoded all passwords with base64_encrypt() in PHP. So, the passwords in the database weren't in their plaintext forms. So, my password wasn't matching up with what was in the database. Everything works good now. :) Thanks for your help! tyler - Original Message - From: Stewart Gateley [EMAIL PROTECTED] To: Tyler Longren [EMAIL PROTECTED]; DL Neil [EMAIL PROTECTED] Cc: MySQL List [EMAIL PROTECTED] Sent: Tuesday, February 26, 2002 5:56 PM Subject: Re: SET field=field+1 no longer works? Try: UPDATE users SET board_posts=(board_posts+1) WHERE username='tyler' AND password='myfakepassword'; I am using ? mysql_query (update $table set hits=(hits+1) where id=$id); ? and it works fine. -- Stewart --- Tyler Longren [EMAIL PROTECTED] wrote: Well, here's the query that PHP is generating: UPDATE users SET board_posts=board_posts+1 WHERE username='tyler' AND password='myfakepassword' If I copy and paste that exactly into the mysql client, it's executed correctly. If I use phpMyAdmin to execute it, it IS NOT executed correctly (same as in my PHP code). I really don't think this is a problem with my coding since it worked with previous versions of mysql. Could PHP just be screwing up while sending the query to MySQL? Also, if I use MySQL Front (www.mysqlfront.de), the query doesn't get executed properly. It only works correctly when issuing the query from the mysql command line client. :) Tyler - Original Message - From: DL Neil [EMAIL PROTECTED] To: Tyler Longren [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, February 26, 2002 8:52 AM Subject: Re: SET field=field+1 no longer works? Hi Tyler, [back on-list so that others can offer their wisdom!] OK, so it's not a problem with the MySQL client, then it's likely the PHP. Most likely that the username and password data values are strings and need to be properly contained with single- or double-quotation marks. If you need further assistance, first try some debug ECHOs on the three fields used in the query, and ECHO the query itself immediately prior to the call to MySQL. (is the last how you posted (copy-pasted) the query into the MySQL client, or did you type it into MySQL by hand?) If lights still don't go off, please post the PHP code snippet. Regards, =dn I tried it in PHP first, and it doesn't work in that. But, when I use the mysql client, it works as expected. Any ideas? Hello Tyler, Did someone pick up this question - haven't spotted a response on the list? I haven't spotted any such mis-behavior under either Win2000 or WinNT. Are you entering the query at the command line or into some tool? Have you tried another client? If it is still unresolved, send me (NOT the whole list) the actual query, and a short table with sample data, and I'll try it on my two Win boxes here. Regards, =dn I'm running MySQL on a Windows 2000 box. I was running 3.23.47 until 3.23.49 was released. After upgrading to 3.23.49, queries like this don't work: UPDATE test_table SET board_posts=board_posts+1 WHERE username='blah' AND password='blah'; Normally, that would increment the value in board_posts by 1, this no longer happens. Is there a different way I should do this now? Thanks, Tyler - 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
SET field=field+1 no longer works?
Hello, I'm running MySQL on a Windows 2000 box. I was running 3.23.47 until 3.23.49 was released. After upgrading to 3.23.49, queries like this don't work: UPDATE test_table SET board_posts=board_posts+1 WHERE username='blah' AND password='blah'; Normally, that would increment the value in board_posts by 1, this no longer happens. Is there a different way I should do this now? Thanks, Tyler - 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 unsubscribe from this list?
To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php It's at the bottom of every message sent to this list. Tyler - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 18, 2002 9:19 AM Subject: how to unsubscribe from this list? Hello, I have found the solution of my sql quueris, I want to unsubscribe from this list can u help? thanx - 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: Where Did Mysql Go?
is mysqld running on your box? Tyler - Original Message - From: Rich [EMAIL PROTECTED] To: MySql [EMAIL PROTECTED] Sent: Monday, February 11, 2002 6:49 AM Subject: Where Did Mysql Go? I was working on updating some databases yesterday and when I booted up my computer this morning I couldn't connect to MySQL, the error message is can't connect to local MySQL server through socket /path/mysql.socket. It was there yesterday and now it's gone! Where did it go (a search of the HD doesn't show it) and, more important, how do I get it back? Rich -- [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 - 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: Coldfusion?
-Original Message- From: Andy Ingham [mailto:[EMAIL PROTECTED]] We've been running Cold Fusion with MySQL on the Solaris platform for almost two years now and have had such terrible problems with Cold Fusion errors that we have begun the process of migrating to PHP. Our average load has been about 30,000 .cfm pages (linked to MySQL backend) served per week, which I don't consider to be too heavy a load to expect the system to handle successfully. Unfortunately, our log files are riddled with fatal Cold Fusion errors and subsequent restarts. It got so bad that we had to institute a cron job to check for the happiness of the CF processes every 3 minutes and restart them if there was a problem. Oh boy... I'll confirm that as well. I previously worked at Macmillan Computer Publishing (www.mcp.com) when I wrote The Personal Bookshelf and migrated that application from cgi-bin/perl and dbm arrays to Cold Fusion/Oracle all on Solaris. It was CF version 4. And it was really bad. In a development environment where there is limited access, and the machine load is relatively low, it's no problem. Yet, the webstats were saying we had approximately 8,000 users using the Personal Bookshelf at any one time, so it was going to be put under a heavy load once it is in production. Such happened and CF really really choked. The machine suffered under a really high *load*. Typically above 90%. The sysadmins joked that the machine was working so hard it was glowing in the corner. We optimized the code over the course of a couple of weeks scruitinizing the CF markup for more efficient ways to do things in order to get it down to a load. We got the load down to between 60-70% as I remember, which was still too high. Not only was the machine at an unusually high load, but the CF server would die periodically between every 10-45minutes. The sysadmins eventually wrote a script to check the health of the CF server instance that'd run every 3 minutes to determine whether or not it should restart CF automtically. It was a really bad situation. We talked with Allaire and they couldn't believe the problems we had with CF on Solaris. At the time, Allaire said that we had the largest *nix based CF application on the www with a Sun Ultra with 4 GB of RAM tied to a pretty heavy amount of disk space, etc. We provided them with database schema's, data, and our code ... and let them try it out. They did. And they confirmed everything we had said...even in their environment. They said the design of the database and the coding of the pages didn't contribute to the poor performance of the CF engine. Ultimately, they said they couldn't help us because the thing in CF that was causing all of the problems (they said) was a simulated windows registry that CF requires in order to operate. They said that we were also suffering from a lot of errors where CF would loose database connections and not keep threads alive like they would in a non-*nix environment without a heavy load. They had no answers for us at all. They suggested that it be monitored constantly so that the application stays running as much as possible. When I heard about the simulated registry for *nix servers built into CF, I nearly hit the roof! I couldn't hardly believe it. That was a couple of years ago, and CF has went from 4 -- 4.5 -- 5. Under a windows environment, it's probably pretty good. Under *nix (Solaris in my experience) it really left much to be desired. I'd avoid it and stick with php on Solaris any day. Tyler Nally -- __ _Tyler Nally / /__ _(_)___ _ _ [EMAIL PROTECTED] / / _ \/ __ `/ / __ \/ __ \ / __ \/ ___/ __ `/ 317-860-3016 / / __/ /_/ / / /_/ / / / // /_/ / / / /_/ / American Legion Website /_/\___/\__, /_/\/_/ /_(_)/_/ \__, /http://www.legion.org // // - 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: Disable case sensitivity
-Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Subject: Re: Disable case sensitivity If is possible, in everything from a Database, but if is not, in columns is more important. Column names are case insensitive. Correct... Database names and Table names don't necessarily share this (according to the MySQL manual snippet below). 6.1.3 Case Sensitivity in Names In MySQL, databases and tables correspond to directories and files within those directories. Consequently, the case sensitivity of the underlying operating system determines the case sensitivity of database and table names. This means database and table names are case sensitive in Unix and case insensitive in Windows. See section 1.7.3 MySQL Extensions to ANSI SQL92. NOTE: Although database and table names are case insensitive for Windows, you should not refer to a given database or table using different cases within the same query. The following query would not work because it refers to a table both as my_table and as MY_TABLE: SELECT * FROM my_table WHERE MY_TABLE.col=1; - 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 vs Interbase
Yeah, any lookups based on char based columns are slower than integer queries any day. I'm assuming it's a char column because you're searching with apostrophe's '0'. Would a between statement in the where clause help? select * from experian.experian where latitude between '038631928' and '038638092' and longitude between '096671646' and '096680757' -Original Message- From: Dan Nelson [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 10, 2002 12:09 PM To: Mike Grover Cc: [EMAIL PROTECTED] Subject: Re: mySQL vs Interbase In the last episode (Jan 10), Mike Grover said: select * from experian.experian where latitude = '038631928' and latitude = '038638092' and longitude = '096671646' and longitude = '096680757'; Interbase takes 10 seconds to return 70 records, but mySQL takes 18 seconds to return the same record count. my Index is: ALTER TABLE EXPERIAN.EXPERIAN ADD INDEX latlong (latitude,longitude); explain says it is using the latlong index with a key length of 20. Is this the best mySQL will do? Is there a better sql statement I can use? That's about as efficient as you can get. You can try raising your mysqld key_buffer_size to allow more of the index to be cached, or maybe use INTEGER types for lat and long, which will bring your key down to 8 bytes total instead of 20 (cutting your index size by more than 50%). -- Dan Nelson [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
Problem with date fcolumn in query
Hello, My boss is going through the mysql.com tutorials starting at ... http://www.mysql.com/articles/ddws/12.html ... and currently stuck at ... http://www.mysql.com/articles/ddws/13.html The boss is using phpMyAdmin to access the database, and everything has been working just fine until it gets to a database query where it's using a date column (JokeDate) in the where clause. The query is shown below and the phpMyAdmin error is also shown... SELECT COUNT(*) FROM Jokes WHERE JokeDate = 2000-01-01 MySQL said: Lost connection to MySQL server during query When I made a php page with the query in it, it's dying on the ... $sql_result = mysql_query($SQL) or die (bad SQL [$SQL]); ... where $SQL is the defined sql statment that's passed to the mysql_query function. The database table is defined thusly: CREATE TABLE Jokes ( ID int(11) DEFAULT '0' NOT NULL auto_increment, JokeText text, JokeDate date DEFAULT '-00-00' NOT NULL, PRIMARY KEY (ID) ); With three rows of information in it. Even if I change the query to : select * from Jokes where JokeDate = 2001-01-01 -or- select * from Jokes where JokeDate = '2001-01-01' -or even- select ID, JokeText, JokeDate from Jokes where JokeDate = '2001-01=01' ... it just doesn't work and it returns the Lost Connection error. If I select on a different column (like ID or JokeText) it works just fine. The MySQL database is 3.22.26a running on a Solaris through iPlanet webserver on a test machine/database and Apache on production machine/database. Any help. Thanks in advance. -- __ _Tyler Nally / /__ _(_)___ _ _ [EMAIL PROTECTED] / / _ \/ __ `/ / __ \/ __ \ / __ \/ ___/ __ `/ 317-860-3016 / / __/ /_/ / / /_/ / / / // /_/ / / / /_/ / American Legion Website /_/\___/\__, /_/\/_/ /_(_)/_/ \__, /http://www.legion.org // // - 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, remove unique?
I think it's like this... alter table hrcontract drop index login ... assuming the name of the key is login. You can have key names (which is what a unique constraint is) and column names of the same name. If you do a ... show index from hrcontract ... it'll show you all of the key_name values paired with the column names that are with that table that you can drop. -Original Message- From: dan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 10:13 AM To: [EMAIL PROTECTED] Subject: alter table, remove unique? Hi, I'd like to alter a field and change it from being Unique using the alter table command but can't seem to get the syntax correct? Can someone give me an example? IE: alter table hrcontact modify login varchar(70) not null default'' _NOT UNIQUE'; thanks, Dan - 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 query
Rember that the sum function sums the total of all of the colum specified. Is there multiple rows where the same c.cid_no occurs many times? If so, then you need a group by and having clauses. If not, then you don't need the sum function. With a group by, it'd look like this... I think ... select c.cid_no, c.name from carrier c, loads l where c.cid_no = l.cid_no group by c.cid_no having sum(l.amount) 600 Remember that column and tablenames are *spefic* to the definition of the table. So, a columnname of C.CID_NO isn't the same as defined as c.cid_no. And that a tablename of CARRIER isn't the same as carrier. To see specifically what the columnname case sensitive spellings are do a show columns on tablename. Without a group by, because each c.cid_no only appears once in the carrier table, it'd be a regular query without any summing being performed on a column. -Original Message- From: Richard Reina [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 1:11 PM To: [EMAIL PROTECTED] Subject: mysql query I am trying to write a query that gets the name of every carrier who has done more than $600 in loads. Can anyone help? SELECT c.name FROM carrier c, loads l WHERE c.CID_NO = l.CID_NO AND SUM(l.amount 600); This, unfortunately does not work. - 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 Query and Fetch work?
Basically, the mysql_query submits the sql statement to the database engine, and the mysql_fetch_array allows retrieval of selected information returned from the query into an associative array with each columnname of the query an associative key in the array Example... --login-to-host-and-db-connectors-here-- $sql = select name, address, city, state, zip ; $sql .= from addressbook ; $sql_result = mysql_query($sql) or die (bad SQL [$sql]); --print beginning html table tags and first row headers here--- while($data_row = mysql_fetch_array($sql_result)) { $sel_name= $data_row[name]; $sel_address = $data_row[address]; $sel_city= $data_row[city]; $sel_state = $data_row[state]; $sel_zip = $data_row[zip]; // my personal preference is to use simple fields for // display purposes. I could have easily used the // array names as well... such as $data_row[name] for $sel_name echo(trtd$sel_name/td); echo(td$sel_address/td); echo(td$sel_city/td); echo(td$sel_state/td); echo(td$sel_zip/td/tr); } --print closing html table tags--- -Original Message- From: Dibo Chen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 11:45 AM To: Alex Shi Cc: [EMAIL PROTECTED] Subject: Re: How Query and Fetch work? When you are told to fill in fuel and turn the key to drive, I suppose you don't care how the fuel runs the car. Do the same things in any lib you use, pushing the buttons in told order would work. Well, you may dig deeper if you like since the code is available. Alex Shi wrote: Yesterday I posted a question yet got response. The question is regarding to how Query works. Now I repost it in a more specific way. I am just wondering how MySQL API functions work. Let's look at following two functions: 1. mysql_query(), 2. mysql_fetch_array() To my understanding, mysql_query() will definately to its job with MySQL server. But how about the latter? Does it just fetch data from client/local buffer, which is previously put in by mysql_query(), or still has to goto server side to fetch data? 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 - 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 Query and Fetch work?
Not knowing the exact internals of how it works... Assuming that it works much the same way other RDB's work in their native GL's (generation languages), the common practice with a relational database is to define/declare a cursor with the SQL statement executed against the database. After the cursor is defined/declared, then the next operation that is performed is a fetch where information that is available by the cursor is actually pulled from the database and somehow used. Specifically *how* I don't know. I remember years ago when doing COBOL programming, when dealing with a random access indexed file, what we had to do to get to the data was to... open indexedfile-name start indexedfile-name at a particular key value if error (the start was bad and you're record pointer was now at the end of the indexedfile) go back and get a new key value or end program if good (read operations can be performed to retrieve a record) continue looping paragraph ( read recordname next at end close indexfile-name ) This is pretty much the same operation as is done with a RDB. The open is the database/host/user connection. The start is the definition/declaration of the cursor, and the read next's are the fetches that return values to be processed. -Original Message- From: Stephen Abshire [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 12:41 PM To: [EMAIL PROTECTED] Subject: Re: How Query and Fetch work? I like the explanation using the automobile and key. Very good :-) Yet at the same time if I understand what effect using the different grades of fuel in my car will have on its performance, I can optimize how the car operates. Much like the original question, if I know when MySQL caches result sets and when it is forced to hit the database again I can optimize the performance of my application. Personally, I would like to know the answer to this question myself. Anyone know the internals? Original Message Follows From: Dibo Chen [EMAIL PROTECTED] To: Alex Shi [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: How Query and Fetch work? Date: Wed, 09 Jan 2002 10:45:07 -0600 When you are told to fill in fuel and turn the key to drive, I suppose you don't care how the fuel runs the car. Do the same things in any lib you use, pushing the buttons in told order would work. Well, you may dig deeper if you like since the code is available. Alex Shi wrote: Yesterday I posted a question yet got response. The question is regarding to how Query works. Now I repost it in a more specific way. I am just wondering how MySQL API functions work. Let's look at following two functions: 1. mysql_query(), 2. mysql_fetch_array() To my understanding, mysql_query() will definately to its job with MySQL server. But how about the latter? Does it just fetch data from client/local buffer, which is previously put in by mysql_query(), or still has to goto server side to fetch data? 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 _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - 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 on Linux 2.4 question
Amazing! I've not had a chance to upgrade a server to 2.4 yet, though I've long imagined that the results would be similar. I imagine the biggest performance boost you received is due to the built-in multi-threading that the 2.4 kernel enjoys which is currently lacking in the 2.2 kernel. Linux is becoming more robust all the time along with a pretty hard kernel. It's come a long way in a short time. Linux is developing along a more solid path than Windoze. Even the big boys are turning to open source to handle the high-traffic/high-availability jobs. Yahoo saved somewhere around 17 million dollars by switching needed infrastructure over to linux/open source. I just read today that MySQL is their big database that handles 800 transactions a second for their stock quotes and financial handlings. In the year that M$ wants to rent the OS to you, linux will only continue to grow in it's usage as the desktop gets more friendly and the applications are developed to make people want to use linux instead of windoze. Tyler -Original Message- From: Weaver, Walt [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 5:18 PM To: [EMAIL PROTECTED] Subject: MySQL on Linux 2.4 question Anyone else out there been playing with the new Linux 2.4 kernel? I just upgraded a test server from 2.2 to 2.4 and reran some of my InnoDB tests. The results were dramatic; updating a 600,000 row table went from 21 minutes and change to 6 minutes and change. Haven't tried 2.4 and MyISAM tables yet; on 2.2 the same update ran in about 8 minutes. This is obviously a big improvement, if my tests are valid. It's SUCH a big improvement that I'm wondering if I messed something up. Any comments/statement of support/snide remarks will all be appreciated. Thanks, --Walt Weaver Bozeman, Montana - 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: GUI for Windows
Might wanna try MySQL Front at http://www.mysqlfront.de. It's pretty good. Tyler Longren Captain Jack Communications [EMAIL PROTECTED] www.captainjack.com - Original Message - From: John Mayson [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Monday, December 24, 2001 6:41 PM Subject: GUI for Windows Eventually my databases will be on my Linux system. In the meantime, is there a Windows program that builds a quick and dirty GUI interface for my SQL databases? Thanks, John -- John Mayson KC4VJO Linux/Perl/HP-UX/ICT Austin, Texas 78729 30.4560N 97.7851W [EMAIL PROTECTED] http://www.nyx.net/~jmayson - 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
PASSWORD() question
Hello, I have some usernames and passwords. The passwords have had the PASSWORD() function used on them. I need to set up an area of a site to allow users to have their passwords e-mailed to them. I can't just say SELECT password FROM table WHERE email='$email' AND username='$username' because that will give me a bunch of gibberish. Is there anyway to get the password back into plaintext to be emailed to the user? Thanks, Tyler Longren - 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
Error 1045 - Access denied
Hello, I keep on getting 1045 - Access denied for user: [EMAIL PROTECTED] (using password: YES) errors. I'm connecting to this MySQL server from a remote site. I don't see any reason for this. I KNOW that my password is correct. In the user table, the Host is set to % for the mysql user. There's also another entry for the mysql user and the host on that is set to localhost. Could having 2 of the same usernames have an effect on this? I really don't see any reason that I can't connect to this MySQL server from a remote site. Thanks all, Tyler - 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 1045 - Access denied
Hello, I created the entries by adding them manually to the table (not using GRANT). And yes, I did run FLUSH PRIVILEGES. Anything else I should try doing? The MySQL manual didn't really provide much help. Thanks! Tyler - Original Message - From: Carsten H. Pedersen [EMAIL PROTECTED] To: Tyler Longren [EMAIL PROTECTED]; MySQL List [EMAIL PROTECTED] Sent: Wednesday, December 05, 2001 3:28 PM Subject: RE: Error 1045 - Access denied Hello, I keep on getting 1045 - Access denied for user: [EMAIL PROTECTED] (using password: YES) errors. I'm connecting to this MySQL server from a remote site. I don't see any reason for this. I KNOW that my password is correct. In the user table, the Host is set to % for the mysql user. There's also another entry for the mysql user and the host on that is set to localhost. Could having 2 of the same usernames have an effect on this? I really don't see any reason that I can't connect to this MySQL server from a remote site. How were the entries created? Using GRANT ... or by editing the user table directly? In the latter case, did you remember to FLUSH PRIVILEGES? / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - 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 Question; Backups?
mysqldump -uusername -ppassword -hhostname dbname dbname.sql That will dump the database 'dbname' into the file 'dbname.sql' Tyler Longren - Original Message - From: ROGGER ALEXIS VASQUEZ MARTINEZ [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 9:40 AM Subject: NewBie Question; Backups? How do I make a Backup of a MYSQL database ,,, It is simple as just copying the files of each table ? or exists a command to make backup ( including TEXT Fields ) ? Thanks -Original Message- From: Michael Widenius [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 10:51 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Proposal for two (or more) new time and date functions Hi! Jeremy == Jeremy Zawodny [EMAIL PROTECTED] writes: Jeremy On Wed, Nov 28, 2001 at 01:30:42PM -0800, [EMAIL PROTECTED] wrote: I think while you've got the hood up, a better method of doing the difference between two dates should be derived. Unless I'm going about this all wrong, the only way to get the time difference between two values currently is: UNIX_TIMESTAMP(end_datetime) - UNIX_TIMESTAMP(start_datetime) Wouldn't something like SECONDS_DIFF(start,end) make more sense? Or perhaps TIME_DIFF(start,end)? Jeremy It's not the only way, but none of them are as simple as a Jeremy SELECT date1 - date2 The problem with implementing the above simple expression is that you can easily run into problems because of the automatic convert of strings to numbers. For example: What should we do if one of the strings is a date and the other is a number or a string ? If we would do the above, then we would also be able to handle: SELECT 2001-01-01 - date from table_name; SELECT 2001-01-01 - 2000-01-01; One simple solution is to to only do this if both columns are of type DATE. You can always 'cast' a column to date with: SELECT DATE 2001-01-01 - DATE 2000-01-01; How would this sound? Regards, Monty - 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: What is errno: 13
I think that's the error code that's spit out when permissions are wrong on the DB file. You might want to check permissions. Good luck, Tyler Longren - Original Message - From: Venu Allavatam [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 28, 2001 4:10 PM Subject: What is errno: 13 Hello All: I am working on a particular database, which I created some days ago in mysql ver. 3.23.36. I am quite sure that I have not made any changes to the system (Dell WS with Red Hat Linux 7.1) either. What I see is this... ### [Venu@localhost Venu]$ db Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any fields in table 'ecg_datafile' Didn't find any fields in table 'event_info' Didn't find any fields in table 'event_lookup' Didn't find any fields in table 'lead_lookup' Didn't find any fields in table 'properties_info' Didn't find any fields in table 'record_info' Didn't find any fields in table 'subject_info' Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 to server version: 3.23.36 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql use sadms Database changed mysql mysql mysql select * from ecg_datafile; ERROR 1017: Can't find file: './sadms/ecg_datafile.frm' (errno: 13) mysql quit Bye [Venu@localhost Venu]$ # what is this error? I created all these tables a few days back and now I am unable to view them. Could anyone suggest what is going and what the solution is? Thanks Venu __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 - 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/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
Select in groups of 5
Hello everyone, Is there any way to make selections in groups of 5. I want to get 5 record sets at a time until we get to a point that there's 4 or less records. Thank you everyone, Tyler database,sql,query,table - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error: 6 (Errcode: 13)
DROP TABLE Track Error: 6 - Error on delete of '.\sports\track.ISD' (Errcode: 13) Anyone know what that means? As you can see, it came from tryign to do a DROP on a table. Thanks, Tyler Longren - 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: PHP Warning
Does /var/lib/mysql/mysql.sock exist??? -- Tyler Longren Captain Jack Communications [EMAIL PROTECTED] www.captainjack.com On Tue, 21 Aug 2001 10:06:43 -0700 (PDT) my sql [EMAIL PROTECTED] wrote: On a new install of Suse 7.2 I get this message when attempting to acces MySQL through a php scrpipt in apache 1.30.20 (MySQL 3.23.39 and PHP 4.0.6): Warning: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/apache_1.3.20/htdocs/dbtest.php on line 16 any ideas? __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.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: mysql only stores one word?
post some code. Make sure you're using quotes in the right places. Tyler Longren Captain Jack Communications [EMAIL PROTECTED] www.captainjack.com On Tue, 14 Aug 2001 13:39:48 -0700 Nate Sanden [EMAIL PROTECTED] wrote: Hey im pretty new to mysql, but I made a basic html form and used php to post it to my mysql database. It goes in fine, but it only carries the first word in each input box. So say for description I put in My little white dog it only stores My in the database. Would appreciate any insight you may have! 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
Re: Problems compiling mysql on linux 7.0
Which Linux 7.0 are you using? I'll assume you're talking about Redhat. So why don't you just download the mysql rpm and install it instead of doing it from source? Good luck, Tyler Longren Captain Jack Communications [EMAIL PROTECTED] www.captainjack.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
Re: Sub select.
I don't think MySQL supports sub selects. Tyler On Tue, 07 Aug 2001 14:57:33 +0200 Anders Alstrin [EMAIL PROTECTED] wrote: Does anyone know how to do this sub select in MySQL. I know how to do it in Oracle! table media +--+---+--+ | media_id | price |filename | +--+---+--+ |3 | 0 | cal.jpg | | 82 | 0 | Soa.jpg | | 13 | 0 | ca.jpg | | 71 | 0 | gt.pdf | | 67 | 0 | low.pdf | | 68 | 0 | 10.pdf | | 83 | 0 | B5.pdf | +--+---+--+ table category_locks +--+-+--+ | category_lock_id | category_id | media_id | +--+-+--+ | 92 | 0 | 68 | | 93 | 0 | 67 | | 94 | 0 | 13 | | 91 | 0 | 71 | | 90 | 0 |3 | | 118 | 43 | 82 | | 121 | 43 | 83 | +--+-+--+ table categories +-+-++---+--+ | category_id | category_up | upload | dynamic_media | name | +-+-++---+--+ | 43 | 0 | false | true | web | | 0 | 0 | false | false | trine| | 0 | 0 | false | false | shop | +-+-++---+--+ A Oracle way to do it: SELECT * FROM media WHERE media_id = (SELECT media_id FROM category_locks WHERE category_id = (SELECT category_id FROM categories WHERE dynamic_media = 'true')) A MySQL way to do it? - 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 and PHP
No need to install locally. You could write everything locally, upload it to the server, and see if what you wrote works. Tyler On Tue, 7 Aug 2001 13:51:01 +0100 Matt Gaskin [EMAIL PROTECTED] wrote: Hi All Currently I have rented space on a Web Server that has MySql installed and PHP, They have created a database directory for myself. Do I need to install Mysql and PHP locally to take advantage of this. If so where do I start. I have had no experience of the above two products, although I have written a number of websites in HTML and a number of access databases. We have just started to get a number of enquiries for databases online and would like to develope in this area. Thanks M - 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: Remote MySQL Console?
Get the mysql client from www.mysql.com. Tyler On Sun, 5 Aug 2001 13:38:09 -0400 Chris [EMAIL PROTECTED] wrote: Is there a method I can use to log into a remote mysql server through something such as telnet to pass queries on my database? - 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: Adding a [mysql] to the subject line
You could just filter for [EMAIL PROTECTED]. That's what I do. Tyler Longren Captain Jack Communications [EMAIL PROTECTED] www.captainjack.com On Tue, 7 Aug 2001 17:12:29 -0700, Randy Johnson wrote: I am not sure if this has been addressed before, I think it would be neat if the list admin could put a [mysql] in the subject line for messages. I get a lot of email and it would help having that in the subject line. it would also help me in filtering my mail. Please let me know your comments. Randy - 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- [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 stop msqld
$ ps -ax | grep mysqld get the pid of mysql $ kill -9 pid_of_mysql that'll do it. :) Tyler On Thu, 26 Jul 2001 13:24:41 -0500 cjackson [EMAIL PROTECTED] wrote: Hello all, I just installed mysql 3.23.32-1.7 with an rpm on redhat7.0 server running apache and php. I could start msqld and shut it down. Then I created a password for root. Mysql still starts but I can't stop it as root or any other user. It runs as user mysql which also requires password. Thanks, Jackson - 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 running ./mysql_install_db
Try doing it as root if you're not already. Tyler Longren Captain Jack Communications [EMAIL PROTECTED] www.captainjack.com - Original Message - From: Michael Nezi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 25, 2001 11:08 AM Subject: Problems running ./mysql_install_db When installing mysql the only problem I receive is the following which cannot install the grant tables. I am unable to view the log because my access is denied. What to do? Anyone? [localhost:/usr/local/bin] nezi% ./mysql_install_db mkdir: /usr/local/var/mysql: Permission denied chmod: /usr/local/var/mysql: Permission denied mkdir: /usr/local/var/test: Permission denied chmod: /usr/local/var/test: Permission denied Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables /usr/local/libexec/mysqld: Can't change dir to '/usr/local/var/' (Errcode: 13) 010725 9:56:55 Aborting 010725 9:56:55 /usr/local/libexec/mysqld: Shutdown Complete Installation of grant tables failed! Examine the logs in /usr/local/var for more information. You can also try to start the mysqld daemon with: /usr/local/libexec/mysqld --skip-grant You can use the command line tool /usr/local/bin/mysql to connect to the mysql database and look at the grant tables: shell /usr/local/bin/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in /usr/local/var that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the /usr/local/bin/mysqlbug script! -- - 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
not selecting last row
Hi everyone, Is there a way to NOT select the last row that was inserted into a table? I want everything before it. I know how I could do this using 2+ queries, but can it be done by issuing just 1 query? Thanks everyone, Tyler - 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: not selecting last row
That should work just fine. :) Thanks! - Original Message - From: John Meyer [EMAIL PROTECTED] To: Tyler Longren [EMAIL PROTECTED]; MySQL List [EMAIL PROTECTED] Sent: Friday, July 20, 2001 3:21 PM Subject: Re: not selecting last row At 12:25 PM 7/20/01 -0500, Tyler Longren wrote: Hi everyone, Is there a way to NOT select the last row that was inserted into a table? I want everything before it. I know how I could do this using 2+ queries, but can it be done by issuing just 1 query? Thanks everyone, Tyler Assuming you had a unique ID, couldn't you do it this way: SELECT * FROM TABLE WHERE ID=!LAST_INSERT_ID(); John Meyer [EMAIL PROTECTED] Programmer If we didn't have Microsoft, we'd have to blame ourselves for all of our programs crashing - 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: Easiest way to create a duplicate of a db?
copy a table: mysqldump database table_name table.sql or to copy the whole db: mysqldump database db.sql - Original Message - From: Victor Spång Arthursson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 09, 2001 12:51 PM Subject: Easiest way to create a duplicate of a db? For example if I want a copy of products named products1? Sincerely Victor 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
Re: How do I restore a database backed up using mysqldump?
do this: mysql -uusrename -ppassword dbname brand.txt mysql -uusrename -ppassword dbname brand.sql Tyler - Original Message - From: Victor Spång Arthursson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 02, 2001 1:59 PM Subject: How do I restore a database backed up using mysqldump? Hi! Mysqldump creates the files brand.txt brand.sql etc. How do i restore the database in a simple way..? I've looked in the manual but couldn't find out... Sincerely Victor - 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
system error 1067
Hello everyone, I have mysql-3.23.39 installed on a Win2k Pro box (not sure why!). It had been running just fine, then all of a sudden stopped working. When I try a 'NET START mysql', I get the below error: ---Begin Error The MySql service is starting. The MySql service could not be start A system error has occurred. System error 1067 has occurred. The process terminated unexpectedly. ---End Error Has this happened to anyone else? Or am I just the unlucky one? Tyler - 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: constraint question
just do: mysqldump options db_name db_name.sql Your database tables and contents will be dumped into db_name.sql Tylre - Original Message - From: ah [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 21, 2001 12:19 PM Subject: constraint question hi I am using mysql 3.23.29 under windows 2000.I have a table: create table ies( libID bigint NOT NULL AUTO_INCREMENT , lib_datsvrID bigint null, primary key (libID), constraint FK_LIBRAR_REF_584_DATASE foreign key (lib_datsvrID) references DataServers (datsvrID)) I want to know how to view the constraints defined for libraries. I have another question: i want to do a backup of my database using mysqldump. what's the syntax of mysqldump database (under windows) thanks for help cheers - 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: Connect mySQL with HTML or something
You'd probably be interested in PHP: www.php.net Tyler - Original Message - From: Laura Lía Marcello [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 21, 2001 12:03 PM Subject: Connect mySQL with HTML or something I need to know if there is a way to create a searchable database that returns results as a web page... As you can see, I'm just begining, so I would really apreciate an answer, even if it's short. Thanks! Laura Lía Marcello Web Development www.editorialargenta.com www.marketaxa.com www.newsbookonline.com Avda. Corrientes 1250 Piso 3º oficina F tel. 4382-9085 (rot) 1043 Capital Casilla Postal 233 suc. 12 (1412) Buenos Aires - Argentina - 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: inserting images in mysql tables
you should probably just store the images on your server, and provide the location to the image in the table...much quicker. Tyler - Original Message - From: Felicia [EMAIL PROTECTED] To: mysql post [EMAIL PROTECTED] Sent: Tuesday, June 19, 2001 11:03 AM Subject: inserting images in mysql tables I am new to mysql. I am attempting to place images in one of my columns. As for my table structure, I have gotten as far as: image blob NOT NULL, How should I proceed? Thanks a bunch Get free email and a permanent address at http://www.netaddress.com/?N=1 - 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 GUI for windows NT/98 is it available?
http://mirror.sit.wisc.edu/mysql/downloads/gui-clients.html Tyler - Original Message - From: John Kennedy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 13, 2001 10:31 AM Subject: mysql GUI for windows NT/98 is it available? I am just curious to know whether you have any GUI for mysql for Windows NT/98? If so kindly send me the link where I could download it. I am curios to work on MYSQL. thanks John _ Get your FREE download of MSN Explorer at http://explorer.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 Port number
Default mysql port is 3306. Tyler -Original Message- From: sanborn [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 9:36 PM To: MySQL Mailing List Subject: MySQL Port number How is MySQL used over a network? I assume there is a port involved, and some kind of transaction server built into mysql? How do I configure, test this? In the several documents I have read so far, I haven't found much on the subject. Thanks for your input. Gene Sanborn - 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
update query produces warnings?
Hello everyone, I have a database of alumni at school. Each alumnus that registers gets assigned their own id. Id's are made with mysql's auto_increment. Everything worked fine until a few days ago when everybody that signed up got the id of 127 assigned to them. MySQL will NOT assign them an id higher than 127. So, now everybody that signs up gets the id of 127. I tried to fix this by using update on the table...here is an example of the table: ID | fname | lname --- 127 | MaryBeth | Elliott --- 127 | Becky | Beving --- 127 | Russell | Oswalt --- 127 | Wanda | Oswalt --- 127 | Brandon | Kohlwes --- 127 | Kenneth | Smith, Jr. --- 127 | Benjamin | Dykstra --- 127 | Laura | Hand --- 126 | Eric | Beal --- 125 | Doug | Franklin --- Here is what I used to try to UPDATE the id: UPDATE alumni SET id=128 WHERE fname='Benjamin' AND lname='Dykstra'; That didn't work, it said that 0 lines were changed and there was one warning (couldn't figure out how to read the warning). I also tried this: UPDATE alumni SET id=id+1 WHERE fname='Benjamin' AND lname='Dykstra'; That also didn't work...same result as above. I am convinced that my syntax is correct because phpMyAdmin can't even change the id. Anybody have any ideas why this happened? BTW, I'm running mysql-3.23.38 on NT4. Thanks everyone, -- Tyler Longren [EMAIL PROTECTED] Currently Unemployed www.noworkfortyler.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
Re: update query produces warnings?(fixed)
This post can be ignored now. Turned out the datatype for the id field was set to tinyint, changed it to int and everything worked great. Tyler On Thu, 31 May 2001 00:26:12 -0500 Tyler Longren [EMAIL PROTECTED] wrote: Hello everyone, I have a database of alumni at school. Each alumnus that registers gets assigned their own id. Id's are made with mysql's auto_increment. Everything worked fine until a few days ago when everybody that signed up got the id of 127 assigned to them. MySQL will NOT assign them an id higher than 127. So, now everybody that signs up gets the id of 127. I tried to fix this by using update on the table...here is an example of the table: ID | fname | lname --- 127 | MaryBeth | Elliott --- 127 | Becky | Beving --- 127 | Russell | Oswalt --- 127 | Wanda | Oswalt --- 127 | Brandon | Kohlwes --- 127 | Kenneth | Smith, Jr. --- 127 | Benjamin | Dykstra --- 127 | Laura | Hand --- 126 | Eric | Beal --- 125 | Doug | Franklin --- Here is what I used to try to UPDATE the id: UPDATE alumni SET id=128 WHERE fname='Benjamin' AND lname='Dykstra'; That didn't work, it said that 0 lines were changed and there was one warning (couldn't figure out how to read the warning). I also tried this: UPDATE alumni SET id=id+1 WHERE fname='Benjamin' AND lname='Dykstra'; That also didn't work...same result as above. I am convinced that my syntax is correct because phpMyAdmin can't even change the id. Anybody have any ideas why this happened? BTW, I'm running mysql-3.23.38 on NT4. Thanks everyone, -- Tyler Longren [EMAIL PROTECTED] Currently Unemployed www.noworkfortyler.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
sql to select 2 entries/name?
Hello list, I have a table in a database that has a field named 'artist'. There are multiple entries of the same artist/band. Example: deftones iggy pop kiss deftones glassjaw deftones kiss new found glory kiss There's 3 entries for deftones and 4 entries for kiss. What I need to do is select a maximum of 2 entries for each artist. I've tried a few different things, but nothing has given me what I need. Is there any way to do this? Thanks everyone, Tyler Longren - 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 shutdown mysqld (nicely or not) on OS X 10.0.2
Hi Jim, This is a known problem on OS X 10.0.x. I keep meaning to take a look at it, but haven't had the time ( I have to learn gdb and the mysql source first/at the same time). If you are already a familiar with gdb and can help the mysql programmers by finding out more info and/or even a fix, that would help get this fixed. safe_mysqld has the job of keeping a copy of mysqld running. If it finds mysqld not running (or if one dies?), it will start another. So if you kill -9 on safe_mysqld first and then on mysqld you can get them all stopped. If you just kill -9 mysqld then safe_mysqld is simply starting another for you (just doin' it's job don't cha know!). I'd love to get mysql working on OS X, I'm just really swamped right now and behind the learning curve for this unix stuff being a mac hack. One pointer I received from Sinisa (from the mysql dev team): Signal handling is all done in mysqld.cc in sql/ subdir. which is where we need to start I think since it appears that mysql's handling of the shutdown signal is not working. If you run the mysql-test-run script it has trouble and says: Warning; Aborted waiting on pid file: '/usr/local/mysql- test/var/run/mysqld-slave.pid' after 10 seconds Slave shutdown finished that's what makes it seem like the signals are not working. Either that or the file locking done on the pid file (what is that done for and who does it? I don't know). Let me know if you make any progress. Tyler On Saturday, May 5, 2001, at 10:58 AM, Jim McCarty wrote: From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: can't shutdown mysqld (nicely or not) on OS X 10.0.2 Description: After starting mysqld with: safe_mysqld --user-mysql I cannot shutdown the daemon. None of the mysqladmin commands work, kill -HUP does nothing and after using kill -9, mysqld restarts. I've tried with 10.0.1 as well as 10.0.2 and also trashing everything and rebuilding from the source again. How-To-Repeat: On my system (following instructions in INSTALL-SOURCE), DL 3.23.37 source and extract in /usr/local. From mysql-3.23.37/ run configure with: ./configure --with-pthread --with-named-curses-libs='' --with-named-thread-libs='' --prefix=/usr/local/mysql configure completes without hitch. Next, compile with: make -i compile completes without hitch. Then I 'make install', 'scripts/mysql_install_db' and the rest. I start testing the installation but I can't stop the daemon! I can only kill it with 'kill -9' but then it restarts again immediately. Fix: Submitter-Id: Originator:System Administrator Organization: MySQL support: none Synopsis: Cannot shutdown daemon on OS X 10.0.2 Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.37 (Source distribution) Environment: System: Darwin localhost 1.3.2 Darwin Kernel Version 1.3.2: Fri Apr 27 22:50:58 PDT 2001; root:xnu/xnu-124.7.obj~1/RELEASE_PPC Power Macintosh powerpc Some paths: /usr/bin/perl /usr/bin/make /usr/bin/cc Compilation info: CC='cc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxr-xr-x 1 root wheel 15 May 1 23:49 /usr/lib/libc.dylib - libSystem.dylib Configure command: ./configure --with-pthread --with-named-curses-libs= --with-named-thread-libs= --prefix=/usr/local/mysql Thanks, Jim - 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- [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: What do I do now?
stat error seems like a permissions error. I'd guess it's a permissions problem. Perhaps figure out what user the process trying to stat the file is running under and then figure out what permissions that user has on the file in question. (Also check the directory chain going up for permissions being appropriate?). luck, Tyler On Wednesday, May 2, 2001, at 07:22 PM, Paul DuBois wrote: At 11:52 PM -0600 5/1/01, Colin Faber wrote: why not just use the LOAD DATA INFILE option? That probably won't help much. All the mysqlimport does is issue a LOAD DATA statement for you. LOAD DATA LOCAL INFILE might help, though. Or mysqlimport --local. At least, if the file_name.csv file is on the client host. Bombardier Systems Consulting wrote: HELP!!! I sent a message to this forum a couple of days ago about a problem that I am having with MySQL 3.23.37 (and now 36) running under RedHat 7.1. I am trying to use the mysqlimport utility and continue to get the following error: mysqlimport: Error: Can't get stat of '/home/yada/yada/file_name.csv' (Errcode: 13), when using table: file_name This utility was working when I was running 3.23.36 and RedHat 7.0 but RedHat kept crashing and so I had to upgrade to 7.1. When I installed MySQL I got the 3.23.37 version of MySQL. I have since re-installed RedHat 7.1 and the MySQL 3.23.36 version and am getting the same error. I looked up the error in the documentation and tried the UMASK change, rebooted, created new directory and moved file into it...still same problem. ANY ASSISTANCE WOULD BE APPRECIATED! Jim - 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- [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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Paul DuBois, [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 mysql-unsubscribe- [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: What can I do to help the mysql developers to get mysql to work on OS X?
On Tuesday, May 1, 2001, at 04:42 AM, Sinisa Milivojevic wrote: [EMAIL PROTECTED] writes: So, I'd really like to have mysql working on OS X and while there were a few people trying it out and having difficulty, I have yet to see any posts of total success. I'm an experienced MacOS programmer, but I have little experience on Unix -- so I'm way behind the curve on looking at the source and figuring it out. My only thought is to try to dive in and run mysqld via gdb and then try to figure out the source tree sufficiently to see where the shutdown (HUP?) message is getting handled and then set a breakpoint to see if that code is ever getting called and watch where it gets stuck by tracing from there. Unfortunately, I don't know how to use gdb (yet), and there is a LOT of source to slog through to find where the shutdown code is.Perhaps a more experienced unix hack could recommend some starting places; perhaps someone more experienced with the mysql source could point me to the locations of signal handling code (I hope it's not too obvious, since I haven't even looked yet... :-( Got to get gdb working first... ). So, if there is something I can do here to help get the issues resolved, I'd like to do so. Please feel free to email me directly with suggestions, staring points etc., if that helps. Thanks, Tyler [EMAIL PROTECTED] P.S. The problems I have seen posted and experienced myself are: 1) the small edit to get it to compile (not a big deal, but should get fixed) 2) The mysqld cannot be stopped short of kill -9 3) trying to use mysqladmin shutdown to stop mysqld (and safe_mysql) fails (hangs, requires kill -9 to halt) 4) the tests do not work. 4a) make test fails 4b) mysql-test-run fails Thank you Sinisa for responding. I have made some responses below and I have included the logs and errors from the test run.The errors may perhaps give you a clue that can direct my further efforts. Please find them below after the screen output of running the tests. Thanks very much for your assistance! I'd really like to have Mac OS X be a fully supported mysql platform! You should first learn to use gdb ... ;o) It is truly not so difficult. I figure, just a matter of TIME :-) so I'm rebuilding with the -with-debugging=full now and hopefully that'll help see stuff. Regarding a diff to make it compile, if you have not sent it to us, please do. I have not, but I saw someone else on the list saying they would (or you asked them to). Regarding second and third problem, you should take a deeper look at OS X signals and try to see what goes on. Signal handling is all done in mysqld.cc in sql/ subdir. OK that's what I needed a pointer to where to look in the source. Regarding failing tests, you should examine the error log. Ok. Here's the output to the screen: ./mysql-test-run Installing Test Databases Removing Stale Files Installing Master Databases Installing Slave Databases Starting MySQL daemon Loading Standard Test Databases Starting Tests TEST USER SYSTEM ELAPSEDRESULT alias 0.03 0.02 0.25 [ pass ] alter_table 0.04 0.01 0.29 [ pass ] analyse 0.02 0.02 0.12 [ pass ] auto_increment0.01 0.02 0.26 [ pass ] backup0.01 0.06 0.27 [ pass ] bdb-crash 0.02 0.03 0.07 [ pass ] bdb [ fail ] /usr/local/bin/mysqltest: Can't get stat of 'r/have_bdb.require' (Errcode: 2) real 0.07 user 0.02 sys 0.02 Aborting. To continue, re-run with '--force'. Ending Tests Shutting-down MySQL daemon Warning; Aborted waiting on pid file: '/usr/local/mysql- test/var/run/mysqld.pid' after 10 seconds Master shutdown finished Warning; Aborted waiting on pid file: '/usr/local/mysql- test/var/run/mysqld-slave.pid' after 10 seconds Slave shutdown finished So it looks like we have the shutdown failure problem here also. Almost looks like it's waiting for the 'lock' on the pid file to be removed but I don't really know what I'm talking about... When I look at the logs, the last thing in each log is: 11 Shutdown or 2 Shutdown The .err files say the following: tyler% more *.err :: mysqld-slave.err :: Warning: One can only use the --user switch if running as root /usr/local/bin/mysqld: ready for connections 010501 19:39:06 Slave: connected to master '[EMAIL PROTECTED]:9306', replication started in log ' FIRST' at position 4 010501 19:39:31 Aborted connection 2 to db: 'unconnected' user: 'root' host: `localhost' (Got a n error writing communication packets
mysql-test does not work from install directory after source dist. install
Description: There are several problems running the mysql-test-run script from the installed directory if you are installing from a source distribution. e.g., if you do as the manual suggests (4.7.1 Quick Installation Overview) shell groupadd mysql shell useradd -g mysql mysql shell gunzip mysql-VERSION.tar.gz | tar -xvf - shell cd mysql-VERSION shell ./configure --prefix=/usr/local/mysql shell make shell make install shell scripts/mysql_install_db shell chown -R root /usr/local/mysql shell chown -R mysql /usr/local/mysql/var shell chgrp -R mysql /usr/local/mysql shell /usr/local/mysql/bin/safe_mysqld --user=mysql and then do the seeminly logical: shell cd /usr/local/mysql/mysql-test shell ./mysql-test-run FIX: suggest that script be changed to detect when it has been run in the install directory and is part of a source dist. Note that the permissions on the installed mysql-test directory after make install are also problematic and will have to be changed (script will fail when trying to make mysql-test/var and sub directories). How-To-Repeat: cd mysql-VERSION ./configure --prefix=/usr/local/mysql make su make install groupadd mysql useradd -g mysql mysql scripts/mysql-install_db chown -R root /usr/local/mysql chown -R mysql /usr/local/mysql/var chgrp -R mysql /usr/local/mysql exit (to stop being root) /usr/local/mysql/bin/safe_mysqld --user=mysql cd /usr/local/mysql/mysql-test ./mysql-test-run Synopsis: mysql-test-run script does not work from install directory after source dist. build/install Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.37 (Source distribution) Environment: System: Darwin localhost 1.3.2 Darwin Kernel Version 1.3.2: Fri Apr 27 22:50:58 PDT 2001\ ; root:xnu/xnu-124.7.obj~1/RELEASE_PPC Power Macintosh powerpc SAME problem on Yellow Dog Linux 1.2.1 (based on RedHat Linux). Some paths: /usr/bin/perl /usr/bin/make /usr/bin/cc Compilation info: CC='cc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxr-xr-x 1 root wheel 15 May 1 12:44 /usr/lib/libc.dylib - libSystem.dylib Configure command: ./configure -prefix=/usr/local/mysql - 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: Possible bug in 3.23.32 or later
FWIW: It also appears to me that negative one (-1) plus one (1) is ZERO (0) which may be why you are having trouble...? in ignorance, haiku On Wednesday, April 18, 2001, at 01:09 AM, Milo Stefani wrote: As Far as I can remember it is explicitly said in the Manual that inserting a negative value in an autoincrement field is a Bad Thing - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 18, 2001 6:14 AM Subject: Possible bug in 3.23.32 or later Description: When i insert into a negative integer into primary key (id int) field, it works fine. However, the next insert i do without specifing the id explicitly and relying on mysql to generate the next number in the sequence (should be 1) will use the upper bound (2^32 - 1) Then every other insert after that will not insert since there are no id's available. How-To-Repeat: CREATE TABLE category ( idINT NOT NULL AUTO_INCRE17;6, name VARCHAR(50) NOT NULL, code VARCHAR(50) NOT NULL, description TEXT, picture VARCHAR(50), parentINT NOT NULL DEFAULT 0, activeTINYINT, members INT NOT NULL DEFAULT 0, storeid INT, feature1 INT NOT NULL DEFAULT 0, feature2 INT NOT NULL DEFAULT 0, priority INT, KEY (code), KEY (name), PRIMARY KEY (id) )\g INSERT INTO category (id,name,code,description,picture,parent,active,members,storeid,feature1, fea ture2) VALUES (-10,'NEW','NEW','All new products','none',-1,0,0,1,0,0); Then try: INSERT INTO category (name,code,description,picture,parent,active,members,storeid,feature1,featur e2) VALUES ('test','test','All test products','none',-1,0,0,1,0,0); That should make the id 2^32 -1 (or something aroudn there). That id should be 1!!! Fix: Submitter-Id: submitter ID Originator: Duane Homick Organization: Inline Internet Systems, Inc. MySQL support: none Synopsis: bug in primary key insert with negative integers Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.32 (TCX binary) Environment: - 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 mysql-unsubscribe- [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
On Wednesday, April 18, 2001, at 07:29 AM, B. van Ouwerkerk wrote: I'm trying to install mysql onto a uniz environment. I've already unzipped and untarred, and I've created the mysql - version directory, but when I type configure, I get a grant table failed error. I cant find anything on how to fix this. Take a look at www.devshed.com they've got a nice tutorial.. more specifically: mysql basic area:http://www.devshed.com/Server_Side/MySQL/ and grant tables: http://www.devshed.com/Server_Side/MySQL/Grant_Tables/ luck, haiku - 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