Re: users and db visibility
on 8/4/02 3:13 AM, Hussein Morsy, typed: how can i make MySQL show only what db are available to the user? i.e., when a user logs in from a terminal application and types: 'show databases;' mysqld --safe-show-database or in my.cnf: safe-show-database With this option, the SHOW DATABASES command returns only those databases for which the user has some kind of privilege. In 4.0.2 this option is default enabled. thanks. i just searched: http://www.mysql.com/doc/en/index.html for my.cnf and got no returns. i searched my system for it and couldn't find it. can you tell me something about it, like maybe where it could be? i'm using MySQL 3.23.51.thanks in advance, Lloyd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: users and db visibility
how can i make MySQL show only what db are available to the user? i.e., when a user logs in from a terminal application and types: 'show databases;' mysqld --safe-show-database or in my.cnf: safe-show-database With this option, the SHOW DATABASES command returns only those databases for which the user has some kind of privilege. In 4.0.2 this option is default enabled. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SIGPROF problem in FreeBSD 4.6 (REPOST)
I thought I got this through the list, but it doesn't show up in the search, and I didn't get any responses... -- Forwarded message -- Date: Wed, 31 Jul 2002 23:14:13 -0400 (EDT) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: SIGPROF problem in FreeBSD 4.6 This almost belongs on the bugs list, but I don't have a stable, sure way to trigger it. Symptoms: mysqld locks itself in a tight loop, consuming all available CPU cycles. a simple kill sometimes kills the daemon, other times a -9 is required. While in this state, any access to the daemon stops - mysql queries simply hang. ktrace -p pid -t+ shows this repeating endlessly: 44113 mysqld PSIG SIGPROF caught handler=0x812d58c mask=0x0 code=0x0 44113 mysqld CALL gettimeofday(0x81c634c,0) 44113 mysqld RET gettimeofday 0 44113 mysqld CALL sigprocmask(0x3,0x81c63d8,0) 44113 mysqld RET sigprocmask 0 44113 mysqld CALL sigaltstack(0x8203ca0,0) 44113 mysqld RET sigaltstack 0 44113 mysqld CALL poll(0x821c000,0x2,0) 44113 mysqld RET poll 0 44113 mysqld CALL sigreturn(0x24473064) 44113 mysqld RET sigreturn JUSTRETURN 44113 mysqld PSIG SIGPROF caught handler=0x812d58c mask=0x0 code=0x0 44113 mysqld CALL gettimeofday(0x81c634c,0) 44113 mysqld RET gettimeofday 0 44113 mysqld CALL sigprocmask(0x3,0x81c63d8,0) 44113 mysqld RET sigprocmask 0 44113 mysqld CALL sigaltstack(0x8203ca0,0) 44113 mysqld RET sigaltstack 0 44113 mysqld CALL poll(0x821c000,0x2,0) 44113 mysqld RET poll 0 44113 mysqld CALL sigreturn(0x24473064) 44113 mysqld RET sigreturn JUSTRETURN 44113 mysqld PSIG SIGPROF caught handler=0x812d58c mask=0x0 code=0x0 44113 mysqld CALL gettimeofday(0x81c634c,0) 44113 mysqld RET gettimeofday 0 44113 mysqld CALL sigprocmask(0x3,0x81c63d8,0) 44113 mysqld RET sigprocmask 0 44113 mysqld CALL sigaltstack(0x8203ca0,0) 44113 mysqld RET sigaltstack 0 44113 mysqld CALL poll(0x821c000,0x2,0) 44113 mysqld RET poll 0 It's happening fairly often now. It's not load related - nothing besides a simple data loading program is running when it enters this loop. It's not seemingly data related: I've run myisamchk --safe-recover on the entire database and had the problem an hour later. I've started loading the data over and had the problem not recur. It's not strictly version related: I've had the same problem with 3.23.51, 4.0.1-alpha, and 4.0.2-alpha. The program that causes it is a simple perl script that reads input data, splits it into fields, validates the data, and uses a REPLACE statement with DBD to update/insert the table. One thing that may be related is that there are quite a few rows in the table in question - something over 197 million now. I don't recall the problem happening at all with fewer than 180 to 190 million rows. I'd love to track this down. I could use some help. Suggestions on what I can do to help are most welcome. Thanks, --- David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
reload my.cnf without restarting
Is it possible to reload changes of my.cnf without restarting the Server ? The reason is, that i want to toggle the log-file output of mysqld. Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: benchmark to my MySQL
if you have downloaded the src of mysql and installed it you can find the mysql benchmark in your /usr/local/sql-bench Else you also have downloads seperately on the mysql site for only the benchmark (in rpm and others). Grtz. Luuk On 4 Aug 2002, at 1:58, savaidis wrote: Is there any standard method or benchmark to run localy or remotly to my host to help me to setup MySQL better or to check various computer/configurations? I could find anything on http://www.mysql.com/information/benchmarks.html links. Only at third part software but it is in C++, not .sql. What that means? Makis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Compiling error 3.23.51 under RedHat 7.3
Can someone give a solution for the following error-message when runing make? llibmysql.c: In function `mysql_real_connect': libmysql.c:1324: warning: passing arg 5 of `gethostbyname_r' from incompatible pointer type libmysql.c:1324: too few arguments to function `gethostbyname_r' libmysql.c:1324: warning: assignment makes pointer from integer without a cast make[2]: *** [libmysql.lo] Fehler 1 -- Jochen Kaechelin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
automating import process
Hi, I want to try to automate a phonebook list import process into MySQL database. The phonebook was originally created with MS Access and exported into a text file. I upload that text file onto my server and I proceed with the following import process. Using Telnet I type: # ./mysql -u 'root' -p It then asks Enter password: I then select the database to use mysql use import_test1; I delete the previous phonebook list table because the import process does not know that it should replace the previous records even though there have been changes mysql use import_test1; mysql exit Bye I then import by doing the following: [root@ns2 bin]# ./mysqlimport --local -u root -p --fields-terminated-by=, import_test1 phone2.txt Enter password: import_test1.phone2: Records: 53 Deleted: 0 Skipped: 0 Warnings: 1 I was wondering is there anyway to automate this process in a script? I have never written a script in Linux before. If I can automate this process, what kind of script should I use? Thanks. 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
Compile time error
Hi! I've experienced a strange problem while making mysql-3.23.51: The following command is issued: g++ -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -rdynamic -o .libs/mysqlbinlog mysqlbinlog.o ../libmysql/.libs/libmysqlclient.so -lz -lcrypt -lnsl -lm -lz -lcrypt -lnsl -lm -Wl,--rpath -Wl,/usr/local/lib/mysql This gives the following errors: mysqlbinlog.o(.gnu.linkonce.d._ZTV9Log_event+0xc): undefined reference to `__cxa_pure_virtual' mysqlbinlog.o(.gnu.linkonce.d._ZTV9Log_event+0x1c): undefined reference to `__cxa_pure_virtual' Since I'm relatively new to MySQL, I don't know what to do about this. Does anyone know? Fredrik Tolf - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: SIGPROF problem in FreeBSD 4.6 (REPOST)
On Sat, Aug 03, 2002 at 11:59:56PM -0400, [EMAIL PROTECTED] wrote: Symptoms: mysqld locks itself in a tight loop, consuming all available CPU cycles. a simple kill sometimes kills the daemon, other times a -9 is required. While in this state, any access to the daemon stops - mysql queries simply hang. Hmm. Looks like a problem we solve recently, but yours is a bit different. We found that FreeBSD's not-so-thread-safe gethostbyname_r() causes problems for MySQL. So it's best to use --skip-name-resolve when starting it up. Maybe the same bug is somehow triggering this? Seems unlikely, but ya never know... Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 66 days, processed 1,370,770,519 queries (238/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: reload my.cnf without restarting
On Sun, Aug 04, 2002 at 11:45:27AM +0200, Hussein Morsy wrote: Is it possible to reload changes of my.cnf without restarting the Server ? The reason is, that i want to toggle the log-file output of mysqld. Some changes are going into MySQL 4.0.3 to allow many server settings to be changed without restarting MySQL. But that doesn't help you yet, I'm afriad. You need to restart MySQL. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 66 days, processed 1,370,844,776 queries (238/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: Crashing under high load
Jeremy Zawodny wrote: On Fri, Aug 02, 2002 at 05:41:09PM -0500, Shane Allen wrote: The gentleman on PHPBuilder (http://www.phpbuilder.com/columns/tim2705.php3) (again, I acknowledge this is an old article) says flat out that MySQL tends to die under high load. Also, when I say high load, I am talking 15-30. I have yet to see an application (other than MySQL when it's loaded down with queries) die under this level of load. That's not normal at all. MySQL shouldn't care about the system load. It may run *slower* but it shouldn't die. Generally if it dies. Its because the operating system reached some limit. Often if you look at the hostname.err file in /var/lib/mysql there will be some clue as to what resource you ran out of. Some possibilities are o Virtual memory (swap space) o Open file descriptors o Address space o Stack space I think you need to examine your system when its underload and see if any of these resources are near exhaustion. Jeremy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqldump --xml does not generate well formed XML
At 0:53 +0300 8/4/02, Martin Tsachev wrote: mysqldump invoked with --xml/-X omits the backslash from closing tags for columns of type: enum, varchar and date. Fixed in 3.23.51. There's also a bugfix for mysqldump -X for another problem in 3.23.50. Martin Tsachev Web developer http://martin.f2o.org MySQL support: none Synopsis: mysqldump --xml generates opening tags instead of closing for data, varchar and enum Severity: non-critical Priority: low Category: mysqldump Class:sw-bug Release: mysql-3.23.49 (Source distribution) Environment: System: Linux localhost 2.4.18 #1 Sat Aug 3 13:08:07 EEST 2002 i686 unknown Architecture: i686 (Pentium III, Slackware 8.1) Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-slackware-linux/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Jul 10 22:40 /lib/libc.so.6 - libc-2.2.5.so -rwxr-xr-x1 root root 4783716 May 26 2001 /lib/libc-2.2.3.so -rwxr-xr-x1 root root 5029105 May 18 06:54 /lib/libc-2.2.5.so -rw-r--r--1 root root 24991240 May 18 06:53 /usr/lib/libc.a -rw-r--r--1 root root 178 May 18 06:53 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Crashing under high load
Our application (Win32) gives MySQL a real pounding, but we have never had it die on a server with proper resources. On Win32 systems, you can not underestimate the importance of virtual memory (swap file) and drive defragmentation. On Win32 systems with SCSI RAID, we set the virtual memory to 20% or more of the total disk storage capacity. If the customer insists on cheaper EIDE drives, we install three ... two in a normal mirrored config, and a third drive that contains nothing more than a big swap file. We make the swap files static (same min and max) to reduce file fragmentation. We no longer support servers that are not running DisKeeper (full version ... not the crippled one in M$ distributions). Gerald Jensen - Original Message - From: Mike Wexler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Shane Allen [EMAIL PROTECTED]; Georg Richter [EMAIL PROTECTED] Sent: Saturday, August 03, 2002 7:14 PM Subject: Re: Crashing under high load Jeremy Zawodny wrote: On Fri, Aug 02, 2002 at 05:41:09PM -0500, Shane Allen wrote: The gentleman on PHPBuilder (http://www.phpbuilder.com/columns/tim2705.php3) (again, I acknowledge this is an old article) says flat out that MySQL tends to die under high load. Also, when I say high load, I am talking 15-30. I have yet to see an application (other than MySQL when it's loaded down with queries) die under this level of load. That's not normal at all. MySQL shouldn't care about the system load. It may run *slower* but it shouldn't die. Generally if it dies. Its because the operating system reached some limit. Often if you look at the hostname.err file in /var/lib/mysql there will be some clue as to what resource you ran out of. Some possibilities are o Virtual memory (swap space) o Open file descriptors o Address space o Stack space I think you need to examine your system when its underload and see if any of these resources are near exhaustion. Jeremy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Error Logs Question
How can I set up MySQL error logging? Is there any PHP MySQL error log parsers? Thank You - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Re: Replication Circle
Hello, I also plan to use two servers such that each is a master for the other. A - B B - A Unless you tell me otherwise, the log-server-updates option will not be used. Seems to work in a small test I've conducted. In fact this setup will be used for reasons of high availability. (rather than performance). Whenever at least one of the servers is up it should be used (and the other is not used even if it is also up). Can you think of some pitfalls I need to watch out from? Regards, Oren. Oren Zeev-Ben-Mordehai Infrastructure Engineer PhoneDo Networks office: +972-9-951-7771 ext. 204 fax:+972-9-951-7772 email: [EMAIL PROTECTED] sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql.sock on a Cobalt raq connection problems.
Dear All, We are running MySQL on a Cobalt Raq 4. After a while the socket 'mysql.sock' will not work anymore and access to our database is not possible. The error MySQL reported is: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) The mysql deamon is still functioning well and can be stopped and started normally again. Can you please help us solving this problem? Kind reagards, Johan Blaauw TobeOnline Tulderhei 16 5508 VM Veldhoven Nederland Tel: 0031 (0)40 254 99 09 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: Select Date_Add help
Please ! I thought I had this working, but it seems unfortunately not !!! I'm trying to list events for each month and my select query is as follows SELECT DISTINCT t_city_name,t_city_id_city FROM t_city,t_zipcodecity,t_location,t_event WHERE (t_city_id_city = t_zipcodecity_id_city) AND (t_zipcodecity_zipcode = t_location_zipcode ) AND ((t_location_sex = 4) OR (t_location_sex = 6) OR (t_location_sex = 0)) AND (t_location_id_location = t_event_id_location) AND (t_event_date (DATE_ADD('2002-08-01 00:00:00', INTERVAL 31 day)) ) AND (t_event_date '2002-08-01 00:00:00') ORDER by t_city_name this is for August and seems to work fine, but my problem is that in the running month I only want to show the still forthcoming events so for today July the 31 st my query looks like this SELECT DISTINCT t_city_name,t_city_id_city FROM t_city,t_zipcodecity,t_location,t_event WHERE (t_city_id_city = t_zipcodecity_id_city) AND (t_zipcodecity_zipcode = t_location_zipcode ) AND ((t_location_sex = 4) OR (t_location_sex = 6) OR (t_location_sex = 0)) AND (t_location_id_location = t_event_id_location) AND (t_event_date (DATE_ADD('2002-07-31 00:00:00', INTERVAL 0 day)) ) AND (t_event_date '2002-07-31 00:00:00') ORDER by t_city_name But it doesn't work ?? Can anyone give me a hint in the right direction ?? The problem is definately in the last part (t_event_date (DATE_ADD('2002-07-31 00:00:00', INTERVAL 0 day)) ) AND (t_event_date '2002-07-31 00:00:00') Thanks in advance - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
select box result on page1 to insert statement table name on page2- not working
I first posted this on the php-db list, but am not getting the proper results yet, so I am copying here, hopefully someone can help me figure this one out... I have a form with a select list and a hidden field to save the selected item. On submit another page is loaded with a few fields to be filled in and submitted to a table. Using get I see the data is being passed from the first page to the second properly, and the second page sends its data properly. The hidden field from the first page is to be used by the second page as the name of the table in the query. I have a place where I echo the contents of the hidden field just to be sure it is correct, and that does indeed show what I expect. I then make the query statement point to the variable but it always responds that it cannot find the table. The table does exist, the variable does contain the appropriate table name, but is not being replaced by the name. What am I doing wrong? On Sat, 2002-08-03 at 06:05, Rich Hutchins wrote: Try referencing the $listbox variable in you SQL statement like this: $sql = insert into .$listbox. values(NULL,'$date','$exercise','$reps','$comments'); I'm guessing that it might also work like this: $sql = insert into '$listbox' values(NULL,'$date','$exercise','$reps','$comments'); I think your core problem is that the $listbox variable is not being evaluated properly in the SQL statement. Once you solve that, you're good to go. Hope this helps. Rich I tried both suggestions and neither are working. I am using the get format for the form so I can see what is being sent, and I am getting this: http://192.168.1.53/workout-absflexor.php?exerciselist=%24listboxexercise=80 reps=12comments=submit=Send+Data Notice that the $listbox variable is still not being sent. Notice the two echo statements both of which shows what's in that variable, and it displays the expected result (see code below). I am at a loss as to why the one in the sql insert statement is not working. If I replace the $listbox variable with the table name shown in the echo statement, a connection is made and the query is completed. -- Chip W www.wiegand.org [EMAIL PROTECTED] Below is the code for the first page -- html head title/title /head body div align=center ? $exercises=array(absflexor,absmachine,leglifts); echo form action='workout-absflexor.php' method='get'; echo table width='70%' border='0' align='center'; echo trth align='center'h2Exercise Data Input/h2/th/tr; echo trth align='center'select name='listbox'; echo option$exercises[0]/option; echo option$exercises[1]/option; echo option$exercises[2]/option; echo /selectbrbr; echo /th/tr/table; echo input type='hidden' name='exerciselist' value='$listbox'; echo input type='submit'; echo /form; ? /div /body /html And below is the code for the second page (the form hidden field was later added, but still no good) (the echo statement at the bottom was later added to verify the variable) -- !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd; html xmlns=http://www.w3.org/1999/xhtml; head titleWorkout Data Entry Form/title style type=text/css body { background-color: aqua; } div.c1 {text-align: center} /style /head body div class=c1 h2Work-Out Data Entry Screen/h2 form action=? PHP_SELF ? method=get input type='hidden' name='exerciselist' value='$listbox' table summary= width=60% border=1 align=center bgcolor=green tr thWeight/th td align=leftinput type=text name=exercise maxlength=4/td /tr tr thReps/th td align=leftinput type=text name=reps maxlength=4/td /tr tr thComments/th td colspan=2textarea cols=50 rows=3 name=comments /textarea/td /tr trtd? echo $listbox; ?/td/tr /table br / input type=submit name=submit value=Send Data / input type=reset / /form /div ? if(isset($submit)): $db = mysql_connect(localhost,root,carvin); if(!$db) error_message(sql_error()); mysql_select_db(workout,$db) or die (Ack! Where's the database?); $date = date(m-d); $sql = insert into .$listbox. values(NULL,'$date','$exercise','$reps','$comments'); mysql_query($sql) or die (Ack! No response when I queried the server!); endif; echo $listbox; ? /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
problem creating table with default date
I'm using the following DDL statement: create table if not exists dbname.tablename ( ..., the_datedate not null default current_date ); I receive the following error message: ERROR 1064: You have an error in your SQL syntax near 'current_date, I'm been looking around and can find no support on how to instruct the database to default to current date. All I've found was something like this: create table if not exists dbname.tablename ( , the_datedate not null default '-00-00' ); This second option is not really what I want. I want the let the database create the current date when I insert a row. Is this possible and if so, how can it be done? Thanks. Eric Ray [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
Text formating in Perl
Greetings! I have the same problem Blue Presley did only I'm using Perl. Using a textarea field with -wrap=virtual I input Twas brillig, and the slithy toves Did gyre and gimbol in the wabe. All mimsy were the borogroves, And the mome raths outgrabe and it shows up this way when I look at the table with mycc However when I try to print it out after SELECT print p($ref-[5]); it prints all as one line. How do I maintain text format extraction in Perl 5.6.1? I can't seem to find the answer in either of the two books on Perl and MySQL. Thanks! Eric - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MyCC connection
Does MyCC is able to connect to MySQL servers in the local network...or it can connect only to localhost? NN ___ NOCC, http://nocc.sourceforge.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Pattern matching - regexp
Hello, How is REGEXP used? I have looked at the manual. If I have the following values in my db table: Id. regdate 00ca. 1900 011910 02ca. 1700-tallet 031550-tallet 041600-1700 ... and the query parameters: 190, 155, 170, I want the result of the search to be: ca. 1900 1900-tallet 1550-tallet 1600-1700 I have tried $sql = SELECT . FROM ... WHERE .= .. AND regdate REGEXP '(190|155|170)' ; What is wrong here? I am new starter in the world of mysql. Thanks in advance. OO - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Text formating in Perl
Use pre /pre around the text. If you look at the html source, I think you will find that the text is, in fact, formatted. Also, you could write a regular expression to replace a line break with a br. On Sun, 4 Aug 2002, eric wrote: Date: Sun, 4 Aug 2002 18:56:26 +0200 From: eric [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Frau [EMAIL PROTECTED] Subject: Text formating in Perl Greetings! I have the same problem Blue Presley did only I'm using Perl. Using a textarea field with -wrap=virtual I input Twas brillig, and the slithy toves Did gyre and gimbol in the wabe. All mimsy were the borogroves, And the mome raths outgrabe and it shows up this way when I look at the table with mycc However when I try to print it out after SELECT print p($ref-[5]); it prints all as one line. How do I maintain text format extraction in Perl 5.6.1? I can't seem to find the answer in either of the two books on Perl and MySQL. Thanks! Eric - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Re: InnoDB: Looong pause when log file is full?
Hi Heikki, Thank you for responding. (http://www.innodb.com/ibman.html#InnoDB_tuning), but am getting bit when the log files are full and the buffer pool is checkpointed. InnoDB does 'fuzzy checkpoints'. That means modified database pages in the buffer pool are flushed to disk in small batches. The time when a physical log file becomes full does not affect this continuous background checkpointing activity, since InnoDB sees all the log files as one catenated log file. That's good to know---so that isn't it. The pauses you experience are probably caused by high load in general, probably too much disk i/o. You should study your queries, use the InnoDB Monitor, watch 'top', adjust buffer pool size, spread disk i/o. Respectfully, I don't think that's it. Both times I've seen the database do this it's been in periods of relatively low traffic. Until we switched to InnoDB tables, the only times the database was frozen up like this was when someone did an ill-advised select that took forever and gummed everything up. That's the main reason we switched to InnoDB tables---so a long select wouldn't hold up the db (by an update blocking, which would block subsequent selects). In this case, when the (inno-)db was 'pausing', all of the queries in the (growing) queue looked normal. And there was a lot of free ram. I didn't see anything useful in the InnoDB monitor, but then I'm new to reading it. Then all of a sudden all queries finished and there were no more in the queue and the problem didn't recur for five days. I thought it must be related to the log files, because when I looked at them it looked like one was just finished being written to. (Because its modification time was the previous minute, while the next (zeroth) log file was now the active one.) I know without a repeatable test case, there's not much you can do. If I get more information I'll let you know. It helps to hear that this behavior isn't normal, though. --Pete 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
MYSQL/GNU-Linux CLasses by User Group in NYC
Revised Class Schedule Free Software Institute REVISED Class Schedule for August: Classes $300 individually perl 1 and 2 bundle $550 GNU/Linux 1 Unix 1 bunlde $550 - Students talking GNU/Linux 1 are require to purchase a computer used for the rest of the corse work Complete program package - perl1, perl2, gnu/linux 1, unix 1, gnu/linux 2, unix 2 Database Programming 1, Introdution to Networking 1 $4000 Perl2 - Object Orientation in Perl · Basic CGI Programming · Database usage and SQL · Building Database Web Applications with DBI · Basic MYSQL administration and SQL · Templating Web Design and Rapid Development with Perl · Introduction to mod_perl · Writing Basic Apache Tuesday at ASHA: 7:00PM - 11:00PM August 6th August 13th August 20th August 27th September 3rd Unix 1 - Unix Tool, find, locate, man, grep, AWK, sort, df, ls, gcc, make cp, ln, mv Permissions, tcp networking,route. Wednesday at Rozensweig and Maffia 7PM-11:00 August 7th August 14th August 21st Augisyt 28th September 4th Linux 2 - Apache Installation: Download Source Code untar make make install Configure Apache Apache root httpd.conf initiation startup script httpd processes htdocs directory mysql installation Download source untar make install set initial permissions set up initiation file System monitoring tripwire system log monitoring top kill renice/nice last who w netstat route cron/crontab Port scanning/network security nmap inetd.conf tcp wrappersm- hosts.allow hosts.deny simple package forwarding, firewall, ipchains/NAT sshd,encrypted channels, VPN Thusdays - Brooklyn NYLXS Headquarters - 7PM-11:00PM August 8th August 15th August 21st August 28th September 5th Unix 2 - shell scripting, C programming, Desktop X Tuesdays NYLXS Headquarters - Brooklyn August 6th August 13th August 20th August 27th September 3rd -- Total program for reference: Sylibus: Introduction to GNU/Linux Installation Boot Media, Kernels Hard Drives Partitions fdisk, type 82, type 83 swap partition mkswap, swapon, partition types, partition tables, /boot /home /usr /var file systems, ext2, reiser, ext3, mke2fs inodes, MBR Introduction to the Shell kernle -getty - login -shell /etc/passwd adduser /etc/group Introduction to VI, vim, vi commands: command mode i =insert o =open a =append dd=delete g=goto yy =yank p=paste jklim edit mode type and character into screen esc to go back to command mode execute mode :w write :q quit /search search :wq! at all costs 1,$s/old/new/g == substitution globaly Basic Shell comands ls - directory listing cp - copy mv - move ls ru* - globing cat - cancatonate ps -auxw - see processes pstree - see process tree top - system report Directory tree files, ownership, group permissions Setting up X XF86Setup Knowing your video card Knowing your monitor sysinit - /etc/rc.d/init.d - turning services off and on network setup ipaddress host name domain gateway dns adding users - different on different systems /etc/passwd /etc/shadow ifconfig - see network connections modules - modprobe, demode, lsmod, kernel compile Introduction to unix Unix Tool, find, locate, man, grep, AWK, sort, df, ls, gcc, make cp, ln, mv Permissions, tcp networking,route. Introduction to Programming with Perl Advanced Unix2 shell scripting, C programming, Desktop X. Introduction to Apache: GNU/Linux 2 Install of mod perl, install of Apache, Install of embperl, and mason, basic apache configuration with files and virtual servers, etc Advanced Web Programming with Perl embperl, modperl, the apache request cycle, cgi's, html, forms, cookies and sessions Database Programming 1 MYSQL installation, Creating tables, performance evalutions, SQL seelcts, Inserts, user permissions, Perl DBI, C API. Introdution to Networking 1 REVIEW tcp/id, introduce mail, sendmail, bind, DNS, DHCP, SAMBA, NFS, SSH, ROUTE -- __ Brooklyn Linux Solutions __ http://www.mrbrklyn.com - Consulting http://www.nylxs.com/radio - Free Software Radio Show and Archives http://www.brooklynonline.com - For the love of Brooklyn http://www.nylxs.com - Leadership Development in Free Software http://www.nyfairuse.org - The foundation of Democracy http://www2.mrbrklyn.com/resources - Unpublished Archive or stories and articles from around the net http://www2.mrbrklyn.com/mp3/dr.mp3 - Imagine my surprise when I saw you... http://www2.mrbrklyn.com/downtown.html - See the New Downtown Brooklyn 1-718-382-5752 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try:
Fwd: MYSQL/GNU-Linux CLasses by User Group in NYC [ruben@www2]
SQL MYSQL On 2002.08.04 14:46 Ruben I Safir wrote: Revised Class Schedule Free Software Institute REVISED Class Schedule for August: Classes $300 individually perl 1 and 2 bundle $550 GNU/Linux 1 Unix 1 bunlde $550 - Students talking GNU/Linux 1 are require to purchase a computer used for the rest of the corse work Complete program package - perl1, perl2, gnu/linux 1, unix 1, gnu/linux 2, unix 2 Database Programming 1, Introdution to Networking 1 $4000 Perl2 - Object Orientation in Perl · Basic CGI Programming · Database usage and SQL · Building Database Web Applications with DBI · Basic MYSQL administration and SQL · Templating Web Design and Rapid Development with Perl · Introduction to mod_perl · Writing Basic Apache Tuesday at ASHA: 7:00PM - 11:00PM August 6th August 13th August 20th August 27th September 3rd Unix 1 - Unix Tool, find, locate, man, grep, AWK, sort, df, ls, gcc, make cp, ln, mv Permissions, tcp networking,route. Wednesday at Rozensweig and Maffia 7PM-11:00 August 7th August 14th August 21st Augisyt 28th September 4th Linux 2 - Apache Installation: Download Source Code untar make make install Configure Apache Apache root httpd.conf initiation startup script httpd processes htdocs directory mysql installation Download source untar make install set initial permissions set up initiation file System monitoring tripwire system log monitoring top kill renice/nice last who w netstat route cron/crontab Port scanning/network security nmap inetd.conf tcp wrappersm- hosts.allow hosts.deny simple package forwarding, firewall, ipchains/NAT sshd,encrypted channels, VPN Thusdays - Brooklyn NYLXS Headquarters - 7PM-11:00PM August 8th August 15th August 21st August 28th September 5th Unix 2 - shell scripting, C programming, Desktop X Tuesdays NYLXS Headquarters - Brooklyn August 6th August 13th August 20th August 27th September 3rd -- Total program for reference: Sylibus: Introduction to GNU/Linux Installation Boot Media, Kernels Hard Drives Partitions fdisk, type 82, type 83 swap partition mkswap, swapon, partition types, partition tables, /boot /home /usr /var file systems, ext2, reiser, ext3, mke2fs inodes, MBR Introduction to the Shell kernle -getty - login -shell /etc/passwd adduser /etc/group Introduction to VI, vim, vi commands: command mode i =insert o =open a =append dd=delete g=goto yy =yank p=paste jklim edit mode type and character into screen esc to go back to command mode execute mode :w write :q quit /search search :wq! at all costs 1,$s/old/new/g == substitution globaly Basic Shell comands ls - directory listing cp - copy mv - move ls ru* - globing cat - cancatonate ps -auxw - see processes pstree - see process tree top - system report Directory tree files, ownership, group permissions Setting up X XF86Setup Knowing your video card Knowing your monitor sysinit - /etc/rc.d/init.d - turning services off and on network setup ipaddress host name domain gateway dns adding users - different on different systems /etc/passwd /etc/shadow ifconfig - see network connections modules - modprobe, demode, lsmod, kernel compile Introduction to unix Unix Tool, find, locate, man, grep, AWK, sort, df, ls, gcc, make cp, ln, mv Permissions, tcp networking,route. Introduction to Programming with Perl Advanced Unix2 shell scripting, C programming, Desktop X. Introduction to Apache: GNU/Linux 2 Install of mod perl, install of Apache, Install of embperl, and mason, basic apache configuration with files and virtual servers, etc Advanced Web Programming with Perl embperl, modperl, the apache request cycle, cgi's, html, forms, cookies and sessions Database Programming 1 MYSQL installation, Creating tables, performance evalutions, SQL seelcts, Inserts, user permissions, Perl DBI, C API. Introdution to Networking 1 REVIEW tcp/id, introduce mail, sendmail, bind, DNS, DHCP, SAMBA, NFS, SSH, ROUTE -- __ Brooklyn Linux Solutions __ http://www.mrbrklyn.com - Consulting http://www.nylxs.com/radio - Free Software Radio Show and Archives http://www.brooklynonline.com - For the love of Brooklyn http://www.nylxs.com - Leadership Development in Free Software http://www.nyfairuse.org - The foundation of Democracy http://www2.mrbrklyn.com/resources - Unpublished Archive or stories and articles from around the net http://www2.mrbrklyn.com/mp3/dr.mp3 - Imagine my surprise when I saw you... http://www2.mrbrklyn.com/downtown.html - See the New Downtown Brooklyn 1-718-382-5752 -- __ Brooklyn Linux Solutions __ http://www.mrbrklyn.com - Consulting http://www.nylxs.com/radio - Free Software Radio Show and Archives http://www.brooklynonline.com - For the love of Brooklyn http://www.nylxs.com - Leadership
RE: users and db visibility
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 04, 2002 3:17 AM To: Hussein Morsy; MySQL List Subject: Re: users and db visibility on 8/4/02 3:13 AM, Hussein Morsy, typed: how can i make MySQL show only what db are available to the user? i.e., when a user logs in from a terminal application and types: 'show databases;' mysqld --safe-show-database or in my.cnf: safe-show-database With this option, the SHOW DATABASES command returns only those databases for which the user has some kind of privilege. In 4.0.2 this option is default enabled. thanks. i just searched: http://www.mysql.com/doc/en/index.html for my.cnf and got no returns. i searched my system for it and couldn't find it. can you tell me something about it, like maybe where it could be? Yes, well, a quick 30 seconds worth of work: (1) go to mysql.com (2) click on Search (3) Type in --safe-show-database in the box (4) click on Search1 Volia! For the truly lazy, here's a link to get you started: http://www.mysql.com/doc/en/Command-line_options.html -- Ed Carp, N7EKG http://www.pobox.com/~erc 214/986-5870 Director, Software Development Escapade Server-Side Scripting Engine Development Team Pensacola - Dallas - London - Dresden http://www.squishedmosquito.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