Hello, there.
I have a question about altering table which has foreign key constraints.
MySQL manual says that :
"In InnoDB versions < 3.23.50 ALTER TABLE or CREATE INDEX should not be used in
connection with tables which have foreign key constraints or which are
referenced in foreign key constr
HAVING is applicable only when you are using GROUP BY clause, HAVING acts on
the resultset after records are grouped while WHERE restricts the records
which are used in grouping.
Manual clearly states (under WHERE optimisation) that:
"HAVING is merged with WHERE if you don't use GROUP BY or group
Hello All,
I am trying to develop a SQL statement to ultimately strip a field of
everything buy numeric digits. Does anyone know how to do this or can
anyone look at the below code and give direction if I am on the right
track?
For example, let's say the contact_phone field has 2 records:
(555
I have never tried MS DTS, but SQLyog works great for
me in transferring MS SQL Server data to MySQL.
--- phil <[EMAIL PROTECTED]> wrote:
> 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 transformat
>Description:
It is unbelievable that the MySQL ver 4.0 have so many bug, I have been
reported 2 bugs just a few days ago.
Now, I have found a bug again.
The bug is :
When I execute "select * from old_topic where FID=4 and (page=0 or page=167) order by
replytime asc limit 40;" returns 40
I have mysql 3.23.55 for Windows where charset "win1250ch" is included. Now
I download the same version for Linux (rpm) but this charset is not included
here. Why?
Thank you for your quick reply.
Petr Vileta, Czech Republic
http://www.practisoft.cz
Hi,
I had some private e-mail suggesting that MAX functions should apply to
the full table - as it is the maximum value of the field- and this is why
HAVING clause behaved in that manner.
I'm sure this is not the case since MAX does obey (as it should)
WHERE clause in the query.
To
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
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
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:
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
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
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
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...
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
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
>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
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
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
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
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
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
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
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
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'
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
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
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
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 ..
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
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]:
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
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
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
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 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
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 (
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
> >>
> > 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
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
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
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
-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.
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
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
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
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
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
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
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
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,
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
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
>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
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,
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
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
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
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
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
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"
* 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
* 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?
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
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
---
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
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
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
>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
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
>
>
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 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 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 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 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 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
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
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
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
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
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
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
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.
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
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
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
>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:
> 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
Dear mysql ,
äÁâ¤Ã«Í¿·ì ( www.microsoft.com ) áÅÐ áÁç¤ÍÒ¿Õ( www.mcafee.com )
à¾Ô觾ºäÇÃÑʵÑÇãËÁè «Öè§ÊÒÁÒöÊÃéÒ§¤ÇÒÁàÊÕÂËÒÂÁÒ¡·ÕèÊØ´à·èÒ·ÕèÁÕÁÒ
áÁç¤ÍÒ¿Õà¾Ô觾ºäÇÃÑʵÑǹÕé
àÁ×èͺèÒ Çѹ·Õè 2¡ØÁÀҾѹ¸ì áÅÐÂѧäÁèÁÕÇѤ«Õ¹»éͧ¡Ñ¹ äÇÃÑʹÕé¨Ð·ÓÅÒÂ
૤àµÍÃì «ÕâÃè ã¹ÎÒÃì´´Ôʤì«Öè§à»ç¹·Õèà¡çº¢éÍÁÙÅ¡Ò÷ӧҹ
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
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
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
-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
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.
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
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
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
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
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
1 - 100 of 107 matches
Mail list logo
