Hi Victoria!
After running "myisamchk -r" it works.
Thanks a lot!
Kai
-Ursprüngliche Nachricht-
Von: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 15. November 2002 17:41
An: [EMAIL PROTECTED]
Betreff: Re: AW: Index of packed table not used
Hello Kai,
Friday, Novemb
Hi,
I would like to know how to store an image as a BLOB in MySQL. (from
Delphi).
Sincerely,
Adrian Tarniceru
---
Xnet scaneaza automat toate mesajele impotriva virusilor folosind RAV AntiVirus.
Xnet automatically scans all messages for viru
While not pretty the following would do it
SUBSTRING_INDEX(SUBSTRING_INDEX(value, ',', 3), ',', -1)
John W Higgins
[EMAIL PROTECTED]
-Original Message-
From: Paul van Brouwershaven [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 16, 2002 5:46 AM
To: [EMAIL PROTECTED]
Subject: SQL Qu
I have a two table query where I want to return records from the first table
and if they have corresponding details in my second table I wish to return
those as well. A sample sql statement I am using is as follows:
select decheader.code, decheader.height, decheader.width,
decplacement.position, d
Are you talking about Microsoft.net?
7. Most part of its interface is not accessible for the people with
dissabilities like Visual Studio 6.
...
Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]
- Original Message -
From: "Robert Raisch" <[EMAIL PROTECTED]>
To: "Josep
I am having some problems seeing posts to the list so if anyone has already
received this mail I apologise. Anyway, I have a two table query where I
want to return records from the first table and if they have corresponding
details in my second table I wish to return those as well. A sample sql
sta
Hello,
Try this:
mysql> CREATE TABLE a (
id int NOT NULL PRIMARY KEY,
des varchar(20) default NULL
);
Query OK, 0 rows affected (0.00 sec)
mysql> INSERT INTO a VALUES (1,'pepe'),(2,'juan'),(3,'mariano');
Query OK, 3 rows affected (0.00 sec)
Registros: 3 Duplicados: 0 Peligros: 0
mysql> se
dear all,
i want to change my field type from varchar(255) into varchar2(1024) --- (as
i use in oracle)
can i use this in mysql? anyway i don't wanna use tinyblob/mediumblob...
TIA,
Ivan Paul
SQL, Query
-
Before posting, plea
Hi guys,
I am trying to install mysql-3.23.53a-pc-linux-gnu-i686 to my linux kernel
2.2.14(Caldera OpenLinux 2.4). I follow throught the installation porcess
in the documentation in the mysql.com web site.
I am using bash shell, here is the list of commands i went through:
shell> groupadd mysql
s
Hi all,
Brand new to these parts so go easy on me! :)
Right - I want to use MySQL - but doing things backward. What are you
people using as a front end?
I mean MySQL just sits in the background churning out stuff - but
obviously the instructions have to come from somewhere.
Someone suggested
I am just starting to use mysql and I need some help on probably some
simple items
I have created a database and now I want to just do a simple query and
display the results on the screen and that is where I am having the
trouble. How do I get it to print the variables on the webpage.
Thanks
Rya
Gurhan,
The outlined method is unnecessary if you are using Mysql.
The same output can be achieved by using,
select @a:=substring_index(val,',',3), substring_index(@a,',',-1) as
value_i_want from test;
Richard.
- Original Message -
From: "Gurhan Ozen" <[EMAIL PROTECTED]>
To: "P
I have a two table query where I want to return records from the first table
and if they have corresponding details in my second table I wish to return
those as well. A sample sql statement I am using is as follows:
select decheader.code, decheader.height, decheader.width,
decplacement.position, d
Hi all,
I've got a SQL query I can't seem to generate, and am hoping someone out
there has some ideas. I can not use subselects [using mysql 3.23, which
doesn't support subselects].
I have 3 tables, laid out as follows:
mysql> desc authors;
+-+-+--+-+-+-
Hi,
Can someone help on this question?
I have downloaded and intalled succesfully mysql-max 4.0.4. However, when I
checked the information I stored via insert statements, I noticed weird
characters placed in the positions of letter that have accents. I am storing
information in portuguese and the
Hello All;
I am setting up a backup system for a client and am thinking to use
mysqldump on a daily cron job to back up my SQL database. Does anyone know
if I will have any concerns using mysqldump with a table that contains BLOB
columns? (No larger than 15 megs for any given file)
Mike Hillyer
Hey all,
All of a sudden, we are having MySQL (3.23.51) quit serving, running on OS X
Server (10.2.1). This particular box has been running flawlessly for a
month. There are about 140 databases on it.
When I log in via command line and do a show databases; I get this:
++
| Database
Hello all,
All of a sudden, we are having MySQL (3.23.51) quit serving, running on OS X
Server (10.2.1). This particular box has been running flawlessly for a
month. There are about 140 databases on it.
When I log in via shell and do a show databases; I get this:
++
| Database |
+-
HI
I'm not sure what I'm doing wrong in the following example, the foreign
key is NOT working. I'm using ver3.23.53.
-
mysql> CREATE TABLE unit (
-> unitCode CHAR(20) NOT NULL,
-> uni
>Description:
mysql crushed here is the stack dump
0x80b9862 handle_segfault__Fi + 406
0x187f05 (?)
0x814e0ab _hp_delete_key + 107
0x814db94 heap_write + 204
0x80dff5f end_update__FP4JOINP13st_join_tableb + 395
0x80df346 sub_select__FP4JOINP13st_join_tableb + 238
0x80df346 sub_select__FP4J
#Hello
#I'm using hibernate a O/R model from sourceforge and it makes the #bridge
#between sql and a query languange from hibernate.
#Why this query dont work
#at mysql. this query is generated by hibernate but
#it works in all databases I know:
#You just need to run this in the command
#prompt of
Hi people,
It's available in the site br.geoticies.com/burbello the Source of My
Database Manager.
I opened the source for everybody to do the best tool for us. It's was made
in Delphi 6 and Zeos DBO. Ok
Regards.
Alexander
sql,query
--
I was wondering if some things can be done with mySQL:
Select rows that have a number in ANY column, without specifying every
column in the select statement.
Perform statistical analysis on the numbers in a column (like regression).
I've only seen simple things like maximum and sum.
---
Hi,
Can someone help on this question?
I have downloaded and intalled succesfully mysql-max 4.0.4. However, when I
checked the information I stored via insert statements, I noticed weird
characters placed in the positions of letter that have accents. I am storing
information in portuguese and
Hi,
Can someone help on this question?
I have downloaded and intalled succesfully mysql-max 4.0.4. However, when I
checked the information I stored via insert statements, I noticed weird
characters placed in the positions of letter that have accents. I am storing
information in portuguese and
Hi,
Can someone help on this question?
I have downloaded and intalled succesfully mysql-max 4.0.4. However, when I
checked the information I stored via insert statements, I noticed weird
characters placed in the positions of letter that have accents. I am storing
information in portuguese and
I just downloaded and installed MySQL 3.23.53-win. The installation required
DBI and DBD-mysql which I installed using PPM.
I'd like to test mysql, but everything I run is looking for perl56.dll and
fails to load.
DBI and DBD-mysql appear to be compiled/linked using Perl 5.6. All of my
efforts a
I have posted many emails asking help for my question and it seems that the
list does not work. Can someone reply please?
From: [EMAIL PROTECTED]
To: "Siomara Pantarotto" <[EMAIL PROTECTED]>
Subject: Re: testing Date: Sun, 17 Nov 2002 16:12:41 +0100
Your message cannot be posted because it a
Dear list,
yesterday I imported some tables from MS Access via ODBC into my brand
new MySQL 4.0.4 server. Everything went fine, but the tables did not
have a primary key, so I did the following:
mysql> ALTER TABLE auftrag CHANGE Nummer Nummer INT UNSIGNED NOT NULL
PRIMARY KEY;
ERROR 7: Error on r
Hi all.
Hi spam filter. SQL. Query.
I'm teaching myself PHP while building a graphing engine for my work.
When a client logs in, I want to make a temporary table with the primary
keys of the last 3 months worth of their data. I will then be averaging
the data and using JPGraph (which is quite co
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 18 November 2002 13:37, Bill Leonard wrote:
> All of a sudden, we are having MySQL (3.23.51) quit serving, running on OS
> X Server (10.2.1). This particular box has been running flawlessly for a
> month. There are about 140 databases on it.
On 14 Nov 2002 Fraser Stuart shaped the electrons to write something
about [Mysql & Encryption]
> We are about to embark on a project that requires data encryption -
> mainly to stop sensitive information being viewed accidentally (ie
Isn´t it possible to tunnel MySQL connections through ssl?
Und
* Vince LaMonica
[...]
> I'm currently attempting this by doing [only trying priority 1 and 2
> right now]:
>
> SELECT
> papers.id,
> a1.last_name as auth1,
> a2.last_name as auth2,
> papers.year
> FROM
> paper_authors, papers,
> authors AS a1
> left join authors AS a2 ON (a2.id = paper_authors.au
No.
Just escape the fields properly.
Rgds
Insane
SQLyog
The Definitive GUI for MySQL ( http://www.sqlyog.com )
- Original Message -
From: "Mike Hillyer" <[EMAIL PROTECTED]>
To: "MySQL Mailing List" <[EMAIL PROTECTED]>
Sent: Sunday, November 17, 2002 12:17 AM
Subject: MySQLDump & BLOB Co
This query uses a "subselect" that is not currently supported
by MySQL.
Check the manual for details:
http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html
Regards,
Joseph Bueno
jorge machado wrote:
> #Hello
> #I'm using hibernate a O/R model from sourceforge and it makes the #bridge
> #between
Change room to unit
FOREIGN KEY (unitCode) REFERENCES room (unitCode) ON DELETE CASCADE
FOREIGN KEY (unitCode) REFERENCES unit(unitCode) ON DELETE CASCADE
Hope this helps,
Sil
- Original Message -
From: "vinita vigine Murugiah" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, Nove
At 10:10 +0200 11/15/02, [EMAIL PROTECTED] wrote:
Hi all,
I'm working on design step for a new application and I'm interested about
fulltext indexes. I need a safe transaction tables also.
Does Mysql support this or is a feature?
In need a SOLUTION for a fulltext search on the InnoDB table.
A
Hi
Yes the list works!
It sounds as though you do not have support for the character set you are
using. Check the MySql manual for supported character sets.
HTH
Peter
---
Excellence in internet and open source software
---
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
You can rest assured that the list does indeed work. And as it is a
list, and you have posted a question to the list, you have to wait
until someone reads your question that might be able to help you with
whatever problem you are having. As I have ze
Hello list,
since I've upgraded to 4.0.4 I'm experiencing serious problems.
When mysql starts up, everything is fine (~50 req/sec, ~10 threads)
and the system load is about 1.0.
After a while, the number of threads rises up to 60-80 and the CPU load
increases up to similar values. The response is
Well, It will be up to someone else to determine whether there is a way to
persist a connection in PHP. Going from the idea that you cannot persist a
connection, I reccomend you name the normal table based on something unique
to the individual user, like their IP, the time, or something like that.
> SELECT * FROM foo WHERE id2=1 AND id2=2 (for example)...
Given your structure, no row can satisfy your criteria. You are asking ID2
to have two values on one row, which is clearly impossible. Did you by
chance mean:
SELECT * FROM foo WHERE id2=1 OR id2=2
or alternatively
SELECT
A windows versionof Stunnel is available from the stunnel website
(www.stunnel.org), I would reccomend using it for your needs.
Mike Hillyer
-Original Message-
From: Alexandre Aguiar [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 18, 2002 6:09 AM
To: Fraser Stuart
Cc: [EMAIL PROTECTED
Say we create a table as follows:
CREATE TABLE account (id INTEGER, balance DECIMAL(20, 2), col_double
DOUBLE(20,2));
And we insert 6 rows as follows:
INSERT INTO account (id, balance, col_double) VALUES (1,
12345678901234567890.56, 12345678901234567890.56);
INSERT INTO account (id, balance, col
Hi all,
Can anyone help? I want to know if there is an easy way to return the
number of days in a month from mysql.
Ideally there would be a function that did the following...
mysql> SELECT DAYSINMONTH('2002-10');
+---+
| DAYINMONTH('2002-10') |
+---+
|
* Alexandre Aguiar
> On 14 Nov 2002 Fraser Stuart shaped the electrons to write something
> about [Mysql & Encryption]
>
> > We are about to embark on a project that requires data encryption -
> > mainly to stop sensitive information being viewed accidentally (ie
>
> Isn´t it possible to tunnel MyS
On Mon, 2002-11-18 at 15:06, [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
>
> If you just reply to this message,
Hi.
I'm setting up a slave for a 4.0.4-beta mysql server.
The first time it worked perfectly, doing what is
written here:
http://www.mysql.com/doc/en/Replication_HOWTO.html
But I am trying to do it again and I receive this
error:
021117 23:10:31 mysqld started
/mysql/libexec/mysqld: ready for
IMO you should begin with the command-line client mysql and get to know the
various commands such as SHOW. Import some data from somewhere and play
around with SELECT and UPDATE and joins. Once you have a basic understanding
of these commands, then a GUI front end will be a lot more useful, IMO. So
Hi,
In fact it seems the list have had some problems this week-end, as sent
messages seems to have been delayed of about 1 day.
Regards,
Jocelyn
- Original Message -
From: "Bryant Hester" <[EMAIL PROTECTED]>
To: "'Siomara Pantarotto'" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Mo
Hi,
I'm hoping I can explain this better so here it goes. I'm using ColdFusion and MySQL.
My database has the following fields and what they contain:
strUser_ID (auto-generated)
strUsername = 'Bill'
strSelect = 'D:\test\dir1,D:\test\dir2,D:\test\dir3,D:\test\dir4,D:\test\dir5'
strSelectFlag = '
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 18 November 2002 14:53, Stefan Bohm wrote:
> since I've upgraded to 4.0.4 I'm experiencing serious problems.
> When mysql starts up, everything is fine (~50 req/sec, ~10 threads)
> and the system load is about 1.0.
>
> After a while, the num
Mysql 4.01 beta has support for ssl connections. I have it compiled and
running with the openssl support and it's working good. Have a look at the
documentation at http://www.mysql.com/doc/en/Secure_connections.html I
think this would be the best way to encrypt your data.
Matthew Scarrow
ComIT So
It's not all that elegant, but how about this:
Mysql> SELECT date_format(date_add('2002-10-01', interval -1 day), "%d");
Basically, take the first day of the month, subtract one and figure out what
the day number is.
-- Jason
On 11/18/02 9:02 AM, "Andrew Braithwaite" <[EMAIL PROTECTED]> wro
What version of MySQL JDBC are you using?
Scott Pippin
[EMAIL PROTECTED]
>>> "jsplist" <[EMAIL PROTECTED]> 11/16/02 12:13PM >>>
Hello ! ,
Im running Tomcat on a Windows machine and Ive got my CLASSPATH
pointing to c:\tomcat\lib\mysql.jar .
Then in my webapps folder I have a web application cl
* Andrew Braithwaite
> Can anyone help? I want to know if there is an easy way to return the
> number of days in a month from mysql.
>
> Ideally there would be a function that did the following...
>
> mysql> SELECT DAYSINMONTH('2002-10');
> +---+
> | DAYINMONTH('2002-10') |
Ivan,
Monday, November 18, 2002, 7:02:33 AM, you wrote:
IP> i want to change my field type from varchar(255) into varchar2(1024) --- (as
IP> i use in oracle)
IP> can i use this in mysql? anyway i don't wanna use tinyblob/mediumblob...
Use TEXT column type:
http://www.mysql.com/doc/en/Column_t
Neulinger,
Friday, November 15, 2002, 7:25:27 PM, you wrote:
NN> Assume I have a mysql table (myisam most likely) with a few hundred
NN> thousand rows in it. One of the columns indicates success or failure.
NN> 99.9% of the rows will have "0" in that column. But a small number will
NN> have 1. I n
MySQL Classic (Commercial License)
Similar to MySQL Standard, but *without* InnoDB and only available as a commercial
licensed version.
MySQL Pro (Commercial)
Similar to MySQL Standard (*including* InnoDB), but only available as a commercial
licensed version.
What is the diference in (Comm
Thanks for solving this all,
I have do something ugly because I only have the -mm (3rd party DB)
which ends up like this:
Mysql> select dayofmonth((concat('2004-02','-01') + interval 1 month) -
interval 1 day);
Urrggg ;)
Still, much more graceful (and more future proof) than what I just cam
In the last episode (Nov 18), Lenz Grimmer said:
> You have experienced a bug that Mac OS X seems to have inherited from
> FreeBSD, which shows a similar behaviour. For a very detailed
> description, see this entry in Jeremy's blog
>
> http://jeremy.zawodny.com/blog/archives/000264.html#000264
>
Hello,
I have a problem that I could use some help with. We're running a
mysql/php intranet site for time sheets (home grown solution). However
from time to time a user will tell me hours from the previous week are
just "gone". I go to look and sure enough, no hours have been entered. I
have not b
I've having trouble figuring out the SQL to do this.
I have two tables, user, and group_map, and I want to insert a row into
group_map for every row in user.
user
user_id
group_map
user_id
group_id
For each user_id:
insert into group_map ( user_id, group_id )
In the last episode (Nov 18), Greg Macek said:
> Hello,
>
> I have a problem that I could use some help with. We're running a
> mysql/php intranet site for time sheets (home grown solution). However
> from time to time a user will tell me hours from the previous week are
> just "gone". I go to loo
>Description:
I just installed redhat8 this weekend and am using the rpm's provided by them. when
mysql runs it will only run a single process. and even worse... when I try and
connect to port 3306 (even via telnet) the process is immediately killed and
safe_mysqld restarts it. it logs the f
Don't forget that SSH (eg OpenSSH) can tunnel regular port connections too.
This is dead easy to set up with a client such as "SecureCRT" from Van Dyke,
but this is a paid product (although worth the money in my opinion - I own
it). They also do "Entunnel" which is cheaper product which just doe
Hi---
I'm working on a rulebase for MySQL (a final project for a DB graduate
course) and was wondering whether anything similar has been attempted in
the past. This would be a logical system in the flavor of POSTGRES.
Thanks!---
Jinger Zhao
(214) 450-6845
http://www.people.fas.harvar
Hello list,
when upgrading the master in a master slave setup from 3.23.x to 4.0.x or
downgrading back to 3.23.x the binlog seems to be corrupt for the slaves.
I get error messages like "binlog truncated" or 'unexpected success or fatal
error' on query ''
I always have to copy the whole DB to the
That's the weird part of it. Last week in reviewing the system, making
sure reports were working I can personally verify his stuff was in there
(not even logged on as him). This week: nothing. Is there any record of
3.23.49 ever having random data loss issues? Related to something else
on the syste
At 08:15 AM 11/18/2002, you wrote:
* Alexandre Aguiar
> On 14 Nov 2002 Fraser Stuart shaped the electrons to write something
> about [Mysql & Encryption]
>
> > We are about to embark on a project that requires data encryption -
> > mainly to stop sensitive information being viewed accidentally (ie
Any suggestions? This is a live DB ...
021118 10:43:47 InnoDB: Started
/usr/libexec/mysqld: ready for connections
1254 021118 10:43:49 Slave: connected to master
'[EMAIL PROTECTED]:3303', replication started in log 'FIRST' at
position 31804350 ' at line 1
ERR
On Mon, Nov 18, 2002 at 09:54:21AM -0600, Dan Nelson wrote:
> In the last episode (Nov 18), Lenz Grimmer said:
> > You have experienced a bug that Mac OS X seems to have inherited from
> > FreeBSD, which shows a similar behaviour. For a very detailed
> > description, see this entry in Jeremy's blog
Hi,
I just install MySQL-3.23.53 on a redhat-7.2.
I believe I did it quite correctly *after several
attempts*.
So I intended to benchmark my server.
So in /usr/local/mysql/mysql-test, I run this:
# ./mysql-test-run
And then I got the
mysqld is missing in /usr/local/mysql/bin...
I read in th
In the last episode (Nov 18), Greg Macek said:
> That's the weird part of it. Last week in reviewing the system,
> making sure reports were working I can personally verify his stuff
> was in there (not even logged on as him). This week: nothing. Is
> there any record of 3.23.49 ever having random d
You can use
insert group_map (user_id,group_id) select user_id,"6" as any_label from
user
> -Original Message-
> From: Zabel, Ian [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 18, 2002 11:35 AM
> To: [EMAIL PROTECTED]
> Subject: Insert row in x for every row in y
>
>
> I've hav
An update to my earlier post. I'm getting a bit closer but still not there.
In the following query:
select decheader.code, decheader.height, decheader.width,
decplacement.position, decplacement.product
from decheader left join decplacement on decheader.code = decplacement.code
and
(decheader.code
Hi!
I've had a good look through the documentation and here is where I am:
I'm logging users coming in to a web site, by ip address column called ip
and by dateIn (a
timestamp of 14 bytes). I'd like to list (one row per day) the COUNTs of
unique (DISTINCT) ip addresses. I'd also like to have t
I'll look into the code on the PHP side (since I wrote that too). Maybe
it is something I did. :)
I may avoid repairing the tables for now, since the missing records have
already been re-entered and I don't want to risk anything being
duplicated at this point. Perhaps I'll drop all the indexes for
Greg Macek said..
---
>>I have a problem that I could use some help with. We're running a
mysql/php intranet site for time sheets (home grown solution). However from
time to time a user will tell me hours from the previous week are just
"gone". I go to look and s
Try to upgrade glibc:
https://rhn.redhat.com/errata/RHSA-2002-197.html
[EMAIL PROTECTED] wrote:
> >Description:
>
> I just installed redhat8 this weekend and am using the rpm's provided
> by them. when mysql runs it will only run a single process. and even
> worse... when I try and connec
I have just updated from MySQL 3.23.51 to 4.0.4 on my Win2000 Prof SP2
portable, and shortly afterwards noted some runaway problem was consuming
memory. Left long enough, Windows eventually starts bleating about its
amount of virtual memory; obviously things start to thrash, and apps
gradually grin
Greg Macek wrote:
That's the weird part of it. Last week in reviewing the system, making
sure reports were working I can personally verify his stuff was in there
(not even logged on as him). This week: nothing. Is there any record of
3.23.49 ever having random data loss issues? Related to somethi
Hi,
I'm having weird errors right now, running MySQL queries from PHP as
an Apache module. Sometimes (in a seemingly random way) some queries fail
and mysql_error() displays "Commands out of sync; You can't run this
command now". I would say it seems to happen when different queries are
launched
On Mon, Nov 18, 2002 at 05:38:00PM +0200, Egor Egorov wrote:
> Neulinger,
> Friday, November 15, 2002, 7:25:27 PM, you wrote:
>
> NN> Assume I have a mysql table (myisam most likely) with a few hundred
> NN> thousand rows in it. One of the columns indicates success or failure.
> NN> 99.9% of the r
On Fri, Nov 15, 2002 at 05:55:07PM +0900, Chung Ha-nyung wrote:
>
> Dear,
>
> I'm so sorry that nobody didn't answer for my question, which asked
> about the condition relay log files are deleted in replication slave
> server. Anyway. Although somebody said that the files will be
> deleted aut
On Fri, Nov 15, 2002 at 05:55:07PM +0900, Chung Ha-nyung wrote:
>
> Dear,
>
> I'm so sorry that nobody didn't answer for my question, which asked
> about the condition relay log files are deleted in replication slave
> server. Anyway. Although somebody said that the files will be
> deleted aut
Have you considered putting your databases on an encrypted filesystem ?
You don't need to add anything to mysql and those filesystems
already exist (although I have not yet used them).
Regards,
Joseph Bueno
mos wrote:
> At 08:15 AM 11/18/2002, you wrote:
>
> > * Alexandre Aguiar
> > > On 14 Nov
On Mon, Nov 18, 2002 at 05:41:51PM +0100, Stefan Bohm wrote:
>
> when upgrading the master in a master slave setup from 3.23.x to
> 4.0.x or downgrading back to 3.23.x the binlog seems to be corrupt
> for the slaves. I get error messages like "binlog truncated" or
> 'unexpected success or fatal e
Just replying to myself... After replacing mysql_pconnect() with
mysql_connect(), the problems seems gone so far. So chances are
it is a bug on the PHP side.
Regards
Antoine.
> Hi,
>
> I'm having weird errors right now, running MySQL queries from PHP as an
> Apache module. Sometimes (in a seem
not sure what you're after, but here's one:
if you have windows boxes for frontends, take a
look at http://corereader.com
it's a free query tool that's designed to
simplify the query operation for administrators
and users. after you connect, it's entirely
point and click. it'll query anyth
On Mon, Nov 18, 2002 at 11:47:48AM -0500, Michael T. Babcock wrote:
> Any suggestions? This is a live DB ...
>
> 021118 10:43:47 InnoDB: Started
> /usr/libexec/mysqld: ready for connections
> 1254 021118 10:43:49 Slave: connected to master
> '[EMAIL PROTECTED]:3303', replication started in lo
I sent a bug report earlier and have had some responses of others with
the same problems.
is there *anyone* on this list that is running redhat8 (with the mysql
on the redhat install disks) and can query from remote machines?
when I connect to port 3306 the process instantly dies...
k
--
Kevin
Jeremy Zawodny wrote:
I hate to ask this, bug did you change anything? :-)
In the data? Heck ya :-) ... the versions of the software? No --
although either of them has restarted / flushed logs from time to time
as necessary (I don't have a log rotation program yet for the binary
logs mind
PuTTY is a nice freeware SSH client.
http://www.chiark.greenend.org.uk/~sgtatham/putty/
-mike
> -Original Message-
> From: Andy Eastham [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 18, 2002 8:39 AM
> To: Mysql@Lists. Mysql. Com
> Subject: RE: Mysql & Encryption
>
>
> Don
Hi!
InnoDB is a MySQL table type which supports transactions, row level locking,
foreign keys, and a non-free hot backup tool. InnoDB is included in all
downloads of MySQL-4.0. Of the commercially licensed versions, MySQL-Pro
contains InnoDB.
Release 4.0.5 contains a feature which application pro
Dear list,
sorry for bothering you again, but no one has answered to my request for
help so far, not even Jeremy Z. who *I know* can solve every and any
problem remotely ;-)
On Win2K with MySQL 4.0.4 I get this error with a MyISAM table:
mysql> ALTER TABLE auftrag CHANGE Nummer Nummer INT UNSIGN
after pawing through octobers messages on this mailing list I found out
that I can put the requesting ip's in /etc/hosts and everything is ok.
must be some bad mojo in glibc's resolver.
(I would hope redhat would come out with erratta for redhat8)
k
Joseph Bueno wrote:
Try to upgrade glibc:
Hi,
It's known bug of PHP, which has just been fixed in 4.3 CVS.
Use mysql_connect instead of mysql_pconnect as a workaround of the problem.
(or get the latest CVS version of php 4.3.0)
For more infos :
http://bugs.php.net/bug.php?id=19529
Regards,
Jocelyn
- Original Message -
From:
Comment out the body of the _restore_connection_defaults in php_mysql.c
file in PHP. Recompile, etc. Or dont use persistent connections. Should
be fixed in PHP 4.3.
See http://bugs.php.net/?id=19529 for more info.
Sincerely,
Steven Roussey
http://Network54.com/
-
I'm running 8.0 (which according to that link is unaffected) and I
have the same problem (except I compiled from source). Any ideas?
On Mon, 2002-11-18 at 12:16, Joseph Bueno wrote:
> Try to upgrade glibc:
> https://rhn.redhat.com/errata/RHSA-2002-197.html
>
>
>
> [EMAIL PROTECTED] wrote:
>
1 - 100 of 154 matches
Mail list logo
