Multiples instances of MySQL
Hello all, Could someone please advise, what is the procedure to start and run more than one instance of MySQL? Kind regards Emmanuel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Multiples instances of MySQL
See manual section 4.1.4. - Original Message - From: Emmanuel van der Meulen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, December 30, 2001 9:47 AM Subject: Multiples instances of MySQL Hello all, Could someone please advise, what is the procedure to start and run more than one instance of MySQL? Kind regards Emmanuel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
SSL connection question Again!
Happy New Year! I'm Sorry if this question has been posted often. but i cannot find answer. I have installed openssl and MySQL 4.0.1 with --with-openssl --with-vio And... mysql SHOW VARIABLES LIKE '%ssl%' ; +---+---+ | Variable_name | Value | +---+---+ | have_openssl | YES | +---+---+ 1 row in set (0.10 sec) and I granted somebody with REQUIRE SSL. But He cannot connect to MySQL using mysql . mysql client does not support SSL connection? How can he/she connect to MySQL with SSL? about PHP and MySQL? I'm very pleased if give me any Information ! Thank you for advanced Answer! Homepage = http://www.nnr.or.kr/inos/ ICQ # = 123534385 Member of DSN(database.sarang.net), NNR(nnr.or.kr) --MIME Multi-part separator-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 compiling
Hi! Esko == Esko Ilola [EMAIL PROTECTED] writes: Esko The Compaq CC compiler (V6.4) has slightly different prototype for strtoll Esko than does the version with mysql. The difference is not that big and would Esko not affect to execution but the compiler thinks this as a bad thing and Esko gives You an error. Esko I've included the global.h with a fix to this problem. Esko /Esko Thanks for the patch. I belive that all compilers should be able to handle: typedef unsigned long long int ulonglong; typedef long long int longlong; So I have now changed global.h to always us this construct. Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Embedded MySQL terminate abnormally.
I installed Embedded MySQL( compiled --with-embedded-server) And I compiled source code from Manual. (I did not modify the source) compiled nicly, but I run the Embedded MySQL, Segmentation fault occured [wertyu@inos prog]$ ls Makefile mysqld* mysqld.c mysqld.c~ [wertyu@inos prog]$ ./mysqld Segmentation fault [wertyu@inos prog]$ here is output from GDB Program received signal SIGSEGV, Segmentation fault. 0x8051984 in vio_read () (gdb) bt #0 0x8051984 in vio_read () #1 0x807357d in net_clear () #2 0x804857f in simple_command () #3 0x80494f0 in mysql_close () #4 0x80481e8 in main (argc=1, argv=0xb594) at mysqld.c:54 #5 0x8230a51 in __libc_start_main (main=0x80481a0 main, argc=1, argv=0xb594, init=0x80480b4 _init, fini=0x82782d0 _fini, rtld_fini=0, stack_end=0xb58c) at ../sysdeps/generic/libc-start.c:78 (gdb) gcc version = 2.91.66 OS version = Redhat 6.0 Thank you for advanced answer! Homepage = http://www.nnr.or.kr/inos/ ICQ # = 123534385 Member of DSN(database.sarang.net), NNR(nnr.or.kr) --MIME Multi-part separator-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.org
I see the MySQL.org is now pointing to the MySQL.com site. I have not been able to get an update anywhere on the Nusphere / MySQL lawsuit. The was no recent news on the MySQL site and nusphere seems to be having server problems. Can anyone shed some light on the latest? sql, mysql Fred Steinkopf - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.org
Hi, Well, it certainly seems to be pointing to MySQL.com alright. Although the domain name registrant is still NuSphere and DNS still appears to be handled by NuSphere's command the IPAddress it resolves to is definitely that of MySQL.com. Hmmm, I certainly hope this is justice and not just carrot dangling. Does anyone have any info from the team yet? Regards Andy. - Original Message - From: Frederick L. Steinkopf [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, December 30, 2001 3:09 PM Subject: MySQL.org I see the MySQL.org is now pointing to the MySQL.com site. I have not been able to get an update anywhere on the Nusphere / MySQL lawsuit. The was no recent news on the MySQL site and nusphere seems to be having server problems. Can anyone shed some light on the latest? sql, mysql Fred Steinkopf - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
4.0.1 Linux binary won't launch
Hi all, Downloaded the binary distribution of 4.0.1 for Linux, and am attempting to launch on an HP laptop with RedHat 7.0. This will replace my already functional installation of 3.23.46. When I go to launch, it gives me the Starting mysqld daemon with databases... etc. message. It then fails immediately with the message mysqld ended. Here's the content of the error file in the data directory: 011230 12:14:48 mysqld started /usr/local/mysql/bin/mysqld: Fatal error: Can't find messagefile '/usr/local/mysql-4.0.1-alpha-pc-linux-gnu-i686/mysql-4.0.1-alpha-pc-linux-gnu-i686/share/mysql/english/errmsg.sys' 011230 12:14:48 Aborting 011230 12:14:48 mysqld ended So, the error is pretty obvious -- the mysql directory is named twice in the path. My question: where do I go to change this? Thanks all, /Rob -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting Searchable MySQL List Archive: http://archive.workmate.ca/myarchive - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 RPM Install Problem - Ignorance
Hi Dennis, There's several ways you can move the datafile location: 1. create a symlink at /var/lib/mysql that points to your data directory 2. you can change or add the 'datadir' variable in your my.cnf file (usually /etc/my.cnf) see: http://www.mysql.com/doc/C/o/Configuring_MySQL.html 3. you can specify the data directory location as a configure option before compiling. Lots about this issue in the archives, too. Take a look. Hope this helps, /Rob At 09:56 -0600 2001/12/30, DWilliams wrote: Hi all, I have recently installed a MySQL server and client RPM 3.23.47 on a Linux system. The system that I am setting up is a Cobalt RAQ4, first time for me to install MySQL on Linux. The installed datadir turned out to be /var/lib/mysql. I get errors when trying to move a very large MySQL data (800MB) directory from a previous host system. It turns out that the /var directory has it's own partition, I think. A 'df' command shows not enough room on the /var directory for the MySQL data files. I am thinking I need to change the datadir variable to somewhere on the /home directory, where I have 15GB free. How can I achieve this? Or is this the right approach? I think I understood that the server can be started up with a different --datadir option, but I would like this to be more permanent in case of system reboots. Thanks, Dennis Williams -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting Searchable MySQL List Archive: http://archive.workmate.ca/myarchive - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
InnoDB ibd file hit 400MB default
I've been using InnoDB for the last week or so with good results then all of a sudden I started getting errors : table is full. I finally tracked it down to the size of the IBD file which I had at the 400MB default. Does an IBD file expand out columns to their data type max size ? I have some TEXT columns that are sparsely used that I'm thinking are the cause of large space wasting. What can I do when my IBD file reaches the 2GB Linux file size limit ? Which alternate file system should I use for 2GB or should I switch to BSD ? Is there any way to have separate IBD files for each MySQL table or at least DB ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Embedded MySQL terminate abnormally.
At 23:46 30/12/2001 +0900, Heo, Jungsu Mr. wrote:
Hi!
Below the patch made by Monty:
(/my/mysql) bk diffs sql/net_serv.cc
= sql/net_serv.cc 1.32 vs edited =
170c170
#ifndef EXTRA_DEBUG
---
#if !defined(EXTRA_DEBUG) !defined(EMBEDDED_LIBRARY)
(/my/mysql) bk diffs -c sql/net_serv.cc
= sql/net_serv.cc 1.32 vs edited =
*** /tmp/net_serv.cc-1.32-4839 Sat Dec 22 15:13:31 2001
--- edited/sql/net_serv.cc Sun Dec 30 12:43:17 2001
***
*** 167,173
void net_clear(NET *net)
{
! #ifndef EXTRA_DEBUG
int count; /* One may get 'unused' warn */
bool is_blocking=vio_is_blocking(net-vio);
if (is_blocking)
--- 167,173
void net_clear(NET *net)
{
! #if !defined(EXTRA_DEBUG) !defined(EMBEDDED_LIBRARY)
int count; /* One may get 'unused' warn */
bool is_blocking=vio_is_blocking(net-vio);
if (is_blocking)
Regards,
Miguel
I installed Embedded MySQL( compiled --with-embedded-server)
And I compiled source code from Manual.
(I did not modify the source)
compiled nicly, but I run the Embedded MySQL,
Segmentation fault occured
[wertyu@inos prog]$ ls
Makefile mysqld* mysqld.c mysqld.c~
[wertyu@inos prog]$ ./mysqld
Segmentation fault
[wertyu@inos prog]$
here is output from GDB
Program received signal SIGSEGV, Segmentation fault.
0x8051984 in vio_read ()
(gdb) bt
#0 0x8051984 in vio_read ()
#1 0x807357d in net_clear ()
#2 0x804857f in simple_command ()
#3 0x80494f0 in mysql_close ()
#4 0x80481e8 in main (argc=1, argv=0xb594) at mysqld.c:54
#5 0x8230a51 in __libc_start_main (main=0x80481a0 main, argc=1,
argv=0xb594, init=0x80480b4 _init, fini=0x82782d0 _fini,
rtld_fini=0, stack_end=0xb58c) at ../sysdeps/generic/libc-start.c:78
(gdb)
gcc version = 2.91.66
OS version = Redhat 6.0
Thank you for advanced answer!
Homepage = http://www.nnr.or.kr/inos/
ICQ # = 123534385
Member of DSN(database.sarang.net), NNR(nnr.or.kr)
--MIME Multi-part separator--
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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, goto https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil
___/ 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
database accessable by everybody
Hi i'm a linux newbie! I need to create a database that is accessable by everybody but i can't find an easy to use example of this. I have seen many attempts at it, but none that say, do this and that, here is an example TAH DAH!. That is what I need. I have setup a database and that was quite easy, it can only be accessed by the user that created it though. Please help! If this doesn't fly soon the wife will ask why I spent money on a Linux box that I don't use! EEECK! _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.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: InnoDB ibd file hit 400MB default
Innobase allows you to specify multiple data files and will use them automatically. So to keep under the 2gb limit just keep adding 2gb files as needed. You can see how much space is left in the innobase data files by doing the following query: show table status from 'dbname' like 'tablename'. ryan - Original Message - From: Sam Lam [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Sunday, December 30, 2001 12:00 PM Subject: InnoDB ibd file hit 400MB default I've been using InnoDB for the last week or so with good results then all of a sudden I started getting errors : table is full. I finally tracked it down to the size of the IBD file which I had at the 400MB default. Does an IBD file expand out columns to their data type max size ? I have some TEXT columns that are sparsely used that I'm thinking are the cause of large space wasting. What can I do when my IBD file reaches the 2GB Linux file size limit ? Which alternate file system should I use for 2GB or should I switch to BSD ? Is there any way to have separate IBD files for each MySQL table or at least DB ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
OleDB
Anyone know how to write a connectionstring for the OleDB in ASP. I get all different kinds of errors when i try to do this. I write rsDB.ActiveConnection =Provider=MySQLProv; Data Source=server=localhost;DB=test but it don't work - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: It stoped working, and won't work anymore
Our site has been turfed b/c of an identical problem, and despite many people reporting the same problem, no useful advice has yet surfaced. Our site has been running for over a year (non-stop) with no incident. Yesterday I logged on and noticed that mysqld was not accepting connections. After trying to restart the server, reboot the machine, checking permissions, etc, I decided to try an reinstall. Every type of install results in the process hanging at: Installing all prepared tables I have tried various RPMS and building from source. After killing the process there are no tables in the mysql folder. I have tried: - checking hostname - checking freespace - making sure there is a mysql user - making sure there is a mysql group - chowning all files in /var/lib/mysql to mysql:mysql (including /var/lib/mysql) - chmoding all files 777 (and everything below) - running mysql_install_db --user=mysql - running mysql_install_db --user=root - erasing all pids, socks and locks - creating a /etc/my.cnf file with user=mysql but I can not get beyond mysql_install_db Despite this I have copied in backed up tables into the mysql folder and have tried to start mysql (even as root). Error log says: 011230 13:52:55 mysqld started Yet I can not connect through the client, or use mysqladmin status, etc. Everything just hangs. Any advice would be appreciated, our (live) site has been down for 2 days and it seems like the only solution is to go to our co-location center and upgrade to 7.1 (or format). Although having sifted through the last 2 years worth of messages and seeing this problem reported several times with no solution, it doesn't look good.. Thanks! -mark I've decided to ask for help after 8 hours, two reinstalls, and searching the mail archives...ARGH!! System 586, RedHat 6.2, MySQL 3.22.32 Anyway, installed mysql 5 days ago, every thing went smooth with the RPM install. No problems. I made a couple of little databases, added some users, all was smooth. Then today, I couldn't connect to the database from command line 'mysql -u myname'. The mysql client would just hang and sit there, no verbose, no warnings, nothing. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: General database questions
* Emmanuel van der Meulen Roger, I attempted adding additional space with a new file under innodb_data_file_path as follows; Before: innodb_data_file_path = ibdata1:50M;ibdata2:50M After : innodb_data_file_path = ibdata1:50M;ibdata2:50M;ibdata3:50M Stopped and restarted MySQL, but this did nothing. Could you please point me! I have no idea, try URL: http://www.mysql.com/doc/I/n/InnoDB.html Maybe someone on the list who have actually used the inndb tables could give you a hint...? Knowing almost nothing about MySQL InnoDB, I looked at the .frm file, thinking they are the data files, and they have a file size of 9kb. :) Mystery solved. This is also my understanding. It scares me. Thus when using MySQL with InnoDB, all data of all databases on my different website stages, viz., PROD, QA, DEV would share the same InnoDB dataspace for data. yes, but this is not so bad, is it...? Thus PROD data is at risk. why? And furthermore, data cannot be backed up separately. Yes, it can, the mysqldump utility will address the _database_, but you can not do backups of individual databases by simply copying the files on the OS level, like you can with myisam tables. I feel this is an oversight of MySQL InnoDB. And let me add further, my concern is that when I eventually go live, with a HSP, that my data would thus be shared further with other websites hosted on the same server. It is not a very big difference between one 'tablespace' (or multiple, possibly spanning multiple disks) sharing multiple databases, and one (or more) disks with separate databases in separate files. The database partition can be seen as a kind of filesystem... Surely I'm overlooking something. Could this please be logged as a major issue? It is an issue, but I don't think it is a big issue. InnoDB sharing the same dataspace, and therefore different unrelated databases's data being at risk. What exactly do you see as a risk? -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: It stoped working, and won't work anymore
On Sun, 2001-12-30 at 14:12, mark priatel wrote: Our site has been turfed b/c of an identical problem, and despite many people reporting the same problem, no useful advice has yet surfaced. I've decided to ask for help after 8 hours, two reinstalls, and searching the mail archives...ARGH!! System 586, RedHat 6.2, MySQL 3.22.32 It sounds like there is a vendor-specific (RedHat) problem, as I've been using prebuilt mysql daemons for a year now (Debian) and haven't experienced this. Perhaps check again to see if there is a newer version available - mine reports 3.23.46 as the version. Billy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: General database questions
Hello Roger, [snip] Roger, I attempted adding additional space with a new file under innodb_data_file_path as follows; Before: innodb_data_file_path = ibdata1:50M;ibdata2:50M After : innodb_data_file_path = ibdata1:50M;ibdata2:50M;ibdata3:50M Stopped and restarted MySQL, but this did nothing. Could you please point me! I have no idea, try URL: http://www.mysql.com/doc/I/n/InnoDB.html Maybe someone on the list who have actually used the inndb tables could give you a hint...? I got this to work, I suspect a typo resulted that it did not work the first time. It was a matter of adding the extra ibdata file (as above), stop/start, and viola, space was added. [snip-1] This is also my understanding. It scares me. Thus when using MySQL with InnoDB, all data of all databases on my different website stages, viz., PROD, QA, DEV would share the same InnoDB dataspace for data. yes, but this is not so bad, is it...? [snip-2] Thus PROD data is at risk. why? [snip-3] And furthermore, data cannot be backed up separately. Yes, it can, the mysqldump utility will address the _database_, but you can not do backups of individual databases by simply copying the files on the OS level, like you can with myisam tables. [snip-4] What exactly do you see as a risk? Well, i.r.o. the matter of risk, if different websites's data is in one set of files, and especially with DEV, where programs which still have bugs or with finger trouble, could damage the data in general for PROD system; also they would interfere with PROD throughput etc. I have an extremely good backup program which I would stick to; now it'll be fine with different databases each at a separate location. At some point, I'll also look at mysqldump, thank you. NB. In the meantime, I also posted this issue to InnoDB's Heikki Tuuri, who confirmed my concerns - but only if used in one MySQL server instance; he advised the actual way to handle this, is to run separate MySQL server instances. I'm busy setting this up. With different instances, each instance could have its dedicated datadir etc. I use Win2k Pro; struggling with multiple instances; MySQL does not see the /mysql/data/my.cnf - for some reason it only sees c:/winnt/my.ini and c:/my.cnf. I started another thread, 'Multiples instances of MySQL' asking for assistance. BTW, Heikki's response; [snip] It is better to run a different instance altogether of mysqld for production and development systems. Development will inevitably cause disturbance to a production system. The same with co-hosting: high load on one database will make others freeze. [snip-1] It is not a very big difference between one 'tablespace' (or multiple, possibly spanning multiple disks) sharing multiple databases, and one (or more) disks with separate databases in separate files. The database partition can be seen as a kind of filesystem... [snip-2] It is an issue, but I don't think it is a big issue. Sorted with finesse with multiple instances. Anyway, Roger thank you for all your assistance. And BTW, the more I work with MySQL, the more I'm enjoying it. Kind regards Emmanuel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Multiples instances of MySQL
Hello Tony, Thank you for your note and assistance. However, I'm stuck on a particular point; I use Win2k Pro; struggling with 3rd option below, 'server-specific options', for multiple instances; MySQL does not see the \mysql\data\my.cnf options file, for some reason it only sees c:\winnt\my.ini and c:\my.cnf. Got this from the manual - 4.1.2; Filename Purpose windows-system-directory\my.ini Global options C:\my.cnfGlobal options C:\mysql\data\my.cnf Server-specic options MySQL tries to read option files in the order listed above. If multiple option files exist, an option specified in a file read later takes precedence over the same option specified in a file read earlier. Options specified on the command line take precedence over options specified in any option file. Some options can be specified using environment variables. Options specified on the command line or in option files take precedence over environment variable values. I cannot see where I'm going wrong; is this possibly a version 4.0.1 option. I'm using, 3.23.46-max. I also looked at 4.7.3, cannot figure out where and how to use mysqld# outside the my.cnf options file. Tony, could you please point me? Kind regards Emmanuel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 RPM Install Problem - Ignorance
Robert, Thanks for the tips... 1. create a symlink at /var/lib/mysql that points to your data directory I had read that this might not be the best way prior to v4.0, something about an alter table statement might ignore the symlink? 2. you can change or add the 'datadir' variable in your my.cnf file (usually /etc/my.cnf) see: I apparently don't have a 'my.cnf' file after install...I found the following in /usr/share/mysql/: my-huge.cnf my-large.cnf my-medium.cnf my-small.cnf I guess these are example my.cnf files to use...If so, the next question which is the appropriate/best type? I guess whatever choice should be renamed and located as 'my.cnf' in /var/lib/mysql directory? I'm assuming the server on start-up reads this file and overrides compiled commands. Which section does the 'datadir=path/to/data/' command go...to the [mysqld] section? There is no mention of this command on: http://www.mysql.com/doc/O/p/Option_files.html 3. you can specify the data directory location as a configure option before compiling. Eventually, I will learn how to do this...but I opted for the RPM instead. I guess that is why I have these sort of configuration difficulties. Thanks again, Dennis Williams - Original Message - From: Robert Alexander [EMAIL PROTECTED] To: DWilliams [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, December 30, 2001 11:51 AM Subject: Re: MySQL RPM Install Problem - Ignorance Hi Dennis, There's several ways you can move the datafile location: 1. create a symlink at /var/lib/mysql that points to your data directory 2. you can change or add the 'datadir' variable in your my.cnf file (usually /etc/my.cnf) see: http://www.mysql.com/doc/C/o/Configuring_MySQL.html 3. you can specify the data directory location as a configure option before compiling. Lots about this issue in the archives, too. Take a look. Hope this helps, /Rob At 09:56 -0600 2001/12/30, DWilliams wrote: Hi all, I have recently installed a MySQL server and client RPM 3.23.47 on a Linux system. The system that I am setting up is a Cobalt RAQ4, first time for me to install MySQL on Linux. The installed datadir turned out to be /var/lib/mysql. I get errors when trying to move a very large MySQL data (800MB) directory from a previous host system. It turns out that the /var directory has it's own partition, I think. A 'df' command shows not enough room on the /var directory for the MySQL data files. I am thinking I need to change the datadir variable to somewhere on the /home directory, where I have 15GB free. How can I achieve this? Or is this the right approach? I think I understood that the server can be started up with a different --datadir option, but I would like this to be more permanent in case of system reboots. Thanks, Dennis Williams -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting Searchable MySQL List Archive: http://archive.workmate.ca/myarchive - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Support for older Berkeley databases
Hello Does MYSQL currently support, or has it ever supported the old Berkeley database version 1.8? Thanks David Robinson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: General database questions
* Emmanuel van der Meulen I got this to work, I suspect a typo resulted that it did not :) Well, i.r.o. the matter of risk, if different websites's data is in one set of files, and especially with DEV, where programs which still have bugs or with finger trouble, could damage the data in general for PROD system; also they would interfere with PROD throughput etc. Yes, but is there really a big difference as long as the data is on the same disk computer? I would keep PROD on a separate physical machine... If the databases are in the same physical files or not will only matter if the inndb format itself is insecure, as far as I can see... and if you actually could destroy one table by doing some illegal operation to another table with innodb, I would simply not use it in PROD... :) Anyway, Roger thank you for all your assistance. And BTW, the more I work with MySQL, the more I'm enjoying it. HTH. :) -- Roger, also enjoying mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Multiples instances of MySQL
Hi! You could try the following: make Windows batch files where you give all options to mysqld-max.exe on the command line: instance1.bat: mysqld-max --port=3306 --socket=... --datadir=... --basedir=... --innodb_data_home_dir=... --set-variable=innodb_buffer_pool_size=30M ... instance2.bat: mysqld-max --port=3307 --socket=... ... I hope we do not run over the command line length limit! But with the above you can get rid of my.ini and my.cnf altogether, or put just the shared starup parameters to my.cnf. Actually, Monty should add a startup option to mysqld: --read_this_my_cnf=a_path_to_my_cnf_file where you could tell from what location this instance of mysqld should read its startup parameters. I am forwarding this email to Monty too. He can consider adding the above startup option. Automatically searched my.cnf files cause constant confusion. Having an option to explicitly give the path would help in many situations. Regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB Hello Tony, Thank you for your note and assistance. However, I'm stuck on a particular point; I use Win2k Pro; struggling with 3rd option below, 'server-specific options', for multiple instances; MySQL does not see the \mysql\data\my.cnf options file, for some reason it only sees c:\winnt\my.ini and c:\my.cnf. Got this from the manual - 4.1.2; Filename Purpose windows-system-directory\my.ini Global options C:\my.cnfGlobal options C:\mysql\data\my.cnf Server-specic options MySQL tries to read option files in the order listed above. If multiple option files exist, an option specified in a file read later takes precedence over the same option specified in a file read earlier. Options specified on the command line take precedence over options specified in any option file. Some options can be specified using environment variables. Options specified on the command line or in option files take precedence over environment variable values. I cannot see where I'm going wrong; is this possibly a version 4.0.1 option. I'm using, 3.23.46-max. I also looked at 4.7.3, cannot figure out where and how to use mysqld# outside the my.cnf options file. Tony, could you please point me? Kind regards Emmanuel --- - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 RPM Install Problem - Ignorance
At 14:37 -0600 2001/12/30, DWilliams wrote: Robert, Thanks for the tips... 1. create a symlink at /var/lib/mysql that points to your data directory I had read that this was not the best way prior to v4.0, something about an alter table statement might ignore the symlink? I've used symlinks a lot and have never had any problems. I usually just install the binary distro, and symlink from /usr/local/mysal/data - my/data/location. 2. you can change or add the 'datadir' variable in your my.cnf file (usually /etc/my.cnf) see: I apparently don't have a 'my.cnf' file after install...I found the following in /usr/share/mysql/: my-huge.cnf my-large.cnf my-medium.cnf my-small.cnf I guess these are example my.cnf files to use...If so, the next question which is the appropriate/best type? Just open them up in an editor and read what it says at the top. Then copy the one you want to /etc/my.cnf I guess whatever choice should be renamed and located as 'my.cnf' in /var/lib/mysql directory? I'm assuming the server on start-up reads this file and overrides compiled commands. Not in the data dir. You're telling it where to *look* for the data, right? This would be your global settings and goes into /etc/my.cnf. Which section does the 'datadir=path/to/data/' command go...to the [mysqld] section? Yup. There is no mention of this command on: http://www.mysql.com/doc/O/p/Option_files.html In a browser, open up the manual that came with your distro and do a search for 'my.cnf' Lots o' good stuff... : 3. you can specify the data directory location as a configure option before compiling. Eventually, I will learn how to do this...but I opted for the RPM instead. I guess that is why I have these sort of configuration difficulties. Thanks again, Dennis Williams Regards, /Rob -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting Searchable MySQL List Archive: http://archive.workmate.ca/myarchive - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Support for older Berkeley databases
In the last episode (Dec 31), David Robinson (AU) said: Does MYSQL currently support, or has it ever supported the old Berkeley database version 1.8? No. The whole reason the BDB table type exists is to support transactions, and BDB 1.8 doesn't. If you want the BDB table type, you'll have to install Berkeley DB 3. -- 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
Getting NO format output from cmd-line ?
Hi Folks, I use a shell script, to get data from a mysql database. I use the following call mysql -ddatabase -uusername -ppassword file_with_sql_select file_to_get_output I even tried mysql -e select foo from database -uusername -ppassword file_to_get_output but I always get as first line the names of the columns and further on data_fied_1 (several spaces (0x20)) data_field_2 Is there a way to supress headers and to get the datafields without spaces? (in one result there has been a TAB (0x09) between the fields). I just want data_field_1 (0x20) data_field_2 (\n). Thanks in advance Oliver - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: database accessable by everybody
* Curtis Gordon I need to create a database that is accessable by everybody but i can't find an easy to use example of this. I have seen many attempts at it, but none that say, do this and that, here is an example TAH DAH!. That is what I need. I have setup a database and that was quite easy, it can only be accessed by the user that created it though. Please help! If this doesn't fly soon the wife will ask why I spent money on a Linux box that I don't use! EEECK! Do you need everybody on your lan to access the database, or everybody on the internet? I guess you mean everybody on the internet... and probably they will access it through some kind of user interface... a .php or perl script, perhaps? If this is the case: connect with the same mysql-user for all actual users... you could create a mysql user called 'wwwguest' or similar, and GRANT privileges as described in the manual: URL: http://www.mysql.com/doc/G/R/GRANT.html . See also URL: http://www.mysql.com/doc/P/r/Privilege_system.html . -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Getting NO format output from cmd-line ?
* Oliver Heinisch Is there a way to supress headers and to get the datafields without spaces? (in one result there has been a TAB (0x09) between the fields). I just want data_field_1 (0x20) data_field_2 (\n). You can use the --skip-column-names parameter when calling the mysql client to avoid column names, and the CONCAT() function to create whatever output you want: SELECT CONCAT(data_field_1,' ',data_field_2) FROM table; -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
incrementing a non auto_increment column on insert
I have the ID column auto_incrementing and I don't want to change that. Newbie that I am, I tried to add auto_increment to another column and failed. Is there any way to have a field other than the ID field increment by a set value? create table test ( ID mediumint(9) NOT NULL auto_increment default 0, visitor_ID mediumint(9) NOT NULL default select 4 + ID, RandomData varchar(10) default null, PRIMARY KEY (ID) ) TYPE=MyISAM; Inserting a new record and only populating RandomData auto increments ID as expected but visitor_ID is not incremented. How can I accomplish this? Charley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 RPM Install Problem - Ignorance
Robert, Thanks again... I think I am on the right track, maybe. I am trying to use the symlink method you suggested. Below is the command I used to create a symlink named 'amgr' in /var/lib/mysql/ pointing to the real data directory of 'amgr' in /home/mysql/amgr/. The database 'amgr' shows up as a reference (with tables) when I use phpMyAdmin to view it, but the database and tables are totally empty of records...which of course it has many. ln -s /home/mysql/amgr/ /var/lib/mysql/ Also, it produces an error when I click to view one of the tables in phpMyAdmin. MySQL said: Can't find file: './amgr/.frm' (errno: 13) Did I miss something? Did I mention I was ignorant? Thanks, Dennis Williams - Original Message - From: Robert Alexander [EMAIL PROTECTED] To: DWilliams [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, December 30, 2001 3:29 PM Subject: Re: MySQL RPM Install Problem - Ignorance At 14:37 -0600 2001/12/30, DWilliams wrote: Robert, Thanks for the tips... 1. create a symlink at /var/lib/mysql that points to your data directory I had read that this was not the best way prior to v4.0, something about an alter table statement might ignore the symlink? I've used symlinks a lot and have never had any problems. I usually just install the binary distro, and symlink from /usr/local/mysal/data - my/data/location. 2. you can change or add the 'datadir' variable in your my.cnf file (usually /etc/my.cnf) see: I apparently don't have a 'my.cnf' file after install...I found the following in /usr/share/mysql/: my-huge.cnf my-large.cnf my-medium.cnf my-small.cnf I guess these are example my.cnf files to use...If so, the next question which is the appropriate/best type? Just open them up in an editor and read what it says at the top. Then copy the one you want to /etc/my.cnf I guess whatever choice should be renamed and located as 'my.cnf' in /var/lib/mysql directory? I'm assuming the server on start-up reads this file and overrides compiled commands. Not in the data dir. You're telling it where to *look* for the data, right? This would be your global settings and goes into /etc/my.cnf. Which section does the 'datadir=path/to/data/' command go...to the [mysqld] section? Yup. There is no mention of this command on: http://www.mysql.com/doc/O/p/Option_files.html In a browser, open up the manual that came with your distro and do a search for 'my.cnf' Lots o' good stuff... : 3. you can specify the data directory location as a configure option before compiling. Eventually, I will learn how to do this...but I opted for the RPM instead. I guess that is why I have these sort of configuration difficulties. Thanks again, Dennis Williams Regards, /Rob -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting Searchable MySQL List Archive: http://archive.workmate.ca/myarchive - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: General database questions
Hello Heikki, Thank you very much for this note and your valued assistance. I have the different instances of MySQL running with your proposal to add the lot to a bat file. And yes, if such a option as you propose exists, others would possibly get multiple instances / my.cnf files working more easily. BTW, I wasn't aware that I could place the InnoDB options as options on the command line. They are not mentioned as command line options in chapter 4.1.1. So it was extremely helpful that you gave me that pointer. Either way thank you again for an excellent feature and also for your clear assistance. Kind regards Emmanuel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: General database questions
Hello Roger, [snip] Yes, but is there really a big difference as long as the data is on the same disk computer? I would keep PROD on a separate physical machine... Yes, either on a separate physical machine or a different HDD (to curtail costs, I'd first go for HDD). If the databases are in the same physical files or not will only matter if the inndb format itself is insecure, as far as I can see... and if you actually could destroy one table by doing some illegal operation to another table with innodb, I would simply not use it in PROD... :) I'm certain InnoDB is 100% safe. My concern is probably related to being unfamiliar with MySQL/InnoDB. However, I take Heikki's point of the access impact of DEV on PROD - never thought of that. BTW, Heikki also assisted me to get multiple instances of MySQL going. So all is exactly as per my requirements. Until another time. Kind regards Emmanuel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Multiples instances of MySQL
Hello Heikki, Note, this is a duplicate posting - erroneously posted against 'General database questions'. Thank you very much for this note and your valued assistance. I have the different instances of MySQL running with your proposal to add the lot to a bat file. And yes, if such a option as you propose exists, others would possibly get multiple instances / my.cnf files working more easily. BTW, I wasn't aware that I could place the InnoDB options as options on the command line. They are not mentioned as command line options in chapter 4.1.1. So it was extremely helpful that you gave me that pointer. Either way thank you again for an excellent feature and also for your clear assistance. Kind regards Emmanuel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: General database questions
* Emmanuel van der Meulen I'm certain InnoDB is 100% safe. My concern is probably related to being unfamiliar with MySQL/InnoDB. However, I take Heikki's point of the access impact of DEV on PROD - never thought of that. This impact also very much applies to the cpu... I would highly recomend spending a few $ on a DEV server... doesn't need to be expensive, any old box capable of running linux and mysql will do. BTW, Heikki also assisted me to get multiple instances of MySQL going. So all is exactly as per my requirements. Great! :) -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Prepare of SQL statements
I am using the 'C' API and would like to be able to be able to get information on columns involved in a SELECT statement without executing the statement. I am also using placeholders. An example of what I would like to get info on (but not execute) is: SELECT col1 from table1 where col2 = ? Currently I am parsing the statement myself to get the field list and then getting info on the fields (pretty horrible and dangerous), and replacing the '?' at execution time. Any ideas appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--- query to find records related tables with no match?
Ack - sorry - can someone remind me the SQL format for this? if you have a linked CLIENTS and INVOICES table... ...what's the query to find CLIENTS with NO INVOICES? (say 'clientid' is the name of the field in both clients and invoices table) I think it's some kind of join=NULL but I'm stuck. 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
Null Value In a Column
Hi, I want to select record from a table that return empty string or something else that i want, if a column contains null value. can we do that in a select statement. I tried IsNUll function but it return wither 1 or 0. In MS SQL Server u got a function IsNULL that accepts 2 parameter - first the column name, second the value to be returned if that column contain null value. Is there any function MySQL? Shankar __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.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: --- query to find records related tables with no match?
From page 165 MySQL (New Riders): LEFT JOIN: SELECT t1.* FROM t1 LEFT JOIN t2 ON t1.i1 = t2.i2 WHERE t2.i2 IS NULL -- david Ack - sorry - can someone remind me the SQL format for this? if you have a linked CLIENTS and INVOICES table... ...what's the query to find CLIENTS with NO INVOICES? (say 'clientid' is the name of the field in both clients and invoices table) I think it's some kind of join=NULL but I'm stuck. Thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Null Value In a Column
Try IFNULL HTH Dan Crawford Integrated Network Strategies -Original Message- From: SankaraNarayanan Mahadevan [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 30, 2001 9:52 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Null Value In a Column Hi, I want to select record from a table that return empty string or something else that i want, if a column contains null value. can we do that in a select statement. I tried IsNUll function but it return wither 1 or 0. In MS SQL Server u got a function IsNULL that accepts 2 parameter - first the column name, second the value to be returned if that column contain null value. Is there any function MySQL? Shankar __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: OleDB
This works for me... var connectionString = Provider=MySqlProv; Integrated Security=''; Password=1234abcd; User ID=root; Location=localhost; Extended Properties=''; Data Source=test Mattias Persson wrote: Anyone know how to write a connectionstring for the OleDB in ASP. I get all different kinds of errors when i try to do this. I write rsDB.ActiveConnection =Provider=MySQLProv; Data Source=server=localhost;DB=test but it don't work - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
date_format
Hello, i'm new to mysql, so please bear with me... My database has a field called datafield as datetime. I want to display just the date #1 this works but gives the full datetime $result = mysql_query (SELECT title, description, url, author, datefield FROM documents); #2 All I have read on the web/books suggests that this is what to do $result = mysql_query (SELECT title, description, url, author, date_format(datefield, %M %D %Y') FROM documents); This just leaves out all dates. Can anyone see where I'm going wrong Thank you so much Jules - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: date_format
#2 All I have read on the web/books suggests that this is what to do $result = mysql_query (SELECT title, description, url, author, date_format(datefield, %M %D %Y') FROM documents); This just leaves out all dates. You may want to try: $result = mysql_query(SELECT title, description, url, author, date_format(datefield, '%M %D %Y') AS datefield FROM documents); You can also do $result = mysql_query(SELECT title, description, url, author, unix_timestamp(datefield) AS datefield FROM documents); then use php's date() function. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 RPM Install Problem - Ignorance
Dennis if you want to see if the /var/lib/mysql directory is on it's own partition or drive look at /etc/fstab and see which /dev it is mounted on. If you wanted to you can mount a new drive at /var/lib/mysql and have you data on it's own drive. If you have some sort of system failure you can just mount the drive on a new installation using the /etc/fstab file. Some people mount there individual databases on standalone drives. Not saying this the best way but it is one way if you can afford hardware. That leaves you root drives for programs. Regards Trevor -Original Message- From: DWilliams [mailto:[EMAIL PROTECTED]] Sent: Monday, 31 December 2001 2:56 AM To: [EMAIL PROTECTED] Subject: MySQL RPM Install Problem - Ignorance Hi all, I have recently installed a MySQL server and client RPM 3.23.47 on a Linux system. The system that I am setting up is a Cobalt RAQ4, first time for me to install MySQL on Linux. The installed datadir turned out to be /var/lib/mysql. I get errors when trying to move a very large MySQL data (800MB) directory from a previous host system. It turns out that the /var directory has it's own partition, I think. A 'df' command shows not enough room on the /var directory for the MySQL data files. I am thinking I need to change the datadir variable to somewhere on the /home directory, where I have 15GB free. How can I achieve this? Or is this the right approach? I think I understood that the server can be started up with a different --datadir option, but I would like this to be more permanent in case of system reboots. Thanks, Dennis Williams - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: General database questions
Hello Roger; [snip] * Emmanuel van der Meulen I'm certain InnoDB is 100% safe. My concern is probably related to being unfamiliar with MySQL/InnoDB. However, I take Heikki's point of the access impact of DEV on PROD - never thought of that. This impact also very much applies to the cpu... I would highly recomend spending a few $ on a DEV server... doesn't need to be expensive, any old box capable of running linux and mysql will do. Point taken, also got me thinking, thank you. Kind regards Emmanuel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
