cannot access mysql and see privileges
Warning: Access denied for user: 'root@localhost' (Using password: NO) in /var/www/html/phpMyAdmin/lib.inc.php3 on line 255 Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' (Using password: NO) in /var/www/html/phpMyAdmin/lib.inc.php3 on line 255 Error MySQL said: Access denied for user: 'root@localhost' (Using password: NO) Also I get an error message when trying to show grants privileges using: show grants; Thanks -- Jon Miller [EMAIL PROTECTED] MMT Networks Pty Ltd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: sql query using select and row functions
Thank you all for your help. I think that is all I need to do is select it by row. -Original Message- From: R. Hannes Niedner [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 28, 2003 2:02 PM To: Christopher Lyon; MySQL Mailinglist Subject: Re: sql query using select and row functions On 1/28/03 12:26 PM, Christopher Lyon [EMAIL PROTECTED] wrote: I do have a timestamp field would I be better off using that? Granted it might not be the same amount of rows every time but how would that work? Select * from tbl_name where TIMESTAMP ( ) -3 hours; Well, that is not what you asked for you just wanted to get the last N records inserted into the database which is different from what you asked now. Your original question is best answered with having an autoincrement field in your table and do a: SELECT field FROM table WHERE whatever = don'tknow ORDER BY autoincrement_field DESC LIMIT N; Using the timestamp field to retrive all records inserted within the last n years/months/weeks/days/hours/minutes/second requires some string conversion of the timestamp. Your best bet in that case is to look into the Date and Time Functions: Check comments also! http://www.mysql.com/doc/en/DATETIME.html http://www.mysql.com/doc/en/Date_and_time_functions.html After reading through the excellent documentation it should be rather straight forward how to do it. Hth/h SQL, QUERY, TABLE P.s. I also strongly recommend to keep the discussion on the list for your benefit (there are much better experts on the mysql list than me) but also for the benefit of others with a similar problem (although there is a rather big lag from posting to appearing on the list). The list archives also getting way to little attention. -Original Message- From: R. Hannes Niedner [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 28, 2003 11:50 AM To: Christopher Lyon; MySQL Mailinglist Subject: Re: sql query using select and row functions On 1/28/03 8:26 AM, Christopher Lyon [EMAIL PROTECTED] wrote: I am trying to do an sql query and am trying to select the last x rows from the database. I see the limit function but that seems like that is from the first row down. I want to start from the last row to the first row. So, selecting the last 5 rows for instance? Can this be done? The easiest way is probably to add an ORDER BY field DESC into your SQL statement. If you use an autoincrement field you could use that otherwise add a field and make it TIMESTAMP. Hth/h - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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_install_db doesn't install grant tables
Description: When I tried to start MySQL server with shell/usr/bin/safe_mysqld it gave me the error: - Starting mysqld daemon with databases from /var/lib/mysql 030128 08:56:42 mysqld ended - The log file /var/lib/mysql/stvme2.log has only following: /usr/libexec/mysqld, Version: 3.23.52-log, started with: Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock Time Id CommandArgument The log file /var/log/mysqld.log has the followings: -- 030128 08:56:42 mysqld started Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add to the [mysqld] section, for example, innodb_data_file_path = ibdata1:10M:autoextend But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 2 at http://www.innodb.com/ibman.html 030128 8:56:42 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errn o: 13) 030128 08:56:42 mysqld ended -- I did put the line innodb_data_file_path = ibdata1:10M:autoextend on the mentioned place now it gaves the same error with log: -- 030128 09:56:44 mysqld started 030128 9:56:44 InnoDB: Out of memory in additional memory pool. InnoDB: InnoDB will start allocating memory from the OS. InnoDB: You may get better performance if you configure a bigger InnoDB: value in the MySQL my.cnf file for InnoDB: innodb_additional_mem_pool_size. InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 030128 9:56:44 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 030128 9:56:45 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 030128 9:56:45 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 030128 9:56:46 InnoDB: Started 030128 9:56:46 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 030128 09:56:46 mysqld ended It would be great if one could help me on this. Thanks in advance, Ozlem How-To-Repeat: Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: Ozlem Celik Originator:development Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-3.23.52 (Source distribution) Environment: machine, os, target, libraries (multiple lines) System: Linux stvme2.astro.ucla.edu 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386 GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-sh\ ared --enable-threads=posix --disable-checking --host=i386-redhat-linux --with-system-zlib --enable-__cxa\ _atexit Thread model: posix gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7) Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LA\ RGEFILE_SOURCE' CXX='g++' CXXFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_ \LIBC: lrwxrwxrwx1 root root 14 Jan 10 07:06 /lib/libc.so.6 - libc-2.2.93.so -rwxr-xr-x2 root root 1235468 Sep 5 16:12 /lib/libc-2.2.93.so -rw-r--r--1 root root 2233342 Sep 5 15:59 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 5 15:50 /usr/lib/libc.so Configure command: ./configure --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --datadir=/usr/share --\ libdir=/usr/lib
mysqld got signal 11; This could be because you hit a bug ....
Hello, I am running mysql server (mysql-standard-4.0.5-beta-64bit) 64 bit on Sun Solaris 2.8 and I have got the binaries form the mysql web site. The machine I am using has 32GB of RAM + 64GB of swap. At the certain point I got : __ /usr/local/mysql-standard-4.0.5-beta-64bit/bin/mysqld: ready for connections mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=11274285056 read_buffer_size=2093056 sort_buffer_size=2097144 max_used_connections=0 max_connections=16 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 11075515 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. __ I have tried also 4.0.8 and I have the same problem. I do not think it is an hardware problem, because I have tried the same task on a different Sun machine (with Solaris 2.8 and the same executable) and I get the same problem after a while. I have tested the memory allocation with mysqld through the creation of big HEAP table and mysqld could allocate all the memory (32GB+64GB) for the heap table. I have got an error after that because mysqld needed more memory for finishing filling the heap table and it could not allocate more (xmalloc failed) of it. So if mysqld can use all the Solaris Virtual memory of the system, why do I get that problem, provided that I have more memory (32GB + 64GB) of what it is complaining ? key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 11075515 K Could someone help, please ? Thanks in advance for your help, Mariella - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
'mysqladmin slave-st(art|op)' - is it implemented?
Hello, I see in the mysqladmin man page for version 3.23.55-1 that 'slave-start' and 'slave-stop' have at least been thought of at some stage (they're listed in the COMMAND SYNOPSIS section), but they don't seem to work when I try them... I've just been through the change logs for version 4, and can't find any mention of them in there... Can anyone tell me whether these options for mysqladmin are implemented? If not, can anyone tell me whether I can tell mysqld to stop or start replicating from a shell script rather than the mysql client? Thanks in advance, Guy. -- Guy Waugh Unix Team Information Technology Telecommunication Services Southern Cross University P.O. Box 157 Lismore NSW 2480 Ph: 61 2 6620 3196 Fax: 61 2 6620 3033 www.scu.edu.au/admin/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
mysql php and blank variables...
hi all.. having a little problem with mysql_query()... for some reason when i type mysql_query(insert into table_name ('$var list'...); i come up with a bunch of blank/empty variables... im using apache 1.3.4x mysql 3.2.3.x wwinME .. any ideas how to fix the problem...? --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.443 / Virus Database: 248 - Release Date: 1/10/2003 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
can someone help me optimize this?
i have a select that seem to be taking too long for what it is, and after looking over the documents i can't seem to find a better way. probably some things that would help: -on a datetime field, is there a way to look at everything from a month that still uses the index. -is there a way to cause a select to work more in the background and not kill the server while its working (it may take longer, but atleast other queries will keep working) select logon_id from customers where Limited_Access = 1; 2100 rows in set (0.41 sec) select Username, sum(AcctSessionTime)/3600 as hrs from customers left join radacct on (customers.logon_id = radacct.username) where Limited_Access=1 and AcctStopTime '2002-12-31' and AcctStopTime '2003-02-01' group by Username having hrs 65 order by Username; after about 8 minutes, killed the process, but it should have about 2100 records as well, and getting a few complaints about the data server not responding from one of the main programs that is using it. explain says: | table | type | possible_keys | key| key_len | ref | | rows | Extra | +---+--+++-+- ---+--+-+ | customers | ref | Limited_Access | Limited_Access | 2 | const | | 2169 | where used; Using temporary | | | radacct | ref | UserName | UserName | 64 | customers.LOGON_ID |3 | where used CREATE TABLE customers ( ### trimmed the extra fields out of this one ID int(11) NOT NULL auto_increment, LOGON_ID varchar(20) default NULL, Limited_Access tinyint(4) default NULL, PRIMARY KEY (ID), KEY Limited_Access (Limited_Access) ) TYPE=MyISAM; CREATE TABLE radacct ( RadAcctId bigint(21) NOT NULL auto_increment, AcctSessionId varchar(32) NOT NULL default '', AcctUniqueId varchar(32) NOT NULL default '', UserName varchar(64) NOT NULL default '', Realm varchar(64) default '', NASIPAddress varchar(15) NOT NULL default '', NASPortId int(12) default NULL, NASPortType varchar(32) default NULL, AcctStartTime datetime NOT NULL default '-00-00 00:00:00', AcctStopTime datetime NOT NULL default '-00-00 00:00:00', AcctSessionTime int(12) default NULL, AcctAuthentic varchar(32) default NULL, ConnectInfo_start varchar(32) default NULL, ConnectInfo_stop varchar(32) default NULL, AcctInputOctets int(12) default NULL, AcctOutputOctets int(12) default NULL, CalledStationId varchar(10) NOT NULL default '', CallingStationId varchar(10) NOT NULL default '', AcctTerminateCause varchar(32) NOT NULL default '', ServiceType varchar(32) default NULL, FramedProtocol varchar(32) default NULL, FramedIPAddress varchar(15) NOT NULL default '', AcctStartDelay int(12) default NULL, AcctStopDelay int(12) default NULL, PRIMARY KEY (RadAcctId), KEY UserName (UserName), KEY FramedIPAddress (FramedIPAddress), KEY AcctSessionId (AcctSessionId), KEY AcctUniqueId (AcctUniqueId), KEY AcctStartTime (AcctStartTime), KEY AcctStopTime (AcctStopTime), KEY NASIPAddress (NASIPAddress) ) TYPE=MyISAM; there are about 780,000 records in the radacct table, about 1/2 of that is this month -- mysql, sql, query, sql, sql, 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Configure prob with FreeBSD/Linuxthreads
I've since given up, installed with the exact configure line shown in the MySQL docs, FreeBSD section, and it worked perfectly, so I'm worrying about moving my grant tables from 3.23.49 and so forth, instead of getting Linuxthreads to workBut I'd be happy to try to get this fixed, especially if it will help others. If I remember correctly, it was the --with-libwrap that broke it on my box. Try removing that. -j - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Netware
Has anyone any experience of running MySQL on Netware 6? I am thinking of porting our helpdesk to Netware AMP (Apache/MySQL/PHP) to better integrate it with eDirectory. Cheers, Martin S. -- Martin Skjoldebrand http://www.skjoldebrand.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
Error 1148 by remote mysql +execute +insert
I am using mysql 3.23.59. By using the command mysql -h Remote --database=db -uuser -ppassword --execute load data local infile .. I get error nr. 1148: The used command is not allowed with this MySQL Version. Before I used mysql 3.23.37 and the above command was OK. I tested the --execute command with oder SQL Statements like select, update, everything works fine. Only the load command seems to be disabled. Has anybody an idea if the --execute and load infile tag can be enabled with version 3.23.59. My fear is that any new updated version does not allow this command, and I need it !!! ;-) Any hint ? Dirk Hennrichs - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: just a question.
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 29 January 2003 5:11 PM To: Inmate 67859432 Subject: Re: just a question. Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query,queries,smallint If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Hello i am writing to ask for assistance with what exactly i need to purchase/download when creating a web based fantasy game which uses a datbase to store and read records from. I dont know what else i need so any help would be apreciated. thanks Jimmy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Configure prob with FreeBSD/Linuxthreads
On Tue, Jan 28, 2003 at 04:28:53PM -0500, Jesse Sheidlower wrote: Out of curiosity, which version of gcc are you using? As I posted a few lines up, it's gcc 2.95.4 ;-) Oh, err. Hm. Right. I can read. Yeah. After I sent the original message, I tried to play around with the configure variables, and discovered that it only worked by eliminating the entire '--with-named-thread-libs=-DHAVE_GLIBC2_STYLE_GETHOSTBYNAME_R\ -D_THREAD_SAFE -DHAVE_BROKEN_REALPATH\ -L/usr/local/lib \ -llthread -llgcc_r' group; I tried removing each one individually and it failed each time with the checking size of char... configure: error: cannot compute sizeof (char), 77 error. Hmm. I've since given up, installed with the exact configure line shown in the MySQL docs, FreeBSD section, and it worked perfectly, so I'm worrying about moving my grant tables from 3.23.49 and so forth, instead of getting Linuxthreads to workBut I'd be happy to try to get this fixed, especially if it will help others. If you're interested, I could make my FreeBSD binary availale just to see if it runs on your system. I wouldn't expect you to run it for real--just see if it starts. I'm a little curious now to see if my builds even work on a non-Yahoo version of FreeBSD. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.8: up 1 days, processed 36,740,584 queries (336/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
Re: Weird locking/blocking issues
On Tue, Jan 28, 2003 at 01:20:16PM -0500, Grigor, Peter wrote: Heya Folkth: I have built mysql (4.0.9) on freebsd (4.7-RELEASE) with linuxthreads (2.2.3) and still encounter the 'strange threading' behavior described in J. Zawodny's blog. Here's the situation... 1/ there are three threads which lock and then write to two different tables... At the same time? Each thread locks both tables and then writes? Or something else? Can you post the exact SQL and sequence of events to see if someone else can reproduce or explain it? the locks are gotten using 'low_priority write'; the writing threads are continually waiting for locks (i.e two are waiting, one is executing); Hmm. What if you don't use low-priority write? Does it work normally then? 2/ On a different thread I do a select count(*) from one of the tables; Sometimes the select returns pretty quick witht the count; however, frequently the selecting thread will simply hang waiting to get the lock--if I look at the thread in [top] the thread will be taking a LOT of cpu time; if I look at the offending thread in the processlist it has a cycling status of 'waiting for tables', 'NULL', 'Locked', 'System Lock' and 'Reopen Tables'. Any chance you can truss the pid of the process that's sucking CPU time? We manged to find an old thread-related bug on FreeBSD/MySQL that way a year or so back. Note that this behavior occurs whether I compile with Linuxthreads or not, also I tried skip-external-locking to see if the 'system lock' status disappears, but it doesn't. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.8: up 1 days, processed 37,119,319 queries (338/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
Re: Configure prob with FreeBSD/Linuxthreads
In the last episode (Jan 28), Jonathan Disher said: On Tue, 28 Jan 2003, Jesse Sheidlower wrote: I've been trying to install MySQL 4.0.9 on FreeBSD 4.7, and have been getting stuck in the configure phase. I'd be grateful for any suggestions. I'm running FreeBSD 4.7 on a single-processor 1.4GHz PIII, using gcc 2.95.4, and trying to compile with Linuxthreads. I've been using the instructions Jeremy Zawodny posted in his blog at http://jeremy.zawodny.com/blog/archives/000458.html . I actually have a mysql4-server and mysql4-client port that I've been using on both 4.* and 5.*. I'm just waiting for the maintainer to repy to my emails and get it committed. FYI, that successfully built 3.23.54 -AND- 4.0.9 with linuxthreads on FreeBSD 5-RELEASE. I'm still testing, however, as I'm not overly impressed with the performance increase (MySQL 3.23.54 on a single Athlon MP2200+ performs a job of ours faster than a dual Athlon MP2200+ (same hardware, SMP vs NonSMP kernel)). I dunno. If you are only driving the server with a single client connection, or if your queries are CPU-bound, LinuxThreads isn't going to buy you anything. You need multiple clients and lots of simultaneous reads to see a difference. Also make sure you've turned off all the debugging options that 5.0's GENERIC kernel has compiled in. Most important is to disable WITNESS. That probably slows down SMP kernels more than UP. -- 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
Re: cannot access mysql and see privileges
On 1/28/03 3:42 PM, Jon Miller [EMAIL PROTECTED] wrote: Warning: Access denied for user: 'root@localhost' (Using password: NO) in /var/www/html/phpMyAdmin/lib.inc.php3 on line 255 Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' (Using password: NO) in /var/www/html/phpMyAdmin/lib.inc.php3 on line 255 Error MySQL said: Access denied for user: 'root@localhost' (Using password: NO) Also I get an error message when trying to show grants privileges using: show grants; Thanks -- Jon Miller [EMAIL PROTECTED] MMT Networks Pty Ltd Even though you didn't ask a questionit may be answered right here: http://www.mysql.com/doc/en/Resetting_permissions.html /h - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 creating fulltext index
-Original Message- From: Salada, Duncan [mailto:[EMAIL PROTECTED]] Sent: 28. januar 2003 20:40 To: '[EMAIL PROTECTED]' Subject: problems creating fulltext index Hello everyone, I'm running Ver 8.39 Distrib 4.0.9-gamma, for intel-linux on i686. I'm trying to create a fulltext index on an existing myisam table and running up against an error. From what I can tell, I'm using the alter table command correctly, but I keep getting errno 140. Can anyone point out my error? mysql alter table materials add fulltext title (title,variant_title,ss_title,term_1,term_2,term_3,term_4, term_5,abstract,notes,personal_name_1,personal_name_2,personal _name_3,person al_name_4, personal_name_5,personal_name_6); ERROR 1005: Can't create table './lincs/#sql-6d12_7.frm' (errno: 140) Have you tried using create index? From the documentation (http://www.mysql.com/doc/en/CREATE_INDEX.html): CREATE [UNIQUE|FULLTEXT] INDEX index_name ON tbl_name (col_name[(length)],... ) So it would become CREATE FULLTEXT INDEX title_idx ON materials (title,variant_title,ss_title,term_1,term_2,term_3,term_4,term_5,abstract,no tes,personal_name_1,personal_name_2,personal_name_3,person_al_name_4, personal_name_5,personal_name_); Regards Erlend Stromsvik ___ mysql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Mysqlhotcopy and reuilding indexes
-Original Message- From: Harald Fuchs [mailto:[EMAIL PROTECTED]] Sent: 28. januar 2003 10:46 To: [EMAIL PROTECTED] Subject: Re: Mysqlhotcopy and reuilding indexes In article [EMAIL PROTECTED], Erlend Hopsø Strømsvik [EMAIL PROTECTED] writes: Hi Sorry if I'm just being feeble minded here but I can't get this to work. First I take a copy of my database using: mysqlhotcopy --allowold --noindices db_name /path/path using the '--noindices' since it says --noindices Don't include full index files in copy to make the backup smaller and faster The indexes can later be reconstructed with myisamchk -rq.. in the manual. But I can't for the life of me figure out how to restore the index files with myisamchk. All I get is myisamchk: error: 'blabla.MYD' is not a MyISAM-table or myisamchk: error: 'blabla.frm' is not a MyISAM-table. Just omit the suffix: myisamchk -rq dbdir/blabla I'm pretty sure I tried that... myisamchk: error: File 'plassering' doesn't exist is what I get when trying to run it without the suffix. But from the documentation I found this: http://www.mysql.com/doc/en/REPAIR_TABLE.html As of MySQL 4.0.2, there is a USE_FRM mode for REPAIR. Use it if the `.MYI' file is missing or if its header is corrupted. In this mode MySQL will recreate the table, using information from the `.frm' file. This kind of repair cannot be done with myisamchk. So from MySQL 4.0.2 you can't do this with 'myisamchk'. So next time I should include information about which version of MySQL I'm running too *hangs head in shame* Allthough this -could- have been noted in the docs! Maybe there should be a change in the documentation at the mysqlhotcopy page soon then since a lot of people are starting to use MySQL 4.x.x: http://www.mysql.com/doc/en/mysqlhotcopy.html --noindices Don't include full index files in copy to make the backup smaller and faster The indexes can later be reconstructed with myisamchk -rq.. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Self Join on temporary tables in MySQL 3.xx
A understand that a problem with temporary tables is that you can't do a self-join in MySQL 3.xx using temporary tables. I have a situation that requires exactly this (the alternative is not algorithm-effective). I wonder if the following is a practical solution: to create a copy of the temporary table and use it together with the original temporary table to execute the join ? -- Ciprian Ambition is a poor excuse for not having enough sense to be lazy. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Help with SELECT, JOIN and WHERE query
Hi Stefan, Thanks to Dobromir, this works with mysql 3.23 too: select user_profile.user_id from user_profile left join team_member on (team_member.user_id=user_profile.user_id and team_member.team_id=2) where team_member.user_id is NULL; Regards Heiko - Original Message - Subject: Re: Help with SELECT, JOIN and WHERE query From: Stefan Hinz, iConnect \(Berlin\) Date: Wed, 29 Jan 2003 00:02:22 +0100 Victor, good shot! I thought of this one in the first place: SELECT u.user_id FROM user_profile u LEFT JOIN team_member t ON u.user_id = t.user_id WHERE t.team_id 2 But unfortunately, it will yield: +-+-+ | user_id | team_id | +-+-+ |1000 | 1 | |1001 | 3 | |1002 | 3 | |1003 | 3 | |1004 | 1 | |1005 | 1 | |1005 | 3 | +-+-+ 7 rows in set (0.00 sec) Where it should yield: +-+ |1002 | |1004 | +-+ A subselect would be most simple: SELECT u.user_id FROM user_profile u WHERE user_id NOT IN (SELECT user_id FROM team_member t WHERE t.team_id = 2) It's too late am I'm too tired to rewrite this query so it will work in MySQL = 4.0.9. With MySQL 4.1 (alpha out now!!!) we have subselects :) Good night, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Victor Pendleton [EMAIL PROTECTED] To: 'heiko mundle' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, January 28, 2003 5:30 PM Subject: RE: Help with SELECT, JOIN and WHERE query SELECT u.user_id FROM user_profile u LEFT JOIN team_member t ON u.user_id = t.user_id WHERE t.team_id 2 -Original Message- From: heiko mundle [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 28, 2003 8:08 AM To: [EMAIL PROTECTED] Subject: Help with SELECT, JOIN and WHERE query Hi, I got a difficult problem with a SELECT query: In my application there are two tables, one for all users (user_profile) one for a user-in-team relation. I want to know, which user is still not in a speciffic team. Users can be in more than one team, but we don't care about that. Example: user_profile: +-+ | user_id | +-+ |1000 | |1001 | |1002 | |1003 | |1004 | |1005 | |1006 | |... | +-+ team_member: +-+-+ | team_id | user_id | +-+-+ | 1 |1000 | | 1 |1004 | | 1 |1005 | | 2 |1006 | | 2 |1003 | | 2 |1000 | | 2 |1001 | | 2 |1005 | | 3 |1001 | | 3 |1005 | | 3 |1002 | | 3 |1003 | | ... |... | +-+-+ Who is not in team no. 2? Result: +-+ |1002 | |1004 | +-+ Thanks for any hint Kind regards Heiko Mundle -- +++ GMX - Mail, Messaging more http://www.gmx.net +++ NEU: Mit GMX ins Internet. Rund um die Uhr für 1 ct/ Min. surfen! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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_install_db doesn't install grant tables
have look at http://www.mysql.com/doc/en/mysql_install_db.html [EMAIL PROTECTED] wrote: Description: When I tried to start MySQL server with shell/usr/bin/safe_mysqld it gave me the error: - Starting mysqld daemon with databases from /var/lib/mysql 030128 08:56:42 mysqld ended - The log file /var/lib/mysql/stvme2.log has only following: /usr/libexec/mysqld, Version: 3.23.52-log, started with: Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock Time Id CommandArgument The log file /var/log/mysqld.log has the followings: -- 030128 08:56:42 mysqld started Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add to the [mysqld] section, for example, innodb_data_file_path = ibdata1:10M:autoextend But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 2 at http://www.innodb.com/ibman.html 030128 8:56:42 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errn o: 13) 030128 08:56:42 mysqld ended -- I did put the line innodb_data_file_path = ibdata1:10M:autoextend on the mentioned place now it gaves the same error with log: -- 030128 09:56:44 mysqld started 030128 9:56:44 InnoDB: Out of memory in additional memory pool. InnoDB: InnoDB will start allocating memory from the OS. InnoDB: You may get better performance if you configure a bigger InnoDB: value in the MySQL my.cnf file for InnoDB: innodb_additional_mem_pool_size. InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 030128 9:56:44 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 030128 9:56:45 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 030128 9:56:45 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 030128 9:56:46 InnoDB: Started 030128 9:56:46 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 030128 09:56:46 mysqld ended It would be great if one could help me on this. Thanks in advance, Ozlem How-To-Repeat: Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: Ozlem Celik Originator:development Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-3.23.52 (Source distribution) Environment: machine, os, target, libraries (multiple lines) System: Linux stvme2.astro.ucla.edu 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386 GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-sh\ ared --enable-threads=posix --disable-checking --host=i386-redhat-linux --with-system-zlib --enable-__cxa\ _atexit Thread model: posix gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7) Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LA\ RGEFILE_SOURCE' CXX='g++' CXXFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_ \LIBC: lrwxrwxrwx1 root root 14 Jan 10 07:06 /lib/libc.so.6 - libc-2.2.93.so -rwxr-xr-x2 root root 1235468 Sep 5 16:12 /lib/libc-2.2.93.so -rw-r--r--1 root root 2233342 Sep 5 15:59 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 5 15:50 /usr/lib/libc.so Configure command: ./configure
Re: mysqld got signal 11; This could be because you hit a bug ....
- Original Message - From: Mariella Di Giacomo [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, January 29, 2003 1:12 AM Subject: mysqld got signal 11; This could be because you hit a bug Hello, I am running mysql server (mysql-standard-4.0.5-beta-64bit) 64 bit on Sun Solaris 2.8 and I have got the binaries form the mysql web site. The machine I am using has 32GB of RAM + 64GB of swap. Hi Mariella, My, that is a LOT of memory! :) What could you possibly have running that allows only 16 connections, yet uses up to the max of 96 GigaByte? :) Yikes! I take it this is high-quality ECC memory? If not, with that much memory, a seg fault could easily occur. I believe FreeBSD already advises to uses ECC memory when you have as little as 4 G. I'm sure you got that covered, though; just checking. :) - Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 4.0.9 and Jconnector 3.0.5
Hello again! Thanks for all who replied. Im currently setting up Mysql 4.1 to test with my codes. Unfortunately, Binaries for 4.1 version are not yet available. I Followed the steps in building from development source and encountered some problems. In the process of cloning 4.1 branch, while it is running consistency check... it gave me this libmysql/password.c: You are trying to create a symlink on a win32 file system. This file type is not supported on this platform. Then it gave me that message again when I was doing a --- bk -r get -Sq as instructed in the manual. I might be missing out something here. Will it be ok to proceed given that message? TIA From: Mark Matthews [EMAIL PROTECTED] To: avaj avaj [EMAIL PROTECTED] CC: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Mysql 4.0.9 and Jconnector 3.0.5 Date: Tue, 28 Jan 2003 08:21:42 -0600 -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 avaj avaj wrote: [snip] java.sql.SQLException: Syntax error or access violation, message from server: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id FROM table2 WHERE col = '4028809b:60 Somehow.. the string was truncated. I tried displaying the string prior to the sql statement and it return the correct value. I think It has to do with the driver's implemetation of ? and preparedStatement.setString() coz when I tried not using ? and setString it passed thru it correctly. However, there are numerous sql statement that makes use of ? and setString. So, changing them all is not a good idea. MySQL doesn't always return the complete statement during error messages, only the part that is relevant. MySQL 4.0.9 does not support subselects (4.1 does), so the parser is complaining about the SELECT in your IN clause, not the value you are setting. -Mark - -- MySQL 2003 Users Conference - http://www.mysql.com/events/uc2003/ For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.1.90 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+NpH7tvXNTca6JD8RArGqAJ9h4sQB9oShVfz/URrcp5ZZRDzVFgCgxJjR Z8jTv+pTEQ9HmlBQ7Wj8Oxw= =UHAm -END PGP SIGNATURE- _ The new 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
Re: file-descriptor limits for linux
Hi, I think you misunderstood /proc/sys/fs/file-max meaning, it IS an averall machine limit, not per process. From linux kernel documentation (/usr/src/linux/Documentation/sysctl/fs.txt): file-max file-nr: The kernel allocates file handles dynamically, but as yet it doesn't free them again. The value in file-max denotes the maximum number of file- handles that the Linux kernel will allocate. When you get lots of error messages about running out of file handles, you might want to increase this limit. The three values in file-nr denote the number of allocated file handles, the number of used file handles and the maximum number of file handles. When the allocated file handles come close to the maximum, but the number of actually used ones is far behind, you've encountered a peak in your usage of file handles and you don't need to increase the maximum. Whatever value you set with ulimit, you won't get any error message until the system actually reaches file-max limit. It will then deny any new file open (not just those coming from mysqld). Hope this helps, Joseph Bueno Martin Waite wrote: Hi, Does anyone know what the story is for file-descriptor limits on Linux ? I read in http://www.xenoclast.org/doc/benchmark/HTTP-benchmarking-HOWTO/node7.html that root needs to set /proc/sys/fs/file-max to a high value in order that ulimit -n will work. However, on a Debian Woody box (2.4 kernel), this doesn't seem to be necessary. As root, I can set the value as high as I want (up to about 63000) regardless of the value in /proc/sys/fs/file-max. Also, these are per-process limits. What is the overall machine limit - assuming there is one ? These questions are related to MySQL, SQL, etc. Honest. == Martin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Get record with MAX() in one column
Hi, we use this table mobile_pos +-+-+-+ | team_id | time| geometry| +-+-+-+ | 3 | 2003-01-28 16:17:06 | 727105 5282634 651 | | 5 | 2003-01-28 16:19:22 | 728220 5282453 944 | | 1 | 2003-01-28 17:08:24 | 728998 5283317 1423 | | 3 | 2003-01-28 18:47:16 | 727805 5288644 772 | | 5 | 2003-01-28 19:34:25 | 727228 5283755 815 | | 1 | 2003-01-29 11:08:24 | 728938 5283467 1467 | +-+-+-+ how do I get the geometry for every team with every newest time? IF I do something like that, I will get the newest record, but how can I get the geometry of the record? SELECT team_id, MAX(time) FROM SAFETOUR_mobile_pos GROUP BY team_id; Thanks Heiko ps: we use mysql 3.23 -- +++ GMX - Mail, Messaging more http://www.gmx.net +++ NEU: Mit GMX ins Internet. Rund um die Uhr für 1 ct/ Min. surfen! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
May be bug in MySQL Table!!!
Dear Sir/Madam, Here I've attached one Table of MySQL, named as M_Filed. When I am trying to select all tables from VB, it gives me following error Run-time error '-2147467259 (80004005)': [TCX][MyODBC]Got error 127 from table handler Waiting for your reply. Regards, Shripal. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 to Mysql from java(linux)
vim m wrote: Hi: I am new to Mysql. I have installed mysql3.23.55 on linux RH7.1. Now mysql is running successfully on my system. When I try connecting thru java(mysql-connector-java-3.0.1) I am getting an Access Denied error. It says mysql@machinename access denied. Now i tried from command line: mysql -u mysql -p -h localhost. This works, but when i give:mysql -u mysql -p -h machinename it doesnt work. Why is that? The user mysql has all priviliges granted. You need to set proper hosts permissions for user. RTFM section 4 :-) Max - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 php and blank variables...
:when i type :mysql_query(insert into table_name ('$var list'...); i come :up with a bunch :of :blank/empty variables... Try to debug your query by outputting to the stdout instead of sending to the mysql server. You can do it by simply echo()ing your query as it is to the browser or terminal. I'm sure you'll see it doesn't look like what you really had in mind. This debugging trick may also make this question a non-mysql related ;-). Good luck Sherzod - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Changing the server that is started by entry in Services in Windows XP?
Hi All, I recently downloaded and installed MySQL-3.23.55 for Windows XP. Previously I was running MySQL-3.23.53-max-nt, but now the Service entry that appears under the Services List under Administrative Tools runs 3.23.55-nt when started, when I would prefer it to run 3.23.55-max or 3.23.55-max-nt. I can't seem to edit the server this Service runs by clicking on its properties in the Services List. Can anyone tell me how I change which version of the server this Service runs when started? Following is the information from my my.ini file, if that's helpful. It certainly lists mysql-max.exe, but appears that's not what gets started when I start the service. #This File was made using the WinMySQLAdmin 1.4 Tool #29/01/2003 9:39:14 PM #Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions [mysqld] basedir=C:/mysql #bind-address=169.254.82.163 datadir=C:/mysql/data #language=C:/mysql/share/your language directory #slow query log#= #tmpdir#= port=3306 #set-variable=key_buffer=16M [WinMySQLadmin] Server=C:/mysql/bin/mysqld-max.exe user=[withheld] password=[withheld] Regards and best wishes, Murray Wells - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 1148 by remote mysql +execute +insert
Dirk, you're right. LOCAL is disabled by default with all newer versions of MySQL (server and client). One can enable LOCAL by _compiling_ MySQL with --enable-local-infile, but this is not possible for binaries, of course. The manual says you can enable LOCAL with --local-infile=1, either for the server and/or for the mysql client. This doesn't work for me, though. I'm still waiting for an explanation by a guru/developer whether I am misunderstanding something, or if this is a bug, or even a feature. http://www.mysql.com/doc/en/LOAD_DATA_LOCAL.html Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Dirk Hennrichs [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, January 29, 2003 7:25 AM Subject: Error 1148 by remote mysql +execute +insert I am using mysql 3.23.59. By using the command mysql -h Remote --database=db -uuser -ppassword --execute load data local infile .. I get error nr. 1148: The used command is not allowed with this MySQL Version. Before I used mysql 3.23.37 and the above command was OK. I tested the --execute command with oder SQL Statements like select, update, everything works fine. Only the load command seems to be disabled. Has anybody an idea if the --execute and load infile tag can be enabled with version 3.23.59. My fear is that any new updated version does not allow this command, and I need it !!! ;-) Any hint ? Dirk Hennrichs - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Will DELAYED inserts solve my problem ( also related to indexing )
I have a hit logger tool, which does approximately 200,000 INSERTs a day into tables. The other application uses the same tables to run somewhat complex SELECT queries. Since these tables will be large, SELECT queries are quite slow. Indexing the tables produced prefect results for these SELECT queries. But I guess inserting into a large indexed table may be a lot slower? So my question is, may DELAYED inserts solve my problem here, and allow me to keep those tables indexed? Is there any other trick that may solve my problem? Thank you for any attempt to help. Sherzod - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: restart or not?
FLUSH PRIVILEGES On 29 Jan 2003 07:05:29 +0800, Jon Miller wrote: When granting someone permissions are these permissions dynamic or do I have to reload mysql? Also we have a developer who stated he cannot access the database remotely. I've granted him privileges as follows since he works on the entire system both locally and remotely. There is only one database in the system. I've set a password for access to the system also. grant all privileges on *.* to joseph@% identified by 'his_password' with grant option; grant all privileges on *.* to joseph@localhost identified by 'his_password' with grant option; GRANT RELOAD,PROCESS ON *.* TO joseph@localhost; GRANT USAGE ON *.* TO joseph@localhost; -- Jon Miller [EMAIL PROTECTED] MMT Networks Pty Ltd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: cannot access mysql and see privileges
You need to include the (correct) Root password in mysql_connect(h,u,p) On 29 Jan 2003 07:42:37 +0800, Jon Miller wrote: Warning: Access denied for user: 'root@localhost' (Using password: NO) in /var/www/html/phpMyAdmin/lib.inc.php3 on line 255 Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' (Using password: NO) in /var/www/html/phpMyAdmin/lib.inc.php3 on line 255 Error MySQL said: Access denied for user: 'root@localhost' (Using password: NO) Also I get an error message when trying to show grants privileges using: show grants; Thanks -- Jon Miller [EMAIL PROTECTED] MMT Networks Pty Ltd 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
Cardinality doesn't auto start
mysql Ver 11.18 Distrib 3.23.54, for pc-linux (i686) INDEXING PROBLEM I'm building an application which will have a self install script, intended for use by many people. One particular area of the program requires the need for an index. If I create this index when I build the table or apparently even after the table is built but before any data is written to the table, cardinality is shown as 'None' (using phpMyAdmin) and futhermore it does not start counting until after data is entered and the index is recreated. Seems like when the index is created, if no data is in the table, it should be given a default cardinality of 0 and the count continue as data is entered. This need to create/recreate the index after data is written, is tough to deal with as a programmer having to ask the end user to create this index after data is gathered. Any ideas besides creating an index creater script for the user to run later? Would this be considered a bug? SQL to create table with index CREATE TABLE somename ( ndx int(10) NOT NULL auto_increment, d_now int(7) default NULL, adate timestamp(14) NOT NULL, PRIMARY KEY (ndx), UNIQUE KEY id (ndx), KEY d_now (d_now) ) TYPE=MyISAM; end SQL --- I have also tried it with d_now set to NOT NULL with the same results. The index just won't start counting with no data entered. -- John Hinton - Goshen, VA. http://www.ew3d.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
Recovery in MySql
Hi All, I have MySql on Windows. Today i had an electrical power interruption in the middle of working. The database remain not consistent and i could not continue working with it. Is there any Recovery after crash mechanism in mySql? Thanks, Inbal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 mysqlhotcopy version 1.17 when using --record_log_pos
Description: With mysqlhotcopy version 1.15 (from MySQL-3.23.49-1) I used to do like this: mysqlhotcopy --user=root --password=foo -q --allowold --record_log_pos backup.log_pos db1 db2 backup $TMPDIR After upgrading to MySQL-3.23.55-1 and thus mysqlhotcopy version 1.17 the same command gave this error: DBD::mysql::db do failed: Not unique table/alias: 'log_pos' at /usr/bin/mysqlhotcopy line 437. The problem is that line 311 now adds backticks around database and table names: my @hc_tables = map { `$db`.`$_` } @dbh_tables; This is not taken into account at line 422 where $table comes directly from $opt{checkpoint} or $opt{record_log_pos}: unless ( $hc_locks =~ s/$table\s+READ/$table WRITE/ ); The resulting lock-command becomes: LOCK TABLES `db1`.`table1` READ, `db2`.`table1` READ, `backup`.`log_pos` READ, backup.log_pos WRITE How-To-Repeat: Try issuing the command mysqlhotcopy --user=root --password=foo -q --allowold --record_log_pos backup.log_pos db1 db2 backup $TMPDIR where the database that the log_pos is recorded in is also in the list of databases to backup. Fix: Fix documentation so it doesn't say The name of the log-pos table should be supplied in database.table format. but ... supplied in \`database\`.\`table\` format. Or better, add this fix (sorry about my Perl - I know it is bad): --- mysqlhotcopy.orig Wed Jan 29 14:00:00 2003 +++ mysqlhotcopyWed Jan 29 14:00:14 2003 @@ -113,6 +113,14 @@ dryrun|n, ) or usage(Invalid option); +# Make sure that $opt{record_log_pos} is of form `db`.`table` +if (defined($opt{record_log_pos})) +{ +$opt{record_log_pos} =~ tr/\`//d; +$opt{record_log_pos} =~ s/\./\`\.\`/; +$opt{record_log_pos} = \`$opt{record_log_pos}\`; +} + # @db_desc # == # a list of hash-refs containing: The same should probably be done for $opt{checkpoint}. Submitter-Id:[EMAIL PROTECTED] Originator: Soeren Thing Andersen Organization: TDC MySQL support: none Synopsis:Backticks not added to $opt{record_log_pos} Severity:non-critical Priority:medium Category:mysql Class: sw-bug Release: mysql-3.23.55 (Official MySQL RPM) Environment: System: Linux alarmnetgw2.vpn.alarm-net.dk 2.4.9-31 #1 Tue Feb 26 07:11:02 EST 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-85) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Oct 10 14:51 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 1285884 Sep 9 18:10 /lib/libc-2.2.4.so -rw-r--r--1 root root 27336078 Sep 9 17:48 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 9 17:48 /usr/lib/libc.so Configure command: ./configure '--disable-shared' '--with-mysqld-ldflags=-all-static' '--with-client-ldflags=-all-static' '--without-berkeley-db' '--without-innodb' '--enable-assembler' '--enable-local-infile' '--with-mysqld-user=mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--prefix=/' '--with-extra-charsets=complex' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info' '--includedir=/usr/include' '--mandir=/usr/share/man' '--with-comment=Official MySQL RPM' 'CC=gcc' 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' 'CXX=gcc' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: restart or not?
Jon: Reload the permissions tables. It looks like your permissions for Joseph are on the money ... are other people able to access the database remotely? Gerald Jensen - Original Message - From: Jon Miller [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Tuesday, January 28, 2003 5:05 PM Subject: restart or not? When granting someone permissions are these permissions dynamic or do I have to reload mysql? Also we have a developer who stated he cannot access the database remotely. I've granted him privileges as follows since he works on the entire system both locally and remotely. There is only one database in the system. I've set a password for access to the system also. grant all privileges on *.* to joseph@% identified by 'his_password' with grant option; grant all privileges on *.* to joseph@localhost identified by 'his_password' with grant option; GRANT RELOAD,PROCESS ON *.* TO joseph@localhost; GRANT USAGE ON *.* TO joseph@localhost; -- Jon Miller [EMAIL PROTECTED] MMT Networks Pty Ltd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 dump for remote db
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mark -- ...and then Mark Stringham said... % % Does anyone have a suggestion as to how I could run a periodic mysql dump % for a db that is hosted remotely - IE a web host. I do know that this host % does not support crons. Do you want it dumped on that machine or across to another machine? Is there a web server on that machine? You've gotten a number of answers that will dump the database across the network. If you want it locally and have a web server, write a little php or perl script which will do the dump and then hit that page from any other machine that has cron or task scheduler or whatnot. Meanwhile, start shopping around for other hosts that let you use cron :-) % % Any help is appreciated. % % thanks HTH HAND % % MS mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+N+AyGb7uCXufRwARAuwUAKC2pD4LcRul/lsr/apSeMDw3Q/NSwCffDoy 7gpmgG0uOrRu5CRM8NnKSfM= =nxjf -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
examples of user defined functions
I was reading about user defined functions, and although they sound interesting, I can't find many examples of their use. If anyone is using them, what are you using them for? Are they a way to manipulate data going into a record, or a way to run pre-defined queries? -bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqld got signal 11; This could be because you hit a bug ....
On Tue, 28 Jan 2003 17:12:14 -0700 Mariella Di Giacomo [EMAIL PROTECTED] wrote: Hello, I am running mysql server (mysql-standard-4.0.5-beta-64bit) 64 bit on Sun Solaris 2.8 and I have got the binaries form the mysql web site. The machine I am using has 32GB of RAM + 64GB of swap. Thanks in advance for your help, Mariella Hi! The reason why MySQL is crashing is not due to the fact that your memory is exhausted. It is possible that you have shell limits that are far below the available memory, but in your case even that is not a problem. What you should do is get a 4.0.10 debug binary for Solaris 2.8 from our site and send us a core file that is created on the crash. Also add --core-file to startup options. -- Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.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: Weird locking/blocking issues
I have built mysql (4.0.9) on freebsd (4.7-RELEASE) with linuxthreads (2.2.3) and still encounter the 'strange threading' behavior described in J. Zawodny's blog. Here's the situation... 1/ there are three threads which lock and then write to two different tables... At the same time? Each thread locks both tables and then writes? Or something else? Can you post the exact SQL and sequence of events to see if someone else can reproduce or explain it? Your first thought is right...each thread locks both tables and writes. These threads are three instances of the same procedure: each thread does a 'lock tables table_a low_priority write, table_b low_priority write'; hence two waiting for the thread that presently has the locks. I've tried with two threads and four threads as well and I get the same result. the locks are gotten using 'low_priority write'; the writing threads are continually waiting for locks (i.e two are waiting, one is executing); Hmm. What if you don't use low-priority write? Does it work normally then? I tried with low_priority and without low_priority--no difference. 2/ On a different thread I do a select count(*) from one of the tables; Sometimes the select returns pretty quick witht the count; however, frequently the selecting thread will simply hang waiting to get the lock--if I look at the thread in [top] the thread will be taking a LOT of cpu time; if I look at the offending thread in the processlist it has a cycling status of 'waiting for tables', 'NULL', 'Locked', 'System Lock' and 'Reopen Tables'. Any chance you can truss the pid of the process that's sucking CPU time? We manged to find an old thread-related bug on FreeBSD/MySQL that way a year or so back. Actually I can kill off the process from within Mysql--it's not really frozen, it simply is thrashing through the aforementioned status over and over without ever getting its lock. I have observed this behavior with Mysql and Linuxthreads, as well as with native threads on FreeBSD--haven't tried on Linux. FWIW, I tried doing the count(*) on 'table_a' both as a single sql statement, and bracketed by lock tables/unlock tables. Also FWIW, one of the tables that is being locked has a blob column in it. Regards, Peter ^_^ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 creating fulltext index
Hi! -Original Message- From: Erlend Hopsø Strømsvik [mailto:[EMAIL PROTECTED]] -Original Message- From: Salada, Duncan [mailto:[EMAIL PROTECTED]] Hello everyone, I'm running Ver 8.39 Distrib 4.0.9-gamma, for intel-linux on i686. I'm trying to create a fulltext index on an existing myisam table and running up against an error. From what I can tell, I'm using the alter table command correctly, but I keep getting errno 140. Can anyone point out my error? mysql alter table materials add fulltext title (title,variant_title,ss_title,term_1,term_2,term_3,term_4, term_5,abstract,notes,personal_name_1,personal_name_2,personal _name_3,person al_name_4, personal_name_5,personal_name_6); ERROR 1005: Can't create table './lincs/#sql-6d12_7.frm' (errno: 140) Have you tried using create index? From the documentation (http://www.mysql.com/doc/en/CREATE_INDEX.html): CREATE [UNIQUE|FULLTEXT] INDEX index_name ON tbl_name (col_name[(length)],... ) So it would become CREATE FULLTEXT INDEX title_idx ON materials (title,variant_title,ss_title,term_1,term_2,term_3,term_4,term_5,abstract,no tes,personal_name_1,personal_name_2,personal_name_3,person_al_name_4, personal_name_5,personal_name_); Yes, I tried using CREATE INDEX, and I received exactly the same error. I probably should have mentioned that in my original email. I also failed to mention that I am trying to upgrade from 3.23.54. I still have 3.23.54 running on the same machine with 4.0.9 running on a different port and socket. Both installations were built from source as well. I copied var from the 3.23.54 install to the 4.0.9 install. Changed directory owners and groups and ran mysql_fix_privilege_tables as stated in the manual. I also ran REPAIR TABLE materials USE_FRM because the table already has another fulltext index (created in 3.23.x) yielding... mysql REPAIR TABLE materials USE_FRM; +-++--+- --+ | Table | Op | Msg_type | Msg_text | +-++--+- --+ | lincs.materials | repair | warning | Number of rows changed from 0 to 8700 | | lincs.materials | repair | status | OK | +-++--+- --+ 2 rows in set (2 min 16.23 sec) I tried to create my new fulltext index (for those just joining us see orginal message) and got error 140. I also tried dropping the other old fulltext indexes and then creating the new index with the same result. Perhaps I'm missing something with the changeover to 4.0.9? Any help would be greatly appreciated. Thanks, Duncan Salada - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
linux novice cannot resolve apache-php-mysql linkage.
dell 4100 256mb, 11gb hd, Redhat grub-linux linux novice cannot resolve apache-php-mysql linkage. local closed system (No modem, no www access, no internet) I have tried to create a database of 7 tables with about 840mb of data since the 20th of November 2002. My own db handler (.cpp's) will take years to code and test what the apache-php-mysql combo can do in hours. I've been able to load all mysql tables with about 30kb each of data as a test. I've made php test scripts and run them with apache server (local). I have n-o-t been able to run apache-php-mysql as a single application. About the 22nd of January, 2003, I started over with: file:/usr/local/src/httpd-2.0.44.tar.gz file:/usr/local/mysql-3.23.55.tar.gz file:/usr/local/php-4.3.0.tar.gz Using root, I entered the following commands: for apache: cd /usr/local/src tar -xzvf httpd-2.0.44.tar.gz cd httpd-2.0.44 ./configure --prefix=/usr/local/apache --enable-module=so make make install for mysql: groupadd mysql useradd -g mysql mysql cd /usr/local gunzip mysql-3.23.55.tar.gz | tar -xvf - ./configure --prefix=/usr/local/mysql make make install /scripts/mysql_install_db chown -R root /usr/local/mysql chown -R mysql /usr/local/mysql/var chgrp -R mysql /usr/local/mysql cp support-files/my-medium.cnf /etc/my.cnf /usr/local/mysql/bin/safe_mysqld --user=mysql mysql quit; for php: cd /usr/local/ tar -xzvf php-4.3.0.tar.gz cd php-4.3.0 ./configure --with-php=/usr/local/php --with-apxs2=/usr/local/apache/bin/apx s make make install then changed file:/usr/local/apache/conf/httpd.conf ServerAdmin root@localhost ServerName root@localhost:80 then added to file:/usr/local/apache/conf/httpd.conf LoadModule php4_module modules/libphp4.so AddType application/x-httpd-php .php AddType application/x-httpd-php-source .phps then /usr/local/apache/bin/apachectl stop /usr/local/apache/bin/apachectl start and file:/var/www/test1.php could not be found using the browser. note that /var/www/test1.php is the only ?/www/? directory found. changed ServerName root@localhost:80 to 127.0.0.1:80 then /usr/local/apache/bin/apachectl stop /usr/local/apache/bin/apachectl start and file:/var/www/test1.php could not be found using the browser. any help or documentation pointers would be very much appreciated. I've installed RH at least 20 times, and will continue to install until I can run my personal scripts to test that apache-php-mysql are doing what I want. Any suggestion that I should (re)install should include the specific platform to be selected. Thanks dander cut and paste of my version of test1.php html head titlePHP Test/title /head body ?php echo Hello Worldp;? /body /html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Increment in update
Could you help me with this. I`m trying to increment values of primary auto_increment field from table, and ofcourse it is not working. Could you tell me how to construct a query correctly. +---+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-++ | id | int(11) | | PRI | NULL| auto_increment | | descr | varchar(255) | YES| MUL | NULL| | +---+--+--+-+-++ mysql update tb_roubr set id=id+1 where id1 order by id; ERROR 1064: You have an error in your SQL syntax near 'order by id' at line 1 why this is not working and what are other ways to do such a query. - ðÏÌÕÞÉÔÅ ÂÅÓÐÌÁÔÎÙÊ ÐÏÞÔÏ×ÙÊ ÑÝÉË @ukr.net ÎÁ http://freemail.ukr.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
query cache
Hi! I've got one question which belongs to the new query cache in 4.01. I wonder why the cache should be deleted if there's a statement like update, insert etc. I think it must be considered that there are possible situations where this isn't the best way. For example: 1) select * from DATABASE where DATE = '2002-12-02' 2) update DATABASE set NAME = 'my name' where DATE = '2002-12-01' So 2) would kill the whole cache, but for 1) the update doesn't matter! Wouldn't it be better to look for what selects matters for the cache by updating something in the table??? I think that would improve much more performance. Regards, Reiner - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Writing a database program in GNU C++ using MySQL.
Dear my friends, My boss wants a database application running on linux machine without XWindows. Is it easy to make the connection to MySQL with GNU C++ . Is perl better then GNU C++ in this case? How is Jave ? TAC. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
rebuilt index
hi all, which is the command to rebuilt innodb tables indexes? (if exists). many thanks. (mysql,sql) __ Yahoo! Cellulari: loghi, suonerie, picture message per il tuo telefonino http://it.yahoo.com/mail_it/foot/?http://it.mobile.yahoo.com/index2002.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
datetime field question
is there a way to use the date part of a datetime field that still uses the index on the datetime field? i've tried a few different things and it keeps saying in the explain it says that its a possible_key, but NULL for the key -- mysql, sql, query, sql, sql, 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
Re: Help - Convert Date from longtext to MySQL date format
* Wong Zach-CHZ013 [...] In table a, the columns are my_date - longtext num - int(11) [...] Q: How do I convert 08/06/2002 to 2002-08-06 format LONGTEXT is not a good column type for dates, you should use the special 'date' type, see URL: http://www.mysql.com/doc/en/Column_types.html . To change the table a, adding a new date column: ALTER TABLE a ADD new_date date; Updating the new column with dates from the old: UPDATE a SET new_date = CAT( MID(my_date,7,4),'-', MID(my_date,1,2),'-', MID(my_date,4,2)); Finally, after checking the result, you may want to drop the old column and rename the new one, and you can use ALTER TABLE for this too: ALTER TABLE a DROP my_date; ALTER TABLE a CHANGE new_date my_date date; URL: http://www.mysql.com/doc/en/ALTER_TABLE.html URL: http://www.mysql.com/doc/en/UPDATE.html HTH, -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Get record with MAX() in one column
* heiko mundle we use this table mobile_pos +-+-+-+ | team_id | time| geometry| +-+-+-+ | 3 | 2003-01-28 16:17:06 | 727105 5282634 651 | | 5 | 2003-01-28 16:19:22 | 728220 5282453 944 | | 1 | 2003-01-28 17:08:24 | 728998 5283317 1423 | | 3 | 2003-01-28 18:47:16 | 727805 5288644 772 | | 5 | 2003-01-28 19:34:25 | 727228 5283755 815 | | 1 | 2003-01-29 11:08:24 | 728938 5283467 1467 | +-+-+-+ how do I get the geometry for every team with every newest time? IF I do something like that, I will get the newest record, but how can I get the geometry of the record? SELECT team_id, MAX(time) FROM SAFETOUR_mobile_pos GROUP BY team_id; Try the MAX-CONCAT trick, described in the manual: URL: http://www.mysql.com/doc/en/example-Maximum-column-group-row.html SELECT team_id, MAX(CONCAT(time,'|',geometry)) FROM SAFETOUR_mobile_pos GROUP BY team_id; -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 dies after FreeBSD 4.6.2-cvsup-4.7
Hi, We just cvsup'd a FreeBSD machine from 4.6.2 to 4.7, made world, and installed a new kernel. Now mysql is complaining : Fatal error 'Can't create gc thread' at line ? in file /usr/src/lib/libc_r/uthre ad/uthread_create.c (errno = ?) 030129 10:36:35 mysqld restarted Fatal error 'Can't create gc thread' at line ? in file /usr/src/lib/libc_r/uthre ad/uthread_create.c (errno = ?) 030129 10:36:35 mysqld restarted Fatal error 'Can't create gc thread' at line ? in file /usr/src/lib/libc_r/uthre ad/uthread_create.c (errno = ?) Any ideas where to start? Tried to recompile mysql to see if it just needed that, and it didn't change anything. (This is 3.23.54a) Thanks, Tuc/TTSG Internet Services, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqld got signal 11; This could be because you hit a bug ....
Hi Mark, Thanks. The memory that we are using is ECC. The reason I have only 16 connections is because that DB is used only for updates. In reality for that DB we use 3 or 4 connections maximum. We have a mirror copy used for customers which has a lot of connections. Mariella At 10:22 AM 1/29/03 +0100, Mark wrote: - Original Message - From: Mariella Di Giacomo [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, January 29, 2003 1:12 AM Subject: mysqld got signal 11; This could be because you hit a bug Hello, I am running mysql server (mysql-standard-4.0.5-beta-64bit) 64 bit on Sun Solaris 2.8 and I have got the binaries form the mysql web site. The machine I am using has 32GB of RAM + 64GB of swap. Hi Mariella, My, that is a LOT of memory! :) What could you possibly have running that allows only 16 connections, yet uses up to the max of 96 GigaByte? :) Yikes! I take it this is high-quality ECC memory? If not, with that much memory, a seg fault could easily occur. I believe FreeBSD already advises to uses ECC memory when you have as little as 4 G. I'm sure you got that covered, though; just checking. :) - Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Endian problem in auto_increment variable?
Description: After fixing a table with myisamcheck on Linux, the auto_increment on Solaris was completely off (very large 9-digit integer instead of around 50,000). My suspicion is that this has to do with an endianness issue. (I had to use Linux since the Solaris version of myisamcheck just hangs.) How-To-Repeat: Check table containing AUTO_INCREMENT on Linux, then use Solaris. Fix: No fix know, except use SET INSERT_ID afterwards to fix. Submitter-Id: submitter ID Originator:Henning Schulzrinne Organization: Dept. of Computer Science, Columbia University MySQL support: [none | licence | email support | extended email support ] Synopsis: AUTO_INCREMENT wrong Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.54 (Official MySQL binary) Environment: System: SunOS signal.cs.columbia.edu 5.8 Generic_108528-17 sun4u sparc SUNW,UltraAX-i2 Architecture: sun4 Some paths: /usr/bin/perl /usr/local/gnu/bin/make /usr/local/gnu/bin/gmake /usr/local/gnu/bin/gcc /import/pkg/SUNWspro/bin//cc GCC: Reading specs from /usr/local/gnu/bin/../lib/gcc-lib/sparc-sun-solaris2.8/3.2.1/specs Configured with: /src/unpack/gnu/gcc-3.2.1/configure --prefix=/opt/CUCSgnu --with-gnu-as --with-as=/opt/CUCSgnu/bin/as --with-gnu-ld --with-ld=/opt/CUCSgnu/bin/ld --enable-languages=c,c++,f77,objc Thread model: posix gcc version 3.2.1 Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: -rw-r--r-- 1 root bin 1788196 Sep 21 00:52 /lib/libc.a lrwxrwxrwx 1 root root 11 Jan 29 03:49 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1157872 Sep 21 00:52 /lib/libc.so.1 -rw-r--r-- 1 root bin 1788196 Sep 21 00:52 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Jan 29 03:49 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1157872 Sep 21 00:52 /usr/lib/libc.so.1 Configure command: ./configure '--prefix=/usr/local/mysql' '--with-comment=Official MySQL binary' '--with-extra-charsets=complex' '--with-server-suffix=' '--enable-thread-safe-client' '--enable-local-infile' '--enable-assembler' '--with-named-z-libs=no' '--with-named-curses-libs=-lcurses' '--disable-shared' '--without-innodb' 'CC=gcc' 'CFLAGS=-O3 -fno-omit-frame-pointer' 'CXXFLAGS=-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' 'CXX=gcc' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Connector/J 3.0.5 GAMMA Has Been Released
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL Connector/J 3.0.5 a new version of the Type-IV all-Java JDBC driver for MySQL has been released. It is now available in source and binary form from the Connector/J download pages at http://www.mysql.com/downloads/api-jdbc-dev.html and mirror sites. Note that not all mirror sites may be up to date at this point of time - if you can't find this version on some mirror, please try again later or choose another download site. This is a bugfix release for the feature set that has been frozen for version 3.0 of Connector/J. This will most likely be the last GAMMA version of the 3.0 series, and 3.0.6 is expected to be declared STABLE. From the changelog: * Fixed Buffer.fastSkipLenString() causing ArrayIndexOutOfBounds exceptions with some queries when unpacking fields. * Implemented an empty TypeMap for Connection.getTypeMap() so that some third-party apps work with MySQL (IBM WebSphere 5.0 Connection pool). * Added missing LONGTEXT type to DBMD.getColumns(). * Retrieve TX_ISOLATION from database for Connection.getTransactionIsolation() when the MySQL version supports it, instead of an instance variable. * Quote table names in DatabaseMetaData.getColumns(), getPrimaryKeys(), getIndexInfo(), getBestRowIdentifier() * Greatly reduce memory required for setBinaryStream() in PreparedStatements. * Fixed ResultSet.isBeforeFirst() for empty result sets. * Added update options for foreign key metadata. * - Fixed Connection.getTransactionIsolation() not picking up isolation levels for servers older than 4.0.x. * Backport 4.1 protocol and authentication changes from Connector/J 3.1.x -Mark - -- MySQL 2003 Users Conference - http://www.mysql.com/events/uc2003/ For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.1.90 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+OAm9tvXNTca6JD8RAlUSAKCZXviyE00ZcLhytizzeKw0wWz6/gCglbgT x+SN4VZyRE4YP8m3R9IDCrI= =baH0 -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqldump, exclude table?
is they a way to have mysqldump ignore a list of tables, but get everything else? something like: mysqldump -ume -psecret -hserver --all-databases --exclude-tables=server.acctlog mysql 3.23.49-8.2 debian -- mysql, sql, query, sql, sql, 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
Re: Configure prob with FreeBSD/Linuxthreads
Try this, this is what I used (I didn't need things like innodb, but needed static linkings): king as jdisher# more foo CFLAGS=-O3 -pipe -mcpu=pentiumpro -D__USE_UNIX98 -D_REENTRANT -D_THREAD_SAFE -DHAVE_BROKEN_REALPATH -I/usr/local/include/pthread/li nuxthreads CXXFLAGS=-O3 -pipe -mcpu=pentiumpro -D__USE_UNIX98 [..-] -O3 on a production server? Mmmm... not good. gcc 2.95 is sometimes buggy, I suggest to use -O alone. Static linking is ok, it really increased performace of 15% on my FreeBSD servers. FYI, that successfully built 3.23.54 -AND- 4.0.9 with linuxthreads on FreeBSD 5-RELEASE. I'm still testing, however, as I'm not overly impressed with the performance increase (MySQL 3.23.54 on a single Athlon MP2200+ performs a job of ours faster than a dual Athlon MP2200+ (same hardware, SMP vs NonSMP kernel)). I dunno. I don't see any reason to use LinuxThreads. What kind of advantages they have? I neved had performance problems on heavy-used databases (7 mil records, 50 tps) on FreeBSD 4.6. Gianluca Sordiglioni DB Manager Vox2Web Srl - Italy tel. +390245054533 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: restart or not?
have you looked at the mysql command flush privileges - hcir On Tuesday, January 28, 2003, at 02:05 PM, Jon Miller wrote: When granting someone permissions are these permissions dynamic or do I have to reload mysql? Also we have a developer who stated he cannot access the database remotely. I've granted him privileges as follows since he works on the entire system both locally and remotely. There is only one database in the system. I've set a password for access to the system also. grant all privileges on *.* to joseph@% identified by 'his_password' with grant option; grant all privileges on *.* to joseph@localhost identified by 'his_password' with grant option; GRANT RELOAD,PROCESS ON *.* TO joseph@localhost; GRANT USAGE ON *.* TO joseph@localhost; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Cardinality doesn't auto start
You need to run [analyze table] to create the index stats...do this reasonable often (once a day for a well-used table). Running [optimize table] on the table recreates index stats AND reorganizes/defrags/coalesces data pages...do this once a week or so. Look up the mysqlcheck utility--it lets you do this from scrips pretty easy. Peter ^_^ -Original Message- From: John Hinton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 7:36 AM To: [EMAIL PROTECTED] Subject: Cardinality doesn't auto start mysql Ver 11.18 Distrib 3.23.54, for pc-linux (i686) INDEXING PROBLEM I'm building an application which will have a self install script, intended for use by many people. One particular area of the program requires the need for an index. If I create this index when I build the table or apparently even after the table is built but before any data is written to the table, cardinality is shown as 'None' (using phpMyAdmin) and futhermore it does not start counting until after data is entered and the index is recreated. Seems like when the index is created, if no data is in the table, it should be given a default cardinality of 0 and the count continue as data is entered. This need to create/recreate the index after data is written, is tough to deal with as a programmer having to ask the end user to create this index after data is gathered. Any ideas besides creating an index creater script for the user to run later? Would this be considered a bug? SQL to create table with index CREATE TABLE somename ( ndx int(10) NOT NULL auto_increment, d_now int(7) default NULL, adate timestamp(14) NOT NULL, PRIMARY KEY (ndx), UNIQUE KEY id (ndx), KEY d_now (d_now) ) TYPE=MyISAM; end SQL --- I have also tried it with d_now set to NOT NULL with the same results. The index just won't start counting with no data entered. -- John Hinton - Goshen, VA. http://www.ew3d.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: InnoDB / MyISAM
-- Joe Stump [EMAIL PROTECTED] http://www.joestump.net Label makers are proof God wants Sys Admins to be happy. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 11:29 AM To: Joe Stump Subject: Re: InnoDB / MyISAM Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query,queries,smallint If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: I've been looking into switching to InnoDB. I have a few questions though. 1.) Can I do joins between InnoDB / MyISAM tables? 2.) Do FK restraints work if the FK referenced is in a MyISAM table? I'm trying to get the best of both worlds. I'd have a data table with FULLTEXT and then have join tables, etc. InnoDB so I can have transactions and FK restraints. I've looked through the archives and couldn't find any answers to these questions. BTW, I'm using 4.0-gamma right now. --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net Label makers are proof God wants Sys Admins to be happy. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Recovery in MySql
Hello Inbal, Wednesday, January 29, 2003, 4:13:24 PM, you wrote: IO Hi All, IO I have MySql on Windows. IO Today i had an electrical power interruption in the middle of working. IO The database remain not consistent and i could not continue working with it. IO Is there any Recovery after crash mechanism in mySql? IO Thanks, Inbal http://www.mysql.com/doc/en/Disaster_Prevention.html -- Best regards, Andreymailto:[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
Re: mysql php and blank variables...
ok will try that too... - Original Message - From: Sherzod Ruzmetov [EMAIL PROTECTED] To: Sunfire [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, January 29, 2003 7:07 AM Subject: RE: mysql php and blank variables... :when i type :mysql_query(insert into table_name ('$var list'...); i come :up with a bunch :of :blank/empty variables... Try to debug your query by outputting to the stdout instead of sending to the mysql server. You can do it by simply echo()ing your query as it is to the browser or terminal. I'm sure you'll see it doesn't look like what you really had in mind. This debugging trick may also make this question a non-mysql related ;-). Good luck Sherzod - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.443 / Virus Database: 248 - Release Date: 1/10/2003 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Recovery in MySql
On 1/29/03 5:13 AM, Inbal Ovadia [EMAIL PROTECTED] wrote: Hi All, I have MySql on Windows. Today i had an electrical power interruption in the middle of working. The database remain not consistent and i could not continue working with it. Is there any Recovery after crash mechanism in mySql? Thanks, Inbal If you tables are of type MYISAM (find out with SHOW CREATE TABLE table) then most of the answers are here (myisamchk): http://www.mysql.com/doc/en/Table_maintenance.html Hth/h - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
OK... stuck on can't connect from client
It´s happen exactly the same with me. Do you have some suggestion to solve this? I'm on Linux Redhat 7.2 and MySQL v. 3.23.41 I can make connections from the server... including the use of other hostnames for test purposes. All my PHP/MySQL sites are up and running. I can access the database through phpMyAdmin. I cannot connect from a client app such as Mascon. I notice that each time I try I get the following added to my logfile. Number of processes running now: 1 mysqld process hanging, pid 8617 - killed 021013 20:08:43 mysqld restarted /usr/libexec/mysqld: ready for connections Number of processes running now: 1 mysqld process hanging, pid 9796 - killed 021013 20:10:02 mysqld restarted /usr/libexec/mysqld: ready for connections Number of processes running now: 1 mysqld process hanging, pid 9858 - killed 021013 20:25:23 mysqld restarted /usr/libexec/mysqld: ready for connections I've included the last three instances. I've been fighting with this now for the last three days!!! Please help. All 'was' working fine for a year or more, up until the point of a machine reboot. -- John Hinton - Goshen, VA. http://www.ew3d.com Those who dance are considered insane by those who can't hear the music - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 dump for remote db
Well it looks like I have limited options. I'm guessing that the web host will let me have limited rights to the server as it is - probably only basic FTP and other limited DB rights - I do hve some control using phpmyadmin to manipulate data. I'll almost bet that they won't let me run a task from the server. What about running a script from an exe ? thanks MS -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mark -- ...and then Mark Stringham said... % % Does anyone have a suggestion as to how I could run a periodic mysql dump % for a db that is hosted remotely - IE a web host. I do know that this host % does not support crons. Do you want it dumped on that machine or across to another machine? Is there a web server on that machine? You've gotten a number of answers that will dump the database across the network. If you want it locally and have a web server, write a little php or perl script which will do the dump and then hit that page from any other machine that has cron or task scheduler or whatnot. Meanwhile, start shopping around for other hosts that let you use cron :-) % % Any help is appreciated. % % thanks HTH HAND % % MS mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+N+AyGb7uCXufRwARAuwUAKC2pD4LcRul/lsr/apSeMDw3Q/NSwCffDoy 7gpmgG0uOrRu5CRM8NnKSfM= =nxjf -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.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 Mark Stringham edea solutions 801.808.8791 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 dump for remote db
Well it looks like I have limited options. I'm guessing that the web host will let me have limited rights to the server as it is - probably only basic FTP and other limited DB rights - I do hve some control using phpmyadmin to manipulate data. I'll almost bet that they won't let me run a task from the server. What about running a script from an exe ? thanks MS -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mark -- ...and then Mark Stringham said... % % Does anyone have a suggestion as to how I could run a periodic mysql dump % for a db that is hosted remotely - IE a web host. I do know that this host % does not support crons. Do you want it dumped on that machine or across to another machine? Is there a web server on that machine? You've gotten a number of answers that will dump the database across the network. If you want it locally and have a web server, write a little php or perl script which will do the dump and then hit that page from any other machine that has cron or task scheduler or whatnot. Meanwhile, start shopping around for other hosts that let you use cron :-) % % Any help is appreciated. % % thanks HTH HAND % % MS mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+N+AyGb7uCXufRwARAuwUAKC2pD4LcRul/lsr/apSeMDw3Q/NSwCffDoy 7gpmgG0uOrRu5CRM8NnKSfM= =nxjf -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.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 Mark Stringham edea solutions 801.808.8791 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help - Convert Date from longtext to MySQL date format
this command should get your data moved to a new sql table insert into table2 select (concat(mid(my_date,7,4),'-',mid(my_date,1,2),'-',mid(my_date,4,2))) from table1; - hcir On Tuesday, January 28, 2003, at 01:45 PM, Wong Zach-CHZ013 wrote: Hi I have a few tables in a database Z, namely table a b c In table a, the columns are my_date - longtext num - int(11) eg: mysql select * from a; +--+--+--+ | my_date | x| +--+--+ | 08/06/2002 |1 | | 08/07/2002 |2 | +--+--+--+ 2 rows in set (0.00 sec) Tables b and c have the same table structure and data type format. Q: How do I convert 08/06/2002 to 2002-08-06 format without having to reinput all my data from scratch ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 dump for remote db
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mark -- ...and then Mark Stringham said... % % Well it looks like I have limited options. Yep. Hey, you could always host with me ;-) % % I'm guessing that the web host will let me have limited rights to the % server as it is - probably only basic FTP and other limited DB rights - % I do hve some control using phpmyadmin to manipulate data. OK. If I were you I'd just try a quick test. Whip up a php page that says ?php exec(du -h -d 1,$results,$exit) or die(Could not run du\n) ; print space is:br\npre\n ; print_r($results) ; print /prebr\n ; print exit code was '$exit'br\n ; ? and see what you get. If it works, whip up another about like ?php $stamp = date(Y-m-d) ; exec(mysqldump -uUSER -pPASS DATABASE,$results,$exit) or die(Could not run mysqldump\n) ; print results are:br\npre\n . print_r($results) . /prebr\n ; print exit code was '$exit'br\n ; ? with USER, PASS, and DATABASE set accordingly (and you should check the mysqldump grammar; this is all right off the top of my head) and if it doesn't try any of system, `` or popen. % % I'll almost bet that they won't let me run a task from the server. % What about running a script from an exe ? What script, what exe, and what machine? % % thanks Sure thing! % % MS mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+OEx9Gb7uCXufRwARAod+AKDaV3f6KSh2eT7zuvIy3gn/osAV6QCgv160 rlm+atsvuT22qIj4fZEKId4= =0Umb -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[patch] for 4.0.9 Makefile (my_inet_ntoa reference)
Description: While building 4.0.9: gcc -O3 -DDBUG_OFF -rdynamic -o test-ssl test-ssl.o -lstdc++ ../dbug/libdbug.a ../mysys/libmysys.a ../strings/libmystrings.a libvio.a -L/usr/lib -lssl -lcrypto -lz -lcrypt -lnsl -lm -lpthread libvio.a(viosocket.o)(.text+0x2b6): In function `vio_peer_addr': : undefined reference to `my_inet_ntoa' collect2: ld returned 1 exit status How-To-Repeat: build it Fix: The order of the libraries must change to: libvio.a ../mysys/libmysys.a ../strings/libmystrings.a Submitter-Id: submitter ID Originator:Christian Hammers Organization: Debian Project MySQL support: none Synopsis: Makefile problem in 4.0.9 (my_inet_ntoa reference) Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.55 (Source distribution) Environment: System: Linux app109 2.4.20-app109-3 #3 Sat Jan 25 14:55:31 CET 2003 i686 unknown unknown GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/3.2.2/specs Configured with: ../src/configure -v --enable-languages=c,c++,java,f77,proto,pascal,objc,ada --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --with-gxx-include-dir=/usr/include/c++/3.2 --enable-shared --with-system-zlib --enable-nls --without-included-gettext --enable-__cxa_atexit --enable-clocale=gnu --enable-java-gc=boehm --enable-objc-gc i386-linux Thread model: posix gcc version 3.2.2 20030124 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 2003-01-23 13:49 /lib/libc.so.6 - libc-2.3.1.so -rwxr-xr-x1 root root 1102984 2003-01-21 23:15 /lib/libc-2.3.1.so -rw-r--r--1 root root 2337952 2003-01-21 23:15 /usr/lib/libc.a -rw-r--r--1 root root 178 2003-01-21 23:15 /usr/lib/libc.so -rw-r--r--1 root root 716080 2002-01-13 21:06 /usr/lib/libc-client.so.2001 Configure command: ./configure --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler --with-berkeley-db --with-innodb --enable-static --enable-shared --enable-local-infile --with-raid --enable-thread-safe-client --without-readline --with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql --without-bench --without-docs --with-client-ldflags=-lstdc++ --with-extra-charsets=all - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 creating fulltext index
Hi! I'm running Ver 8.39 Distrib 4.0.9-gamma, for intel-linux on i686. I'm trying to create a fulltext index on an existing myisam table and running up against an error. From what I can tell, I'm using the alter table command correctly, but I keep getting errno 140. Can anyone point out my error? mysql alter table materials add fulltext title (title,variant_title,ss_title,term_1,term_2,term_3,term_4, term_5,abstract,notes,personal_name_1,personal_name_2, personal_name_3,personal_name_4, personal_name_5,personal_name_6); ERROR 1005: Can't create table './lincs/#sql-6d12_7.frm' (errno: 140) Too many columns. No more than 14 is allowed in FULLTEXT index in MySQL before 4.1, because MySQL adds two columns internally to each FULLTEXT index. In 4.1 it was fixed, but the way it was fixed cannot be backported to 4.0 :( Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 issue
We're having difficulties compiling MySQL on a RedHat 6.2 machine and then installing on a RedHat 7.2 machine. This has worked in the past. The reason for doing this is to avoid the gcc 2.96 compilation problems indicated on the mysql.com download page. The symptoms are that the 'make install' process attempts to recompile the binaries on the RedHat 7.2 system. We think it may be related to the information stored in the .deps directories or a result of the most recent RedHat 7.2 glibc update. Version Info: Problems known to occur with mysql-3.23.54, mysql-3.23.54a, and mysql-3.23.55. Previous versions have not been re-tried since the problems appeared. RedHat 6.2 gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) glibc-2.1.3-24 RedHat 7.2 gcc version 2.96 2731 (Red Hat Linux 7.2 2.96-108.7.2) glibc-2.2.4-31 ./configure --prefix=/usr/local/mysql --with-mysqld-user=mysql --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static --with-berkeley-db=/usr/local/BerkeleyDB.3.2 --with-innodb Any thoughts? Thanks, Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Date Range
Hi all, I am trying to get my mysql database to be searchable by date, by both current and past events. My perl program doesn't compile--- here's an excerpt-- package Date::Range; my $range = Date::Range - new ($date1, $date2); error message: -- can't locate object method new via package Date::Range Thanks for your help. Melissa Stranzl __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problems creating fulltext index
In the last episode (Jan 28), Salada, Duncan said: I'm running Ver 8.39 Distrib 4.0.9-gamma, for intel-linux on i686. I'm trying to create a fulltext index on an existing myisam table and running up against an error. From what I can tell, I'm using the alter table command correctly, but I keep getting errno 140. Can anyone point out my error? mysql alter table materials add fulltext title (title,variant_title, ss_title,term_1,term_2,term_3,term_4,term_5,abstract,notes, personal_name_1,personal_name_2,personal_name_3,personal_name_4, personal_name_5,personal_name_6); ERROR 1005: Can't create table './lincs/#sql-6d12_7.frm' (errno: 140) # perror 140 Error code 140: Unknown error 140 140 = Wrong create options The myisam handler will return a 140 error in a couple cases: if you have more than 16 fields in a key or more than 32 keys on a table, if any of your indexed fields are not text or varchar, or another test that I can't quite figure out, but I don't think it applies here. From looking at the code, fulltext indexes have two invisible fields that count against your 16-field limit. Your index has 16 fields, so that's probably what the problem is. What happens if you try building an index with only 14 fields? -- 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
linux novice cannot resolve apache-php-mysql linkage 2.
dell 4100 256mb, 11gb hd, Redhat 8.0 grub-linux linux novice cannot resolve apache-php-mysql linkage. local closed system (No modem, no www access, no internet) I have tried to create a database of 7 tables with about 840mb of data since the 20th of November 2002. My own db handler (.cpp's) will take years to code and test what the apache-php-mysql combo can do in hours. I've been able to load all mysql tables with about 30kb each of data as a test. I've made php test scripts and run them with apache server (local). I have n-o-t been able to run apache-php-mysql as a single application. About the 22nd of January, 2003, I started over with: file:/usr/local/src/httpd-2.0.44.tar.gz file:/usr/local/mysql-3.23.55.tar.gz file:/usr/local/php-4.3.0.tar.gz Using root, I entered the following commands: for apache: cd /usr/local/src tar -xzvf httpd-2.0.44.tar.gz cd httpd-2.0.44 ./configure --prefix=/usr/local/apache --enable-module=so make make install for mysql: groupadd mysql useradd -g mysql mysql cd /usr/local gunzip mysql-3.23.55.tar.gz | tar -xvf - ./configure --prefix=/usr/local/mysql make make install /scripts/mysql_install_db chown -R root /usr/local/mysql chown -R mysql /usr/local/mysql/var chgrp -R mysql /usr/local/mysql cp support-files/my-medium.cnf /etc/my.cnf /usr/local/mysql/bin/safe_mysqld --user=mysql mysql quit; for php: cd /usr/local/ tar -xzvf php-4.3.0.tar.gz cd php-4.3.0 ./configure --with-php=/usr/local/php --with-apxs2=/usr/local/apache/bin/apx s make make install then changed file:/usr/local/apache/conf/httpd.conf ServerAdmin root@localhost ServerName root@localhost:80 then added to file:/usr/local/apache/conf/httpd.conf LoadModule php4_module modules/libphp4.so AddType application/x-httpd-php .php AddType application/x-httpd-php-source .phps then /usr/local/apache/bin/apachectl stop /usr/local/apache/bin/apachectl start and file:/var/www/test1.php could not be found using the browser. note that /var/www/test1.php is the only ?/www/? directory found. changed ServerName root@localhost:80 to 127.0.0.1:80 then /usr/local/apache/bin/apachectl stop /usr/local/apache/bin/apachectl start and file:/var/www/test1.php could not be found using the browser. any help or documentation pointers would be very much appreciated. I've installed RH at least 20 times, and will continue to install until I can run my personal scripts to test that apache-php-mysql are doing what I want. Any suggestion that I should (re)install should include the specific platform to be selected. Thanks dander cut and paste of my version of test1.php html head titlePHP Test/title /head body ?php echo Hello Worldp;? /body /html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Increment in update
In the last episode (Jan 29), Igor Kutsyy said: Could you help me with this. I`m trying to increment values of primary auto_increment field from table, and ofcourse it is not working. Could you tell me how to construct a query correctly. +---+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-++ | id | int(11) | | PRI | NULL| auto_increment | | descr | varchar(255) | YES| MUL | NULL| | +---+--+--+-+-++ mysql update tb_roubr set id=id+1 where id1 order by id; UPDATE statements return no records, so ORDER BY is meaningless. You can't control the order the records are modified. If your problem is that id is a primary key and it won't let you temporarily have duplicate id's, just drop the index, do your update, and recreate it. If you can't drop the index, you can sort of cheat by creating another unindexed column id1, then do three separate updates: SET id1=id, SET id=NULL, then finally SET id=id1. You might be able to do the first two at the same time with SET id1=id, id=NULL, but test it on a scratch table first :) -- 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