hi guys
im working with some unicode data , store it in mysql db and retrieve it
now its storing the data fine when i use longtext or mediumtext
EXCEPT for a few characters it gives BOXes fo those characters in the
web-browser
& the boxes suddenly increase their numbr of existance if i
On Sat, Jun 22, 2002 at 07:26:36PM -0500, mos wrote:
>
> >We've managed to reproduce this pretty reliably at Yahoo and are
> >working to track and fix the bug. If we find a resolution, I'll post
> >a note here.
>
> There have been a few threads regarding high CPU utilization on
> FreeBSD systems
I recently installed mysql on a new system and the client on works with root?
Whats up?
ruben@www2:~> !mys
mysql -p
Enter password:
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
ruben@www2:~>
--
__
Brooklyn Linux Solutions
At 06:59 PM 6/22/2002, you wrote:
>On Mon, May 27, 2002 at 11:46:44AM +0100, Simon Green wrote:
> > Re Gunnar Helliesen e-mail
> > I have FreeBSD4.2 and MySQL 3.23.49.
> > I two have hi cpu (99%) on a twin cpu system. (Compaq DL380)
> > After making the suggested changes to my.cnf we rebooted the
On 22/6/02 at 17:05, [EMAIL PROTECTED] (Timothy J. Luoma) wrote:
> I've looked through Google and the MySQL website without luck.
>
> I'm looking to find a place which discusses the theory of how one
> should
> create a database, how to organize the information, etc.
>
> There's got to be a g
On Mon, May 27, 2002 at 11:46:44AM +0100, Simon Green wrote:
> Re Gunnar Helliesen e-mail
> I have FreeBSD4.2 and MySQL 3.23.49.
> I two have hi cpu (99%) on a twin cpu system. (Compaq DL380)
> After making the suggested changes to my.cnf we rebooted the system.
> For 3 days all ran fine (low cpu)
I haven't tried it, yet, but this looks like an interesting alternative for
a "try-before-you-buy" method of selecting books:
http://safari.informit.com/mainhom.asp?home
You can subscribe to a list of books monthly and have full access to them
online. If you take a look at this, I would recommen
TjL,
To start with:
http://www.amazon.com/exec/obidos/ASIN/0764507370/qid=1024783081/sr=8-1/ref=
sr_8_1/104-4398960-1440757
If the title bothers you, take a Sharipe, cross out "Dummies" and write
"Managers", no one will ever know. :)
This book gives an excellent primer in theory and normalizati
For theory and history, I found the manual to be an excellent place to start...
http://www.mysql.com/manual.php
and have a walk through the tutorial starting with:
http://www.mysql.com/doc/C/o/Connecting-disconnecting.html
At 05:05 PM Saturday, 6/22/2002, Timothy J. Luoma wrote -=>
>I've lo
- Original Message -
From: "Hytham Shehab" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, June 22, 2002 12:15 AM
Subject: Fw: insert BLOB values
>
> - Original Message -
> From: "Hytham Shehab" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, June 21, 1
Nevermind- I just re-installed mySQL and rebooted. everything works again.
Pierre
Pierre du Parte wrote:
> Hi,
>
> We have been using a simple mySQL database successfully for some time.
> The database has a couple of tables and < 1000 records in the primary
> table. It has been well behaved
Hi
Not sure about sites but try searching for 'database normalisation tutorial'
I found
http://www.codelearn.com/rdb/rdbd_nt1_s.html
which looks to be a reasonable start.
Peter
---
Excellence in internet and open source software
---
Hi,
We have been using a simple mySQL database successfully for some time.
The database has a couple of tables and < 1000 records in the primary
table. It has been well behaved and performing well.
Development & record maintenance is taking place locally under Delphi/
dbExpress applications a
I've looked through Google and the MySQL website without luck.
I'm looking to find a place which discusses the theory of how one should
create a database, how to organize the information, etc.
There's got to be a good site out there, but I'm obviously plugging in the
wrong search terms or somet
Hi,
This problem is probably due to the fact the ft_min_word_len variable is set
to 4 by default.
Try to add
set-variable= ft_min_word_len=3
in your my.cnf, and then recreate your table (or do a REPAIR TABLE test
USE_FRM).
Regards,
Jocelyn Fournier
- Original Message -
From: "G
I've compiled mysql 4.0.2-alpha from source.
I've created table:
create table test (
id_test int4,
body text);
Next:
create fulltext index test_body on test (body);
insert into test (id_test,body) values (1,'test rpm');
insert into test (id_test,body) values (2,'test rpm');
insert into test (i
Also, if you are doing any 'LOAD DATA INFILE' where the master has access to
the file but the slave does not, then this could happen. On most errors, the
slave stop replicating and slave status will be turned to OFF.
The error file, hostname.err might tell you some thing too.
Regards,
Bhavin.
---
At 15:41 +0100 6/21/02, Bill Ferrett wrote:
>I would like to have a MySql table where each row has a unique id (using
>auto-increment) but is clustered, i.e. physically stored, in a different
>sequence, e.g. name. This is so that an sql query to order by namew will be
>quicker.
>
>I don't want th
Is there any particular reason that anyone knows of that would prevent
mysql 3.23.51 for windows from working upon the execution of the SHOW
STATUS FROM tablename query?
In Linux it works fine, in windows it crashes mysqld with an illegal op.
Any other SHOW command works but the one I really need
if(ok)
{
include('zap.htm')
}
else
{
include('zip.htm')
}
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
On Sat, 22 Jun 2002 11:37:29 +0200 (CEST)
Careri Giuseppe <[EMAIL PROTECTED]> wrote:
> >
> > DWP> just do from mysql prompt :
> > DWP> mysql> repair table [tablename]
> >
> > REPAIR TABLE doesn't repair BDB tables!
> >
> Infact I can not repair BDB table, but when a index is corrupted
> what
I think somewhere in the manual it warns against running slave and master as
different versions.
=C=
-Original Message-
From: Kannan R [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 22, 2002 7:15 AM
To: [EMAIL PROTECTED]
Subject: replication error
mysqld --skip-grant-tables
-Original Message-
From: Jesse Angell [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 22, 2002 3:38 AM
To: [EMAIL PROTECTED]
Subject: mysql help !! urgent
Hello,
In phpmyadmin I accidentaly gave root no privlegaes.. Now I cannot do
anything as phpmyadmin w
Placed At :
Hi..
I run a replicated mysql server set up..The version i use on the master is
3.23.49 and on the slave is 3.23.46.
following is the problem I'm facing..
the binlog postion on the master and the slave are always in sync with each
other
Heikki Tuuri writes:
> Jon,
>
> - Original Message -
> From: ""Jon Frisby"" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.mysql
> Sent: Saturday, June 22, 2002 12:51 AM
> Subject: Nasty LIMIT/multi-table DELETE bug?
>
>
> > I just discovered a very scary behavior. We're using MySQ
Hi,
It seems you've not installed automake.
> checking for working automake... missing
Download automake 1.4-p5 and then try to run configure again.
(you can also download texinfo to make makeinfo avalaible)
Regards,
Jocelyn
- Original Message -
From: "Olivier Schildt" <[EMAIL PROTE
[localhost:/usr/local/mysql-3.23.51] root# ./configure
--prefix=/usr/local/mysql
--with-unix-socket-path=/usr/local/mysql/run/mysql_socket
--with-mysqld-user=mysql --with-comment --with-debug
checking build system type... powerpc-apple-darwin5.5
checking host system type... powerpc-apple-darwin
Hi,
It seems to be linked with the gethostname_r detection
"checking style of gethostname_r routines... other"
I think you should have the following line instead :
checking style of gethostname_r routines... glibc2
Can you take a look at the config.log file and tell us what is wrong ?
(in my
You wrote:
> From: Egor Egorov <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Date: Sat, 22 Jun 2002 12:10:01 +0300
> Subject: Re: Re: corrupt index in BDB table
>
>
> Dicky,
> Friday, June 21, 2002, 11:04:32 AM, you wrote:
>
> >> i have a problem with an index of a BerkeleyDB table because th
Hi Jesse,
On Sat, Jun 22, 2002 at 03:42:57AM -0500, Jesse Angell wrote:
> Hello,
> In phpmyadmin I accidentaly gave root no privlegaes.. Now I cannot do
> anything as phpmyadmin wont work because root can't do anything at all... I
> have complete ssh access etc to the server, Please help me o
Dicky,
Friday, June 21, 2002, 11:04:32 AM, you wrote:
>> i have a problem with an index of a BerkeleyDB table because this is corrupted
>> and crashes Mysql (v. 3.23.49).
>>
>> The size of table file is correct 8Mb for 15.000 records but from a select
>> I view only the first 957
>>
>> I
Christian,
Friday, June 21, 2002, 5:42:58 PM, you wrote:
CH> Is a restart/reload or a "flush tables" necessary when creating or removing
CH> databases?
Nope.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita
I have a mysql dbase.
I use a time field to save a number of hours (think about number of
houres spent out of office, or anything else).
A table holds the global values for people and their status, another
table holds every single entry of data, so
john smith 5 hours and 2 minutes outside on 16-06
Hello,
In phpmyadmin I accidentaly gave root no privlegaes.. Now I cannot do
anything as phpmyadmin wont work because root can't do anything at all... I
have complete ssh access etc to the server, Please help me out what do i do
to give root full privs again?!? Please help me get mysql running
Hello,
In phpmyadmin I accidentaly gave root no privlegaes.. Now I cannot do
anything as phpmyadmin wont work because root can't do anything at all... I
have complete ssh access etc to the server, Please help me out what do i do
to give root full privs again?!? please help me make mysql work a
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, June 22, 2002 9:48 AM
Subject: confirm subscribe to [EMAIL PROTECTED]
> Hi! This is the ezmlm program. I'm managing the
> [EMAIL PROTECTED] mailing list.
>
> To confirm that you would like
>
>[EMA
hi guys
im working with some unicode data , store it in mysql db and retrieve it
now its storing the data fine when i use longtext or mediumtext
EXCEPT for a few characters it gives BOXes fo those characters in the
web-browser
& the boxes suddenly increase their numbr of existance if i
At 17:30 -0400 6/21/02, Michael Jessop wrote:
>Can someone tell me what this means? I mean, I guess I *know* what it
>means, but why?
Placeholders for Python scripts using MySQLdb should be %s, not ?.
Convert your ? characters to %s and see what happens.
>
>The insert statement into a mysql dat
Below are what I believe to be the relevant lines from the config.log...
> > Running Debian, 2.4.19pre1 kernel, gcc 3.0.4, glib-2.2.2 with linuxthreads
> > and the mysql-supplied linuxthreads patch.
After re-reading my original post as well, I realize that I forgot to mention that I
compiled th
39 matches
Mail list logo
