Re: Record Lock?

Hi. On Sun 2002-12-08 at 14:50:35 +0200, [EMAIL PROTECTED] wrote: [...] SELECT * FROM your_table WHERE some-condition-for-the-row-in-question FOR UPDATE [...] I would like to clarify that InnoDB holds locks till the current transaction COMMIT or ROLLBACK. Thus, in the

RE: Quota Support

You can place the actual database files inside your user's home directory, and sym-link to them from the MySQL's data folder. That way they will contribute to the user's whole quota and you don't end up with one quota for DB and another for everything else. The drawback, of course, is that you

Re: Date field

Hello. On Sun 2002-12-08 at 16:03:22 -0500, [EMAIL PROTECTED] wrote: I am trying to store a date in the following format '08/12/2002' pr '08/12/2002' or any other format if I have to ...on SQLServer 7. This is the mysql list. What has SQLServer 7 to do with MySQL? Basically I want to use

Re: Select * From table where name Like 'help'; Help

Hello. On Mon 2002-12-09 at 01:00:33 -0500, [EMAIL PROTECTED] wrote: I am doing this search from a website, What does that mean? Which scripting language do you use? PHP? This is more a question for your website environment than about MySQL. and from what I can tell there is no way to use a

Re: Question

Hello. On Mon 2002-12-09 at 08:48:51 +0700, [EMAIL PROTECTED] wrote: Hello, every body I have 2 database server. the second is a copy of the first. It's replication. But there is no connection line because it is not necesery to have an identical copy. Every day, i have to update the second

Re: UNION

Hello. On Mon 2002-12-09 at 10:56:21 +0530, [EMAIL PROTECTED] wrote: MySQL 3.23.53 I have a table T1 and want to do something like SELECT * FROM T1 WHERE A = 1 AND xxx... UNION SELECT * FROM T1 WHERE A = 2 AND yyy... Don't read to much in the WHERE clause, this is just for question

mysql and swap

Hello! :) The problem is that after working 5-6 hours without swapping Mysql begin to swap. If I switch off swap with swapoff -a and then switch it on again after 5-6 horis withut swapping Mysql begin to swap again. Can anybody give me some advice? I'm using Apache with mod_perl enabled+mysql OS

total idiot

Okay, Let's just say I made a stupid mistake, and deleted an entire table's contents, rather than just one row. And let's also assume that the CD burn which has the latest back-up of this data has shit itself, and won't work. I'm still waiting to hear from the ISP about their own back-up, but

RE: total idiot

There is data in the logs. So you mite be able you use them to recreate the data? Simon -Original Message- From: Justin French [mailto:[EMAIL PROTECTED]] Sent: 09 December 2002 09:05 To: MySQL Subject: total idiot Okay, Let's just say I made a stupid mistake, and deleted an entire

Re: total idiot

Great idea, but everything I think I need was done with POST, and it appears my host doesn't have the most detailed logs :) I can't see anything I can use in the log file they've given me, but I'll keep looking. Thanks anyway! Justin on 09/12/02 8:11 PM, Simon Green ([EMAIL PROTECTED]) wrote:

Re: No Ä, Ö, Ü, etc.

Hello. On Mon 2002-12-09 at 07:54:46 +0100, [EMAIL PROTECTED] wrote: All 'ä', 'ö', 'ü', etc. are changing in ?,! Since MySQL simply stores what it is given, without interpreting charsets, this means that the input method/device you use and the output method/device disagree on the encoding. So

Re: No Ä, Ö, Ü, etc.

On Mon, 9 Dec 2002, Sollinger Rainer (dienstlich) wrote: All 'ä', 'ö', 'ü', etc. are changing in ?,!   What can I do against it? Rainer, first of all: tell us about your setup. What is the output of: prompt mysqladmin variables Then give an example how you populate your db with data and how

Re: mysql and swap

Hello. On Mon 2002-12-09 at 00:57:37 -0800, [EMAIL PROTECTED] wrote: The problem is that after working 5-6 hours without swapping Mysql begin to swap. How do you determine that? Is MySQL the only process on the server? If I switch off swap with swapoff -a and then switch it on again after

Re: total idiot

On Monday 09 December 2002 10:35, Justin French wrote: Great idea, but everything I think I need was done with POST, and it appears my host doesn't have the most detailed logs :) I think you are messing up httpd-Logs and MySQL logs here. The question was: Are there MySQL binlogs or ascii logs?

Re: total idiot

Hello. On Mon 2002-12-09 at 20:35:53 +1100, [EMAIL PROTECTED] wrote: Great idea, but everything I think I need was done with POST, and it appears my host doesn't have the most detailed logs :) I can't see anything I can use in the log file they've given me, but I'll keep looking. I am sure

No Ä, Ö, Ü, etc.

Thanks for all the replays, here are the details: The server is Windows 2000 with SP3 and the client is Windows XP Prof. The Frontend is written under Java and is a special programm for us. Here is my my.ini: #This File was made using the WinMySQLAdmin 1.4 Tool #04.12.2002 09:52:43

No Ä, Ö, Ü, etc. Now it works

Thanks, for all the replays, now it´s ok. The problem was in the db.properties, there was an insert like this: db.connect.suffix=characterEncoding=iso-8859-2useUnicode=true it only works without the : db.connect.suffix=characterEncoding=iso-8859-2useUnicode=true Rainer Sql, query

SELECT rows from multiple tables and order all by last added

Hi, I've joined this list today - looking for a good forum to discuss my difficulties with Mysql as they arise - I'm an SQL newbie. I'd like to construct a single query that creates one list of the contents of multiple tables (which all have a dateadded column) sorted so that output rows from

distinct and distinctrow

sql,query Hi List Please can someone help me with this: I need to filter duplicate entries from my result query, but there's a twist... The table has something like this: id namekey 1 name1 key1 2 name2 key2 3 name3 key3 4 name1 key1 5 name 1

help on NOT EXISTS SQL query

Hello all, I need to run query like (in mysql ver.4): select * from table1 as t1 where not exists (select NULL from table2 as t2 where t1.field1 = t2.field1) I know you can emulate an 'exists' subquery with a join. but I just can't think of a way to emulate a 'not exists' without a subquery.

Re: How to backup without blocking?

On 7 Dec 2002, at 14:34, Jason Brooke wrote: I just connected to one of my masters, inserted a record into a table by referencing database.table in the insert query and the query is never written to the binary log, thus the slaves never replicate it. Are you using binlog-do-db or

RE: help on NOT EXISTS SQL query

SELECT * FROM table1 t1 LEFT OUTER JOIN table2 t2 ON t1.field1=t2.field2 WHERE t2.field2 IS NULL -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Murad Nayal Sent: Monday, December 09, 2002 11:38 AM To: MySQL List Subject: help on NOT EXISTS SQL

Re: Compile error on HPUX

Benjamin, Thanks for you information, now I tried to use gcc compile: CC=gcc CXX=gcc CXXFLAGS=-O3 ./configure Configure has no problem. But When I run make, I got: gcc -O3 -DDBUG_OFF -DHAVE_BROKEN_PREAD -DDONT_USE_FINITE -DHAVE_BROKEN_GETPASS -DNO_FCNTL_NONBLOCK

A log for mysqlimport.

Hello everybody, I played with mysqlimport because I must transfer a db from msql to mysql. I have 1.600.000 records to transfer. Everything's perfect except when I finished the import, I have Warning:16. All the records were transfered. So, my question is: is there a log created by mysqlimport

Re: Can't connect error 10061 - nothing but Mascon works remotely.

Dear Daevid, [root@daevid]# mysqladmin ping -h daevid.com -uroot -p [root@daevid]# mysqladmin ping -h 192.168.1.254 -uroot -p mysqld is alive So this means a connection is possible, and it doesn't matter whether you issue a host name or an ip number. Now you have two programs that can access

Re: FULLTEXT

I'm an ex-Lasso developer, using PHP now. More of a pricing issue than anything else. 1) Are you trying to combine 15 columns together into one full text index? It sounds like you are trying to setup freeform searching on structured data. If you really need to do this you might want to think

Re: Start up problem

It's OK, MySQL start... On Mon, 09 Dec 2002 10:48:47 -0600 gerald_clark [EMAIL PROTECTED] wrote: # su mysql $ mysqld What do you see now? Touch13 wrote: The data directory is well owned by mysql. In fact my problem is : I cannot start mysql daemon in root user with change user

re: SELECT rows from multiple tables and order all by last added

On Monday 09 December 2002 13:23, Angus Fraser wrote: Hi, I've joined this list today - looking for a good forum to discuss my difficulties with Mysql as they arise - I'm an SQL newbie. I'd like to construct a single query that creates one list of the contents of multiple tables (which all

re: autoextend on innoDB tables

anders, Friday, December 06, 2002, 1:14:04 PM, you wrote: adnaxsds In an attempt to use innoDB tables I added this to my 'my.cnf': adnaxsds innodb_data_home_dir = adnaxsds innodb_data_file_path = /var/mysql/admin/ibdata1:100M:autoextend adnaxsds mysqld claimed this was an syntax error if I

Re: Select * From table where name Like 'help'; Help

I am using PHP on my website, but this is certainly a MySQL question. That shouldn't matter, because the real value $var is inserted before the query is send to the MySQL server, where REGEXP of the query is evaluated. If there is a problem, you need to be much more specific. Quote the error

backrev mysql while retaining data?

Due to some application compatibility issues, I may have to backrev mysql-3.23.53a-1 to 3.23.52-3. I have only a few weeks' experience with mysql -- can I do this and retain the current tables and data contained therein? Ron - I do not love the bright sword for its sharpness, nor the

A log for mysqlimport.

Hello everybody, I played with mysqlimport because I must transfer a db from msql to mysql. I have 1.600.000 records to transfer. Everything's perfect except when I finished the import, I have Warning:16. All the records were transfered. So, my question is: is there a log created by mysqlimport

Re: Problem compiling mysql-3.23.53

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Mon, 9 Dec 2002, Pierre wrote: I tried mysql-4.0.5a-beta, and same error... Try to compile without --with-libwrap - seems like there is a buglet in this part of the code - or do you desperately need TCP wrapper support? Bye, LenZ - --

Re: Error compiling mysql 3.23.53

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Mon, 9 Dec 2002, Pierre wrote: I try to compile mysql-3.23.53 on my GNU/Linux system with gcc-3.2 there was no problem with the configure, but for the make I got this : [...] Making all in isam gmake[2]: Entering directory

Re: Select * From table where name Like 'help'; Help

My mistake, I assumed the space was just for clarity and not really meaningful, but since it is between the ' ' it makes sense that is. I tried a few variations on this and think I have found what I need - where title like binary '%$var%. Notice the key word 'binary' which makes the world of

Re: Question about SLAVE STOP

Hello. On Mon 2002-12-09 at 08:17:41 -0600, [EMAIL PROTECTED] wrote: I know that the slave will honor transactions but how does that effect the STOP SLAVE command? Based on your note, I'm assuming (Oh, that nasty word!) that if the stop slave is issued in the middle of a transaction it will

Re: Record Lock?

Benjamin, - Original Message - From: Benjamin Pflugmann [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, December 09, 2002 9:58 AM Subject: Re: Record Lock? Hi. On Sun 2002-12-08 at 14:50:35 +0200, [EMAIL PROTECTED] wrote: [...] SELECT *

Re: Select * From table where name Like 'help'; Help

Andy, I mentioned in my previous email that I am using PHP, and I have also tried putting quotes around $var (many different ways) with no better results. REGEXP just gives a syntax error when I do this. Through the suggestion of another list user I have found a way that suits my needs using the

MySQL Command to List existing db's = ??

I have a Linux/Apache/MySQL box with a number of MySQL db's on it... all were created by someone else expermenting with MySQL... I'm not sure of all the names of the db's on the system... Is there a MySQL command to List the names of all the MySQL db's on the box? The system is not on the

Re: help on NOT EXISTS SQL query

Thanks Adolfo, this actually won't quite do the trick though. I should have been a bit more specific. the query actually comes up in the context of computational genomics. a similar, perhaps more familiar problem would be something like this: table id customer purchase 1 c1 microwave 2

segmentation fault with mysql_num_rows - C API in Apache module

I am writing an Apache module that has to perform some queries against a MySQL database. For the most part, it is working properly. However, when I get an empty result set for my query (that is, the select returns no rows) I get a segmentation fault when trying to call mysql_num_rows. Here is

locking issues

Hi All, I may be confused here but it would appear that when you issue a LOCK TABLES tbl_name { READ|WRITE }; You cannot read from another unlocked table in the same connection eg: mysql LOCK TABLES users read; Query OK, 0 rows affected (0.00 sec) mysql select * from Logger limit 1; ERROR

Re: distinct and distinctrow

On Mon, 2002-12-09 at 12:45, Petre Agenbag wrote: sql,query [snip] I need to filter duplicate entries from my result query, but there's a twist... [snip] Where name 1 key1 was obviously a typo, yet, I would ideally want to filter or flag this through some kind of logic = ( there is already a

Error: Can't lock file

I am getting the following error while trying to do read-write queries on MySQL. Does anyone know what this error means? The name of the script that generated this error is called randomreadwrite.pl. Can't lock file (errno: 12) at ./randomreadwrite.pl line 54. Line 54 does the following:

Re: QUICK: What is the optimal way to store opening times ?

On Fri, Dec 06, 2002 at 05:54:53PM +0100, Alliax wrote: I have one question : if I go the RestTimes route, that is having a row per day and so 7 row per restaurants : can I, in one SQL request, know if THAT restaurant is open or close now ? I now there are NOW() function in SQL and probably

Re: How to backup without blocking?

On Sat, Dec 07, 2002 at 02:34:01PM +1000, Jason Brooke wrote: ...and then do the insert query it's written to the binary log fine, and of course picked up by the slaves. Similarly when using mysql via Php, if I don't use mysql_select_db() and instead, simply use mysql_query() and specify the

[mysql] Lock status

I'am working with MySQL 3.23.51-Max in a linux box and Visual Fox and Delphi in a WinXP box, mostly using InnoDB tables. Is there a way to know wich rows are lockedin a table? is there a function that returns if a row is locked, or the rows locked in a table? It can be done with a UDF? My

Buffer Pool Hit Rate calculation

Hi, Greets! I am a beginner in MySQL DBA. I am having InnoDB installed MySQL version is 3.23.53. I am also getting the statistics through InnoDB monitor. In that i am getting the Buffer pool hit rate as 1000 / 1000. I unable to understand how it has been calculated? I am getting the hit rate

OBDC and MySQL 4.0.5a

Greetings: I installed MySQL 4.0.5a using the RPMs downloaded from http://www.mysql.com on RedHat 8.0. I also installed unixODBC that comes with the RHL 8.0 CD. When I try to install the MySQL odbc driver I get the unresolved dependency: libmysqlclient.so.10 I created a symlink from

Re: OT Select * From table where name Like 'help'; Help

On Mon, Dec 09, 2002 at 09:22:09AM -0500, Beauford.2003 wrote: The real value of $var is not inserted before it is sent to the server. REGEXP thinks that 'var' is part of the search pattern because $ is a reserved operator for REGEXP. So what gets sent to the server is totally Have you tried

RE: MySQL Command to List existing db's = ??

If I understand right try.. SHOW DATABASES; The mysql and test database are installed by default. Hope this helps -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 8:12 PM To: [EMAIL PROTECTED] Subject: MySQL Command to List existing

Re: Select * From table where name Like 'help'; Help

This is most definitely a quoting issue with your PHP string. If it is quoted correctly, the MySQL server will never see the string $var appearing after the keyword REGEXP, so if $ has meaning to a regular expression wouldn't matter (unless the value of $var contained a $). I've used REGEXP

Re: Select * From table where name Like 'help'; Help

You still have not mentioned what language you are using to interface with MySQL. If you are using PHP or Perl, then things like single and double quotes will make a difference here, and looking in the MySQL manual will not help you. Check the string that contains the query, if it looks like

Re: Select * From table where name Like 'help'; Help

On Mon, 2002-12-09 at 16:10, Beauford.2003 wrote: Andy, I mentioned in my previous email that I am using PHP, and I have also tried putting quotes around $var (many different ways) with no better results. REGEXP just gives a syntax error when I do this. I'm sorry, I did miss the where you

RE: Can't connect error 10061 - nothing but Mascon works remotely.

[root@daevid]# mysqladmin ping -h daevid.com -uroot -p [root@daevid]# mysqladmin ping -h 192.168.1.254 -uroot -p mysqld is alive But as I see, you tried the ping from the local host (i.e. you connected from the same machine where the MySQL server is running). What happens if you try

Multiple MySQL db's on one machine

I was told that if you had multiple MySQL db's on a single machine... that actually it was really only one db with tables for for db1, db2, db3... ??? This doesn't sound right. I thought MySQL created a seperate directory for each db put each db's files in their respective folder... true or

Re: help on NOT EXISTS SQL query

Hello Stefan, thanks for the feedback. I think I probably misstated my problem. I just emailed a more explicit example of the sort of thing I am trying to do. for the sake of completeness I'll reproduce it here: table id customer purchase 1 c1 microwave 2 c1 car 3 c1

RE: RE: relational is relational is relational, but ...

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 6:00 PM To: Jon Frisby Subject: Re: RE: relational is relational is relational, but ... Your message cannot be posted because it appears to be either spam or simply off

Re: mysql port number

I use freeBSD and like to use sockstat -4. It tells you the user, the command that is used and the PID, Protocol local address and the foreign address it is connected to. - Original Message - From: Brian P. Austin [EMAIL PROTECTED] To: Mike At Spy [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]

Re: backrev mysql while retaining data?

Dear Ronald, Due to some application compatibility issues, I may have to backrev mysql-3.23.53a-1 to 3.23.52-3. I have only a few weeks' experience with mysql -- can I do this and retain the current tables and data contained therein? Backup your databases and tables first. I would suggest

Re: Can't connect error 10061 - nothing but Mascon works remotely.

Dear Daevid, I don't have mySQL installed on the XP box, so I can't run mysqladmin. I knew your answer to this before I pressed the send button ;-) Do install MySQL on your Win XP box. The installation procedure will not start the MySQL server, so there's nothing to worry about. If you leave

Re: help on NOT EXISTS SQL query

Dear Murad, I know you can emulate an 'exists' subquery with a join. but I just can't think of a way to emulate a 'not exists' without a subquery. probably due to my limited sql experience. any hints? You have probably tried something like SELECT ... WHERE condition IS NOT NULL. To emulate a

Re: help on NOT EXISTS SQL query

I think i found a way to do this: in case anybody is interested: select customer from purchases group by customer having sum(case when purchase = 'freezer' then 1 else 0 end) = 0; I am finding that SQL is trickier (and more powerful) than I thought originally!! Murad Nayal wrote: Thanks

Re: distinct and distinctrow

Hello. On Mon 2002-12-09 at 13:45:42 +0200, [EMAIL PROTECTED] wrote: Please can someone help me with this: I need to filter duplicate entries from my result query, but there's a twist... [...] Now I want to search the table for all unique name/key combinations. I tried select

Re: Select * From table where name Like 'help'; Help

Hello. On Mon 2002-12-09 at 09:22:09 -0500, [EMAIL PROTECTED] wrote: I am using PHP on my website, but this is certainly a MySQL question. That shouldn't matter, because the real value $var is inserted before the query is send to the MySQL server, where REGEXP of the query is evaluated.

RE: Desc question

From: Alex Behrens [mailto:[EMAIL PROTECTED]] ...How can I make it so only one form selection adds a DESC tag to the query, is this possible? I'm using this code: $fetch = mysql_query(SELECT * FROM players ORDER BY $var); select name='var' size='1' style='border-style: solid;

Re: locking issues

At 19:52 + 12/9/02, [EMAIL PROTECTED] wrote: Hi All, I may be confused here but it would appear that when you issue a LOCK TABLES tbl_name { READ|WRITE }; You cannot read from another unlocked table in the same connection eg: You're supposed to lock all the tables that you'll need until

ADO Bulk Inserts

Hi All, Does MySQL allow for Bulk Inserts via ADO? I can get a single insert statement to be inserted, but if I try t concatenate multiple inserts, I get a sytax error. I tried putting a space between each statement, return charater, semi-colon, etc, but it doesn't work. I'm doing the

RE: Question about SLAVE STOP

I know that the slave will honor transactions but how does that effect the STOP SLAVE command? Based on your note, I'm assuming (Oh, that nasty word!) that if the stop slave is issued in the middle of a transaction it will roll back. I'm also assuming that the pointer for the bin-log will now

Re: How to backup without blocking?

On Fri, Dec 06, 2002 at 08:36:32AM -0600, Cal Evans wrote: Run your database from a RAID 0. At some point during the night. Down one of the drives, mount it and copy the data. Then unmount it bring it back on-line. The RAID card should re-sync them without any down time. FWIW, you mean RAID

MySQL, OpenLDAP for Authentication

I need to setup a Unix authentication scheme using OpenLDAP with MySQL on the backend storing all of the account data. (Yes, I know that the folks behind OpenLDAP don't recommend using SQL...We have our reasons) I've setup unixODBC so my LDAP server can at least talk to my MySQL server. Has

[mysql] Lock status

I'am working with MySQL 3.23.51-Max in a linux box and Visual Fox and Delphi in a WinXP box, mostly using InnoDB tables. Is there a way to know wich rows are lockedin a table? is there a function that returns if a row is locked, or the rows locked in a table? It can be done with a UDF? My

porting stored procedures from sql server

Hi, Any advice on porting stored procedures from sql server. I have looked at UDF's but can't figure out how to use the existing database connection to perform queries, also have not used C for a very long time. Also had a brief look at myperl, but not well documented and still in beta.

Re: Multiple MySQL db's on one machine

At 16:04 -0800 12/9/02, tmb wrote: I was told that if you had multiple MySQL db's on a single machine... that actually it was really only one db with tables for for db1, db2, db3... ??? This doesn't sound right. Ask the person that told you this for evidence to support the claim. I thought

Re: Installing MySQL on Jaguar?

Brian, This may be late, but you should check out Fink: http://fink.sourceforge.net. A super easy way to get prepackaged UNIX software for OSX. I also highly recommend FinkCommander: http://finkcommander.sourceforge.net/ A great GUI front-end to Fink. Right now I am

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,

Re: Start up problem

The data directory is well owned by mysql. In fact my problem is : I cannot start mysql daemon in root user with change user in line command like this : # safe_mysqld --user=mysql --log=/var/lib/mysql/mysql.log touch13 On Mon, 09 Dec 2002 09:28:30 -0600 gerald_clark [EMAIL PROTECTED]

Subselect workaround

Scenario: Databases to list names, titles, contact information, and other professional stuff about faculty members, administrators, and staff in a university department, used (among other things) as a backend to a series of Web pages with listings. I had had three tables: faculty,

Re: How to backup without blocking?

Are you using 'replicate-wild-do-table = DBName.%' ?? Thanks for the reply. That's a client-only option, we're not actually having any troubles with clients ignoring anything in the binary log - the problem I'm describing is that when a database is not first explictly selected, the master

Re: How to get MySQL to list current db's ?

You can either use mysqlshow databases; or mysqlshow -uroot -p in the command line. Respectfully yours, Sherwin T. Ang Systems Administrator Internet Manila - Original Message - From: Will Standley [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Tuesday, December 10, 2002

Re: Subselect workaround

OOPS! Please note correction below! Here is what I would want to do: INSERT INTO administrators (id) values (SELECT id FROM faculty WHERE lastName = Jones) WHERE ordr = 1; Sorry! I meant UPDATE, not INSERT! UPDATE administrators SET id = (SELECT id FROM faculty WHERE lastName = Jones)

Front end won't connect

Question from a Linux and MySql newbie I just installed RedHat 8.0 and MySQL. During installation there was no prompt for any database server properties (hostname, user). Now I downloaded MySQLCC and try to configure the connection to the server. I assume the server is running, because I can

Re: How to get MySQL to list current db's ?

Hi, At 11:35 2002.12.09._-0500, you wrote: Is there a way to ask MySQL to list the db's that are currently created? Yes: SHOW DATABASES Good luck, Daniel - Before posting, please check:

Re: Start up problem

Try: shell chown -R root /usr/local/mysql shell chown -R mysql /usr/local/mysql/var shell chgrp -R mysql /usr/local/mysql then: shell /usr/local/mysql/bin/safe_mysqld --user=mysql or shell /usr/local/mysql/bin/mysqld_safe --user=mysql if you are running MySQL 4.x. Sean - Original

Re: Front end won't connect

Are you connecting locally or remotely? By default, MySQL creates a Localhost Root account with no password. You can try logging in with that account. If you need to log in remotely, you'll need to change the permissions on the user table (add a % to the hosts section to allow for any ip

Re: How to get MySQL to list current db's ?

Hi, SHOW DATABASES; At 11:35 AM 12/9/2002 -0500, Will Standley wrote: 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? -- Michael She : [EMAIL

MySQL-Installation on a Windows 2000 Cluster

I must install MySQL on a Windows 2000 Cluster-Server. What´s the best way to do it? How must the my.ini configured so that it works as fail over?   Thanks   Rainer SQL, Query - Before posting, please check:

Re: porting stored procedures from sql server

If you use PHP, here is an idea: http://www.ashleyit.com/blogs/brentashley/archives/000339.html Also, someone wrote a UDF to interpret PHP in MySQL...I'm not sure if it'll work as a Stored Procedure system tho. http://www.oreillynet.com/pub/wlg/2292 At 03:03 PM 12/10/2002 +1100, Chandra

Re: distinct and distinctrow

The table has something like this: idnamekey 1 name1 key1 2 name2 key2 3 name3 key3 4 name1 key1 5 name 1 key1 6 name2 key2 Now I want to search the table for all unique name/key combinations. select name,key from table group by name,key;