RE: How to get MySQL to list current db's ?
show databases. -Original Message- From: Will Standley [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 10:36 AM To: MySQL List Subject: How to get MySQL to list current db's ? I have two sample MySQL db's running on a local Linux box w/Apache... Once I enter mysql from the Linux command line... Is there a way to ask MySQL to list the db's that are currently created? Thanks, Will - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: E-Commerce, db-clustering and MySQL?
There is no clustering in MySQL. Replication features allow something similar. In my opinion, the reason I prefer MySQL is the fact that the basics are there to do what ever you need to. You are responsible for making the solution, not the vendor. Multiple MySQL slave servers, and multiple webservers with heartbeat or something similar to spread the web load, and some nifty programming can usually solve high load problems with MySQL. The lack of all the advanced features in MySQL is what makes it a joy to work with. (you get to be creative:) plus the people hear on the lists are really good at helping in those clustering situations, when you get specific. As for people with wxperience in this, I do high load stuff alot, you just have to read the manual thouroghly and try out different techniques. I hope this helps at least somewhat. brian -Original Message- From: Dietrich Speer [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 07, 2002 6:20 PM To: [EMAIL PROTECTED] Subject: E-Commerce, db-clustering and MySQL? Hello: We are running a large e-commerce site currently with ASP/MSSQL. The ever increasing number of hits, complexity of the site and request for reporting is slowly but surely bringing us to the point were the current database application is getting tired. Now we're thinking Linux, MySQL and clustering. I have been looking around a little and don't like the fact that there are no stored procedures and no triggers. However - if we cluster several quad processor machines we should be fine without. Right now it's all theory, and there don't seem to be a lot of articles on the web about this. At least I had no luck finding any. Does anybody have real life experiences with this kind of a setup? Does anybody know where to find reports about this? I'd be greatful for any link or hint! Dietrich Speer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql port number
show variables that will show you what you need. you can use a like statement, because there is a lot of stuff hope that helps brian -Original Message- From: Mike At Spy [mailto:[EMAIL PROTECTED]] Sent: Friday, December 06, 2002 9:51 AM To: [EMAIL PROTECTED] Subject: RE: mysql port number That, of course, isn't even getting into the point that you didn't answer my question. I asked how I could tell, not what the default port was! Thank you to the others that did. :) -Mike -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 6:19 PM To: Mike At Spy Cc: [EMAIL PROTECTED] Subject: Re: mysql port number On Wed, Dec 04, 2002 at 12:04:52PM -0500, Mike At Spy wrote: How can I tell what port number mysql is running on? I need it for a chat program. :) 3306 A google search would have found the answer in no time. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 14 days, processed 434,170,735 queries (344/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: undefined function: mysql_connect()
Are you using MySQL 4.x sumthing? I thought that function was taken out and replaced with mysql_real_connect()? I may be wrong. -Original Message- From: Julie Meloni [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 10:35 AM To: Tewfic Kidess Cc: [EMAIL PROTECTED] Subject: Re: undefined function: mysql_connect() TK Hello, i'm trying to use PHP4 and MySQL and i'm getting undefined function: TK mysql_connect() This question belongs on a/the PHP mailing list, but the answer is that you need to compiled PHP --with-mysql. Please read the PHP installation instructions in the very handy manual at http://www.php.net/manual/ - Julie -- Julie Meloni -- [EMAIL PROTECTED] -- www.thickbook.com Find Sams Teach Yourself MySQL in 24 Hours at http://www.amazon.com/exec/obidos/ASIN/0672323494/thickbookcom-20 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql on redhat instalation problem
Hello, You probably need to check the permissions for the directory that mysql is trying to create the databases in. Make sure mysql has write permissions in the directory. then run mysql_install_db again and you should be ready to go. - Original Message - From: jake williamson 28 [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 26, 2002 10:50 AM Subject: mysql on redhat instalation problem hello! i'm rapidly loosing the hair i have left i've managed to get our old clockwork pc running redhat 7.1 and php4. apache is a rockin and now i've just installed the mysql RPM... this is where everything's come to a grinding halt... everything's gone in and mysql seems to be up and running in the background - thing is i've just got to the 'what to do to set up mysql' - at this point in the manual it seems to forget that you've used a PRM and uses a load of stuff that doesn't seem to be in my machine! it's this bit 'See section 2.4 Post-installation Setup and Testing.' where it all goes wrong - none of the directories seem to be there! in your new server wisdom dus you have any advice?? driving me bonkers... cheers dude, jake - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
RPMS for Development Branch
Hello all, I have finished setting up a web page that contains RPMS for the Development Branch of MySQL-4.0. These RPMS are compiled every night at 11:00 p.m. CST and are posted to the site at 12:00 a.m. CST. They are built on a standard RedHat 6.2 install. You must use RPM version 4 to install. the Perl dependancy error is still there so --nodeps will bypass it. I have also installed them sucessfuly on RedHat 7.2. I did this myself, and MySQL is not responsible if they do not work. So do not mail the lists if there is an install error, or a specific feature that is not enabled. such requests should be sent to [EMAIL PROTECTED] I did this in hopes of making things easier for people (and myself) who want to try the new stuff out without downloading and compiling themselves. Have fun. Brian P. Austin query, mysql, server - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: RPMS for Development Branch
http://www.linuxmonsters.com sorry about that -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Monday, February 18, 2002 3:41 PM To: 'Brian P. Austin' Cc: mysql Subject: RE: RPMS for Development Branch and the URL is??? it's not www.codemonsters.net; I just checked -Original Message- From: Brian P. Austin [mailto:[EMAIL PROTECTED]] Sent: Monday, February 18, 2002 3:20 PM To: [EMAIL PROTECTED] Cc: mysql Subject: RPMS for Development Branch Hello all, I have finished setting up a web page that contains RPMS for the Development Branch of MySQL-4.0. These RPMS are compiled every night at 11:00 p.m. CST and are posted to the site at 12:00 a.m. CST. They are built on a standard RedHat 6.2 install. You must use RPM version 4 to install. the Perl dependancy error is still there so --nodeps will bypass it. I have also installed them sucessfuly on RedHat 7.2. I did this myself, and MySQL is not responsible if they do not work. So do not mail the lists if there is an install error, or a specific feature that is not enabled. such requests should be sent to [EMAIL PROTECTED] I did this in hopes of making things easier for people (and myself) who want to try the new stuff out without downloading and compiling themselves. Have fun. Brian P. Austin query, mysql, server - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Request for help in testing new replication code in 4.0.2
I have finished a script that takes the bit keeper sources and makes MySQL-4.0.2 RPMS for Redhat 6.x and apparently 7.X as well. I can put these up on our site for download if you want. They might get others trying the code out. I use the spec file included with the source code. I'll put it up if it's something you might find useful. -Original Message- From: Steven Roussey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 12:41 PM To: 'Sasha Pachev' Cc: 'Mysql' Subject: Re: Request for help in testing new replication code in 4.0.2 * If you want to do it this very moment, read the instructions at http://www.mysql.com/doc/I/n/Installing_source_tree.html and install a pre-release 4.0.2 MySQL on your test server. You may also wait until 4.0.2 is released, but in that case, replication in 4.0.2 may have a bug you could have caught on your system and it will not be fixed until 4.0.3. Is that possible to provide a binary snapshot of the pre-release? This can be done with some simple shell scripting, I think. I always found the one I build myself is about 30-50% slower then the official binary. I think that's related to the debian patched glibc-2.95 I am using. Hi, I have to agree with this. I don't want to have to factor in RedHat's 7.2 compiler oddities (which one to use?). Some software projects have a machine to do regular builds on a schedule. This would be ideal. You would find more people testing it. You might just do it in special cases like this one. Testing the new code is relatively easy, and does not require risking the stability of your application by running alpha code. Yes and no. Taking down a server and copying gigs of data can take down a service for a long time (moving gigs of data just is never fast, and the machine I'm going to use has lots of power but no RAID). I don't have time to download and install gcc, bitkeeper, autoconf 2.13, automake 1.4, libtool, m4, and mysql today, but I'll try and get to it this week. Taking down the server will have to wait until maintenance windows over the weekend anyhow. Our test plan for MySQL 4 is as follows: 1. Serialized writes (i.e. replication slave) for two weeks (or about 1 billion insert/update/delete type queries) with no crashes. 2. Everything. We will have the app send duplicates of all queries to the mysql 4 server, but will automatically halt when mysql 4 crashes. We will keep trying this until mysql doesn't crash for a week. 3. Check that the two servers hold the same information and return the same results from queries. With the type and volume of queries that we have, mysql alpha versions either fail within minutes/hours/days or they don't fail at all. We certainly are not the biggest user of mysql, but historically, we have been able to push it hard enough to crash. Not the stable version though. Thankfully, that takes a licking and keeps on ticking. :) Eventually (spring/summer), we will move the main server to v4 and keep the slave around as a live backup. I've been wanting such a slave for a long time. Stopping the slave to make a backup would be great. Not to mention faster fulltext and order by DESC. Sincerely, Steven Roussey http://Network54.com/?pp=e - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Using password: _No_
what command are you issuing. is it mysql? If so, what arguments are you sending it? It should look like this mysql -u user -p prompt: password -Original Message- From: Cliff [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 9:18 PM To: [EMAIL PROTECTED] Subject: Using password: _No_ Hello, Can anyone help? When trying to run mysql I get an ERROR 1045: Access denied for user: 'root@localhost' (Using password: No). In the documentation it mentions 'Using password: YES'. Have tried starting mysql with --skip-grant-tables and then mysqladmin flush-privileges which doesn't seem to do anything. What does the Password No mean? How do I correct it short of reinstallation? Well, I don't know maybe I need to start over yet again. Thanks very much for any help, Cliff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 failure with dev branch
When using the BUILD/compile-pentium and BUILD/compile-pentium-pgcc I get the following errors.. /bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer -rdynamic -o test3 test3.o -all-static libnisam.a ../mysys/libmysys.a../dbug/libdbug.a ../strings/libmystrings.a -lpthread -lz -lcrypt -lnsl -lm -lpthread collect2: ld returned 1 exit status gmake[2]: *** [pack_isam] Error 1 gmake[2]: *** Waiting for unfinished jobs collect2: ld returned 1 exit status gmake[2]: *** [test1] Error 1 gcc -O3 -DDBUG_OFF -Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer -rdynamic -o test3 test3.o -static libnisam.a ../mysys/libmysys.a ../dbug/libdbug.a ../strings/libmystrings.a -lpthread -lz -lcrypt -lnsl -lm -lpthread collect2: ld returned 1 exit status gmake[2]: *** [test2] Error 1 gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/home/baustin/mysql' gmake: *** [all-recursive-am] Error 2 no modifications were made to the BUILD files. Note: I am using the hacked glibc/LinuxThreads library. Don't know if that is the cause though. It looks like the isam stuff instead. any input would be appreciated. thanks, Brian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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, Red Hat Linux and php
If you are using the MySQL RPMS for RedHat, They install in the /usr directory. (Redhat dows things differently) So it would be ./configure --with-mysql=/usr for PHP compilation. as far as upgrading... I have used RedHat for a long time, and have found that in their newest distos, it is extremely difficult to customize your computer. Escpecially with adding your own Kernel. I have stayed with 6.2 because for the most part, the directory structures comply with the source packages most people make available. As long as you keep current with important packages, there really isn't much difference in the newer versions, other than a new GLIBC, but you can add that to a 6.2 distro easily. Hope that helps Brian Austin Neil Zanella wrote: If I were you I would simply upgrade to Red Hat 7.1 or better 7.2. It probably takes just as much time to install a whole distro than having to worry about installing apache, then mysql, then php, all over again, and most likely getting something wrong and having to go back. Also there may be problems with compatibility etc... I remember having some problem compiling php with mysql support when mysql was not installed under /usr/local (something like the php configure option did not allow to specify a directory for the mysql installation). But perhaps this has changed in php 4.0.6. Regards, Neil On Thu, 29 Nov 2001 [EMAIL PROTECTED] wrote: Hello, Which version of MySQL ( RPM packages ) is good for work with php 4.0.6 and Linux Red Hat 6.2 ? Thank for your help ! Edward. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL, Red Hat Linux and php
The RPMS that are available from the MySQL WebSite are OK to use on 6.2. I personnaly prefer to use the source or .src RPMS. But the RPMS work fine on my 6.2 box. [EMAIL PROTECTED] wrote: Hello, Which version of MySQL ( RPM packages ) is good for work with php 4.0.6 and Linux Red Hat 6.2 ? Thank for your help ! Edward. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql.sock deletes itself on Solaris
mysql, query, server there is probably a cron job or sumptin that is deleting your sock file. Try putting it in a different place. [EMAIL PROTECTED] wrote: Description: /tmp/mysql.sock is there and then apparently randomly its removed without warning.. mysql still accepts TCP connections and theres no log comment to indicate an error. How-To-Repeat: It seems random.. Fix: Good question - any ideas?! Submitter-Id: steve Originator:steve Organization: Opal Telecom Plc MySQL support: none Synopsis: mysql.sock deletes itself on solaris Severity: critical Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.42 (Source distribution) Server: /usr/local/mysql/bin/mysqladmin Ver 8.21 Distrib 3.23.42, for sun-solaris2.7 on sparc Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.42 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 1 hour 23 min 50 sec Threads: 5 Questions: 15283 Slow queries: 3 Opens: 16 Flush tables: 1 Open tables: 10 Queries per second avg: 3.038 Environment: System: SunOS mail-3 5.7 Generic_106541-08 sun4u sparc SUNW,Ultra-5_10 Architecture: sun4 Some paths: /usr/bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/local/bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: -rw-r--r-- 1 bin bin 1690732 Oct 14 1999 /lib/libc.a lrwxrwxrwx 1 root root 11 Jul 11 11:33 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1109336 Oct 14 1999 /lib/libc.so.1 -rw-r--r-- 1 bin bin 1690732 Oct 14 1999 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Jul 11 11:33 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1109336 Oct 14 1999 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql.sock ???
Or you could add path-to-unix-socket= somewhere else than /tmp Sometimes your machine will delete things in the /tmp directory without you knowing. I put it in /var/lib/mysql (linux). Ed Carp wrote: Riccardi Moreno ([EMAIL PROTECTED]) writes: Hi all, I've installed mysql 3.23.42 on Freebsd system but when i launch mysql i said me can't connect to localhost /tmp/mysql.sock not found. How can i repair this error? First, you can refrain from posting the same question twice. Second, you can RTFM before posting - specifically, http://www.mysql.com/doc/P/r/Problems_with_mysql.sock.html You can also look at Carsten's *excellent* FAQ - specifically, http://www.bitbybit.dk/mysqlfaq/faq.html#ch10_1_0 -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Embedding MySQL in an application
You need to download the MySQL-4.0 source and compile for
embedded-server. This is a library that you link your programs to.
It is used for small devices, like what we are doing here.
I haven't found any docs on it yet, but the header files give plenty or
explaination.
Hope that helped
Brian Austin
On Thu, 9 Aug 2001, Alex Page wrote:
From: Shawn P. Garbett [EMAIL PROTECTED]
Sent: Thursday, August 09, 2001 3:07 PM
Subject: Fwd: Re: Embedding MySQL in an application
The real point is, that a user can take the product out of shrink rap,
install it, run the program and never fiddle one iota with installation of
MySQL or even know that MySQL is running on the system.
So what you're essentially talking about is embedding the MySQL *binary* in
an
application? There are a lot of reasons why this is a bad idea - it'll
replicate unnecessarily if more than one application does this, you won't be
able to upgrade MySQL (to, say, fix security holes) without upgrading the
application...
...but I suppose that massively monolithic, repetitive code is the way of
the Windows world...
MySQL is entirely
embedded within the application. Sure I could write drivers in the
database
module that did all this with flat-files, but ugh what a horrible thought.
In perl:
use DBI;
if ( -x /usr/local/mysql/bin/mysql ) {
require DBD::mysql;
} else {
require DBD::CSV;
}
But hey, perl's good like that.
The plan is in the future as the product line grows is to eventually tie
several products together through a seperate database engine, or have then
as
stand-alone packages.
This depends on your target platform. With your talk of Microsoft, I presume
that
you're developing for a Windows platform. The best way to do this, IMHO,
would be
to have the installation program for *your* application check to see if
MySQL is
installed (by poking in the registry?), and download and install it (perhaps
invisibly) if it isn't (or you could include MySQL with the CD of your
application, licensing issues permitting).
If you then want to port to (say) Linux, you could have the program package
have a dependency on MySQL (this seems to work very well in Debian, not sure
about RPM-based distribution) which would do exactly the same - check for
MySQL on install, and install it invisibly if it's not there.
Hope this is of some use,
Alex
--
Alex Page, IT Department, Solid State Logic
E-Mail: [EMAIL PROTECTED]
Phone: +44 (0) 1865 842 300
Web: http://www.solid-state-logic.com
**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
**
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RE : WELCOME to mysql@lists.mysql.com
On Sun, 5 Aug 2001, SOHM Philippe wrote: Hi, I'd like to add a function MD5() to mysql with CREATE FUNCTION Someone can help me ? I know nothing in C Philippe That might be a problem if you wnat to compile in your own function. You might want to try a UDF instead. I don't use them much, but I hear they are pretty easy to write. Hope that helps. Brian Austin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
mysqld as a library in 4.0
Has anyone seen any documentation for using mysqld as a library. I am building an embedded device on a machZ chipset, and I would really like to be able to use mysql for some internal querying of our data collection. I can get it to run (barely) as is, but need more room and memory for other parts of the device. any help would be appreciated. Thanks in advance Brian Austin greenleaf technologies austin, texas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
