Did not see a reference to reloading tables in the docs.
This is just weird enough for me to vpn in and try again :-)
Thanks!
--
Steve (egrep)
On Fri, 7 Mar 2003, Ben Balbo wrote:
> Hi Steve,
>
> Really silly question, but you are reloading the tables once you
> change the grants, aren't you :-)
Tried this... no go... The wierd part, is that localhost
works fine, but I cannot connect locally if I use the
hostname. Thanks for the help!
(maybe I should go back to an old version of mysql :-)
--
Steve (egrep)
On Fri, 7 Mar 2003, Ben Balbo wrote:
> Hi Steve,
>
> Really silly question, but y
Yep, tried that... but I will try it again...
--
Steve (egrep)
On Thu, 6 Mar 2003, Roger Davis wrote:
> Or
>
> mysql>> flush privileges;
>
> Roger
>
> -Original Message-
> From: Ben Balbo [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 06, 2003 7:08 PM
> To: MySQL List
> Subject: Re: E
On Thu, Mar 06, 2003 at 04:24:10PM -0800, Ask Bjoern Hansen wrote:
>
> I am running RedHat 7.3, mostly using InnoDB's. I am using the
> MySQL-Max rpms (4.0.11) from mysql.com.
>
> Earlier today it crashed, and while trying to start up again it
> crashed again. Now I can't start the server with
> When I try "telnet localhost 3306" all seems ok. When I try
> "telnet domain.com 3306" I get the message "Connection closed by foreign
> host", same goes when trying the IP address from the local box. If I try
> this as well from a remote box, I get "Connection closed by foreign host".
>
I beli
Ask,
I think some other user encountered the error number 4 EINTR when his
harddisk was broken.
I do not know why in the later runs it did not print an error message.
Possibly the error number was EEXIST, for which InnoDB omits the error
printout and which is nonsensical if you are reading an ope
Mysql 4.0.11a gamma is crashing on Windows 2000 with service pack 3 with the
following error:
MySql: ready for connections
030203 17:39:10 InnoDB: Started
030305 9:32:50 InnoDB: Operating system error number 1450 in a file
operation.
InnoDB: See http://www.innodb.com/ibman.html for installation
Dear Smith, Dave, Clark and Victoria:
Thanks for all of your reply as quick !
Because I am a neewbie on MYSQL, would you mind to teach me how to create a
user and data directory on mysql server ?
Below are the mysql directorys on my server, and I can't find the data
directory. (Does it must be
I've been working for some time with php and mysql. I've always been
curious, and am finally starting to play with C. I downloaded Paul
DuBois' sample "Chapter 6: The MySQL C API".
I am running Mac OS X 10.2.4. I am running mysql version 3.23.54-max. I
followed the instructions in the sample chapt
Apologies if you now get this three times now, but I haven't
received any copies through the mailing list yet, and the first 2 were
sent 3 and 4 hours ago.
I know email can go walkies for a few hours, but I've not been
experiencing any other mail problems, either personally or in
receiving MySQL m
Hi all,
I've been trying to wrap my head round this problem for a few days
now, and have plenty of pieces of scrap paper with lines and arrows
and numbers to prove it.
Anyway, here's the scenario:
I have a table of teachers, and a table of classes. Any teacher can
have taught any class, and any
I've heard a lot of cases where upgrading a windows 98 machine to
windows 2000 will cause problems later on. This may be the case with
your system. The only thing I can say is try using that same downloaded
executable on a friend's machine and see if it works there. If not,
theproblem is with y
On Thu, 6 Mar 2003, Jeremy Zawodny wrote:
> > I am running RedHat 7.3, mostly using InnoDB's. I am using the
> > MySQL-Max rpms (4.0.11) from mysql.com.
> >
> > Earlier today it crashed, and while trying to start up again it
> > crashed again. Now I can't start the server with the InnoDB tables.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wednesday 05 March 2003 16:05, Johannes Ullrich wrote:
> To reduce the size of you index file: try a 'repair table'. The 'alter
> table' will take care of it too. You can also drop and recreate this index.
What's the limit for an index file? S
At 11:07 +1100 3/7/03, Ben Balbo wrote:
Hi Steve,
Really silly question, but you are reloading the tables once you
change the grants, aren't you :-)
mysqladmin -p reload
B.
Yep, it's silly. :-) Because GRANT automatically refreshes the
in-memory copies of the grant tables.
Steve, try this:
mysq
Hi all,
I've been trying to wrap my head round this problem for a few days
now, and have plenty of pieces of scrap paper with lines and arrows
and numbers to prove it.
Anyway, here's the scenario:
I have a table of teachers, and a table of classes. Any teacher can
have taught any class, and any
Hello ,
We are writing some set of generic scripts to start / stop MySQL instances
on a particular Linux machine. We want to address the complexity of
configuring & running multiple MySQL instances on the same machine. Can we
get the information about the parameters that we MUST take care for
laun
Dear mysql ,
äÁâ¤Ã«Í¿·ì ( www.microsoft.com ) áÅÐ áÁç¤ÍÒ¿Õ( www.mcafee.com )
à¾Ôè§¾ºäÇÃÑʵÑÇãËÁè «Öè§ÊÒÁÒöÊÃéÒ§¤ÇÒÁàÊÕÂËÒÂÁÒ¡·ÕèÊØ´à·èÒ·ÕèÁÕÁÒ
áÁç¤ÍÒ¿Õà¾Ôè§¾ºäÇÃÑʵÑǹÕé
àÁ×èͺèÒ Çѹ·Õè 2¡ØÁÀҾѹ¸ì áÅÐÂѧäÁèÁÕÇѤ«Õ¹»éͧ¡Ñ¹ äÇÃÑʹÕé¨Ð·ÓÅÒÂ
૤àµÍÃì «ÕâÃè ã¹ÎÒÃì´´Ôʤì«Öè§à»ç¹·Õèà¡çº¢éÍÁÙÅ¡Ò÷ӧҹ
> The primary key (message_id)is a UNSIGNED BIGINT,
> Which is supposed to be 64 bit, with autoincrement.
> The each row is deleted as soon as it is fetched
> By the client, and also after the expiry of a period
> (~30 days).
> 64 bits does provide a large number, but there is a
> possibility th
>Description:
>How-To-Repeat:
mysql -e"create table `FIELDS` (x int)" test
mysqldump test
>Fix:
Teach mysqldump to use backquotes.
>Submitter-Id:
>Originator:Matthias Urlichs
>Organization:
noris network AG, Nuernberg, Germany
>MySQL support: licence
>Synopsis:
Hello,
maybe someone who set up a mysql replication cluster can help me here.
The problem is that the binary logs of the master server in my cluster
are constantly growing, now I want to plan for the day when my disks get
full. The binary logs get rotated, so I ask myself wether I can riskless
Respondendo,
quinta-feira, 6 de março de 2003, 19:06:06, Mensagem Original:
RM> I have a DB where all of the tables are InnoDB, and there are a few
RM> straightforward FOREIGN KEY constraints. I would like to use mysqldump to
RM> back up the data or move it to another machine.
RM> The problem I'm
Respondendo,
sexta-feira, 7 de março de 2003, 03:02:24, Mensagem Original:
P> Hello ,
P> We are writing some set of generic scripts to start / stop MySQL instances
P> on a particular Linux machine. We want to address the complexity of
P> configuring & running multiple MySQL instances on the same
HI,
I need to create a new user who can can run these two queries
1. SELECT ... INTO OUTFILE
2 LOAD DATA INFILE.
I create a user with this query, GRANT USAGE, SELECT, FILE ON
database.table to [EMAIL PROTECTED]
It gives error running this query...it says illegal Grant/comman check
the manual.
heya,
I have a quick and painless (i hope :) )question..
Do you know how the username length is limited under MySQL. There is no mention of
this in the manual or books. I figured the username length was dynamically limited by
the length of the User field in the mysql.user table.
But i have use
At 14:06 -0800 3/6/03, Rick Mann wrote:
I have a DB where all of the tables are InnoDB, and there are a few
straightforward FOREIGN KEY constraints. I would like to use mysqldump to
back up the data or move it to another machine.
The problem I'm running into is that when I try to import the data us
Yes you can.
Try this query
grant file on database.* to user@'.
also remember
grant file on database.table to user@'. does not work
Anis
>>> "Lakshminarayna U" <[EMAIL PROTECTED]> Friday, March 07, 2003
5:00:30 PM >>>
Hi,
I want to archive and restore a table in MySQL using
Hi,
I want to archive and restore a table in MySQL using SQL
statements. I have tried this by logging in as root user and could
do it fine. But when I created a new user and login as him, I am
not able to archive nor restore. I have granted him all the
rights. Is there any specific rights need
As you write your code in somewhat pseduo code format, I can't comment on the
exact syntax. You may use PERL-DBI-DBD:MySQL to implement your code. However,
it may some problems with your logic. First of all, if the quote_for_family
table already exist, the create table sql do nothing and it defi
to whom it may concern,
I need some help regarding transactions using innodb tables.
I am running MySQL 3.23.51-Max as database server and developing a web
front-end using ASP. Many of the tables used are of innodb format since it
is imperative for me to use transactions in most of my scripts.
I
On Thu, 6 Mar 2003, Fabian Schmidt wrote:
> Am 05.03.03 schrieb Thomas Spahni:
>
> > Some words like "Tetraeder" have the combination 'ae' and should be found
> > looking for LIKE '%ae%'; surprisingly this works:
>
> Queries with "LIKE '%...'" can't use the index and work correct.
> Unfortunately
On Friday 07 March 2003 08:02, Prashant wrote:
> We are writing some set of generic scripts to start / stop MySQL instances
> on a particular Linux machine. We want to address the complexity of
> configuring & running multiple MySQL instances on the same machine. Can we
> get the information about
On Friday 07 March 2003 13:30, Lakshminarayna U wrote:
> I want to archive and restore a table in MySQL using SQL
> statements. I have tried this by logging in as root user and could
> do it fine. But when I created a new user and login as him, I am
> not able to archive nor restore. I have grante
On Thursday 06 March 2003 18:07, Jonathan Li wrote:
> For example I have three databases, db1, db2, db3.
> I have used command "mysql> use db1;" to select db1, then forsome silly
> reason I forgot which db I am in. Is there a quick mysql command that
> can show that you are in "db1"?
Use:
SELEC
On Friday 07 March 2003 14:08, Ahmed S K Anis wrote:
> Yes you can.
>
> Try this query
> grant file on database.* to user@'.
It's wrong!
You can't specify FILE privilege on the database, only on the global level
(*.*).
--
For technical support contracts, goto https://order.mysql.com/?r
On Friday 07 March 2003 13:24, Ahmed S K Anis wrote:
> I need to create a new user who can can run these two queries
> 1. SELECT ... INTO OUTFILE
> 2 LOAD DATA INFILE.
>
> I create a user with this query, GRANT USAGE, SELECT, FILE ON
> database.table to [EMAIL PROTECTED]
> It gives error running t
On Friday 07 March 2003 00:43, Chris Montgomery wrote:
> I have been using MS Access for 5+ years and am new to MySQL. I
> understand the theory behind setting relationships between tables, but
> am trying to get up to speed in how to do it in MySQL.
>
> My environment: Win2k and MySQL 3.23.54
>
>
>Description:
HAVING in SELECT is evaluated before WHERE. This is not the
correct behaviour as HAVING should deal with the remainder of the WHERE
selection (according to manual)
>How-To-Repeat:
mysql: create table tt (f1 int, f2 int);
Query OK, 0 rows affected (0.01 sec)
mysql: insert in
Hye
I try to translate in MySQL language a problem which I mean is a UML
partition constraint.
I explain:
There is a table A binded with a table B.
This table B is itself binded according to a B.P parameter:
either to a table C
either to a table D
but never to both.
I think one solution should
On Thu, 2003-03-06 at 17:52, tommy liu wrote:
> anyways, yes I did run
> # ./configure --with-vio --with-openssl --prefix=/usr/local/mysql
> and also tried the max version
>
> I also ran mysql_fix_privilege_tables.sh (one along 3.23.46 source)because
> we have MySQL 3.23.46 but I don't think it
On Friday 07 March 2003 00:06, Rick Mann wrote:
> I have a DB where all of the tables are InnoDB, and there are a few
> straightforward FOREIGN KEY constraints. I would like to use mysqldump to
> back up the data or move it to another machine.
>
> The problem I'm running into is that when I try to
Hi Guys and Dolls
I am going to add another table to my lovely MySQL DB.
Basically it is the city table I need to add to. For each city I am going to
have Towns. So I need to relate many Towns to one CityID
The city table at the moment is:
City CityID
What the best way forward?
Andrew
---
This is correct.
WHERE clause returns (1,1)
HAVING eliminates all records not HAVING f2=3.
[EMAIL PROTECTED] wrote:
Description:
HAVING in SELECT is evaluated before WHERE. This is not the
correct behaviour as HAVING should deal with the remainder of the WHERE
selection (according to manua
* Andrew
> I am going to add another table to my lovely MySQL DB.
>
> Basically it is the city table I need to add to. For each city I
> am going to
> have Towns. So I need to relate many Towns to one CityID
>
> The city table at the moment is:
>
> City CityID
>
> What the best way forward?
* gregory lefebvre
> I try to translate in MySQL language a problem which I mean is a UML
> partition constraint.
>
>
> I explain:
>
> There is a table A binded with a table B.
> This table B is itself binded according to a B.P parameter:
> either to a table C
> either to a table D
> but never
Charlie H. schrieb:
When I try "telnet localhost 3306" all seems ok. When I try
"telnet domain.com 3306" I get the message "Connection closed by foreign
host", same goes when trying the IP address from the local box. If I try
this as well from a remote box, I get "Connection closed by foreign host"
Ben Balbo wrote:
Teacher (id, name, ...)
TeacherClass (teacherid, classid, timestamp)
Class (id, name, ...)
Now, what I'd really like to do it find all teachers who, for example,
taught Engligh and Math, but not Biology,
Here's a general, recursive, untested solution for you to play with.
We st
Hi,
this is NOT correct behavior. Where clause returns (1,1) and (1,2). The HAVING
clause should be applied to what WHERE has selected and choose the (1,2)
record.
A quote from the manual "It (HAVING) is applied last, just before items are
sent to the client, with no optimisation
Hello,
On a P4-2.6Ghz, 1Gb mem server of ours, mysql keeps getting slower and
slower because the database gets bigger and bigger.
At the moment the database is 5.5Gb big, the biggest table being 1.1Gb.
'top' shows that mysqld is using 264M of memory. So I presume the rest is
used for disk cachi
Hello,
On a P4-2.6Ghz, 1Gb mem server of ours, mysql keeps getting slower and
slower because the database gets bigger and bigger.
At the moment the database is 5.5Gb big, the biggest table being 1.1Gb.
'top' shows that mysqld is using 264M of memory. So I presume the rest is
used for disk cachi
On Friday 07 Mar 2003 3:28 pm, Rick Jansen wrote:
> On a P4-2.6Ghz, 1Gb mem server of ours, mysql keeps getting slower and
> slower because the database gets bigger and bigger.
> At the moment the database is 5.5Gb big, the biggest table being 1.1Gb.
What OS are you using?
> 'top' shows that mysq
At 15:36 7-3-03 +, John Wards wrote:
What OS are you using?
Linux 2.4.20.
> 'top' shows that mysqld is using 264M of memory. So I presume the rest is
> used for disk caching. How do I know for sure that mysql is using the rest
> of the memory, or how do I get mysql to use it all?
That seems f
Hmmm I would say other than upgrading your hardware try upgrading to mySQL 4.
and turn on query caching.
The difference it has made to our server is unbelivable!
We have found no problems with it so far.
John
-
Before posting,
>Description:
UPDATE command fail with multiple myisam tables with error:
ERROR 1142: update command denied to user: '[EMAIL PROTECTED]' for table '***'
This situation occures only when non-root user make UPDATE and
'tables_priv' not empty (no matter what it contain
On Fri, 2003-03-07 at 10:54, [EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> sql,query,queries,smallint
>
> If you just reply
Hello,
I am running MySQL-Max on RH8.0 on a Dell 1650, 2 proc with 512MB ram.
I am only using InnoDB for databases (40gb) other than the mysql.*.
I have the following relevant memory settings:
set-variable= sort_buffer=2M
set-variable= record_buffer=2M
## For redhat 8.0
set-variable
sql,query,queries,smallint
At 10:56 -0500 3/7/03, Dan Geist wrote:
> I read the thread by R. Weiss, P. DuBios, and J. Zawodny regarding the
incomplete implementation of replication over SSL. I had been fighting
the same problem for about a week, thinking it was something I was doing
wrong.
Hello listers,
In mysql, is it possible imbed a conditional CASE statement within a SUM()
function to effect how the SUM() returns the final value for a set of rows?
For example, if I have a table "foo" with column "score", and "score" has
the rows with the values 1 to 10, can I write the SUM() i
Peter,
I think something like this will work:
mysql> select sum( if(score=7, score * 2, score)) from table_name;
David
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mys
On Fri, 2003-03-07 at 17:56, Dan Geist wrote:
> > If I understand the process, the act of replication is a simple connect
> > via a dedicated and persistent thread on the slave which which registers
No, it is not simple. It is not very complicated also but bit unusual.
Usually SSL layer stuff us
MySQL folks,
I posted a full bug report yesterday, but I'm afraid that my problem might
get lost in the details. It also had the wrong reply email address. Here's
a summary:
Under a variety of circumstances, creates and inserts of a
table with many columns, 2304 to be exact, hang the serv
Thanks All for reply my message.
After I reconfigured mysql server, I did load test. When mysql server
reached 99.7%, but CUP resource is only at 50%. Since this server is
mysql database only.
Is there a way I can change some mysql system variables to increase CUP
resource usage to 80%-90% when
I am using the the following command:
#./configure --enable-thread-safe-client --prefix=/usr/local/mysql
This is what happens:
checking "named thread libs:"... "-lpthread -lthread"
checking for strtok_r in -lpthread... yes
checking for strtok_r... yes
checking for dlopen in -ldl... yes
c
At 11:29 -0500 3/7/03, Peter D Bethke wrote:
Hello listers,
In mysql, is it possible imbed a conditional CASE statement within a SUM()
function to effect how the SUM() returns the final value for a set of rows?
For example, if I have a table "foo" with column "score", and "score" has
the rows with
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Smurf wrote:
Description:
How-To-Repeat:
mysql -e"create table `FIELDS` (x int)" test
mysqldump test
Fix:
Teach mysqldump to use backquotes.
Why not mysqldump --quote-names test
-Mark
- --
MySQL 2003 Users Conference -> http://www.
That's also right:
select sum( case 1 when score=7 then score * 2 else score end) from "foo";
[EMAIL PROTECTED] on 03/07/2003
11:28:03 AM
To: Peter D Bethke <[EMAIL PROTECTED]>, MySQL List
<[EMAIL PROTECTED]>
cc:(bcc: David P. Giragosian/MDACC)
Subject: Re: CASE statem
How-To-Repeat:
I am tried to use MS DTS to transfer a table from MSSQL 2000 to MYSQL
3.23.55,
however there has an error during the transformation on one data type. The
error happens when I have a "text" datatype on MSSQL 2000 table, and
"text/blob" on MySQL table.
The error is "fail to insert
i installed
1. MySQL 3.23---Production release(recommende),
2. Windows 95/98/NT/2000/XP 3.23.55 13.co3M,
3. Windows Source(zip) 3.23.55 13.2M
4. Control Center,
in my PC.
I created a testDB from Control Center, Added it and message shows as 'Connection
added successfully' but
its property
> >>
> > When I try to connect to this box from another box which I have
> granted all
> > rights, I get the error:
> > ERROR 2013: Lost connection to MySQL server during query
>
>
> https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=77467
>
> "lost connection ..."
> [mysqld]
> set-varia
That was a great suggestion (getting rid of the
"blank" user), but alas, it did not work. Here
are the three examples: (first one fail because the
blank user was removed)
[EMAIL PROTECTED]:~$ mysql
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)
[EMAIL PROTECTED]:~$ m
Actually thinking about this in a bit more depth! I also have the infamous
items table where individual company records are being stored. So is the best
way to do this:
i) add another field that will coreespond to the items.ItemsID or
ii) create another table town_ref
CREATE TABLE town_ref (
On Fri, Mar 07, 2003 at 11:05:37AM -0600, Judi Buff wrote:
> I am using the the following command:
>
> #./configure --enable-thread-safe-client --prefix=/usr/local/mysql
You realize that you've given us no details of your platform. OS,
version, which version of MySQL, etc.
> Please help if you
MATCH / AGAINST problem/bug
MySQL version: 4.0.11-gamma
OS : Windows 2000 SP3
Under some circumstances this query does never terminate. The win32
service cannot be stopped either.
SELECT f.id as id, fs.name as name, MATCH (f.title,f.body) AGAINST
('550') AS score FROM f
On Fri, Mar 07, 2003 at 01:23:27PM -0600, Judi Buff wrote:
> Brian,
>
> I'm sorry, I am running Solaris8 on Sparc, and trying to install MySQL 3.23.53. I
> get into this stuff so deep I have tunnel vision and think the whole world should
> know what I am talking about.
On Fri, Mar 07, 2003 a
I just installed the standard-4.0.11 binary and
the same problem exists. Error 1130: this host
is not allowed to connect. Run the grant and flush
privs. Access denied...
--
Steve (egrep)
On Fri, 7 Mar 2003, Steve Pirk wrote:
> That was a great suggestion (getting rid of the
> "blank" user), but
Your whole query is malformed. You have an aggregate function in the
having.
try:
select f1,max(f2) from tt where f1=1 group by f1;
Gabriel Tataranu wrote:
Hi,
this is NOT correct behavior. Where clause returns (1,1) and (1,2). The HAVING
clause should be applied to what WHERE has sele
You grant IP address does not match the IP address of the client failing
the connection.
Steve Pirk wrote:
That was a great suggestion (getting rid of the
"blank" user), but alas, it did not work. Here
are the three examples: (first one fail because the
blank user was removed)
[EMAIL PROTECTED]:
Hi ..
Free disk space: 32GB
Thats not the problem I guess.
-Mat
-Original Message-
From: gerald_clark [mailto:[EMAIL PROTECTED]
Sent: Freitag, 7. März 2003 22:03
To: Mathias Berchtold
Cc: [EMAIL PROTECTED]
Subject: Re: MATCH / AGAINST bug/problem
I you run low on temp filesystem spac
thank you very much !!!
I will try 4.0 then
tommy
From: Tonu Samuel <[EMAIL PROTECTED]>
To: tommy liu <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: problem setting up DES_ENCRYPT on MySQL 3.23.46
Date: 07 Mar 2003 16:04:19 +0200
On Thu, 2003-03-06 at 17:52, tommy liu wrote:
> anyways, ye
Hi,
> Your whole query is malformed. You have an aggregate function in the
> having.
It's absolutely legal query. In fact I don't get any error messages that say
otherwise. I'm not SQL guru but I haven't heard that agregate functions have
to be excuded from HAVING clause. To qu
030308 8:09:29 Error reading packet from server: Binary log is not open
(server_
errno=1236)
030308 8:09:29 Got fatal error 1236: 'Binary log is not open' from master
when r
eading data from binary log
030308 8:09:29 Slave I/O thread exiting, read up to log 'FIRST', position
4
030308 8:11:18
Both ip's are in the user table along with the
% wildcard.
--
Steve (egrep)
On Fri, 7 Mar 2003, gerald_clark wrote:
> You grant IP address does not match the IP address of the client failing
> the connection.
>
> Steve Pirk wrote:
>
> >That was a great suggestion (getting rid of the
> >"blank" u
Howdy Egor,
Friday, March 7, 2003, 7:36:00 AM, Egor Egorov wrote:
> Both columns Node are indexed, so just add foreign key constraint. You can
> find examples in the InnoDB manual:
> http://www.innodb.com/ibman.html#InnoDB_foreign_keys
I've looked at the examples, but one thing it doesn'
Hello,
We're a web hosting company currently hosting nearly 2000 MySQL
databases (3.23.54) at around 200-300 queries/second. Amazing
performance, really. But we're growing fast and planning for the next
step. Our wishlist is short:
We want to allow all our customers to have one set of instructio
On Fri, Mar 07, 2003 at 04:56:54PM -0700, John Masterson wrote:
> Hello,
>
> We're a web hosting company currently hosting nearly 2000 MySQL
> databases (3.23.54) at around 200-300 queries/second. Amazing
> performance, really. But we're growing fast and planning for the next
> step. Our wishlist
http://www.databasejournal.com/features/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 PROTE
Can I have multiple foreign keys in a table? Like this... I ask because I
can't seem to get it to work. Errno: 150.
CREATE TABLE `dept_table` (
`dept_id` mediumint(8) unsigned NOT NULL auto_increment,
`dept_timestamp` timestamp(14) NOT NULL,
`dept_company_table_id` mediumint(8) unsigned NOT
I'm investigating the feasibility of converting an MS Access
database to
a MySQL based system and could use some advice.
The server side will probably be run on a Linux box and is not a
problem since I
can deal with that easily enough. The clients will all be win98
based (possibility of
u
Disregard my previous msg. It looks like I have it figured out.
Friday, March 7, 2003, 5:31:38 PM, Chris Montgomery wrote:
> I've looked at the examples, but one thing it doesn't mention is whether
> both indexes need to be unique. In the primary table they are, but does
> the index in the table
If I create a table that uses REFERENCES in it, then mysqldump it, the
REFERENCES isn't there
Notice the `contact_dept_table_id` field in both of the below outputs:
CREATE TABLE `contact_table` (
`contact_id` mediumint(8) unsigned NOT NULL auto_increment,
`contact_timestamp` timestamp(14) NO
>Description:
Message indicates to use /usr/bin/mysqladmin to set root password
at end of installation, but this is not included in the distribution
>How-To-Repeat:
RedHat 8.0 - rpm --install -p MySQL-3.23.55-1.i386.rpm
>Fix:
>Submitter-Id: Paul Higgs
>Origi
Hi. I wanted to connect from a client machine to a MySQL server using
ssh. I execute the following on the local machine (the server is
foo.bar.com):
% ssh -n -N -L 3307:foo.bar.com:3306 foo.bar.com
I then try to connect from the local machine with:
% mysql -h localhost -p 3307 --user=me --pass
On Fri, Mar 07, 2003 at 05:37:38PM -0800, LZ Orders wrote:
> Hi. I wanted to connect from a client machine to a MySQL server using
> ssh. I execute the following on the local machine (the server is
> foo.bar.com):
>
> % ssh -n -N -L 3307:foo.bar.com:3306 foo.bar.com
>
> I then try to connect fr
Hello,
This is my first post to [EMAIL PROTECTED]
I'm about to compile MySQL (3.23.55) för Red Hat 7.2 that I begin with;
./configure --prefix=/usr/local/mysql
I get this error message after a while of machine-chewing;
checking for tgetent in -lncurses... no
checking for tgetent in -lcurses...
At 03:35 2003-03-08, Henrik Leghissa wrote:
I'm about to compile MySQL (3.23.55) för Red Hat 7.2 that I begin with;
./configure --prefix=/usr/local/mysql
I get this error message after a while of machine-chewing;
checking for tgetent in -lncurses... no
checking for tgetent in -lcurses... no
checki
At 03:51 2003-03-08, Henrik Leghissa wrote:
I'm about to compile MySQL (3.23.55) för Red Hat 7.2 that I begin with;
./configure --prefix=/usr/local/mysql
I get this error message after a while of machine-chewing;
checking for tgetent in -lncurses... no
checking for tgetent in -lcurses... no
checki
I managed to get passed the ./configure-phase, but now I encountered more
trouble;
To compile mysql I write "make"... and get these error-messages after a
while;
gcc -DDEFAULT_CHARSET_HOME=\"/usr/local/mysql\"
-DDATADIR=\"/usr/local/mysql/var\"
-DSHAREDIR=\"/usr/local/mysql/share/mysql\" -D
What does it really matter is whether you have create mySQL user that allow
access the database from the SSH server.
Please note that localhost, 127.0.0.1 or the machine ip address will be
treated as different entries by mySQL.
--
Yours,
KH Chiu
C&A Computer Consultants Ltd.
Tel: 3104 2070 Fax:
Hello everyone,
I'm trying to write a query that would update a field in a table. Here is
the catch.
Table 1 has two fields - field A and Field B
Table 2 has two fields - field A and Field B
Each table has many more fields but these are the only two I'm concerned
with right now.
Field B in tab
At 17:10 -0500 3/7/03, Christopher M Burger wrote:
Hello everyone,
I'm trying to write a query that would update a field in a table. Here is
the catch.
Table 1 has two fields - field A and Field B
Table 2 has two fields - field A and Field B
Each table has many more fields but these are the only
1 - 100 of 107 matches
Mail list logo