 | | | MySQL General | | At 16 51 -0500 3/24/04 Raghu Udupa wrote
>Right now we are planning to install MySQL 4.0.17-standard (latest
>production version) on Solaris and Linux servers. We may want to access
>MySQL from Hi List
Ok I 'm a moron... problem solved
Should have been
grant CREATE TEMPORARY TABLES ...
and not
grant Create_tmp_table_priv ...
Well atleast this is now in the archivesHi List
I hate to bother the list with what should be a simple question but I 've been unable to get this
to work or find anything on mysql.com or google.
I need to grant
Create_tmp_table_At 13 24 -0500 3/24/04 Kevin Carpenter wrote
>I 've installed MySQL and started the server with
>
>mysqld_safe &
>
>I 've confirmed the server is running with
>
>ps -ef | grep mysql
>
> At 10 19 -0800 3/24/04 Craig Gardner wrote
>I need to get totals for the data in my database. I stumbled upon
>the "WITH ROLLUP " modifier
>(http //www.mysql.com/doc/en/GROUP-BY-Modifiers.html)Very straightforward if the new column is NULLable OR has a deterministic
value e.g.
INSERT INTO newtable (col1 col2)
SELECT col1 1 FROM oldtable WHERE ID xxx
Or if NULLable
INSERT INMarc Boorshtein wrote
> Hello
>
> I am urgently trying to restore a mysql database that was corrupted when
> upgrading from OSX 10.3.2 to 10.3.3. I have tried downloading MySQL 4.0.14
> and cOn Wed Mar 24 2004 at 06 29 40PM -0700 Sasha Pachev wrote
> mmichaels@(protected) wrote
>
> Hmm.. Looks like Jeremy did not quite fix everything on FreeBSD in version 1.2.
> For a hack cHello Jack
Wednesday March 24 2004 6 50 45 PM you wrote
JC > I tried using 'USE INDEX ' and 'BETWEEN ' but it didn 't change anything.
JC > EXPLAIN SELECT counter UNIX_TIMESTAMP(dtime) FROHi
This a error to install Mysql 4.1 in HP-UX 10.20
040324 12 01 50 mysqld started
Warning One can only use the --user switch if running as root
InnoDB No valid checkpoint found.
I assume you are just trying to make things more readable. As far as I
know MySQL does not support custom sort orders except when a field is
an enum or a set. Even then that 's not a custom order Victor Medina wrote
>Hi!
>On Wed 2004-03-24 at 09 51 Yonah Russ wrote
>
>
> >Hi
> > I 'm trying to compile mysql 4.0.18 with icc 8.0 on RH AS 3u1. I 'm
> >
> >
>----8 <
>GUAO! nice! lHello
Further to my MERGE table query the other day I 've now put it into
action and it seems to be working fine. However I 'm noticing that
"INSERT LOW_PRIORITY " statements are blocking when theHello colleagues
I knew there 's an option to have a row level locking rather than a table
level one the innodb_locks_unsafe_for_binlog
I knew also that this option makes the binary logs unsafe
Bonjour
For the benefit of the group I will translate the French part of my text -)
Le tarball que vous avez telecharge est en fait le binaire executable de MySQL
pas les sources. Donc vousnullevent <nullevent@(protected) > wrote
>
> I have two tables - articles_en and articles_ru.
> Its fields is 'article ' 'author ' 'text '.
> The difference is - field 'text ' in articles_en udo.mysql@(protected) wrote
> Hello
>
> since I moved to another dedicated server 1-2 months ago I 'm
> experiencing big problems with mysql.
>
> Normally the server works fine for a websiteYou need to download "Dynamic client libraries - (including 3.23.x
libraries) " to satisfy these dependencies. This is available on mysql
download page. Choose for your particular version.
And if "Hiep Ho " <hiep@(protected) > wrote
> i have problem adding user to mysql. I can create a database and there is no
> problem however I got this ERROR 1047 Unknown command when I tried to add
> new use "JOHN MEYER " <jmeyer2003@(protected) > wrote
> Is there a way to do a SQL Select and get a record without specifying the
> primary key. Example. I have two tables CANDLE and VOTIVES. Can I define
webmaster@(protected) wrote
> Hi
>
> (Sorry by my english i speak spanish)
>
> I have problem with a Query.
>
> It does not recognize EXISTS nor IN nor NOT IN
>
> My verGreetings All!
We have setting up a mailing list for people who are interested in the
MySQL Users Conference (http //mysql.com/events/uc2004/)
If you are attending planning to attend or want 4.0.18 is the latest stable!
On Tue 2004-03-23 at 19 08 ryan@(protected) wrote
> Hi
>
> A quick question which is the most stable version of mysql to run on a very busy and commercial webRobert Montgomery <mogtnomr@(protected) > wrote
> I recently upgraded to mysql 4.0.18. In the past you
> could set the option safe-show-databases and that
> allowed users to list databases but onlyHi!
just add "old-passwords " to the mysqld section of your mysql server and
recreate the users it should work just fine! mysql 4 and up has a new
auth mecanism
Best Regards
On Wed 2004-03-2Hi!
----- Original Message -----
From "Dan Nelson " <dnelson@(protected) >
Newsgroups mailing.database.myodbc
Sent Saturday April 03 2004 1 02 AM
Subject Re innodb_buffer_pool_size liI am trying to push the performance of a Mysql database a little more
it 's pretty busy but I hope to squeeze a tad more out of it.
I am a newbie/pretty clueless wrt MySQL in general so ...
I 'm a beginner so don 't quote me. I beleive you need something like
Select hs_identifiers.hs_id_num from hs_identifiers
where (accession_num LIKE (result of another select statement)%)
I be "John Brown " <hogan_siteman@(protected) > wrote
> Hi
> I am a total linux and mysql newb I am preparing this info as best as
> possible. Below is the output from the mysqlbug utility.
> I follThis gives me the impression that all update
queries are sent to slave but if they are not
matched by the rules they are ignored. In my case
I am replicating a database with infrequent
updates |
|
|
