On 26-Oct-2001 Tim Evans wrote:
> I have inherited a database built by someone else who was apparently
> very
> stingy. :-)
>
> A primary key was set to 'tinyint(4)' limiting the number of records
> to 128.
>
> I've tried:
>
> alter table my_data modify phyid mediumint unsigned DEFAULT "0";
>
[EMAIL PROTECTED] wrote:
> Hi. I've been reading for several hours on this one. I've tried everything
> I've read. I'm either doing something really stupid or I've missed the
> point completely.
>
> I have a db on a linux server. I used phpAdmin to create a dump file
> (pe.sql) and retrieve
No updates to the master is the rule, our primary key is actually based on a
timestamp unless we can figure an auto_increment bigint (yes, expecting an
obscene amount of transactions) as the key. I think the bigint
auto_increment might be a better option, certainly easier to use in a select
Not sure if this post worked the first time (I never saw it come in), so a
thousand pardons if this is a re-post.
I come from the school of hard knocks, and so it seems my MySQL
indoctrination is no exception. 2 million rows of 'varchar' data
> Today after my server got a real traffic hit for the first time since I
> installed PhpAdsNew (a MySQL/PHP Ad software), MySQL was crashed.
> Here's how
> it happened: watching the "top" load levels, I saw it slow creep
> up about to
> 3, then rockets quickly to 30s, 40s, and on!! MySQL was at
Hi Peple,
thanks for informations about foreign key in mysql!
Now I need some informations about jdbc driver:
- Are there diferences for jdbc driver for diferent versions of mysql and jbuilder and
jdk?
- I use jbuilder 2.0 and mysql 3.23.41, which jdbc driver is better?
thanks
Sandra.
---
> >I have these 3 tables:
> >T1: T2:
> >Service Application | Application Machine
> >---
> >network DHCP DHCP mach1
> >Database SQLSQL mach2
> >EmailExchange SNMP mach2
> >netw
Hi everyone!
I have a huge database (or will have) and I need to search through it for
web sites. It is a regular Google-Like search engine that returns the web
sites closest to the match, the number of returned queries, etc. Now, what
I want to do is use FULLTEXT or LIKE (preferably FULLTEXT)
My website is currently being hosted on a Linux box, and I am wanting to
incoporate a database using MySQL. I have downloaded the NT version of MySQL to
develop the db with, and am wondering what impact, if any, running it on the
Linux box will have. Are the compatible ???
Thanks in advance,
M
Alex,
Please reply to the list in the future, so that others can answer your questions and
also see the answers as well.
You can find info on how to use referential integrity on
http://www.mysql.com/doc/C/R/CREATE_TABLE.html
For more InnoDB specific information about it, see http://www.innodb
Quite a neat trick... but might there be problems with cross join
performance if the table is large? This is based on the assumption that
MySQL first creates the cross product, then culls out the rows that don't
meet the criteria.
Cheers,
Fred Woolsey
-Original Message-
From: Anvar Huss
Is there any function/command/neat query that you can use to get a histogram
of a column's values? I didn't find anything in the manual or the DuBois
book.
If not, can anybody comment on how difficult this might be to implement as a
user defined function? I haven't looked into this to much yet,
I am getting this error message on my slave server
011025 16:46:14 mysqld started
/usr/local/mysql/libexec/mysqld: ready for connections
011025 16:46:14 Slave thread: error connecting to master: Unknown MySQL
Server Host '' (0) (0), retry in 60 sec
This is my my.cnf config file on the slave se
Hello,
I have problem with Mysql 3.23.xxx on Windows :
I have program that inserts "NaN" values via the MySQL C-Programming interface on a
SUN/Solaris. When I retrieve the data on SUN or Linux
everthing works fine.
However, when I move the database to a windows installation the
NaN values are
On Thu, Oct 25, 2001 at 04:22:33PM +0800, Geoffrey Soh wrote:
> Hi All,
>
> I'm new to this list and have some questions about BDB tables and
> replication. Hope some of the more enlightened ones on this list
> might shed some light on the following :
>
> 1. I've a master-slave replication setu
You can also use a tool like urSQL (http://www.urbanresearch.com/ursql) to
convert the table schemas. urSQL has the ability to save MySQL tables as
MS Access CREATE TABLE scripts and the ability to build a script of insert
statements that can be run against the new table. (You can also save MS
A
Before I overcommit myself, I want to find out a few things:
1) How much work does it take to add functions (not procedures)?
2) Is anyone already working on these functions?
3) Is anyone else interested in these functions?
The function I need is a unix-timestamp to huma
On Thu, Oct 25, 2001 at 08:27:00AM -0700, Bill Adams wrote:
> > At http://www.mysql.com/doc/ do a search for multiple processors. There's
> > a refence to http://www.mysql.com/Downloads/Patches/linux-fork.patch that
> > might help.
>
> And don't forget to make sure you have good/needed indexes.
>
Garry Nevin writes:
> Can anyone advise which, if any versions of the MySQLGUI posted can be run
> under MacOS 10.1 please?
>
> Garry Nevin
> --
>
No, there is none.
But it would not be impossible to build one, if you get in touch with
developer that ported FLTK to Mac. You can find him at w
I have inherited a database built by someone else who was apparently
very
stingy. :-)
A primary key was set to 'tinyint(4)' limiting the number of records
to 128.
I've tried:
alter table my_data modify phyid mediumint unsigned DEFAULT "0";
...but got:
ERROR 1121: Column 'phyid' is used with U
Newbie here who has PHP and MySQL going, but can't figure out how to
install calendar. I suspect this is because I don't understand UNIX and
permissions and which account I'm in. Here are the instructions edited:
Unpack the calendar software in its own directory somewhere where
your web server
Rob/All,
While I would hardly consider myself a commercial developer, I have done
some work in app development in Access/VBA with MySQL as the database
engine. Feel free to contact me if you like.
Cheers,
Fred Woolsey
[EMAIL PROTECTED]
-Original Message-
From: Bill Adams [mailto:[EMAIL
Dear Sirs and Madams,
EMS HiTech company is announcing the next version (1.05) of MySQL
Manager -- A Powerful MySQL Administration and Development Tool for
Windows95/98/ME/NT/2000/XP.
You can download the latest version from
http://www.mysqlmanager.com/download.phtml
What's new in version 1.05?
[EMAIL PROTECTED] wrote:
> Hi. I've been reading for several hours on this one. I've tried everything
> I've read. I'm either doing something really stupid or I've missed the
> point completely.
>
> I have a db on a linux server. I used phpAdmin to create a dump file
> (pe.sql) and retrieved it o
jim barchuk wrote:
> Hi Ryan!
>
> > Today after my server got a real traffic hit for the first time since I
> > installed PhpAdsNew (a MySQL/PHP Ad software), MySQL was crashed. Here's how
> > it happened: watching the "top" load levels, I saw it slow creep up about to
> > 3, then rockets quickly
Sorry to post this again. But I havent figured it out yet. Any hints?
Thaks
>From: "Guitar Man" <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: LEFT JOIN?
>Date: Wed, 24 Oct 2001 18:06:29 +
>
>I have these 3 tables:
>T1: T2:
>Service Application | Application M
Rob Vonsee wrote:
> Dear developer,
>
> In the past several years, we have developed a database application in
> MicroSoft's Access '97.
> With our user base growing, we're encountering more and more limitations in
> the Microsoft development environment, especially in the stability and
> number
Rob,
You may start by checking the utility at download.com that claims to be
able to convert Access to MySQL databases. I am currently trying to get
a company off of Access 2000 and onto MySQL in America, but I have not
tried this tool yet and any reviews from someone that knows Access well
are w
Hi,
I have some text files (logs) that are tab delimited containing 3 columns.
I'm loading them into MySql using the LOAD DATA LOCAL INFILE commands, but I
want to load them into a table that has 4 fields, with the 4th field having
a value equal to the name of the file being loaded.
Is this poss
Thanks Sergei,
fantastic news... I like version4.0, thanks folks, big congratulations all
round
:-)
Chris
-Original Message-
From: Sergei Golubchik [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 4:18 PM
To: Christopher Thorpe
Cc: [EMAIL PROTECTED]
Subject: Re: setting f
Hi!
On Oct 25, Christopher Thorpe wrote:
> Is there any way of setting the ft_min_word_len variable in MySQL4.0 without
> having to recompile? I'm like other people finding problems with the 3
> letter block on fulltext index inclusion as a few queries are for people's
> names which are three let
[EMAIL PROTECTED] writes:
> >Description:
> mysql-utilities mysqlcheck and mysql_convert_table don't quote
> table names and so fail in converting/checking/repairing
> specially named tables.
>
> >How-To-Repeat:
> create e.g. a table `A-22bd` and run mysqlcheck on it
Elm Gysel writes:
> Hello,
>
> I have a memory problem when added records to a table.
> The situation is like this (simplyfied) :
>
> query << "select id, symbol from " << STOCKS_TABLE_NAME << std::ends;
> std::vector symbols;
> query.storein(symbols);
> std::vector::iterator I;
> for(I = symbol
Hi Anton
You can find much information here: , http://www.mysql.com/manual.php
(the manual)
and Here: http://www.mysql.com (the website). and Here:
http://swfaq.mysql.com/sw/bin/11/supportwizard.cgi/02200286
The specific on-line manual on installing mysql start here:
http://www.mysql.com/documen
Elm Gysel wrote:
>/* perform query */
>query.execute(nr, Date.str(), Op, Hi, Lo, Cl, Vo);
> The problem is in the above line I think. If I comment it out the memory
> usage doesn't explode.
> I get around 1.5MB more mem usage each time I insert 2000 records.
> I have no clue what
hi there,
We dont want pirahna monitoring one mysql anymore.
Where can I find the file that has the nanny
configuration?
thanks a mil,
Stuart.
Nokia Game is on again.
Go to http://uk.yahoo.com/nokiagame/ and join the new
all media a
Is there any way of setting the ft_min_word_len variable in MySQL4.0 without
having to recompile? I'm like other people finding problems with the 3
letter block on fulltext index inclusion as a few queries are for people's
names which are three letters long.
thanks
Chris
database, query
Dr C
Hi Ryan!
> Today after my server got a real traffic hit for the first time since I
> installed PhpAdsNew (a MySQL/PHP Ad software), MySQL was crashed. Here's how
> it happened: watching the "top" load levels, I saw it slow creep up about to
> 3, then rockets quickly to 30s, 40s, and on!! MySQL wa
piyush shrivastav writes:
> Hi
> I am student of Indian institute Of Technology
> Madras(India) I downloaded your beta version of
> MySqlGui for linux. But it is saying cannot connect to
> server. even after i edited .cnf files. Further i am
> unable to set password for any of clients i made.
> p
Hi All!
> Unable to insert [
> insert into match (league_id,round_id,team_id_1,team_id_2) VALUES ('1','3','2','3')
> ]: You have an error in your SQL syntax near 'match
>(league_id,round_id,team_id_1,team_id_2) VALUES ('1','3','2','3')' at line 1.
(Yes, I see the reserved word comments.)
Debug
Hi. I've been reading for several hours on this one. I've tried everything
I've read. I'm either doing something really stupid or I've missed the
point completely.
I have a db on a linux server. I used phpAdmin to create a dump file
(pe.sql) and retrieved it on my local machine. I've tried wha
Hi!
On Oct 25, Christian Hammers wrote:
> Hi
>
> The above statement does not work :-( This is sad as it would be a nice
> feature.
>
> bye,
>
> -christian-
>
> mysql> SET @RF='user';
> Query OK, 0 rows affected (0.00 sec)
> mysql> SELECT * FROM @RF;
> ERROR 1064: You have an error in your
Okay, I was afraid this was going to happen.
Today after my server got a real traffic hit for the first time since I
installed PhpAdsNew (a MySQL/PHP Ad software), MySQL was crashed. Here's how
it happened: watching the "top" load levels, I saw it slow creep up about to
3, then rockets quickly to
Hi , I am a student in TU-Munich ,
I need more information how is posible to instal MySQL ,
bekause I begin to learn PHP before 2 month :)
Operation Sistem in TUM is Solaris end Linux(KDE).
Tank You!!!
-
Before posting, pl
Please try to reproduce a bug with our MySQL-Max binary for Linux.
Your compiler and glibc versions are a bit too old for the current
MySQL sources.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__
It is in libz.
Add "-lz" to your compile/link line.
M. A. Alves wrote:
> Hello.
>
> I am linking the mysqlclient library (libmysqlclient.a) to my client
> program as indicated in the MySQL Manual section 23.1, and I am getting
> the following linker error messages:
>
> /usr/lib/mysql/libmysqlc
> -Original Message-
> From: Andrew [mailto:[EMAIL PROTECTED]]
>
> Hello, List Members,
>
> Is it possible to write .php script or .html which would
> create a table ? i.e. being uploaded, run once and then
> deleted ? If YES, please send me such script (open
> database,create table
Heikki Tuuri wrote:
>
> Hi!
>
> >Michael Blood wrote:
> >
> >> I am running 3.23.40 on a dual pentium III 800 with 1 GB Ram.
> >>
> >> I have been getting an table handler returns error 127 error
> >>
> >> If I fix the table with myisamchk -r or -o it will work for a while and then
> >> I will g
Hello, List Members,
Is it possible to write .php script or .html which would create a table ?
i.e. being uploaded, run once and then deleted ?
If YES, please send me such script (open database,create table
and fill in init value,close db = that's all).
A can communicate with my ISP only by ftp.
Hi,
Nice to see Mac users out there.
There seem to be some equivalent interfaces. I haven't tried them yet, but go
to
www.stepwise.com
and click on the softrack link and then the MacOS X one.
I found my mysql version there. It was nice to be able to install with a
double click.
/Erik
On T
Hi
The above statement does not work :-( This is sad as it would be a nice
feature.
bye,
-christian-
mysql> SET @RF='user';
Query OK, 0 rows affected (0.00 sec)
mysql> SELECT * FROM @RF;
ERROR 1064: You have an error in your SQL syntax near '@RF' at line 1
--
Christian HammersWESTEND
Hi,
> Unable to insert [
> insert into match (league_id,round_id,team_id_1,team_id_2) VALUES ('1','3','2','3')
> ]: You have an error in your SQL syntax near 'match
>(league_id,round_id,team_id_1,team_id_2) VALUES ('1','3','2','3')' at line 1.
MATCH is a keyword... :) How did you manage to c
>To compile MySql you will need gcc-2.95.2 described above, along with
>FSU-pthreads-3.5c from mysql.com. You will find "custom" loadable copies
pthreads 3.5c has a problem with MySQL on OpenServer. It causes MySQL to
stop and restart. I never did experience any table corruption from this but
it
Can anyone advise which, if any versions of the MySQLGUI posted can be run
under MacOS 10.1 please?
Garry Nevin
--
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
On 25 Oct 2001 [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:
>
> database,sql,query,table
>
> If you just reply to this message,
I had a problem last week with a table I was using maybe you have a similar
problem. I had an auto increment problem as I was using tiny int (which only
allows 127 records) on a column but ended up with more than 127 records.
Once I changed my autoincrement column to int from tiny int I was abl
Chris
Are those columns really character types, or integers ?
The values you list are quoted, which suggests they're character based, but
'id' suggests integers, ie.
insert into match (league_id,round_id,team_id_1,team_id_2) VALUES (1,3,2,3);
Phil
- Original Message -
From: "Chris Ait
hi,
MATCH is a reserved word. Try to rename your table.
HTH.
Anton Tichawa.
> -Original Message-
> From: Chris Aitken [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 25, 2001 1:09 PM
> To: [EMAIL PROTECTED]
> Subject: Weird Error Inserting
>
>
>
Unable to insert [
insert into match (league_id,round_id,team_id_1,team_id_2) VALUES ('1','3','2','3')
]: You have an error in your SQL syntax near 'match
](league_id,round_id,team_id_1,team_id_2) VALUES ('1','3','2','3')' at line 1.
Hi!
On Oct 25, Lowell Allen wrote:
> Thanks for the reply, Sergei. I think I've since found the problem in the
> MySQL documentation -- under "Fulltext restrictions", 6.8.1, "All parameters
> to the MATCH function must be columns from the same table that is part of
> the same fulltext index." I n
Hello.
I am linking the mysqlclient library (libmysqlclient.a) to my client
program as indicated in the MySQL Manual section 23.1, and I am getting
the following linker error messages:
/usr/lib/mysql/libmysqlclient.a(my_compress.o): In function
`my_compress_alloc':
my_compress.o(.text+0xbb): und
Hi!
On Oct 24, Lowell Allen wrote:
> I'm trying to do a search against two fulltext indexes. I can successfully
> search against either one separately, like:
>
> $psl->set_query("SELECT Products.ID, Products.Name, " .
> "Products.Photo, Products.Description " .
> "FROM Products, Cate
Dear developer,
In the past several years, we have developed a database application in
MicroSoft's Access '97.
With our user base growing, we're encountering more and more limitations in
the Microsoft development environment, especially in the stability and
number of simultaneous sessions of t
> -Original Message-
> From: Robert Cross [mailto:[EMAIL PROTECTED]]
>
> I don't think that there is anyway to avoid the command line
> with MySQL, (I'm guessing that initially install and user
> config has to be done with the command line). That said, day
> to day, there are a verita
Todd wrote:
>I come from a microsoft environment and never really had to deal with a
>command line based database before.
>All the documentation for MySQL doesn't make sense to a rookie and is
>frustrating... Anywhere to go where I can feel like I can learn
>something?
Go to your local compute
>Description:
When altering a tables columns, MySQL doesn't check if the
current data in these columns fits into the new options.
Although dumping such a table works, restore fails.
>How-To-Repeat:
Create a table 'test' with a column 'id' and do as following:
>Description:
mysql-utilities mysqlcheck and mysql_convert_table don't quote
table names and so fail in converting/checking/repairing
specially named tables.
>How-To-Repeat:
create e.g. a table `A-22bd` and run mysqlcheck on it:
# mysqlchec
Hi All,
I'm new to this list and have some questions about BDB tables and
replication. Hope some of the more enlightened ones on this list might shed
some light on the following :
1. I've a master-slave replication setup with BDB tables. If for some
reason the BDB tables on the slave go out of
Hi!
1.How i can detect if mysql server had been restarted within safe_masqld
or is already dead before executing queries? In mysql.cc i found magic
variable static bool connected. But it is set to false only when
initialized and after mysql_close()... and the decision is seems to be
based only
The url is on two lines, you had a carriage return.
add the following-> at the end of your URL
inistration.html#mysqld-max
-
At 20:05 24/10/2001 -0700, you wrote:
> > >
> > >
> > > I saw this (mysql-max) on the MySQL Website but no where (at least no
>where
> > > obvious) can the descript
70 matches
Mail list logo
