What didn;t work,,,what happened?
Ken
- Original Message -
From: "Brad Lipovsky" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 10, 2001 11:24 PM
Subject: [PHP-DB] cookie problems
> can anyone help me with this code? i cant believe it wont work, it seems
> pretty simp
On Wed, Jul 11, 2001 at 01:31:15PM +1000, pak wrote:
>
> So is MySQL not suitable for large corporate database ?
It often depends on the corporation and who makes the decisions. In
many corporations, it's the folks who know little about the
technology. In the minority of them, it appears to be
On Tue, Jul 10, 2001 at 07:36:25PM -0400, Wyly Wade wrote:
>
> Never Index on text, blob, and if you can help it don't use var char
> in indexes.
There's nothing wrong with indexing a text or blob field. In fact,
it's often very useful to index just a small prefix (maybe 20
characters). It gives
Try to use PPM utility (if you use ActivePerl).
Dmitri Lubinski
-Original Message-
From: sherzod ruzmetov [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 11, 2001 10:23 AM
To: MySql Mailing List
Subject: Installing DBI
I can install other moduels successfully. But when it comes to D
I can install other moduels successfully. But when it comes to DBI, and
DBD::mysql, it keeps throwing out the following error:
make - not ok
make returned bad status
I am lost :-(. What could that be?
-sherzodOR
-
Before po
Best I can come up with is something like
2 words:
SELECT c1.id
FROM crossref c1, crossref c2
WHERE c1.word='word1'
AND c2.word='word2'
AND c1.id=c2.id
3 words:
SELECT c1.id
FROM crossref c1, crossref c2, crossref c3
WHERE c1.word='word1'
AND c2.word='word2'
AND c3.word='wo
Hi!
Query:
-
select a.id
from crossref a
, crossref b
, crodsref c
where a.id=b.id
and a.id=c.id
and a.word= word1
and b.word= word2
and c.word= word3;
It isn't ideal construction, but it works.
For your example (two words - tintin & register):
select a.id from crossre
Pete Kuczynski wrote:
>
> Hi,
> I've posted this question before, and some were kind enough to respond
> with suggestions to my question [replication], but I'm looking for
> something more difinitave.
>
> Background: I'm running a production mysql database/php4/Apache on a NT4
> IBM Netfinity se
I'm trying to return several pieces of information from a small table.
Table is 'tickets':
idCHAR(50)
group CHAR(50)
issuedDATE
used DATE
'issued' and 'used' are NULL until a date is entered. The found set
is generally based on the 'group'.
I want the actual
>DBS="genldgr ap ar corp misc"
>DUMP=$HOME/archive/dump
>
>cd $DUMP
>
>DIR=`date | cut -d" " -f1`
>mkdir -p $DIR
>rm -f Today
>ln -sf $DIR Today
>cd $DIR
>for K in $DBS
>do
>TBLS=`mysql -N -e "show tables" $K`
>for I in $TBLS
>do
>mysql -e "repair table $I" $K
>mysqldu
I've been attempting to create a mySql database while granting
administration user permissions on just that database to a
particular user. I suppose I'm overlooking something simple, but I
just can't get it after a full day of playing. My root user and its
password work fine, but my other u
Hi,
I have a table:
mysql> describe crossref;
+---+--+--+-+
| Field | Type | Null | Key |
+---+--+--+-+
| word | char(15) | | MUL |
| id| int(10) unsigned | | MUL |
+---+--+--+-+
Please give some examples of 'bad' design where a "foreign key" would have
to be changed..
ken
- Original Message -
From: "Michael Bacarella" <[EMAIL PROTECTED]>
To: "pak" <[EMAIL PROTECTED]>
Cc: "Ken Sommers" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, July 10, 2001 8:53 PM
S
I don't see another way other than like since you build the value on a
"free" form, i.e. you determined the separator ",". You can either get a
dif. form to help on your selection or just do a:
select ID from TABLE_NAME where ID = $value || ID like '$value,%' || ID
like '%,$value,%' || ID like
On Wed, Jul 11, 2001 at 01:31:15PM +1000, pak wrote:
> So is MySQL not suitable for large corporate database ?
That depends more on what you feel is suitable, rather than
someone else trying to tell you objectively what is suitable.
You can argue for and against the use of foreign keys and both
Thanks, but this won't work, we need an exact match of one of the multiple
values, if there is one exact match of any of the values within the column, then
we pull that row out to be displayed. so it has to be an exact match.
>>On Tue, 10 Jul 2001 23:05:02 -0500, "Rodrigo Zerlotti" <[EMAIL PROTEC
Please give some examples where you would need the dbms to do the
referential integrity?
Ken
- Original Message -
From: "pak" <[EMAIL PROTECTED]>
To: "Ken Sommers" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, July 10, 2001 8:31 PM
Subject: Re: Referential Integrity
> So is MyS
select ID from TABLE_NAME where ID like '%value%'
or I misunderstood the question.
-
Regards,
Rod~
> -Original Message-
> From: ThunderRain Publishing Corp. [mailto:ThunderRain Publishing
> Corp.]On Behalf Of MikeBlezien
> Sent: Tuesday, July 10, 2001 10:38 PM
> To: [EMA
Hi All,
Quick question. We need to store a multiple value in a table column as we don't
know how many values at the time of submission there could be. The column would
be storing a group of values something like this:
Column 'ID'
IM34456,IM34485,IM34478
or it could be more or less. So if we p
So is MySQL not suitable for large corporate database ?
- Original Message -
From: "Ken Sommers" <[EMAIL PROTECTED]>
To: "pak" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, July 11, 2001 1:24 PM
Subject: Re: Referential Integrity
| hello,
| Do simple input validation.
|
| If
hello,
Do simple input validation.
If the user is entering what is supposed to be a primary key value,
make sure it is a valid key before sticking it in any where, If it's a bogus
key .tell the user to try again.
If user wants you to delete rows from a primary table (customer)that have
"foreign
Is there a way to build a similar SQL that would work on mySql (I use this
on Oracle):
delete from TABLE_NAME where COL1 not in (
select distinct COL1 from TABLE_NAME where COL2 ='SOMETHING')
-
Regards,
Rod~
-
Before
That would not be true.
You'd receive a message stating that you had one placeholder, but you
were passing 3 arugments, and it script would die on the error.
havoc
ryc wrote:
>
> I was not aware of placeholders, and the benifits of using them instead of
> using $dbh->quote(). It doesnt make se
I create a table, one field is integer type.
I don't know why the following statements work :
select * from table1 where field1 = 3;
select * from table1 where field1 = '3';
-
Before posting, please check:
http://www.mysql.c
MySQL does not support RI, anyone has good suggestion that do this in the
program ?
As this would be a nightmare if I have 50 detail tables to update
programmatically.
-
Before posting, please check:
http://www.mysql.com/manu
That's the way should be, never enter your database access info directly into
any type of script, be it PHP or Perl or what ever, store it in a separate file,
no accessible separate file, then have the related script(s) call up the
variables thru the PHP's include, or Perl's 'require' or 'use' ..
At 05:48 PM 07/10/2001 , you wrote:
>Joe,
>
>Are you assigning your database variables within the config.php file or
>directly
>into the mysql_connet(...);
>
>config.php:
>// database parameters
>// alter this as per your configuration
>$database="database_name";
>$user = "username";
>$pass = "pa
> Group;
>
> There is something missing in my understanding of the php mysql_connect
> statement because I am getting a parse error as follows:
>
> http://cxkop.com/Jobs/job_list.php
> Parse error: parse error in
> /home/virtual/cxkop1365/home/httpd/html/Jobs/job_list.php on line 31
This is a php
Joe,
Are you assigning your database variables within the config.php file or directly
into the mysql_connet(...);
config.php:
// database parameters
// alter this as per your configuration
$database="database_name";
$user = "username";
$pass = "password";
$hostname = "localhost";
>>On Tue, 10 J
On 10-Jul-01 Jason Ziegler wrote:
> I'd like to see some that check current tables for corruption before
> exporting, and then naming the exports by date...
>
>
DBS="genldgr ap ar corp misc"
DUMP=$HOME/archive/dump
cd $DUMP
DIR=`date | cut -d" " -f1`
mkdir -p $DIR
rm -f Today
ln -sf $DIR T
Group;
There is something missing in my understanding of the php mysql_connect
statement because I am getting a parse error as follows:
http://cxkop.com/Jobs/job_list.php
Parse error: parse error in
/home/virtual/cxkop1365/home/httpd/html/Jobs/job_list.php on line 31
The database exists and i
On 10-Jul-01 Chris K wrote:
> Just wondering how many accesses can MYSQL handle... let's say per hour.
> I have about 500 accesses per hour, 8 clicks per second... does anyone
> know about this issue? thanks
One of my advert sites runs about 12,000 hits in 10 minutes, each "hit"
is 4 queries (2
> Just wondering how many accesses can MYSQL handle... let's say per hour.
> I have about 500 accesses per hour, 8 clicks per second... does anyone
> know about this issue? thanks
It really depends on what kind of queries you're running, your hardware,
your configuration, your operating system, e
He wants to know the maximum, like on a search for mysql at google it says
"Results 1 - 10 of about 2,580,000." He wants to know that 2,580,000 number
without doing another query. I don't think that's possible.
> I'm not sure if I understand your problem. You should get exactly
> $end results if
> Hi,
>
> I want to compress my tables but I gets an error:
>
> C:\mysql-data\dtim9t>myisampack wi_abbreviation.MYI
> Compressing wi_abbreviation.MYD: (7221 records)
> - Calculating statistics
> - Compressing file
> myisampack: Error on delete of 'wi_abbreviation.MYD' (Errcode: 13)
> Aborting: wi_
What you described is the strategy to design good tables, called
normalizing. You will find good articles on that subject and even
whole books. There are several rules, but most only apply the
first. The others are for the real masters or the real tough data
models or performance questions.
Sie s
> alter table hr-data set column Reason4leaving1 char(100)
I thought I knew - but I wanted to play safe. So I went to
http://mysql.com and entered alter table to the search box.
>From the results list I chose ALTER TABLE Syntax:
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
Here I found what I
I have seen a lot of question and issues around index size and time on
this list lately.
Well you should increase your Key Buffer but
Roger your record size is about 12k per row
Pawan your record size is an enormous 91k per row
You have to remember that RDBMS(for transaction processing) work
Hi right now I am just developeing a complex listing for 500+
applications over 20 tables per catigory, that is going to be hosted on
my site. besides having the normal info such as: size, file name, datep
ublished, staff comments, program rateing I wanted to include user
opinions of it too.
I'd like to see some that check current tables for corruption before
exporting, and then naming the exports by date...
On Tuesday, July 10, 2001, at 06:18 PM, Wyly Wade wrote:
> Any body got any good through nightly maintenance and back-up scripts?
>
>
> Wyly Wade
> Forefront Inc
> 1413 S.
Title: Blank
Any body got any good through nightly
maintenance and back-up scripts?
Wyly Wade
Forefront Inc
1413 S. Howard Ave
Suite 104
Tampa Fl, 33606
813-253-2267
To whom it may concern:
Every thing makes, but when I do a make test I get ...
$/usr/local/bin/make test
install_driver(mysql) failed: Can't load '../blib/arch/auto/DBD/mysql/mysql.so'
for module DBD::mysql: dynamic linker: /usr/bin/perl: relocation error:
symbol not found: __deregister_frame_
I have not been able to stay away from syntax errors while trying to change
the char(30) to char(100) I have been using the command
alter table hr-data set column Reason4leaving1 char(100)
this is my error
syntax error near unexpected token `char(1'
can anyone set me straight?
Thanks, Jay
-
This topic really interested me.
Can an expert of the list explain a good approach handle distributed system
with distributed databases?
thanks
siomara
>From: <[EMAIL PROTECTED]>
>To: Werner Stuerenburg <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: Re: Join syntax
>Date: Tue, 10 Jul 200
I understand completely and Mysql is not a database, Its a database server
that I already have multiple servers running. I asked this question because
I was curious to know if a package for Solaris exist like one Does for
Linux.
If you are just going to be sarcastic to people who ask questions on
I was updating a database and my database got corrupted ( I'm not sure
what coused this) but ever since then I have been having lots of mysql
problems. The onl way I can stop mysql is by doing a kill, mysqld stop
fails. I was able to restore to a backed up database but now I can not
add new items.
> after reading the excellent docs, I was just a little confused as to the
> actual length of the TEXT datatypes. Are they really as long as you like?
See http://www.mysql.com/doc/n/o/node_180.html
> And does anyone have any tips for indexing (searching) them?
What do you mean? Searching is som
I was not aware of placeholders, and the benifits of using them instead of
using $dbh->quote(). It doesnt make sence that the DBI version of quote isnt
as thorough as having the code behind placeholding do it. But anyhow, I have
a few questions as to how this works. Here is an example from the Per
Most likely your size limitation is comming from the data type used for
'notes'. Check out the documentation for the size of the text types,
mediumtext may be more apropriate for you.
ryan
>
> I'm running into an odd string size limitation. I've traced it down as far
> as I can get, and I didn't
Hi Mark,
Thanks for the suggestion. I do realize it is better using linux
instead; however, my questions are with my setup and OS which I am currently
using, how do I go to tide up the security a bit.
Best regards,
Michael
- Original Message -
From: "md" <[EMAIL PROTECTED]>
To: "Mi
You connect to a database and then issue your queries. So you
should hold all tables within one database that will be addresses
within one query.
Besides this, it is a matter of taste. Think of it this way: will
it affect performance if you put 1000 files in a directory or
just two of them and al
On Tue, Jul 10, 2001 at 04:15:03PM -0400, Michael Meltzer wrote:
> it not a bug, it is a feature, complain to Tomas Riche, 68 years (2038-1970)
> is all the seconds that fit in 2^31 or a signed long number, which is how
> the timestamp was defined a long time ago, it was always figured that some
>
Hi,
after reading the excellent docs, I was just a little confused as to the
actual length of the TEXT datatypes. Are they really as long as you like?
And does anyone have any tips for indexing (searching) them?
Thanks,
James Cox
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
it not a bug, it is a feature, complain to Tomas Riche, 68 years (2038-1970)
is all the seconds that fit in 2^31 or a signed long number, which is how
the timestamp was defined a long time ago, it was always figured that some
would change the base year sooner or later. Or the programmer view ;-) t
I am not real knowledgable in this area, new to MySQL, and only an
intermediate level SQL programmer, but I was just wondering where
MySQL stands in relation to the SQL-99 standard? I notice on the
MySQL site that one of their recommended choices in books is:
SQL-99 Complete, Really
Peter Gul
>Description:
unix_timestamp doesn't understand year 2038.
>How-To-Repeat:
this works:
select unix_timestamp("2037-12-31 23:59:59");
this doesn't:
select unix_timestamp("2038-01-01 00:00:00");
>Fix:
unknown. everything through "Jan 19 03:14:07 2038
Hi all,
This may not directly related to the topic but I think people in this list may
able to give me some ideas.
I am not really kean of security issue and would like to ask the following
questions:
I have 2 win2k pcs one directly connected to internet (say PC A) and PC B is
Make sure gcc is in your PATH, and make sure it's been installed properly.
You might also want to try some test compilations.
--
Alan W. Rateliff, II: YourVillage.com
Assistant Systems Administrator : 2700 Apalachee Pkwy
< [EMAIL PROTECTED] > : Tallahassee, FL 3
Hey all,
This seems like a silly, but rather fundamental question. Should I have
many databases running inside one instance of Mysql with fewer tables in
each, or should have only a few databases with many tables in each (one to
many or many to one, more or less) Does is matter if the
> Just wondering how many accesses can MYSQL handle... let's say per hour.
> I have about 500 accesses per hour, 8 clicks per second... does anyone
> know about this issue? thanks
I just did
picard:/usr/local/mysql/bin# mysqladmin version -upferdezeitung -p
Enter password:
mysqladmin Ver 8.15 D
Yeah I seen that too. It would be nice if it was the latest version.
Mike
-Original Message-
From: Steve Brazill [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 10, 2001 10:47 AM
To: Ravi Raman; Mike Jimenez; Mysql
Subject: Re: Solaris
Just checked the site, and only see version 3.22.26
Jeremy,
I did test it and couldn't get it to work one way or the otherHowever,
as it turns out, the '--binlog-ignore-db' option will work for me.
Thanks for all your help!!
Phil
At 11:03 AM 7/10/2001 -0700, you wrote:
>On Tue, Jul 10, 2001 at 09:20:35AM -0700, Philip Daggett wrote:
> > At
On Tue, Jul 10, 2001 at 09:20:35AM -0700, Philip Daggett wrote:
> At 03:01 PM 7/9/2001 -0700, you wrote:
> >On Mon, Jul 09, 2001 at 03:18:14PM -0600, Chris Bolt wrote:
> > > > We do a few large daily and monthly downloads from an Oracle database
> > > > server. Is there a way to exclude these spec
Just wondering how many accesses can MYSQL handle... let's say per hour.
I have about 500 accesses per hour, 8 clicks per second... does anyone
know about this issue? thanks
_
Get Your Private, Free E-mail from MSN Hotmail at
Just checked the site, and only see version 3.22.26a (very old) on the
site...
- Original Message -
From: "Ravi Raman" <[EMAIL PROTECTED]>
To: "Mike Jimenez" <[EMAIL PROTECTED]>; "Steve Brazill" <[EMAIL PROTECTED]>;
"Mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, July 10, 2001 10:24 AM
Subjec
On 2001 Jul 10, Yan Zhang <[EMAIL PROTECTED]> wrote:
> Please help me here, and let me know if MySQL can do it or not. All people
> around me told it should work in SyBASE.
Please don't spam! Use *one* e-mail address that is appropriate.
This is on our list of things to do, probably in version
On Mon, Jul 09, 2001 at 08:14:24PM -0600, David Keeney wrote:
> dies (during the execute statement) with the error :
>
> Out of Memory: Killed process 31666 (temp.pl).
> Killed
Look for 'SQL_BIG_TABLES' in the Docs...
`SQL_BIG_TABLES = 0 | 1'
If set to `1', all temporary tables are stored
hi.
www.sunfreeware.com has a sun package that can be added via the pkgadd
utility.
hth.
-ravi.
-Original Message-
From: Mike Jimenez [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 10, 2001 12:44 PM
To: Steve Brazill; Mysql
Subject: RE: Solaris
Okay I can understand that I need to pro
Ooops, www.sunsolve.sun.com is for 'patches' for Solaris...
I meant, docs.sun.com
Here's the link to the Solaris 2.5 method of "package creation" (you can
search further for the Solaris 8 method)
http://docs.sun.com/ab2/@LegacySearchResults?toc=SUNWab_42_3%3A%2Fsafedir%2F
space3%2Fcoll2%2FSUNW
Please,help1
[sherzod@cral mysql-3.23.39]$ ./configure
loading cache ./config.cache
checking host system type... i586-pc-linux-gnu
checking target system type... i586-pc-linux-gnu
checking build system type... i586-pc-linux-gnu
checking for a BSD compatible install... /usr/bi
http://www.westhost.com offers a MySQL database for only $8.95 a month.
-Kinney Baughman
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Very cool.
Thaks very much Simon!
Pete
Simon Green wrote:
>
> Hi Pete
> To emable loffing use the --log option eg --log-update when stating the
> server...
>
> Simon
>
> -Original Message-
> From: Pete Kuczynski [mailto:[EMAIL PROTECTED]]
> Sent: 10 July 2001 17:51
> To: Simon Green
>
I have two databases (db1 e db2) on different hosts (host1 e host2). I put them
on different hosts to split the charge (they are very big databases).
However, I have to make some selects on tables of db2 filtering with information
that are on db1.
If db1 and db2 were at the same machine, I wou
Okay I can understand that I need to provide more info.
Im using a Ultra sparc II server with Solaris 8 also can you please provide
the exact link to the sunsolve website.
Thanks
Mike
-Original Message-
From: Steve Brazill [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 10, 2001 9:30 AM
To
I'd think that someone would have to had created a 'package' for Solaris
installations, BUT, you'd have to identify which version of Solaris you
were using, and whether you're running it on a SPARC or Intel based
system
I haven't seen them on the site (you could download the source fi
At 03:01 PM 7/9/2001 -0700, you wrote:
>On Mon, Jul 09, 2001 at 03:18:14PM -0600, Chris Bolt wrote:
> > > We do a few large daily and monthly downloads from an Oracle database
> > > server. Is there a way to exclude these specific queries from the
> > > update/binary log??
> >
> > If the queries o
You can use update/bin_update logs.
Run these logs from the time of the last backup and it should take you DB up
to date till the time in went down
Simon
PS update logs have all the SQL statements in them so it should be very
simple to recover!
-Original Message-
From: Pete Kuczy
Try this assuming you are compiling from source (not ports)
create a test file called makemysql.sh
put this in it
gmake -s clean
rm config.cache
CC=gcc CFLAGS=-O3 CXX=gcc \
CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" \
./configure
$DEBUG --enable-large-files --with-berkeley-
No, MySQL does not support subquery so you need work around (not use)
it, by creating temp tbl and/or join etc. Think it a diff. SQL style.
Yan Zhang wrote:
>
> Please help me here, and let me know if MySQL can do it or not. All people
> around me told it should work in SyBASE.
>
> Yan Zhang
>
Like you have a RPM install for Linux is there something similar that I can
use with Solaris to make the install simple with Mysql?
Thanks
Mike
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Here's a clearer indication of the problem I mentioned earlier:
In the mysql client terminal output below, note how the column type of
startDate does not show up as changed from timestamp to date (even
though I had changed it earlier in phpmyadmin) until I run "Repair
Table" on the table in PH
3.22.38
Hello guys
I figured out how I can set up different user that are able to work
on their own dbs.
here is my command to add a db and a user;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON bernddb.* TO
bernduser@LOCALHOST IDENTIFIED BY '1234'
But a questions:
when I have added th
Hi,
I've posted this question before, and some were kind enough to respond
with suggestions to my question [replication], but I'm looking for
something more difinitave.
Background: I'm running a production mysql database/php4/Apache on a NT4
IBM Netfinity server [3500 records, growing by 100 a da
I hit up against something like this a while ago,
but I didnt have time to debug so I used a quick hack to
get by.
Say you are storing a text article
--
| ArticleID | INT |
--
|ArticleName | TEXT |
--
I just cre
I think the solution would be to do the "join" at the application level
rather than in the database. We frequently had to do this in msql
because it did joins so badly. Basically you do the select in the first
table including the linking field and then do selects against the second
table (th
Hi!Ken Menzel
I edit the file "/etc/hosts",and make mysql-3.23.39.but it stopped at
the below point !!help me ?!!Thanks!!
-
SQLD_NET_RETRY_COUNT=100 -c convert.cc
c++ -DMYSQL_SERVER -
DDEFAULT_MYSQL_HOME="\"/usr/local/mysql\""
Please help me here, and let me know if MySQL can do it or not. All people
around me told it should work in SyBASE.
Yan Zhang
[EMAIL PROTECTED]
>>
I have two tables:
mysql> show tables;
+--+
| Tables_in_vendor
At 14:54 09/07/2001 -0400, Khuon, Dave wrote:
Hi,
Please, read the Manual \mysql\docs\manual.html
section 8.7.2 InnoDB startup options.
Regards,
Miguel
>I recently downloaded the latest MYSQL version 2.23.39a (from page
>http://www.mysql.com/downloads/mysql-3.23.39a.zip), and installed it as
On 2001.07.10 05:46:25 -0200 Gerlinde Fischer wrote:
> Hi,
> maybe you should use when connecting to mysql with the webserver instead
> of
> "pconnect" "connect".
> Pconnect is persistent and is staying as long as you have set
> the wait_timeout. It is set to 28800 sec by default.
>
> Regards Ger
See my other post just a couple of minutes ago.
Sie schrieben am Dienstag, 10. Juli 2001, 15:37:29:
> Hi!
> I am facing a problem .It is somewhat like that.
> I want to insert the 3mb data in the table column
> using MYSQL as my database.
> It shows the error which says that you have to
> incre
While installing mysql in a linux box (mandarake) i had this error.
Please, guys, help me out. I need to install this mysql in this box as
soon as possible :(
[root@cral mysql]# scripts/mysql_install_db
scripts/mysql_install_db: ./bin/my_print_defaults: cannot execute binary
file
WARNING: The h
I'll give you an example: I start mysqld as such:
mysqld -O max_allowed_packet=2M
This set the option. You can do it also in my.cnf:
[mysqld]
port= 3306
socket = /tmp/mysql.sock
skip-locking
set-variable= key_buffer=16M
set-variable= max_allowed_packet=16M
set-varia
I am getting an error when I try to use mysqldump on a database.
/usr/local/mysql/bin/mysqldump: Can't get keys for table poll (Lost
connection to MySQL server during query)
When this happens, I get a message in the mysql error log saying the
database has been restarted.
mysqld restarted on Th
> I'm running into an odd string size limitation. I've traced it down as far
> as I can get, and I didn't run across anything in the docs or on any
> searches I've run so I figured I'd try here. The field in the database is a
> TEXT type column. I'm appending to the front of the text field each ti
Hi everybody,
I use Replication on a windows NT4 Server.
There are 1 master and 2 slaves, all on the same machine.
One slave is started with the option skip-name-resolve, not the other.
For the 2 slaves : master-host=localhost
When adding a user (MYSQL.User), the replication is OK but,
when
What is in /etc/hosts file? My server named tuvok has this:
bash-2.04$ cat /etc/hosts
127.0.0.1 localhost.icarz.com localhost
207.99.22.16tuvok.icarz.com tuvok
207.99.22.16tuvok.icarz.com.
bash-2.04$
Your machine needs a name, there are examples in /etc/hosts
Hi!Ken Menzel
I try to initialize my datebase.but it output as the
below.What's the matter??
DateTest# ./mysql_install_db
Sorry, the host 'DateTest' could not be looked up.
Please configure the 'hostname' command to return a correct hostname.
If you want to solve this at a later s
i like www.Missoulweb.com
check em out..
Ken
- Original Message -
From: "Ohannes Murat Berin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 09, 2001 5:12 PM
Subject: MySQL ISP
> I am searching for an ISP which has MySQL, any suggestions?
>
>
> ---
As it seems, it is not possible. You would have to have a
connection which talks to two databases at once, which may not be
possible at all, at least create numerous problems.
But I think it should be possible to create a temporary table in
db 2 and copy the table from db1 into it, then do a join
> I managed to index and change all queries to use AGAINST and
> etc. but the users didn't like it. They say they really need
> the functioning of '%text%'.
Isn't it rather 'text%' ? This '%text%' you have without FULLTEXT
feature - in fact you have been using it before. Note that google
uses the
1 - 100 of 132 matches
Mail list logo
