Re: '/tmp/mysql.sock' (111)
sarahana schrieb am Freitag, 3. August 2001, 03:07:31: > If mysql is shown when runnnig phpinfo() - does it mean that its installed, > and if yes, why this error? this only shows that php is compiled with mysql support. > thanks, what needs to ben done? I assume you work under win. You need to start mysql - which is done with the executable mysqld - clear to unix users, unfamiliar to win users - means mysql daemon. This is done in a dos window. You should place it into your autostart group or use WinMySQLadmin to do this for you - quite handy, as this program takes care of closing mysql during shutdown - otherwise you have to do it yourself, and if you don't, you may damage your tables. Get yourself WinMySQLadmin from http://mysql.com Also, make sure you read all readmes and install guides and docs that came with the installation. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Crazy Threads
I was watching the log for errors, but none occurred. I absolutely lost at what this could be. I just did a mysql_install_db (and deleted the old) thinking maybe a permission might be messed up. We'll see if that helps. Chris Hilbert -Original Message- From: Werner Stuerenburg [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 02, 2001 8:46 AM To: Chris Hilbert Cc: [EMAIL PROTECTED] Subject: Re: Crazy Threads Chris Hilbert schrieb am Donnerstag, 2. August 2001, 12:54:55: > Its seems like the only way to watch the process list would be to do > something like mysqladmin -uroot -i 1 processlist. Since I can't show > processlist when it won't connect to it (I tried to do it while it was > dead). Still, this would consume a lot of resource and might not even > work right...since I'd technically have to wait an hour or so for it > to crash. > Any other ideas? You could watch the log file and error log. Those grow pretty big very fast, so you could rename the old ones and start new ones. Data from an hour should be easy to manage. Hence you will see exactly what mysql does and what kind of errors occur, if any. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 . Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
binary test failed on Mac OS X Server 1.2
>Description: binary test failed on Mac OS X Server 1.2 using mysql 3.23.40. Problem appears with both binary distribution and built from source according to manual instructions. >How-To-Repeat: make test >Fix: not known. >Submitter-Id: >Originator:David Cake >Organization: System Administration team tomandandy >MySQL support: none >Synopsis: fails binary test on Mac OS X Server 1.2 >Severity: serious >Priority: high >Category: mysql >Class: sw-bug >Release: mysql-3.23.40 (Source distribution) >Environment: Power Computing, Mac OS X Server 1.2, rhapsody-ppc-5.6, pcthreads lib System: Rhapsody duchamp 5.6 Kernel Release 5.6: Tue Nov 23 15:07:38 PST 1999; root(rcbuilder):Objects/kernel-187.obj~2/RELEASE_PPC Copyright (c) 1988-1995,1997-1999 Apple Computer, Inc. All Rights Reserved. Power Macintosh Some paths: /usr/bin/perl /bin/make /usr/bin/cc Compilation info: CC='cc' CFLAGS='-O2 -fomit-frame-pointer' CXX='cc' CXXFLAGS='-O2 -fomit-frame-pointer' LDFLAGS='' LIBC: Configure command: ./configure --prefix=/usr/local/mysql --with-extra-charsets=complex --disable-shared Perl: This is perl, version 5.005_02 built for rhapsody - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
new installation
I downloaded, compiled, and installed the latest MySQL release from the source code at www.mysql.com last night. I was running through the tests documented in the INSTALL-SOURCE file, and I've found that mysqladmin -u root shutdown does not work. I've done a ps and I can still see the mysqld running... more telling is that mysqladmin has not quit yet (I put the command in about 30 minutes ago). My computer has been restarted since I installed mysql. I'm running MacOS X 10.0.4 (*not* MacOS X Server). If anyone could give me some advice on this, I'd appreciate it. Please send e-mail to: [EMAIL PROTECTED] Thank you. 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: Query Not Using Indexing
Hi! > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> Adam Douglas writes: >> I'm running MySQL v3.22.32. Here's my problem I run the following >> select query and both CompanyRep and PostalCodeInfo tables are not >> using my Indexing. Why? How can I get these two tables to use indexing >> to speed up my query. You can look at my indexing on the two tables >> below the query. >> >> Any help would be greatly appreciated, thanks! >> >> SELECT >> Company.Company_Name, >> CompanyShipInfo.Ship_Addr1, >> CompanyShipInfo.Ship_Addr2, >> CompanyShipInfo.Ship_City, >> ProvincesStates.Prov_State_Name, >> Countries.Country_Name, >> CompanyShipInfo.Ship_Postal_Code, >> Company.Phone, >> Company.Fax, >> Company.Email, >> Company.Web_Page >> FROM >> CompanyRep, Company, CompanyShipInfo, PostalCodeInfo, >> ProvincesStates, Countries >> WHERE >> ( >> CompanyShipInfo.Prov_State_ID=PostalCodeInfo.Prov_State_ID >> AND PostalCodeInfo.Postal_Code=98188 >> AND CompanyRep.Company_ID=Company.Company_ID >> AND CompanyShipInfo.Company_ID=Company.Company_ID >> AND CompanyShipInfo.Prov_State_ID=ProvincesStates.Prov_State_ID >> AND CompanyShipInfo.Country_ID=Countries.Country_ID >> AND Company.Company_Status_ID=1 >> AND CompanyRep.Invoice_Only=0 >> AND CompanyRep.Wholesale_Rep=-1 >> ) Sinisa> Hi! Sinisa> You have 6 tables in a join. Sinisa> Possible causes of not using indices could be some index missing or Sinisa> low number of rows. Sinisa> Beside that, you do have Cartesian product as there are some tables Sinisa> not related. Try running an EXPLAIN for the query to verify which indexes are used. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ 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: How to add an excel file directly to MySQL database using PHP?
Yeong CN schrieb am Freitag, 3. August 2001, 06:43:11: > How can I add an excel file with *.xls extension > directly into MySQL database..is it possible to do or > I need to convert it into *.csv format or *.txt format > first? You can put anything into MySQL provided you choose the right column type. In this case, you should use one of the text or blob types. Make sure you escape the special characters. If you program in php, you wrap the input with the function addslashes which does the job for you, and you strip the escapes back on retrieval with stripslashes. If you don't want to operate on these files, it is probably not a good idea to put them into the database. In this case, the general considerations regarding pictures apply. Here is what Rasmus says about storing pictures in databases: When dealing with images, it is of course possible to insert the image data into the database as binary blobs. However, the value in doing that is questionable. Until databases provide you with cool pattern recognition tools that will let you search a blob for a picture of a rose, having the image data itself in the database isn't of much use. Every operating system comes with a finely tuned blob database. It is called your file system. So, just put the full-path filename into the database and leave the images sitting somewhere on your disk. You will save yourself much aggrevation in the long run. As the data format of Microsoft files is not very good documented, I wonder what operations you may want to perform on those. Of course, they do have some ASCII inside you may search for. You seem to be willing to sacrifice all Excel specific data, which will happen if you convert to csv or txt. This looks like you are only interested in the plain ASCII and structure and don't want to conserve anything that adds on that. In this case it will be a good idea to convert xls to any of these formats, because you will save a lot of space. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: new user privileges
Dear Alex, > to add a new user with full privileges on only 'abcdb'. How I assume "abcdb" is a database, not a table. Try this: GRANT ALL ON abcdb.* TO "newuser"@"localhost" IDENTIFIED BY "pw" Regards, --- Stonix <[EMAIL PROTECTED]> wrote: > Hi, > > I'm new in mysql admin. I have question on create new user. > Suppose I have created a database called 'abcdb'. Now I want > to add a new user with full privileges on only 'abcdb'. How > should I do? I tried 'grant all privileges on abcdb.*' > but still the new user has the superuser privileges. I only > want to add a new user of a developer level. Anyone can help > me out for this question. > > Thanks in advance for all reply! > > Alex > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > = --- Stefan Hinz <[EMAIL PROTECTED]> iConnect e-commerce solutions GmbH, 13355 Berlin Office: +49 30 46307-382 Mobil: +49 177 7841069 Antwortadresse dieser E-Mail: <[EMAIL PROTECTED]> BITTE NUR IN DRINGENDEN FÄLLEN AN DIESE ADRESSE ANTWORTEN! --- __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How can try to recover the data from mysql
Hello Friends I think my mysql database carsh but I hope there are some utility to recovered the data crash. Can any one help me in this. Rupak Joshi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
about your GUI Source
hi, mysql£¡ I'm interesting in your GUI style, so I download a copy of your source code, but, IMHO, I'm so surprised that the style of the code is so bad, it's so unreadable. And another question is that, After it is connected to a host(Solaris) which settled in local network, but it is very very very slowly when I execute the query: SELECT count(*) FROM tablename; It's very fast to execute this query in the mysql client under unix console, WHY? Sorry for disturbing you. -- nbumathEmail: [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: password for root
Date |Thu, 2 Aug 2001 15:18:51 -0400 >From |"Stonix" <[EMAIL PROTECTED]> Hello! S> Hi, S> I installed mysql, and found root can login without a password. S> So I checked mysql manual and setup a password for root. However, S> according to the manual, I need to type another commond: S> "flush privileges;" I don't undersdant why should I do this. S> Any one can give me a hint? 'flush privileges' tell the server to reload grant tables on the fly. http://www.mysql.com/doc/m/y/mysql_install_db.html ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ <___/ 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: mySQLd won't die under Darwin (Mac OS X 10.0.4)
Mark Tully writes: > Hi Sinisa, > > The server functions fine, I can run queries on it and I've lot it linked > into a bulletin board through php and apache and that works like a dream. > But it still won't die! > > mysqladmin -uroot -psql shutdown > > Returns without any complaint but the tasks are still going. > > If I stick a sudo before the above command it hangs and I have to kill that > off as well (although kill works for that - phew). > > The only way of killing them seems to be kill -KILL or it's synonym kill -9. > > I've not had any other thread related problems with my install. > > Any other pointers? > > Mark > Can you check with mysqladmin proc in which state were connections after shutdown ?? Sometimes it takes time for all threads to be killed ... I know that older Darwin versions did not require any thread libs, but may be this one does ?? Can you check it out with http://www.prnet.de/RegEx/mysql.html ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /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: data checking during input?
Just do a SELECT query to MySQL before you do an INSERT then compare the two. Compare whatever you don't want to be a duplicate. In most cases you'll have a central point at which you should be able to check but it all depends on your setup/situation. Understand? I could go into a more in depth detail if needed. > -Original Message- > From: Chip [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 03, 2001 12:08 AM > To: [EMAIL PROTECTED] > Subject: data checking during input? > > > I have a database I enter data into from a web based php form. > I wonder if there is a way to have mysql check the database for > a duplicate entry before it gets written into the database? And > inform me of such so I will not have duplicate entries? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Crash on replace
On 2001 Aug 03, Miguel Angel Solórzano <[EMAIL PROTECTED]> wrote: > I was be able to repeat your bug report. Thanks and it > will be fixed. This has been fixed in the current code. Here is a patch: *** sql/ha_berkeley.cc.orig Fri Aug 3 09:46:50 2001 --- sql/ha_berkeley.cc Fri Aug 3 09:46:55 2001 *** *** 1201,1207 if (!(error=key_file[keynr]->cursor(key_file[keynr], trans, &tmp_cursor, 0))) { ! if (!(error=cursor->c_get(tmp_cursor, (keynr == primary_key ? prim_key : create_key(&key, keynr, key_buff2, record)), --- 1201,1207 if (!(error=key_file[keynr]->cursor(key_file[keynr], trans, &tmp_cursor, 0))) { ! if (!(error=tmp_cursor->c_get(tmp_cursor, (keynr == primary_key ? prim_key : create_key(&key, keynr, key_buff2, record)), Tim -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Tim Smith <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-time Developer /_/ /_/\_, /___/\___\_\___/ Boone, NC USA <___/ 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
Databases on Removable Media?
Is it possible to create mulitple database directories ... with one of them on a CD-ROM? One of the databases our app uses is an 'archive', and once a record is written to it, that record is never altered or updated. Each night, a daemon runs through the archive, 'indexes' it and writes out a pair of files that are part of the full-text search engine we use. As the database grows, the amount of time required to build the FTS indexes increases. The FTS engine is being upgraded to handle multiple databases, and there is some thought being given to breaking the archive database by years. When 2001 is over, we would rename the archive database (arc2001) and store it (along with its FTS indexes) with arc1998, arc1999, arc2000, etc. We currently store the databases in the tree MySQL's installer creates. Can you have a second data directory, which would a device like a CD-ROM? Gerald Jensen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
socket error: Can't connect to local MySQL server through socket '' (111)
I am getting an error message Can't connect to local MySQL server through socket '' (111) trying to connect via mySQLgui on my Linux box running RH6.2 I do have a /tmp/mysql.sock with proper authorizations and have no problem connecting to the serverwithout the client. Thanks for your clues Charles - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Host Access denied
It looks like you dont have the correct privileges on your mysql server to connect from a specified host. Look at the Grant function in mysql manual for more info Sherwin Ang Web Programmer Yesmynet Internet - Original Message - From: Mike <[EMAIL PROTECTED]> To: MySQLList <[EMAIL PROTECTED]> Sent: Thursday, August 02, 2001 4:58 PM Subject: Host Access denied Hello all, I have a problem. I am trying to use MyODBC to connect to my DB. My linux box houses the database and I am trying to access that db server from a windows box. The daemon is running and listening on the standard port. I have the odbc driver using that port. I have tried two different methods of using the odbc drivers and both return the exact same error. Error connecting to toiletries Error: [1130] [] "[TCX][MyODBC]Host 'Bob' is not allowed to connect to this My SQL server" I have looked in /var/log/mysqld.log for errors but it has none. Is there anywhere else to look? Is there some step involving adding hosts to the permissions table or something? What am I missing? Why is the sky blue? What is the capital of Arizona? Thanks for any and all help.. Michael Turner - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: generate database script from existing table?
Dear Tong, if you have access to the machine in question as root, try: mysqldump --all-databases > export_it_all_file.sql You may have to enter MySQL superuser name and password, so it goes like this: mysqldump --all-databases -u superuser -p > export_it_all_file.sql (enter pw at prompt) The file mysqldump produces holds all the SQL statements needed for a batch job, creating all databases with all tables and all data. To import this on the other machine, try: mysql -u superuser -p < export_it_all_file.sql You may want to use PhpMyAdmin (www.phpmyadmin.com) for this. It has a graphical, browser based interface which does the same as mysqldump. Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - From: "Tong Kiat, Chiah" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 03, 2001 12:44 PM Subject: generate database script from existing table? Hi I just took over a mysql database with no documenation. Is there any tools or anyway I could generate a database/table creation script from the current database? This is because I need to recreate the database on another machine and currently I have no way of doing so. thanks tk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
'/tmp/mysql.sock' (111)
If mysql is shown when runnnig phpinfo() - does it mean that its installed, and if yes, why this error? thanks, what needs to ben done? > What does this error mean? > I ran a simple connect query just to check if mysql is there, and now I know > it is cause i ran phpinfo(): > > Warning: Can't connect to local MySQL server through socket > '/tmp/mysql.sock' (111) > > 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: Further FreeBSD 4.3 Issues (CPU hogging)
Ken, Thanks for taking the time in the midst of all your priorities to help me look into this problem. I was able to get the proper pid for the mysqld process, but running truss -p (number here) resulted in no return. Running truss /usr/local/libexec/mysqld resulted in the display I sent in my last email. Yes, mysqld was alive at the time, but for whatever reason truss -p did not turn out the expected results. On a similar note, I shutdown mysqld and restarted it a day ago. Since then, mysqld has been running quite reasonably. If the data I sent you does not point to anything, I suppose we can wait and see if the server runs itself up again. Regards, Michael Institute for Social Ecology 1118 Maple Hill Rd. Plainfield, Vermont, 05667 USA Tel./Fax. 1 (802) 454-8493 http://www.social-ecology.org/ -Original Message- From: Ken Menzel [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 02, 2001 10:41 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Further FreeBSD 4.3 Issues (CPU hogging) Hi Michael, Sorry for the delay getting back to you, we had some network problems here and are in the process of upgrading our 30 year old copper to a new 200 pair copper cable to the building (They can't do fiber, sigh!). Anyway, the output from truss that you sent looked like a normal mysqld startup. The way to run truss for debugging a probelm is: ps -ax | grep /mysqld get the process ID and then truss -p process ID. or as one command: truss -p `ps -ax | grep /mysqld | cut -c 1-6` Or are you saying this is what you did and there was no output at all from truss? IE it was "dead"? P.S. I will be out of the office tomorrow. Ken - Original Message - From: "Institute For Social Ecology" <[EMAIL PROTECTED]> To: "Ken Menzel" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, August 01, 2001 4:56 PM Subject: RE: Further FreeBSD 4.3 Issues (CPU hogging) > Ken, > > Thanks as always for your very helpful support. I did a 'truss -p' on > the PID and it came back empty handed. I did do a 'truss > /usr/local/libexec/mysqld' which spat back all sorts of goodies. I > have included the output bellow. Also, as requested, below is the > output of mysqlbug. > > Once again, thank you for your help. > > Regards, > > Michael > > truss /usr/local/libexec/mysqld: > > __sysctl(0xbfbffac4,0x2,0x281bfba8,0xbfbffac0,0x0,0x0) = 0 (0x0) > mmap(0x0,32768,0x3,0x1002,-1,0x0)= 672927744 > (0x281c1000) > geteuid()= 1048 (0x418) > getuid() = 1048 (0x418) > getegid()= 1048 (0x418) > getgid() = 1048 (0x418) > open("/var/run/ld-elf.so.hints",0,00)= 3 (0x3) > read(0x3,0xbfbffaa4,0x80)= 128 (0x80) > lseek(3,0x80,0) = 128 (0x80) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Query Acting Weird
Adam Douglas schrieb am Donnerstag, 2. August 2001, 19:14:15: > I have a group of 3 queries that's used to find our representative for > Unitary, Applied and Wholesale based on a Zip Code. This all is executed > through PHP to MySQL. The three queries work fine and get the results I > want. The problem is the 3 queries seem to work one minute but not the next. > You could enter say 3 or 4 zip codes and have it return results with no > problem, but on the 5 try it will crap out. This seems to be random, one > minute it wouldn't work on the first try and then the next it will. When the > 3 queries crap out it renders MySQL useless, you can send or do any thing to > MySQL when the 3 queries crap out. It puts my CPU usage to 99.0% and stays > roughly there forever. I've left the query running for more then 8 hours and > still nothing seems to be returned. Can anyone direct me in the right > direction on how to resolve this problem? I didn't have a look at your code as I don't think it is probable that you will have a problem here. These days, I am hunting problems similarly weird. I'm looking into faulty hardware now. Yesterday, we changed 2 of the 3 128 MB RAM modules, which has reduced problem frequency from 30 minutes to 10 hours. We see from hostname.err that the problem occurs exactly when the log records 010802 22:35:30 Aborted connection 231 to db: 'pferdezeitung' user: 'pferdezeitung' host: `localhost' (Got an error writing communication packets) So we will replace the 3rd module or all three to see what will happen then. It might be the hard disk, though, or the controller, or something else. Also, it may be a good idea to look at the hostname.log to see what mysql does when running wild. I did this to test queries that seemingly produced errors, but when reproduced, they did not, so this was proof that neither the query nor the data had problems. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Version question...
True, but his question was about Windows NT Server. -Original Message- From: Sommai Fongnamthip [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 02, 2001 2:16 AM To: Gerald R. Jensen; Garth Hansen; [EMAIL PROTECTED] Subject:Re: Version question... 3.23.40 is stable on Linux too. At 18:46 1/8/2001 -0500, Gerald R. Jensen wrote: >Garth: > >I would go for the current version (3.23.39a). > >The current version went on the stable list a long time ago, and has a >boat-load of function/featur eimprovements that either did not exist in >3.22.xx or were not fine-tuned to the extent they are in the current stuff. > >Gerald Jensen > >- Original Message - >From: "Garth Hansen" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Wednesday, August 01, 2001 3:29 PM >Subject: Version question... > > >Quick question for everyone > >Which is the most stable version of MySQL for Windows NT Server version 4.0 >SP6? >I have conflicting information as to which is more stable, and want to be >sure I use the most appropriate version for what we are trying to do. > >Also, if there is some major reasons to go with one version over another, >please let me know! > >Thanks tons in advance! > >Garth > > > >- >Garth Hansen Cognitive Concepts >Network Engineer 990 Grove Street >Suite 300 > (847) 570-3617 voice Evanston, IL 60201 >(847) 328-5881 fax >http://www.earobics.com >[EMAIL PROTECTED] > > >- >Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > >- >Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 problem
Hi, I'm trying to compile MySQL 3.23.40 on Solaris 7 (Intel platform) machine. I extracted and configured the source but when I tried to run "make" there was the follwoing error: In file included from mysql.cc:28: ../include/global.h:646: warning: abstract declarator used as declaration *** Error code 1 make: Fatal error: Command failed for target `mysql.o' Current working directory /usr/local/sources/mysql-3.23.40/client *** Error code 1 make: Fatal error: Command failed for target `all-recursive' Current working directory /usr/local/sources/mysql-3.23.40 *** Error code 1 make: Fatal error: Command failed for target `all-recursive-am' Can anyone help me? Sophokles - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 selecting something that occurred in past 5 minutes
Mark R. Cervarich schrieb am Freitag, 3. August 2001, 03:33:44: > On 2 Aug 2001 [EMAIL PROTECTED] wrote: >> 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: >> >> database,sql,query,table >> >> 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. You have written the following: >> >> >> Part I >> == >> >> I'm setting up a cron job and want to be able to get records that have >> been accessed in the past X number of minutes. >> >> >> I tried doing this: >> >> SELECT postcard.uniq_id, (now() - accesstime) as smalldiff, >> recipients_last_name, accesstime >> FROM postcard >> HAVING (smalldiff <=500) and (smalldiff >= 0); >> >> and it sorta works. (By tinkering I've found out that each minute is >> equal to 100 'ticks'(?) - so in the example above, 5min = 500. >> But it fails if the event occurred at 4:47pm and now it's 5:02pm. ??? how did you define that field? I hope you defined accesstime as timestamp. Read on the definition of timestamp fields. >> Anyway, I'm sure there has to be a better way to do this...please help >> me! >> >> Also, what about in past 30minutes, past hour, past 6 hours, etc. >> >> >> Part II >> === >> How can I get a count of this - meaning I only want outputted a number >> that corresponds to how many uniq.id's have been accessed in past X >> time period. >> >> SELECT postcard.uniq_id, (now() - accesstime) as smalldiff, >> recipients_last_name, accesstime >> FROM postcard >> HAVING (smalldiff <=500) and (smalldiff >= 0); look for count(*) as ... in the manual. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: confirm unsubscribe from mysql@lists.mysql.com
HI, I've tried to unsuscribe myself from this list but I am still getting lots of mails! Can you help me please? Cheers, CHris. -- email: [EMAIL PROTECTED] mobile: 07944 042924 icq: 24960908 > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: 02 August 2001 18:07 > To: [EMAIL PROTECTED] > Subject: confirm unsubscribe from [EMAIL PROTECTED] > > > Hi! This is the ezmlm program. I'm managing the > [EMAIL PROTECTED] mailing list. > > To confirm that you would like > >[EMAIL PROTECTED] > > removed from the mysql mailing list, please send an empty reply > to this address: > > > [EMAIL PROTECTED] > > Usually, this happens when you just hit the "reply" button. > If this does not work, simply copy the address and paste it into > the "To:" field of a new message. > > I haven't checked whether your address is currently on the mailing list. > To see what address you used to subscribe, look at the messages you are > receiving from the mailing list. Each message has your address hidden > inside its return path; for example, [EMAIL PROTECTED] receives messages > with return path: [EMAIL PROTECTED] > > Some mail programs are broken and cannot handle long addresses. If you > cannot reply to this request, instead send a message to > <[EMAIL PROTECTED]> and put the entire address listed above > into the "Subject:" line. > > > --- Administrative commands for the mysql list --- > > I can handle administrative requests automatically. Please > do not send them to the list address! Instead, send > your message to the correct command address: > > To subscribe to the list, send a message to: ><[EMAIL PROTECTED]> > > To remove your address from the list, send a message to the address > in the "List-Unsubscribe" header of messages from the list. If you don't > know how to display headers and haven't changed E-mail addresses since > subscribing, you'll be successful with an e-mail to: ><[EMAIL PROTECTED]> > > Send mail to the following for info and FAQ for this list: ><[EMAIL PROTECTED]> ><[EMAIL PROTECTED]> > > Similar addresses exist for the digest list: ><[EMAIL PROTECTED]> ><[EMAIL PROTECTED]> > > To get messages 123 through 145 (a maximum of 100 per request), mail: ><[EMAIL PROTECTED]> > > To get an index with subject and author for messages 123-456 , mail: ><[EMAIL PROTECTED]> > > They are always returned as sets of 100, max 2000 per request, > so you'll actually get 100-499. > > To receive all messages with the same subject as message 12345, > send an empty message to: ><[EMAIL PROTECTED]> > > The messages do not really need to be empty, but I will ignore > their content. Only the ADDRESS you send to is important. > > You can start a subscription for an alternate address, > for example "[EMAIL PROTECTED]", just add a hyphen and your > address (with '=' instead of '@') after the command word: > <[EMAIL PROTECTED]> > > To stop subscription for this address, mail: > <[EMAIL PROTECTED]> > > In both cases, I'll send a confirmation message to that address. When > you receive it, simply reply to it to complete your subscription. > > If despite following these instructions, you do not get the > desired results, please contact my owner at > [EMAIL PROTECTED] Please be patient, my owner is a > lot slower than I am ;-) > > --- Enclosed is a copy of the request I received. > > Return-Path: <[EMAIL PROTECTED]> > Received: (qmail 15884 invoked from network); 2 Aug 2001 17:06:33 - > Received: from tvout.mail.uk.easynet.net (194.6.96.5) > by www.mysql.com with SMTP; 2 Aug 2001 17:06:33 - > Received: from tank (mantissanet-2.dsl1.easynet.co.uk [212.135.28.194]) > by tvout.mail.uk.easynet.net (Postfix) with SMTP id 1EED963A79 > for <[EMAIL PROTECTED]>; Thu, 2 Aug 2001 > 18:10:52 +0100 (BST) > From: "Chris Toynbee" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Subject: [EMAIL PROTECTED] > Date: Thu, 2 Aug 2001 18:11:03 +0100 > Message-ID: <[EMAIL PROTECTED]> > MIME-Version: 1.0 > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: 7bit > X-Priority: 3 (Normal) > X-MSMail-Priority: Normal > X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) > Importance: Normal > X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Databases on Removable Media?
Gerald R. Jensen schrieb am Freitag, 3. August 2001, 02:51:36: > Is it possible to create mulitple database directories ... with one of them > on a CD-ROM? As far as I know, you can spread your data physically to different locations and different media. You will find information on this question in the manual. How about giving it a try? You will find out immediately. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to Know if DBD is installed ?
Hello How is possible to know if the DBD (for Perl Interface) is already installed in Mysql ? Is there a way to install it , after MySQL is installed ? Regards Claudemir F. Martins - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Access to MySQL Column Type Error
Hi ! Can you send me the ODBC trace ? Thanks in advance venu > -Original Message- > From: Adam Douglas [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 02, 2001 10:52 AM > To: '[EMAIL PROTECTED]' > Subject: Access to MySQL Column Type Error > > > I'm trying to do an append query in Access to MySQL on CompanyRep table. > BTW, I'm using MyODBC to allow connectivity between MS-Access and > MySQL. Now > I've done many queries like this with no problem. For some reason this > append query will not work anymore. I get the following error message > > "Microsoft Access can't append all the records to the table" > > "Microsoft Access set 148 field(s) to Null due to a type > conversion failure, > and it didn't add 0 record(s) due to key violations, 0 record(s) > due to lock > violation, and 0 record(s) due to validation rule violations." > > This error seems to occur only on the Fax_Machine_ID field based on what I > see missing for data in MySQL. Any help would be greatly appreciated, > thanks! > > Schema for Fac_Machine_ID field on Access... > ++--+--+-+-+-- > -- > + > | Field | Date_Type| Null | Key | Default | Extra > | > ++--+--+-+-+-- > -- > + > | Fax_Machine_ID | text(4)| YES | | NULL| > | > ++--+--+-+-+-- > -- > + > > Schema for Fax_Machine_ID field on MySQL... > > ++--+--+-+-+-- > -- > + > | Field | Type | Null | Key | Default | Extra > | > ++--+--+-+-+-- > -- > + > | Fax_Machine_ID | varchar(4) | YES | | NULL| > | > ++--+--+-+-+-- > -- > + > > Specs... > > Microsoft Windows Side > -- > Microsoft Access 2000 (9.0.3821 SR-1) > > OpenBSD v2.8 Side > -- > MySQL (unix) v3.22.32 > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
password for root
Hi, I installed mysql, and found root can login without a password. So I checked mysql manual and setup a password for root. However, according to the manual, I need to type another commond: "flush privileges;" I don't undersdant why should I do this. Any one can give me a hint? Alex - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Table LOCKING
Thanks Gerald, I finally figured that out, from what I understand, when locking and the given table is set to 'WRITE' this includes 'READ' too. so I only needed to use the table once :) Cheers, >>On Fri, 03 Aug 2001 14:31:00 -0500, Gerald Clark <[EMAIL PROTECTED]> > wrote: >> >>> Hi All, >>> >>> Was hoping some one maybe able to explain this error when attempting to LOCK >>> MySQL tables for READ and WRITE: >>> >>> Error Encountered: >>> Unable to LOCK tables. >>> >>> Error: Not unique table/alias: 'members' >>> >>> The correct database has been connected to, and the members table is a valid >>> table. It's executed via Perl coding: >>> $dbh->do("LOCK TABLES members READ, members WRITE, optin WRITE"); >>> >>> is this syntax incorrect?? >> >>No. You included members twice. Thus, it is not unique. >>If you are going to write to it use write, otherwise use read. Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
LOAD tblname FROM MASTER (slave)
I saw this command listed on http://www.mysql.com/doc/R/e/Replication_SQL.html LOAD TABLE tblname FROM MASTER However, the same command is not listed on: http://www.mysql.com/doc/L/O/ Is the command very new, because it doesn't seem to work: mysql> load table sessions from master; ERROR 1189: Net error reading from master Is it possible to start off replication this way, without having to down the master and to grab a snapshot? If it is supposed to work, what could be a possible reason for that error? The slave is running 3.23.40 and the master is running 3.23.39, in case that makes any difference. Ollie -- Oliver CookSystems Administrator, ClaraNET [EMAIL PROTECTED] 020 7903 3065 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Select
just out of curiousity, was there a particular advantage to you using varchar as opposed to date for the column type? because if so it would be a lot easier to manipulate that date.. you could calculate differences in dates, get portions of the date, and all sorts of other nice things if it were a date column... ~shawn On Thu, 2 Aug 2001, Augusto Cesar Castoldi wrote: > HelpHi. > > I have a colun in my table for the birthday.: "DD/MM/". It's varchar. > > In PHP, I can get the month of date, bu substr($date, 3, 2). (MM) > > Can I do a select with %LIKE% but saying the position of the varchar I want to find? > > thanks. > > Augusto > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 3.23.39 slower that 3.22.27?
We've upgraded from 3.22.27 to 3.23.39 to utilise replication but have found that this version is significantly slower that our old version (we haven't switched replication on yet either). Has anyone else noticed this or have any suggestions to improve performance. We upgraded MySQLdb from MySQLdb-0.1.2 to MySQL-python-0.9.0 and Python from 2.0 to 2.1 at the same time but we don't think it's these. When we're running a quite large series of updates the CPU usage is at 90ish% but memory seems ok. We're running on Linux - Red Hat Linux release 6.2 (Zoot) Kernel 2.2.14-5.0 on an i686. Any suggestions gratefully accepted:-) Many thanks Liz - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ALTER TABLE question
Hi people with far more knowledge than myself, I have recently started making use of MySQL on a virtual server provided by my ISP. I can telnet into the server using SSH Telnet, log in to my database, create tables and populate those tables. When I try to alter the field definitions of a table however, I get the following message - Access denied for user: '[EMAIL PROTECTED]' to database 'chrisdb' The query used to add some fields to an already created table called "question" is as follows - ALTER TABLE question ADD NumberOfStaff VARCHAR (20) , ADD PortfolioProducts TEXT , ADD PortfolioClients TEXT , ADD AdditionalInfo TEXT Whether I use the command line to write the query, or a front end such as MySQLFront (which, incidentally, I think is great!!) or even using phpMyAdmin I still get the same response. Anyone with any ideas as to why this should be the case? All help greatly appreciated in advance :-) Regards, Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 + dns server?
on 8/3/01 9:20 AM, Kyle Hayes at [EMAIL PROTECTED] wrote: > I went though the online docs for dbjdns and didn't really see anything that > looked like it would talk to MySQL. DBJ likes to use his CDB code for a lot > of his projects. Is there a FAQ or page I missed? my bad. the reason djbdns popped into my head is that at work we considered using djbdns to solve this problem because its file format is so easy to read/write. we contemplated writing some interface between the zone files and a mysql db. sorry :) mike -- mike cullerton - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [MySQL] Database size
I hate to ask this on the list, but I have tried everything to unsubscribe and nothing works. Any suggestions? Thanks. -Original Message- From: TIGNAC BRUNO <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Friday, August 03, 2001 11:00 AM Subject: [MySQL] Database size >--- Reçu de CMB.TIGNABR 0298426574 03-08-01 17.21 > >Hello, > >I plan to use MySQL/InnoDB to store about 13 GB of data, into 40 tables. One >of the tables is over 5 GB, and a second over 1,5 GB. Do you think I can use >MySQL/InnoDB ? > >Thank you. > >Bruno Tignac > > 03-08-01 17.21 Envoyé - > -> mysql(a)lists.mysql.com > >-- >Ce message et toutes les pieces jointes (ci-apres le "message") sont >confidentiels et etablis a l'intention exclusive de ses destinataires. >Toute utilisation ou diffusion non autorisee est interdite. Tout >message etant susceptible d'alteration, l'emetteur decline toute >responsabilite au titre de ce message s'il a ete altere, deforme ou >falsifie. >--- >This message and any attachments (the "message") are confidential and >intended solely for the addressees. Any unauthorised use or >dissemination is prohibited. As e-mails are susceptible to alteration, >the issuer shall not be liable for the message if altered, changed >or falsified. > > > >- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >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: Crazy Threads
Chris Hilbert schrieb am Donnerstag, 2. August 2001, 12:54:55: > Its seems like the only way to watch the process list would be to do > something like mysqladmin -uroot -i 1 processlist. Since I can't show > processlist when it won't connect to it (I tried to do it while it was > dead). Still, this would consume a lot of resource and might not even > work right...since I'd technically have to wait an hour or so for it to > crash. > Any other ideas? You could watch the log file and error log. Those grow pretty big very fast, so you could rename the old ones and start new ones. Data from an hour should be easy to manage. Hence you will see exactly what mysql does and what kind of errors occur, if any. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 and CharSets
Hi, I import a CSV file into MySQL using LOAD DATA INFILE. That's no problem. The problem is the textfile contains German umlauts. When I query the table with MySQL-program on the console (SQL monitor) it even works fine. But when I output in PHP it only shows the correct characters if I send header header("Content-type: text/html; charset=IBM850"); I don't want to use charset IBM850 but ISO-8859-1. How to convert the umlauts. Why are they different in both charsets? Best regards Bernhard Doebler - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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't find error mesage file
>Description: I get the message bin/mysqld: Fatal error: Can't find messagefile '/usr/local/mysql/share/mysql/english/errmsg.sys' when I try to start mysqld. Note that my mysql is *not* under /usr/local, which might have something to do with it. (The problem is that I don't get an error message, by the way; why there is an error in the first place is probably a fault of my own.) >How-To-Repeat: No idea. I'm sorry. >Fix: >Submitter-Id: >Originator: >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: Can't find error mesage file >Severity: >Priority: >Category: mysql >Class: sw-bug >Release: mysql-3.23.39 (Official MySQL RPM) >Environment: System: Linux misan 2.2.14-5.0 #1 Tue Mar 7 21:07:39 EST 2000 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/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='egcs' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='egcs' CXXFLAGS='-O6 -fno-omit-frame-pointer-felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Jun 1 2000 /lib/libc.so.6 -> libc-2.1.3.so -rwxr-xr-x1 root root 4101324 Feb 29 2000 /lib/libc-2.1.3.so -rw-r--r--1 root root 20272704 Feb 29 2000 /usr/lib/libc.a -rw-r--r--1 root root 178 Feb 29 2000 /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 --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/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' Perl: This is perl, version 5.005_03 built for i386-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: State: "Writing to net"
on 8/3/01 10:30 AM, Ravi Raman at [EMAIL PROTECTED] wrote: > what's up with that 30 second pause? > does this look like a network problem to you guys? if it was, why would it > not affect the 'limit 1' query as well? > is there some sort of resource that mysql needs to process the 53000 rows > that it might not have that would cause this? > maybe different tcpdump options are in order for more pertinent information? this is not a network problem. the network is sending the data fine. the sending machine seems to have an issue getting the data to the packets. ianasg (system guy), but i gotta believe there is a way to trace data getting passed around within the system (or kernel). is there a way to watch how mysql (or any process for that matter) tries to get the data to the network stack? -- mike cullerton - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SQL/Table question
How would I select all the tables _names_ in a particular database? Is it possible? i.e. Select table_names from tables; Thanks. Blessings, Mike Revelation 1:8 I am the Alpha and Omega, the Beginning and the Ending, says the Lord, who is and who was and who is to come, the Almighty. -- The Mighty JC
Re: generate database script from existing table?
TKC> Hi TKC> I just took over a mysql database with no documenation. Is there any TKC> tools or anyway I could generate a database/table creation script from TKC> the current database? This is because I need to recreate the database TKC> on another machine and currently I have no way of doing so. mysqldump -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- | Ilya Martynov (http://martynov.org/)| | GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80 E4AE BE1A 53EB 323B DEE6 | | AGAVA Software Company (http://www.agava.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: Dedicated MySQL Application Server
Sorry, I am not sure to understand with 'interfere with any other instance'. I have more table and application in 1 database (in 1 server) which have a lot of database operation in everyday (insert, delete). and I could backup or restore any table in this database whenever I want. If you mean it may be interfere when you need to config MySQL or upgrade, you should plan to do it after working hour or on holiday. SF At 10:35 3/8/2001 +0500, Grigory Bakunov wrote: >Date |Fri, 03 Aug 2001 11:52:00 +0700 > >From |Sommai Fongnamthip <[EMAIL PROTECTED]> > >Hello! > >SF> Why do not use table and user permission separately in 1 database? >Cause problem specification says "I would not want >this database to interfere with any other instance of MySQL that may be >running on the same machine." > >SF> SF > >SF> At 07:41 3/8/2001 +0500, Grigory Bakunov wrote: > >>Date |Thu, 2 Aug 2001 12:56:23 -0700 > >> >From |Bryan Ross <[EMAIL PROTECTED]> > >> > >>Hello! > >> > >>BR> Hi. > >> > >>BR> What I want to do is this: Use mysql as a dedicated database for a > desktop > >>BR> application, meaning that basically there's only one client allowed to > >>BR> connect to it, and that client is the application. Also, I would > not want > >>BR> this database to interfere with any other instance of MySQL that may be > >>BR> running on the same machine. Basically to be completely wrapped and > only > >>BR> accessible by the application. > >> > >>BR> My question is: is there a relatively simple way of doing this? > >> > >>start another mysql daemon with different socket path and configuraton > file. > >>in config file set up new path to databases. > >>Also change priveleges in new server for more secure access. > >> > >>___ > >>For technical support contracts, visit https://order.mysql.com/ > >>This email is sponsored by SWSoft, http://www.asplinux.ru/ > >>__ ___ ___ __ > >> / |/ /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]> > >> / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft > >>/_/ /_/\_, /___/\___\_\___/ > >><___/ 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 > >___ >For technical support contracts, visit https://order.mysql.com/ >This email is sponsored by SWSoft, http://www.asplinux.ru/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft >/_/ /_/\_, /___/\___\_\___/ ><___/ 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: cannot set root mysql password
Hello, On Fri, Aug 03, 2001 at 10:48:55AM +0500, Grigory Bakunov wrote: > No. You need to remove -p from this command line. > So "/usr/bin/mysqladmin -u root password 'new-password'" works like a dream -); > So, this must be corrected on the install script ($bindir/mysql_install_db): - echo "PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !" echo "This is done with:" echo "$bindir/mysqladmin -u root -p password 'new-password'" echo "$bindir/mysqladmin -u root -h $hostname -p password 'new-password'" echo "See the manual for more instructions." - Hugo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How can try to recover the data from mysql
Rupak schrieb am Dienstag, 10. Juli 2001, 10:27:47: > I think my mysql database carsh but I hope there are some utility to > recovered the data crash. read on myisamchk or recovery in the manual. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem
Date |Thu, 2 Aug 2001 06:08:24 -0700 (PDT) >From |makarand yevatekar <[EMAIL PROTECTED]> Hello! MY> I am makarand From Vinayak Computer When i run the the MY> mysql it gives me errot MY> ERROR 2002 : Canat't connect to the local Mysql server MY> through scocket ' /var/lib/mysql/mysql.sock' (111) MY> How to soil the problem MY> makarand yevatekar MY> Project Manager MY> (Vinayak Computers) 1) May be mysql server does'nt started - start your mysql server. 2) May be you don't have access to mysql socket - use chmod and chown command to change permissions to file /var/lib/mysql/mysql.sock ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ <___/ 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: State: "Writing to net"
hi and thanks for the responses. grigory: obviously local connections will be faster...but a query time difference of 2 seconds locally compared to 5 minutes for a machine on the same network (that can scp/ftp a 1 meg file in a few seconds) is a little strange. and at the risk of going offtopic, i'm attempting to track down what the cause of this is and how it could be improved... downloaded and installed tcpdump. as a disclaimer, IANANG. (network guy) ran it: [root@joker sbin]$ tcpdump -n host 10.10.10.31 no significant traffic between the boxes under regular circumstances. for smaller queries: select * from big_table limit 100, or 1000, or even 1, i receive a solid stream of lines like this, the amount obviously depending on the number of rows returned. 12:15:14.209326 10.10.10.12.4289 > 10.10.10.31.3306: . ack 617866 win 27512 (DF) 12:15:14.209427 10.10.10.31.3306 > 10.10.10.12.4289: P 617866:619314(1448) ack 538 win 32120 (DF) when i do a select * from big_table that returns the 53000 rows, i get around 13 lines of output, followed by a pause of almost exactly 30 seconds, then another 13-ish lines. this continues for a lng time. this time, although the query was executed from a different box (still close to the database server) i waited about 15 minutes for the query to complete, but finally killed the query process in mysql before it did. the other limit-ed queries executed in appropriate times...2 seconds, ~8 seconds, ~20 seconds respectively. what's up with that 30 second pause? does this look like a network problem to you guys? if it was, why would it not affect the 'limit 1' query as well? is there some sort of resource that mysql needs to process the 53000 rows that it might not have that would cause this? maybe different tcpdump options are in order for more pertinent information? again, thanks in advance for any ideas you may have. -ravi. -Original Message- From: mike cullerton [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 02, 2001 8:41 PM To: Ravi Raman; [EMAIL PROTECTED] Subject: Re: State: "Writing to net" being a network guy at heart, i'd like to see what tcpdump says is going over the ethernet card (if anything). does there appear to be traffic moving between the two machines, or is it caught in a buffer somewhere and hasn't even made it to the cable. since ftp works well, i'm guessing it isn't the physical network or anything at the ip layer. possibly getting data into the transport (tcp/udp) layer or above that. on 8/2/01 10:19 AM, Ravi Raman at [EMAIL PROTECTED] wrote: > hi. > > quick question... > i have a simple query that returns ~53000 rows. > > when connected to the mysql server from localhost, this query takes about 2 > seconds. > when connected to the mysql server from another box, this query takes about > 3-4 minutes. 'show processlist' shows the query state as "Writing to net" > for the majority of the query time. > these boxes are right next to each other (1 hop) and ftp and scp transfers > between them are quite fast. > > is this a network problem? > the load average on both machines is quite lowthey're running linux and > relatively recent versions of mysql. > what's going on here? > what does the "writing to net" state mean (besides the obvious)? couldn't > find any relevant docs. > > any input is appreciated. > > -ravi -- mike cullerton - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Bug in MySQL-4.0
Fournier Jocelyn [Presence-PC] writes: > Hi, > > I caught a bug in MySQL-4.0, but I don't know how to reproduce it ;) > > Here is the description : > > 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 agaist 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 > > > It seems to be linked with the new mysql union feature, but I don't use UNION in my >code ;) > > > Regards, > > Jocelyn Fournier > Presence-PC > www.presence-pc.com > > If you don't use UNION's, then they can not cause the crash. First check whether may be memory was not overrun. Otherwise, we do need a repeatable test case in order to pinpoint a bug. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /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
No Database Selected /weird behaviour
Errno: 1046 Error: No Database Selected I get this on only one of my sites, on the first query during a connection only, and actually it is an impossible error. All sites are driven by db_mysql.inc from PHPLIB. Therefore, everything is totally automatic, no chance to omit the database name during connect. In fact, when the query returns that error, I jump in between and look for all the parameters, and indeed, they are present, including the database -- nothing else could be expected. If it occurs, it is a simple query SELECT * FROM lgs which will return the languages supported at the time, three right now. Simple table, simple query, three rows, so I guess the problem is not located here. I could hard code that stuff as well, but why? It worked fine for a year. So this is rather interesting indeed. Also, it does no harm as I default to a standard language if the query doesn't work. But I get an email notice, so I know. The rest runs fine, I didn't have problems although I reuse the connection and do a lot of other queries shortly thereafter. I notice this for at least 6 months now. It happens mostly in intervals, say once a day on three days a week. During the last week, the behavior changed slightly. I received thousands of notices during the period of about one or two hours, then things went back to normal. Before, I mostly received tens or at most hundreds of notices. top shows a really funny picture if it happens: typically no httpd, but 20 or more mysqld processes. I had a look at the hostname.log which looked rather normal, issuing queries that ought to be expected during normal page generation. hostname.err shows Number of processes running now: 34 mysqld process hanging, pid 2830 - killed Currently, there is only this client on the machine. Previously, I had another site on the same machine which produced much more load. Back then, I experienced similar problems with processes hanging. Is this a clue to something? What kind of questions could be asked in this situation? -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Dedicated MySQL Application Server
Date |Fri, 03 Aug 2001 11:52:00 +0700 >From |Sommai Fongnamthip <[EMAIL PROTECTED]> Hello! SF> Why do not use table and user permission separately in 1 database? Cause problem specification says "I would not want this database to interfere with any other instance of MySQL that may be running on the same machine." SF> SF SF> At 07:41 3/8/2001 +0500, Grigory Bakunov wrote: >>Date |Thu, 2 Aug 2001 12:56:23 -0700 >> >From |Bryan Ross <[EMAIL PROTECTED]> >> >>Hello! >> >>BR> Hi. >> >>BR> What I want to do is this: Use mysql as a dedicated database for a desktop >>BR> application, meaning that basically there's only one client allowed to >>BR> connect to it, and that client is the application. Also, I would not want >>BR> this database to interfere with any other instance of MySQL that may be >>BR> running on the same machine. Basically to be completely wrapped and only >>BR> accessible by the application. >> >>BR> My question is: is there a relatively simple way of doing this? >> >>start another mysql daemon with different socket path and configuraton file. >>in config file set up new path to databases. >>Also change priveleges in new server for more secure access. >> >>___ >>For technical support contracts, visit https://order.mysql.com/ >>This email is sponsored by SWSoft, http://www.asplinux.ru/ >>__ ___ ___ __ >> / |/ /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]> >> / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft >>/_/ /_/\_, /___/\___\_\___/ >><___/ 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 ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ <___/ 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: Re: MySQL GUI
Hi there, At 17:09 Uhr +0300 3.8.2001, Sinisa Milivojevic wrote: >Michael Collins writes: >> >> >> Sorry I cannot answer to the technical needs of installing this >> application. I think the answer on whether end-users would install >> the requisite components in order to run this application depends on >> whether it is even possible to run the GUI interface within Aqua. >> Would it require someone to boot into the command line or into a >> separate X Windows environment? If that is the case then it will >> perhaps have limited usefulness. Amd there are other tools for >> getting a GUI interface to MySQL. If it can run off the command line >> from the terminal and the tools to do so are on the developers CD >> then I think it would be used. There would just need to be some >> instructions showing what and how to install what is needed. >> -- >> Michael > >No, that is not so. > >As I have already told you there is a port of FLTK to native Mac GUI. Yup, but that is for the "old" Classic Mac OS, right? I looked around and did not find a port that runs directly on the Aqua UI, which is what would be needed to run this software. -- _ Marc Liyanage [EMAIL PROTECTED] http://www.entropy.ch ICQ 5077985 Yoda I am. Grammar I can't. _ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 selecting something that occurred in past 5 minutes
On 2 Aug 2001 [EMAIL PROTECTED] wrote: > 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: > > database,sql,query,table > > 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. You have written the following: > > > Part I > == > > I'm setting up a cron job and want to be able to get records that have > been accessed in the past X number of minutes. > > > I tried doing this: > > SELECT postcard.uniq_id, (now() - accesstime) as smalldiff, > recipients_last_name, accesstime > FROM postcard > HAVING (smalldiff <=500) and (smalldiff >= 0); > > and it sorta works. (By tinkering I've found out that each minute is > equal to 100 'ticks'(?) - so in the example above, 5min = 500. > But it fails if the event occurred at 4:47pm and now it's 5:02pm. > > Anyway, I'm sure there has to be a better way to do this...please help > me! > > Also, what about in past 30minutes, past hour, past 6 hours, etc. > > > Part II > === > How can I get a count of this - meaning I only want outputted a number > that corresponds to how many uniq.id's have been accessed in past X > time period. > > SELECT postcard.uniq_id, (now() - accesstime) as smalldiff, > recipients_last_name, accesstime > FROM postcard > HAVING (smalldiff <=500) and (smalldiff >= 0); > > > thanks a lot. > mark > Mark R. Cervarich Shelfspace.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: Auto Startup failed - Mysql deamon
Date |Fri, 3 Aug 2001 12:07:15 +0800 >From |"TestMonster" <[EMAIL PROTECTED]> Hello! T> Hi T> I've followed exactly every step lin the README. T> 1. cp ./support-files/mysql.server to /etc/rc.d/ T> 2. create link /etc/rc0.d/S01mysql to /etc/rc.d/mysql.server T> 3. create link /etc/rc3.d/S99mysql to /etc/rc.d/mysql.server T> But the mysql deamon still can't start automatically during bootup. T> I have no more idea how to trouble-shoot it. T> Any comment would be greatly appreciated :-) T> regards, T> David Try to start up mysql.server manualy ? It's work ? ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ <___/ 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: Searching in a mysql table
I hope i'm asking in the right place, as i've asked around alot and haven't gotten an answer. Would it be inefficient to use the command "SELECT * FROM users_info WHERE name LIKE "%phil%" and company like "%" and address like "%";" Note the single % by itself. Would this slow down the system considerably, or would it be roughly the same amount of cpu usage as if i had just left everything but the name LIKE phil out? Thanks guys, i'm kinda new at sql so i'm hoping you might be able to help :) Joe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Kernel crash caused by mysql?
Mario Witte wrote: > > Tonight one of our database servers died, though it din't have any > special load at that time. The following output could be found in > /var/log/warn: > > Aug 3 04:58:57 db2 kernel: Unable to handle kernel paging request at > virtual address 6dad7220 > Aug 3 04:58:57 db2 kernel: printing eip: > Aug 3 04:58:57 db2 kernel: c013195b > Aug 3 04:58:57 db2 kernel: *pde = > Aug 3 04:58:57 db2 kernel: Oops: 0002 > Aug 3 04:58:57 db2 kernel: CPU:0 > Aug 3 04:58:57 db2 kernel: EIP:0010:[__insert_into_lru_list+59/92] > Aug 3 04:58:57 db2 kernel: EFLAGS: 00010282 > Aug 3 04:58:57 db2 kernel: eax: 6dad7200 ebx: 0002 ecx: > c912db00 edx: 0008 > Aug 3 04:58:57 db2 kernel: esi: c912db00 edi: 0001 ebp: > e4015640 esp: d392bedc > Aug 3 04:58:57 db2 kernel: ds: 0018 es: 0018 ss: 0018 > Aug 3 04:58:57 db2 kernel: Process mysqld (pid: 26237, > stackpage=d392b000) > Aug 3 04:58:57 db2 kernel: Stack: c01324ef c912db00 0002 c912db00 > 1000 c0132502 c912db00 c0132ebb > Aug 3 04:58:57 db2 kernel:c912db00 e4015640 00256800 > c13d3e0c c912db00 1000 > Aug 3 04:58:57 db2 kernel:c0133598 e4015640 c13d3e0c 0400 > 0800 c13d3e0c 0800 00256400 > Aug 3 04:58:57 db2 kernel: Call Trace: [__refile_buffer+91/100] > [refile_buffer+10/16] [__block_commit_write+123/208] > [generic_commit_write+52/148] [geneAug 3 04:58:57 db2 kernel: > Aug 3 04:58:57 db2 kernel: Code: 89 48 20 8b 82 cc 58 31 c0 89 48 24 ff > 82 dc 58 31 c0 31 c0 > Aug 3 04:58:57 db2 kernel: Unable to handle kernel paging request at > virtual address 6dad7220 > Aug 3 04:58:57 db2 kernel: printing eip: > Aug 3 04:58:57 db2 kernel: c013195b > Aug 3 04:58:57 db2 kernel: *pde = > Aug 3 04:58:57 db2 kernel: Oops: 0002 > Aug 3 04:58:57 db2 kernel: CPU:0 > Aug 3 04:58:57 db2 kernel: EIP:0010:[__insert_into_lru_list+59/92] > Aug 3 04:58:57 db2 kernel: EFLAGS: 00010282 > Aug 3 04:58:57 db2 kernel: eax: 6dad7200 ebx: 0002 ecx: > c61df980 edx: 0008 > Aug 3 04:58:57 db2 kernel: esi: c61df980 edi: 0001 ebp: > eea49be0 esp: ee565ed8 > Aug 3 04:58:57 db2 kernel: ds: 0018 es: 0018 ss: 0018 > Aug 3 04:58:57 db2 kernel: Process mysqld (pid: 451, > stackpage=ee565000) > Aug 3 04:58:57 db2 kernel: Stack: c01324ef c61df980 0002 c61df980 > 1000 c0132502 c61df980 c0132ebb > Aug 3 04:58:57 db2 kernel:c61df980 eea49be0 0039fc29 > c114e428 c61df980 1000 > Aug 3 04:58:57 db2 kernel:c0133598 eea49be0 c114e428 0b32 > 0c29 c114e428 0c29 0039fb32 > Aug 3 04:58:57 db2 kernel: Call Trace: [__refile_buffer+91/100] > [refile_buffer+10/16] [__block_commit_write+123/208] > [generic_commit_write+52/148] [geneAug 3 04:58:57 db2 kernel: > Aug 3 04:58:57 db2 kernel: Code: 89 48 20 8b 82 cc 58 31 c0 89 48 24 ff > 82 dc 58 31 c0 31 c0 > > Though the system wasn't completely dead at that time. Hours later I was > able to log into the system via ssh, but most commands (e.g. "ps ax" or > "killall mysqld" didn't complete but died, killing of my shell). As a > last resort I did a "reboot" which caused the kernel to spit out > neverending stack trace. A hard reboot plus a manual fsck solved the > problem. > > Does anybody have an idea, if mysqld caused this crash? In fact there > are no other services running on the system and it had been running for > weeks without any problems. > > Any help is appreciated, > With regards, > -- > Mario Witte <[EMAIL PROTECTED]> Mario: Memory or motherboard. How many sticks of RAM do you have in the machine? Are they the same speed (p100/p133, etc.)? What kind of motherboard? Is updatedb running at this time? (might be a hard-drive croaking while trying to update the locate database). Seems I'm pointing to hardware, here. Point is, I have one machine among my tribe of 10 who does this kind of thing to my kernel from time-to-time. Pima has something nasty happening to his hardware situation and dies running setiathome randomly. He's been running 57+ days, but that doesn't mean he's all there. Couple screws loose somewhere. Scared of clowns, or something. Seems your machine might have a wrong hardware component somewhere. I'd check it out if it's a production machine. mysqld can't run as the only service. You can't run anything without initd. Hope that helps. Regards, Van -- = Linux rocks!!! http://www.dedserius.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
RE: Error during make process on mySQL 3.23.40
hi. find ar...add it to your path..something like: PATH=$PATH:/usr/sbin export PATH type make again. hth. -ravi -Original Message- From: Alex Cook [mailto:[EMAIL PROTECTED]] Sent: Friday, August 03, 2001 2:19 PM To: '[EMAIL PROTECTED]' Subject: Error during make process on mySQL 3.23.40 ok, I'm running a Solaris 8 SPARC box, and I configure with: ./configure --enable-thread-safe-client --enable-shared --prefix=/usr2/mysql --enable-user=acook I then run make, use GNU make, and get: ar cru libreadline.a readline.o funmap.o keymaps.o vi_mode.o parens.o rltty.o co mplete.o bind.o isearch.o display.o signals.o util.o kill.o undo.o macro.o input .o callback.o terminal.o xmalloc.o history.o histsearch.o histexpand.o histfile. o nls.o search.o shell.o tilde.o make[2]: ar: Command not found make[2]: *** [libreadline.a] Error 127 make[2]: Leaving directory `/usr2/people/acook/mysql-3.23.40/readline' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr2/people/acook/mysql-3.23.40' make: *** [all-recursive-am] Error 2 Is there a different make then the GNU one I should use for the ar command, or is this a mySQL bug... pardon the newbie type question, but I'm a little stumped... -ALEX Web Designer, LibertyLiveWire 323-603-2118 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Thinking of switching from MyISAM to InnoDB
Apparentlly there's a 4 GB limit to a MyISAM file when the table it contains has VARCHAR, TEXT, or BLOB columns. In order to get around this limitation I was looking to switching to InnoDB table types. As this looks like a relatively new subsystem I'm wondering if it is stable enough for production systems, or is it still too new (and too "feature-prone".) I'd appreciate hearing feedback on this. If I do wind up switching, it won't be for at least a month. TiA, nick Nick Seidenman, CISSP Director of Software Development Hyperon, Inc. www.hyperon.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
newbie: installing mysql
These are the softwares on the sever I'm using: Apache/1.3.12 Cobalt (Unix) mod_ssl/2.6.4 OpenSSL/0.9.5a PHP/4.0.1pl2 mod_auth_pam/1.0a FrontPage/4.0.4.3 mod_perl/1.24 Which of these should I be mysql installing: a.. HP-UX 10.20 [hp-hpux10.20-hppa1.1] b.. IBM AIX (PowerPC) [ibm-aix4.3.3.0-rs6000] c.. Linux (Intel libc6 systems) [pc-linux-gnu-i686] d.. SCO OpenServer (Intel) [pc-sco3.2v5.0.6-i386] e.. SCO UnixWare (Intel) [sco-sysv5uw7.1.0-i386] f.. SCO UnixWare (Intel) [sco-sysv5uw7.1.0-i386-lcudk70] g.. SGI Irix [sgi-irix6.5-mips] h.. Sun Solaris (Sparc) [sun-solaris2.7-sparc] (Use GNU Tar) i.. FreeBSD ELF (Intel) [unknown-freebsdelf4.3-i386] Actually, I don't own the server, and I need tot ell the person who owns it to install it..\ 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: MySQL Client Software
Dear Faiz, try PhpMyAdmin. You can find it here: www.phpmyadmin.com. This is a browser based graphical interface - so it will work everywhere (Win, Linux, Intranet, local machine, web, ...). Well, you need to have PHP and a webserver installed on the machine where PhpMyAdmin runs. You can find a setup.exe for all 3 (PHP, MySQL, and Apache webserver) here: http://sourceforge.net/projects/phptriad/ Regards, --- Faiz Khan <[EMAIL PROTECTED]> wrote: > Hi there, > > I am having problem finding "MySQL Client software" to connect to Web > Hosts > server so i can create tables and run queries at their server > remotely. I am > running windows so any related softwares would be great help. > > Please reply soon as i need to proceed on project and really need > aforementioned piece of software... > > Thanks, > Faiz > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > = --- Stefan Hinz <[EMAIL PROTECTED]> iConnect e-commerce solutions GmbH, 13355 Berlin Office: +49 30 46307-382 Mobil: +49 177 7841069 Antwortadresse dieser E-Mail: <[EMAIL PROTECTED]> BITTE NUR IN DRINGENDEN FÄLLEN AN DIESE ADRESSE ANTWORTEN! --- __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error during make process on mySQL 3.23.40
ok, I'm running a Solaris 8 SPARC box, and I configure with: ./configure --enable-thread-safe-client --enable-shared --prefix=/usr2/mysql --enable-user=acook I then run make, use GNU make, and get: ar cru libreadline.a readline.o funmap.o keymaps.o vi_mode.o parens.o rltty.o co mplete.o bind.o isearch.o display.o signals.o util.o kill.o undo.o macro.o input .o callback.o terminal.o xmalloc.o history.o histsearch.o histexpand.o histfile. o nls.o search.o shell.o tilde.o make[2]: ar: Command not found make[2]: *** [libreadline.a] Error 127 make[2]: Leaving directory `/usr2/people/acook/mysql-3.23.40/readline' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr2/people/acook/mysql-3.23.40' make: *** [all-recursive-am] Error 2 Is there a different make then the GNU one I should use for the ar command, or is this a mySQL bug... pardon the newbie type question, but I'm a little stumped... -ALEX Web Designer, LibertyLiveWire 323-603-2118 [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: ALTER TABLE question
on 8/2/01 9:55 AM, Chris Malloch at [EMAIL PROTECTED] wrote: > Hi people with far more knowledge than myself, > > I have recently started making use of MySQL on a virtual server provided by > my ISP. I can telnet into the server using SSH Telnet, log in to my > database, create tables and populate those tables. When I try to alter the > field definitions of a table however, I get the following message - > > Access denied for user: '[EMAIL PROTECTED]' to database 'chrisdb' > > The query used to add some fields to an already created table called > "question" is as follows - > > ALTER TABLE question ADD NumberOfStaff VARCHAR (20) , ADD PortfolioProducts > TEXT , ADD PortfolioClients TEXT , ADD AdditionalInfo TEXT it appears that your isp needs to turn on 'alter_priv' permission for user '[EMAIL PROTECTED]' on database 'chrisdb'. it's odd that they turned on create and insert but not alter. one solution you can use is to dump the table to a file mysqldump --add-drop-table chrisdb question > somefile.dump then edit the file and use it to reload the table mysql chrisdb < somefile.dump (these examples work on unix, ymmv) hope this helps, mike -- mike cullerton - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: myodbc from windoze to unix
Dear Glyndower, > "All remote db connections are blocked so This says it! You are not allowed to connect to the database server from anywhere else but from localhost. Try: GRANT ALL ON *.* TO me_as_odbc_user@% IDENTIFIED BY "my_password" This will grant access to me_as_odbc_user from everywhere (which is a security problem). If your Windoze machine has the IP "62.122.22.33", better take "me_as_odbc_user@"62.122.22.33" instead of "%" (= all). Hope it helps. Regards, --- Glyndower <[EMAIL PROTECTED]> wrote: > This is the email I recieved from tech support of the host i'm using, > in > reference to using MyOdbcand MyAccess to connect from Access on a > windoze > machine to MySql on a unix machine. > > "All remote db connections are blocked so > phpmyadmin or using ssh to connection (secure telnet) is the two > database > admin methods available." > > Any help for this out there? > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > = --- Stefan Hinz <[EMAIL PROTECTED]> iConnect e-commerce solutions GmbH, 13355 Berlin Office: +49 30 46307-382 Mobil: +49 177 7841069 Antwortadresse dieser E-Mail: <[EMAIL PROTECTED]> BITTE NUR IN DRINGENDEN FÄLLEN AN DIESE ADRESSE ANTWORTEN! --- __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: jdbc - tcp/unixsockets
> -Original Message- > From: kieran buckley [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 03, 2001 10:29 AM > To: [EMAIL PROTECTED] > Subject: RE: jdbc - tcp/unixsockets > > > Venu...lifesaver!! > thanks very much, > kieran You, welcome.. venu > > >> Original Message << > > On 8/3/01, 4:39:49 PM, Venu <[EMAIL PROTECTED]> wrote regarding RE: jdbc - > tcp/unixsockets: > > > > Hi ! > > > -Original Message- > > > From: kieran buckley [mailto:[EMAIL PROTECTED]] > > > Sent: Friday, August 03, 2001 5:17 AM > > > To: [EMAIL PROTECTED] > > > Subject: jdbc - tcp/unixsockets > > > > > > > > > hi , > > > i'm writing a simple java program that i want to access mysql with. > > > the error i'm getting is : > > > > > > "Server configuration denies access to data source" > > > the code is : > > > String url = "jdbc:mysql://localhost:3306/mysql"; > > > Connection con; > > > String query = "SELECT Teacher FROM TimeTable"; > > > Statement stmt; > > > > > > try{ > > > Class.forName( > > > "org.gjt.mm.mysql.Driver").newInstance(); > > > // Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); > > > > > > }catch(ClassNotFoundException e){ > > > System.err.print("ClassNotFoundException: "); > > > System.err.println(e.getMessage()); > > > } > > > catch (Exception E) { > > > System.err.println("Unable to load driver."); > > > E.printStackTrace(); > > > } > > > > > > try{ > > > > > > System.out.println("about to .."); > > > con = DriverManager.getConnection(url,"root", > > > ""); > > > System.out.println("ok"); > > > stmt = con.createStatement(); > > > > > > > > > i can connect via command line no problem to mysql. i downloaded the > > > mysqlgui form mysql.com and by it will only connect using the > UNIX socket > > > ie.not the port number alone (3306). > > > mysqladmin -version says the connection type is UNIX socket, is a tcp > > > connection taken for granted or should it say so? > > > do i have to change some connection parameters to allow connection > > > through tcp ports - any suggestions very welcome. > > > thanks in advance, > > > kieran > > > mysql version 10.8 Distrib 3.23.22-beta > > > mm.mysql.jdbc-1.2c > > > java1.3 > > > linux 7.0 > > > > Please check the following link for work around solution, and > let us know > > whether it helps you or not. > > > http://lists.mysql.com/cgi-ez/ezmlm-cgi?9:mss:11144:200108:enhjbegmebmblme > ae > > jok > > > Thank you > > venu > > > -- > > For technical support contracts, go to https://order.mysql.com/ > >__ ___ ___ __ > > / |/ /_ __/ __/ __ \/ /Mr. Venu <[EMAIL PROTECTED]> > > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer > > /_/ /_/\_, /___/\___\_\___/ Redwood city, California USA > ><___/ 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: Cannot change column type from varchar(32) to char(32)
Dear Tony, try this for a first strike: GRANT ALL ON *.* TO ""@"%" This will grant access to everything for everyone connecting from everywhere. No user name and password are required. If you manipulate the mysql.host and mysql.user tables directly with update or insert statements, you will have to do a FLUSH PRIVILEGES afterwards. This will reload the grant tables and put the grants in effect. You don't have to do this if you use grant (s. a.). Regards, --- Silver Fox <[EMAIL PROTECTED]> wrote: > Hello, everyone, > > I'm Tony. I'm new to this mailing list and I have a question. I'm > currently running MySQL and Apache webserver. My partner needs to > connect > to my MySQL database using JDBC to input data. But every time he > tries to > do that, it tells him "access denied for [EMAIL PROTECTED]" Does any > of you > know what may be causing this? Are there any setting I have to > configure or > my partner has to configure? I have already added an entry in > mysql.user > table for host '%' and user '' so everybody can connect to my > database, but > my partner still cannot connect. Please help. > > Tony > > > >From: "j.urban" <[EMAIL PROTECTED]> > >To: Lezz Giles <[EMAIL PROTECTED]> > >CC: [EMAIL PROTECTED] > >Subject: Re: Cannot change column type from varchar(32) to char(32) > >Date: Wed, 1 Aug 2001 17:08:06 -0500 (CDT) > > > >It might depend on the other columns in your table definition. Have > you > >looked at the Silent Column Specification Changes? > > > >http://www.mysql.com/doc/S/i/Silent_column_changes.html > > > >If you have ANY varchar() columns, all char columns greater than > three > >characters are changed to varchar(). Perhaps the 'little play > table' > >doesn't have any other varchars... > > > >On Wed, 1 Aug 2001, Lezz Giles wrote: > > > > > I'm running 3.21.33b (yes, I know it's old), and I run the > command: > > > > > > alter table branch change codebase codebase char(32) not null > > >default > > > "IPriori"; > > > > > > where column codebase has type varchar(32) - but the type does > not > >change to > > > char(32). > > > There's no error message or other indication of what went wrong, > and if > >I create > > > > > > a little play table I can succesfully change the column type to > char(32) > >from > > > varchar(32). > > > The table "branch" has just 180 rows in it. > > > > > > I'd like to change the column types from varchar to char to speed > up > >queries & > > > etc. > > > Can anybody shed any light on what I'm doing wrong? > > > > > > Thanks, > > > Lezz Giles > > > > > >- > >Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > >To request this thread, e-mail <[EMAIL PROTECTED]> > >To unsubscribe, e-mail > ><[EMAIL PROTECTED]> > >Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > > > _ > Get your FREE download of MSN Explorer at > http://explorer.msn.com/intl.asp > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > = --- Stefan Hinz <[EMAIL PROTECTED]> iConnect e-commerce solutions GmbH, 13355 Berlin Office: +49 30 46307-382 Mobil: +49 177 7841069 Antwortadresse dieser E-Mail: <[EMAIL PROTECTED]> BITTE NUR IN DRINGENDEN FÄLLEN AN DIESE ADRESSE ANTWORTEN! --- __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: LOAD DATA INFILE with JDBC
Curtis Spencer writes: > Is this possible with 2.0 version (type 4 I think) MM driver found on > www.gjt.org? Also how do the file reading privileges for this work because > I tried doing it and it gave me an authorization error even though my mysql > user has FILE on it's privileges. Also, the file to read is chmod 774, so > it should be readable by all. > > Any ideas, > > Thanks Check two things : - file is on the server. If not use LOCAL clause - In both cases provide a full pahtname for the file -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /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
floor/ceiling with myodbc
Hi there, I'm running into problems with functions "floor/ceiling" when I use Visual Basic to talk to mySQL through myODBC. My code looks like this: sSQL = "select floor(3.2)" Set rs = MySQL_conn.Execute(sSQL) I got rs.eof = true after execution of the query. However the following codes works fine. sSQL = "select round(3.2)" Set rs = MySQL_conn.Execute(sSQL) rs.fields(0)=3 Can anyone tell if this is a bug of myODBC or VB's problem? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problems with show tables
Thanks for all the replies - it shows me to look a little harder next time before I send a question to the mailing list. Thanks, but ... I did as it told but it still return an empty set. Here are the results: mysql> show tables; Empty set (0.01 sec) mysql> select database(); ++ | database() | ++ | blackbook | ++ 1 row in set (0.00 sec) mysql> use blackbook; Database changed mysql> show tables; Empty set (0.00 sec) mysql> select * from name; +-++-+---+---+ | name_id | name_first | name_middle | name_last | name_lst_updt | +-++-+---+---+ | 1 | Michael| K. | Turner| NULL | +-++-+---+---+ 1 row in set (0.00 sec) You can see that I am attached to a database and that tables exist but 'show tables;' doesn't seem to work. I am sure it is user error but could you please show me my error. Thanks in advance - Blessings, Mike Revelation 1:8 I am the Alpha and Omega, the Beginning and the Ending, says the Lord, who is and who was and who is to come, the Almighty. -- The Mighty JC
RE: generate database script from existing table?
The only place I've seen a tool like this is in urSQL (a MySQL GUI Client for Windows 95/98/NT 4.0). I'm just using the unregistered version and this feature seems to work fine. You can grab the program from the following location, http://www.urbanresearch.com/software/utils/urbsql/index.html. > -Original Message- > From: Tong Kiat, Chiah [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 03, 2001 4:45 AM > To: [EMAIL PROTECTED] > Subject: generate database script from existing table? > > I just took over a mysql database with no documenation. Is there any > tools or anyway I could generate a database/table creation script from > the current database? This is because I need to recreate the database > on another machine and currently I have no way of doing so. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem.
Ashadul Khan writes: > Dear Sir, > > I'm new to mysql. So please forgive me if I may sound so stupid. > > I did install mysql database. I also downloded you > Sun Solaris 2.7 Sparc static binary of MySQLGUI 1.6 > > After I unziped what should I do? How can this to work? > > My database is running on Sun Solaris 2.8. Your help is all > I need. > > Thanks > Ash. It is possible that Solaris distro of MySQLGUI does not have a README, so I am sending the one to you by separate mail. Just follow those instructions. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /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: Access to MySQL Column Type Error
Well I did the trace and it's about 2.81MBs. What exactly do you need out of it? I didn't notice much help from it but then again I'm not very knowledge in that area. Considering the size do you still want me to directly e-mail it to you? One other thing I forgot to mention was the data in the Fax_Machine_ID field starts with a * and then 3 integers (max size 4). There are the odd few that do not have a * in front and those seem to get through. Would this maybe be taking as a wildcard and I would have to escape it some how so I will be able to append the query over to MySQL successfully? > Hi ! > > Can you send me the ODBC trace ? > > Thanks in advance > venu > > > -Original Message- > > From: Adam Douglas [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, August 02, 2001 10:52 AM > > To: '[EMAIL PROTECTED]' > > Subject: Access to MySQL Column Type Error > > > > > > I'm trying to do an append query in Access to MySQL on > CompanyRep table. > > BTW, I'm using MyODBC to allow connectivity between MS-Access and > > MySQL. Now > > I've done many queries like this with no problem. For some > reason this > > append query will not work anymore. I get the following > error message > > > > "Microsoft Access can't append all the records to the table" > > > > "Microsoft Access set 148 field(s) to Null due to a type > > conversion failure, > > and it didn't add 0 record(s) due to key violations, 0 record(s) > > due to lock > > violation, and 0 record(s) due to validation rule violations." > > > > This error seems to occur only on the Fax_Machine_ID field > based on what I > > see missing for data in MySQL. Any help would be greatly > appreciated, > > thanks! > > > > Schema for Fac_Machine_ID field on Access... > > ++--+--+-+-+-- > > -- > > + > > | Field | Date_Type| Null | Key | Default | Extra > > | > > ++--+--+-+-+-- > > -- > > + > > | Fax_Machine_ID | text(4) | YES | | NULL| > > | > > ++--+--+-+-+-- > > -- > > + > > > > Schema for Fax_Machine_ID field on MySQL... > > > > ++--+--+-+-+-- > > -- > > + > > | Field | Type | Null | Key | Default | Extra > > | > > ++--+--+-+-+-- > > -- > > + > > | Fax_Machine_ID | varchar(4) | YES | | NULL| > > | > > ++--+--+-+-+-- > > -- > > + - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to drop a user from mysql?
A newbie question: how to drop a user from mysql? Alex - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Query Acting Weird
> Adam Douglas schrieb am Donnerstag, 2. August 2001, 19:14:15: > > > I have a group of 3 queries that's used to find our > representative for > > Unitary, Applied and Wholesale based on a Zip Code. This > all is executed > > through PHP to MySQL. The three queries work fine and get > the results I > > want. The problem is the 3 queries seem to work one minute > but not the next. > > You could enter say 3 or 4 zip codes and have it return > results with no > > problem, but on the 5 try it will crap out. This seems to > be random, one > > minute it wouldn't work on the first try and then the next > it will. When the > > 3 queries crap out it renders MySQL useless, you can send > or do any thing to > > MySQL when the 3 queries crap out. It puts my CPU usage to > 99.0% and stays > > roughly there forever. I've left the query running for more > then 8 hours and > > still nothing seems to be returned. Can anyone direct me in > the right > > direction on how to resolve this problem? > > I didn't have a look at your code as I don't think it is probable > that you will have a problem here. These days, I am hunting > problems similarly weird. I'm looking into faulty hardware now. > > Yesterday, we changed 2 of the 3 128 MB RAM modules, which has > reduced problem frequency from 30 minutes to 10 hours. We see > from hostname.err that the problem occurs exactly when the log > records > > 010802 22:35:30 Aborted connection 231 to db: > 'pferdezeitung' user: 'pferdezeitung' host: `localhost' > (Got an error writing communication packets) > > So we will replace the 3rd module or all three to see what will > happen then. It might be the hard disk, though, or the > controller, or something else. > > Also, it may be a good idea to look at the hostname.log to see > what mysql does when running wild. I did this to test queries > that seemingly produced errors, but when reproduced, they did > not, so this was proof that neither the query nor the data had > problems. Mmm.. that's interesting, I will have to look into checking out those two files. But I believe I've found the reason as to why the queries are acting crazy. I was reading through the MySQL manual today and thought I should read the OpenBSD Notes (should have a long time ago, ). Well to my surprise it states that "OpenBSD 2.8 has a threading bug which causes problems with MySQL" and "The symptoms of this threading bug are: slow response, high load, high cpu usage, and crashes". So I was going to upgrade OpenBSD to 2.9 anyways so why not do it now and solve my problems :-). Also upgrade MySQL as well. Do you have any tips on upgrading either OpenBSD or 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
Bulk Friendly Hosting only $300 month.. 30930
Spam friendly offshore website hosting only $300 per month. Advertise your website risk free! More hits and business than you can imagine. 100mb space MYSQL SSL CGI PHP FTP Access Unlimited Band Width Front Page Extensions NO PORN OR CASINO.NO PORN OR CASINO Resellers welcome. Also bulk friendly POP3 mailboxes $200 per month. Never lose your mailbox again! Reply with "99" in subject field for more info. To be removed, Reply with "Remove" in the subject field. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Sorry, but I have another question
Sorry, it never fails. As soon as I send a mail, I find the answer. My last question was about how to find the names of the tables in aparticular database(just a dump of the names). Well I found out the answer is the following mysql> show TABLES; I did as it told but it still return an empty set. Here are the results: mysql> show tables; Empty set (0.01 sec) mysql> select database(); ++ | database() | ++ | blackbook | ++ 1 row in set (0.00 sec) mysql> use blackbook; Database changed mysql> show tables; Empty set (0.00 sec) mysql> select * from name; +-++-+---+---+ | name_id | name_first | name_middle | name_last | name_lst_updt | +-++-+---+---+ | 1 | Michael| K. | Turner| NULL | +-++-+---+---+ 1 row in set (0.00 sec) You can see that I am attached to a database and that tables exist but 'show tables;' doesn't seem to work. I am sure it is user error but could you please show me my error. Thanks in advance - Blessings, Mike Revelation 1:8 I am the Alpha and Omega, the Beginning and the Ending, says the Lord, who is and who was and who is to come, the Almighty. -- The Mighty JC
Re: Searching in a mysql table
joe schrieb am Freitag, 3. August 2001, 07:46:09: > Would it be inefficient to use the command "SELECT * FROM users_info WHERE > name LIKE "%phil%" and company like "%" and address like "%";" What use have > and company like "%" and address like "%" Omit it and you will be just as fine. If you have an index an name, that is. Otherwise mysql will have to read all records. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
silent installation
how can i execute a silent installation of mysql for windows? Thanks a lot for your time. David Tomás Fargas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Further FreeBSD 4.3 Issues (CPU hogging)
Hi Michael, Sounds like the mysqld may have been stuck in a tight loop then. Any ideas Sinisa? Try the truss once more if it happens again. I can't think of anything that would cause this. Let me know what happens, also try the truss when the server is running normally just to see the output and make sure you know how to do it, even on an idle server it Prints something like this: (null)() = 0 (0x0) gettimeofday(0x283558e8,0x0) = 0 (0x0) clock_gettime(0x0,0xbfafefa4)= 0 (0x0) poll(0x82df000,0x2,0x0) = 0 (0x0) Ken - Original Message - From: "Institute For Social Ecology" <[EMAIL PROTECTED]> To: "Ken Menzel" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, August 03, 2001 12:41 AM Subject: RE: Further FreeBSD 4.3 Issues (CPU hogging) > Ken, > > Thanks for taking the time in the midst of all your priorities to help > me look into this problem. I was able to get the proper pid for the > mysqld process, but running truss -p (number here) resulted in no > return. Running truss /usr/local/libexec/mysqld resulted in the > display I sent in my last email. Yes, mysqld was alive at the time, > but for whatever reason truss -p did not turn out the expected > results. > > On a similar note, I shutdown mysqld and restarted it a day ago. > Since then, mysqld has been running quite reasonably. If the data I > sent you does not point to anything, I suppose we can wait and see if > the server runs itself up again. > > Regards, > > Michael > Institute for Social Ecology > > 1118 Maple Hill Rd. > Plainfield, Vermont, 05667 > USA > > Tel./Fax. 1 (802) 454-8493 > > http://www.social-ecology.org/ > > > -Original Message- > From: Ken Menzel [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 02, 2001 10:41 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: Further FreeBSD 4.3 Issues (CPU hogging) > > > Hi Michael, >Sorry for the delay getting back to you, we had some network > problems here and are in the process of upgrading our 30 year old > copper to a new 200 pair copper cable to the building (They can't do > fiber, sigh!). Anyway, the output from truss that you sent looked > like a normal mysqld startup. The way to run truss for debugging a > probelm is: > ps -ax | grep /mysqld > get the process ID and then truss -p process ID. > or as one command: > truss -p `ps -ax | grep /mysqld | cut -c 1-6` > > Or are you saying this is what you did and there was no output at all > from truss? IE it was "dead"? > > P.S. I will be out of the office tomorrow. > Ken > - Original Message - > From: "Institute For Social Ecology" <[EMAIL PROTECTED]> > To: "Ken Menzel" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; > <[EMAIL PROTECTED]> > Sent: Wednesday, August 01, 2001 4:56 PM > Subject: RE: Further FreeBSD 4.3 Issues (CPU hogging) > > > > Ken, > > > > Thanks as always for your very helpful support. I did a 'truss -p' > on > > the PID and it came back empty handed. I did do a 'truss > > /usr/local/libexec/mysqld' which spat back all sorts of goodies. I > > have included the output bellow. Also, as requested, below is the > > output of mysqlbug. > > > > Once again, thank you for your help. > > > > Regards, > > > > Michael > > > > truss /usr/local/libexec/mysqld: > > > > __sysctl(0xbfbffac4,0x2,0x281bfba8,0xbfbffac0,0x0,0x0) = 0 (0x0) > > mmap(0x0,32768,0x3,0x1002,-1,0x0)= 672927744 > > (0x281c1000) > > geteuid()= 1048 (0x418) > > getuid() = 1048 (0x418) > > getegid()= 1048 (0x418) > > getgid() = 1048 (0x418) > > open("/var/run/ld-elf.so.hints",0,00)= 3 (0x3) > > read(0x3,0xbfbffaa4,0x80)= 128 (0x80) > > lseek(3,0x80,0) = 128 (0x80) > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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
Left Join Query
This query is driving me nuts! I have two tables, affiliates, and advertisers. The advertisers table has an affiliate_id field, which matches the affiliates tables' primary key. I'm trying to write a query that will return all affiliate id's, contact names, and the # of rows in the advertisers table. I'm sure this requires a left join, but the following query does NOT work: SELECT af.affiliate_id, af.contact_name, af.contact_email, count(ad.affiliate_id) AS count FROM affiliates AS af LEFT JOIN advertisers AS ad ON af.affiliate_id = ad.affiliate_id GROUP BY ad.affiliate_id ORDER BY count DESC Note, I want to return all affiliates, even if there are no matching rows in the advertisers table, which is why I'm assuming a left join is necessary. TIA, Daren Cotter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: [Got error 139 from table handler using InnoDB]
In the last episode (Aug 02), [EMAIL PROTECTED] said: > I'm new to the list so please forgive me if this problem has already > been solved. > > I've been using MySQL for development for sometime. Up until now I've > been using MyISAM tables. I've decided to switch to InnoDB because > some table files (*.MYD) are approaching the OS limit. You can use the special RAID table type to overcome that. > I get the above error (139) when trying to enter a moderately sized > (~ 23k) into a text column. This error also occurs on sparc running > Solaris 2.5. InnodDB currently has an ~8k size limit on rows. > Has anyone else experienced this? Is there a workaround? It will be fixed eventually, but for now you might have to put your TEXT fields in a separate MYISAM table. -- 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: SQL/Table question
M> How would I select all the tables _names_ in a particular database? Is it possible? M> i.e. Select table_names from tables; SHOW TABLES FROM database_name; or SHOW TABLES; -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- | Ilya Martynov (http://martynov.org/)| | GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80 E4AE BE1A 53EB 323B DEE6 | | AGAVA Software Company (http://www.agava.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: '/tmp/mysql.sock' (111)
I've had this happen (" Can't connect to local MySQL server") at the command line when I forgot to specify a host, so mysql assumes localhost. Check your host argument. On Thu, 2 Aug 2001, sarahana wrote: > If mysql is shown when runnnig phpinfo() - does it mean that its installed, > and if yes, why this error? > AFAIK it means php support for mysql is installed. > thanks, what needs to ben done? Write the code to access your database, and execute it. Check php.net/docs.php for further info HTH David Mintz Spanish Interpreter US District Court, Southern District of New York Web Design & Hosting http://www.dmintzweb.com/ Personal http://www.panix.com/~dmintz/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MySQL GUI
Marc Liyanage writes: > > Hi there, > > > Yup, but that is for the "old" Classic Mac OS, right? > > I looked around and did not find a port that runs directly > on the Aqua UI, which is what would be needed to run this software. > > > > > > > -- > _ > Marc Liyanage [EMAIL PROTECTED] > http://www.entropy.ch >ICQ 5077985 Yes, but write to the author. He once told me he knows how to port it to OS X. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /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
data checking during input?
I have a database I enter data into from a web based php form. I wonder if there is a way to have mysql check the database for a duplicate entry before it gets written into the database? And inform me of such so I will not have duplicate entries? -- Regards, Chip - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: libz.a on AIX 4.3.3
Vish Kolla writes: > Hi, > > We are trying to install mysql on AIX 4.3.3 and have encountered > the following errors. MySQL is dependent upon libz.a(shr.o). Where > can we find this library ? Did anyone encounter this problem before ? > If so what is a viable solution ? > > Please respond to me directly as I am not on the list. > > Thanks, > Vish Kolla. > You can find that library at ftp.gnu.org. Build it from source, that is the best way to do it. On the side note : What are you using MySQL for and why on AIX. Why not Solaris ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /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
generate database script from existing table?
Hi I just took over a mysql database with no documenation. Is there any tools or anyway I could generate a database/table creation script from the current database? This is because I need to recreate the database on another machine and currently I have no way of doing so. thanks tk
Re: A small suggestion for the development team...
Bruce Stewart writes: > Hi Monty and all, > > I believe that you are planning to introduce foreign key support in a future > version of MySQL (I think version 4.0). > > Could you consider offering an option to the definition of a foreign key > which specifies the error message to return if the FK is violated. > something like: > > "ALTER TABLE mytable ADD CONSTRAINT mytable_FK FOREIGN KEY (myfield) > REFERENCES myothertable (myotherfield) MSG 'A friendly totally customizable > message'" > > > Thanks, > Bruce Foreign keys will not be introduced in 4.0. May be in 4.1 ... 4.0 will have cascading deletes and updates , which provides some of the functionality of foreign keys. 4.0 will also save FK info, for use in documentation and in programs that can optimize join queries, like mysqlgui -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /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: Further FreeBSD 4.3 Issues (CPU hogging)
Ken, Thanks for looking into the problem. For now, it seems as if the issue has resolved itself. Kindest Regards, Michael Institute for Social Ecology 1118 Maple Hill Rd. Plainfield, Vermont, 05667 USA Tel./Fax. 1 (802) 454-8493 http://www.social-ecology.org/ -Original Message- From: Ken Menzel [mailto:[EMAIL PROTECTED]] Sent: Friday, August 03, 2001 4:53 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: sinisa@mysql. com Subject: Re: Further FreeBSD 4.3 Issues (CPU hogging) Hi Michael, Sounds like the mysqld may have been stuck in a tight loop then. Any ideas Sinisa? Try the truss once more if it happens again. I can't think of anything that would cause this. Let me know what happens, also try the truss when the server is running normally just to see the output and make sure you know how to do it, even on an idle server it Prints something like this: (null)() = 0 (0x0) gettimeofday(0x283558e8,0x0) = 0 (0x0) clock_gettime(0x0,0xbfafefa4)= 0 (0x0) poll(0x82df000,0x2,0x0) = 0 (0x0) Ken - Original Message - From: "Institute For Social Ecology" <[EMAIL PROTECTED]> To: "Ken Menzel" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, August 03, 2001 12:41 AM Subject: RE: Further FreeBSD 4.3 Issues (CPU hogging) > Ken, > > Thanks for taking the time in the midst of all your priorities to help > me look into this problem. I was able to get the proper pid for the > mysqld process, but running truss -p (number here) resulted in no > return. Running truss /usr/local/libexec/mysqld resulted in the > display I sent in my last email. Yes, mysqld was alive at the time, > but for whatever reason truss -p did not turn out the expected > results. > > On a similar note, I shutdown mysqld and restarted it a day ago. > Since then, mysqld has been running quite reasonably. If the data I > sent you does not point to anything, I suppose we can wait and see if > the server runs itself up again. > > Regards, > > Michael > Institute for Social Ecology > > 1118 Maple Hill Rd. > Plainfield, Vermont, 05667 > USA > > Tel./Fax. 1 (802) 454-8493 > > http://www.social-ecology.org/ > > > -Original Message- > From: Ken Menzel [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 02, 2001 10:41 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: Further FreeBSD 4.3 Issues (CPU hogging) > > > Hi Michael, >Sorry for the delay getting back to you, we had some network > problems here and are in the process of upgrading our 30 year old > copper to a new 200 pair copper cable to the building (They can't do > fiber, sigh!). Anyway, the output from truss that you sent looked > like a normal mysqld startup. The way to run truss for debugging a > probelm is: > ps -ax | grep /mysqld > get the process ID and then truss -p process ID. > or as one command: > truss -p `ps -ax | grep /mysqld | cut -c 1-6` > > Or are you saying this is what you did and there was no output at all > from truss? IE it was "dead"? > > P.S. I will be out of the office tomorrow. > Ken > - Original Message - > From: "Institute For Social Ecology" <[EMAIL PROTECTED]> > To: "Ken Menzel" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; > <[EMAIL PROTECTED]> > Sent: Wednesday, August 01, 2001 4:56 PM > Subject: RE: Further FreeBSD 4.3 Issues (CPU hogging) > > > > Ken, > > > > Thanks as always for your very helpful support. I did a 'truss -p' > on > > the PID and it came back empty handed. I did do a 'truss > > /usr/local/libexec/mysqld' which spat back all sorts of goodies. I > > have included the output bellow. Also, as requested, below is the > > output of mysqlbug. > > > > Once again, thank you for your help. > > > > Regards, > > > > Michael > > > > truss /usr/local/libexec/mysqld: > > > > __sysctl(0xbfbffac4,0x2,0x281bfba8,0xbfbffac0,0x0,0x0) = 0 (0x0) > > mmap(0x0,32768,0x3,0x1002,-1,0x0)= 672927744 > > (0x281c1000) > > geteuid()= 1048 (0x418) > > getuid() = 1048 (0x418) > > getegid()= 1048 (0x418) > > getgid() = 1048 (0x418) > > open("/var/run/ld-elf.so.hints",0,00)= 3 (0x3) > > read(0x3,0xbfbffaa4,0x80)= 128 (0x80) > > lseek(3,0x80,0) = 128 (0x80) > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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/manua
Table LOCKING
Hi All, Was hoping some one maybe able to explain this error when attempting to LOCK MySQL tables for READ and WRITE: Error Encountered: Unable to LOCK tables. Error: Not unique table/alias: 'members' The correct database has been connected to, and the members table is a valid table. It's executed via Perl coding: $dbh->do("LOCK TABLES members READ, members WRITE, optin WRITE"); is this syntax incorrect?? Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to add an excel file directly to MySQL database using PHP?
How can I add an excel file with *.xls extension directly into MySQL database..is it possible to do or I need to convert it into *.csv format or *.txt format first? Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: new installation
At 1:07 PM -0700 8/2/01, Mark -None- wrote: >I downloaded, compiled, and installed the latest MySQL release from >the source code at www.mysql.com last night. I was running through >the tests documented in the INSTALL-SOURCE file, and I've found that >mysqladmin -u root shutdown does not work. I guess you missed the other threads on this topic (posted same or previous day). It is a known issue that mysqladmin -u root shutdown does not work on Mac OS X. You need to use # kill -9 123 # kill -9 235 In the above example, 123 is the PID for safe_mysql and 235 for mysqld, you have to shutdown in that order. A normal kill may not work. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.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: subquery question
Hello. MySQL doesn't support sub-queries (yet). See the following page for more information and also for hints how to work without sub-queries: http://www.mysql.com/doc/M/i/Missing_Sub-selects.html I never used full text search before, so I might miss something, but a starting point for your query should be: SELECT l.arx_id, MATCH (l.arx_xml) AGAINST (r.arx_xml) AS arx_xmlscore FROM arx AS l, arx AS r WHEREr.arx_id = 827 ORDER BY r.arx_xmlscore Bye, Benjamin. On Fri, Aug 03, 2001 at 11:48:49AM +0100, [EMAIL PROTECTED] wrote: > > I'm trying to do a match to find related xml documents against a document... > in this table arx_id is an autonumber column > > SELECT arx_id, MATCH (arx_xml) AGAINST (=select arx_xml from arx where > arx_id = 827) AS arx_xmlscore from arx order by arx_xmlscore > > it throws an exception about the subquery in there (sorry if it's obvious, > I've never tried a subquery before) [...] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Dedicated MySQL Application Server
Date |Thu, 2 Aug 2001 12:56:23 -0700 >From |Bryan Ross <[EMAIL PROTECTED]> Hello! BR> Hi. BR> What I want to do is this: Use mysql as a dedicated database for a desktop BR> application, meaning that basically there's only one client allowed to BR> connect to it, and that client is the application. Also, I would not want BR> this database to interfere with any other instance of MySQL that may be BR> running on the same machine. Basically to be completely wrapped and only BR> accessible by the application. BR> My question is: is there a relatively simple way of doing this? start another mysql daemon with different socket path and configuraton file. in config file set up new path to databases. Also change priveleges in new server for more secure access. ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ <___/ 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: Re: MySQL GUI
Marc Liyanage writes: > >I'm looking into it right now after reading your cc'd mails > >to the list. I'm not on the list BTW, you need to cc me... > > > > > > > >>>But as there is FLTK library for OS X and as there are GNU tools > >>>available, it is quite doable. > > > >Can someone point me to this particular FTLK for OS X? > > > >This seems to require that one is running X11 on > >Mac OS X, right? How many end-users would be willing > >to install XFree86 just for this application? What do > >you folks think? > > > >Also, flvw does not seem to build under OS X, > >it assumes "ar" flags that are invalid under OS X, > >and dynamic linker settings that don't work either... > > > > > >Cheers > > > >-Marc > > > > > > > > > > > >-- > >_ > >Marc Liyanage [EMAIL PROTECTED] > > http://www.entropy.ch > >ICQ 5077985 > > > >Yoda I am. Grammar I can't. > >_ > You can try to do it without X. Go to www.fltk.org and to Bazaar page. You will find there a version of FLTK for Macintosh. If you have problems, write to the author. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /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: How to add an excel file directly to MySQL database using PHP?
Well you have a couple options, you could export the Excel file to a delimited text file and then import into MySQL. You could also just use the Excel file and import directly into MySQL with the use of MyODBC and MS Access. That's all I can think of right now. Either way would work fine I believe. > -Original Message- > From: Yeong CN [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 02, 2001 10:43 PM > To: [EMAIL PROTECTED] > Subject: How to add an excel file directly to MySQL database > using PHP? > > > How can I add an excel file with *.xls extension > directly into MySQL database..is it possible to do or > I need to convert it into *.csv format or *.txt format > first? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 set root mysql password
Date |Thu, 2 Aug 2001 20:20:51 -0700 >From |[EMAIL PROTECTED] Hello! >>Description: E> I cannot set the root password, or any password after installing from RPM. I have installed the following RPM packages: E> MySQL-3.23.40-1.i386.rpm E> MySQL-client-3.23.40-1.i386.rpm E> MySQL-shared-3.23.40-1.i386.rpm >>How-To-Repeat: E> this is where i am seeing the problem, immediately after a fresh RPM install. E> [root@cadillac /root]# /usr/bin/mysqladmin -u root -p password 'new-password' E> Enter password: E> /usr/bin/mysqladmin: connect to server at 'localhost' failed E> error: 'Access denied for user: 'root@localhost' (Using password: YES)' E> [root@cadillac /root]# >>Fix: E> i am _really_ new to mysql, and have no idea. any help would be greatly appreciated. thank you in advance. No. You need to remove -p from this command line. So "/usr/bin/mysqladmin -u root password 'new-password'" works like a dream -); ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ <___/ 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: generate database script from existing table?
Tong Kiat, Chiah schrieb am Freitag, 3. August 2001, 12:44:45: > I just took over a mysql database with no documenation. Is there any > tools or anyway I could generate a database/table creation script from > the current database? This is because I need to recreate the database > on another machine and currently I have no way of doing so. get yourself phpMyAdmin and set it up (you need your username and such). Then it's a snap. Good tool for all sorts of things. Loog in google for it. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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] Database size
--- Reçu de CMB.TIGNABR 0298426574 03-08-01 17.21 Hello, I plan to use MySQL/InnoDB to store about 13 GB of data, into 40 tables. One of the tables is over 5 GB, and a second over 1,5 GB. Do you think I can use MySQL/InnoDB ? Thank you. Bruno Tignac 03-08-01 17.21 Envoyé à - -> mysql(a)lists.mysql.com -- Ce message et toutes les pieces jointes (ci-apres le "message") sont confidentiels et etablis a l'intention exclusive de ses destinataires. Toute utilisation ou diffusion non autorisee est interdite. Tout message etant susceptible d'alteration, l'emetteur decline toute responsabilite au titre de ce message s'il a ete altere, deforme ou falsifie. --- This message and any attachments (the "message") are confidential and intended solely for the addressees. Any unauthorised use or dissemination is prohibited. As e-mails are susceptible to alteration, the issuer shall not be liable for the message if altered, changed or falsified. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 + dns server?
On Thursday 02 August 2001 17:27, mike cullerton wrote: > on 8/2/01 3:31 PM, Ricardo Kleemann at [EMAIL PROTECTED] wrote: > > Hi, > > > > Anyone know if there's a module or plug-in or something that allows BIND > > to work with a mysql database? > > from http://www.isc.org/products/BIND/bind9.html > > "A new, simplified database interface and a number of sample drivers based > on it; see doc/misc/sdb for details" > > > Or are there other dns servers out there that can work together with > > mysql? > > http://cr.yp.to/djbdns.html I don't have the BIND 9 docs handy, but there is also a newly released DNS server module set in Perl on CPAN. It could be easily extended to talk to MySQL. I went though the online docs for dbjdns and didn't really see anything that looked like it would talk to MySQL. DBJ likes to use his CDB code for a lot of his projects. Is there a FAQ or page I missed? If people know of any other such servers, I'd love to know! Best, Kyle - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Minutes Between Dates
HelpHi. I'm using the timestamp format (AAMMDDHHMMSS) on my session. how can I know the minutes between two dates. I'm doing: =20 $date =3D $row_secao['date']; $date_now=3Ddate("ymdHis"); =20 $x=3D$date_atual-$date; if ($x > 1000) { echo "Session expired."; =20 } =20 but I have a problem when turns the hour, like this: date=3D010803105958 date_now=3D010803110518 the sub is 4500 (45 minutes!), but in fact, the real time between is 6 = =20 minutes... is there any function in mysql that does it? thanks. Augusto
Re: Re: MySQL GUI
At 12:49 AM +0200 8/2/01, Marc Liyanage wrote: >>Can someone point me to this particular FTLK for OS X? >> >>This seems to require that one is running X11 on >>Mac OS X, right? How many end-users would be willing >>to install XFree86 just for this application? What do >>you folks think? Sorry I cannot answer to the technical needs of installing this application. I think the answer on whether end-users would install the requisite components in order to run this application depends on whether it is even possible to run the GUI interface within Aqua. Would it require someone to boot into the command line or into a separate X Windows environment? If that is the case then it will perhaps have limited usefulness. Amd there are other tools for getting a GUI interface to MySQL. If it can run off the command line from the terminal and the tools to do so are on the developers CD then I think it would be used. There would just need to be some instructions showing what and how to install what is needed. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.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
Replication and now()
It seems that the replication system takes the value of now() or curtime() to be the time that the query was run on the slave, not the time the master logged the query. Is there a way to get around this (other than changing all the queries)? Thanks, Ord Millar www.cityvu.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