Hi,
I have a table that stores geometry information in one column in
"point" type. After freshly uploading the table,
myisamcheck --sort-index reports an error:
- Sorting index for MyISAM-table 'TEST_I14_GEOM'
myisamchk: Unknown error 126
myisamchk: error: Can't read key block from filepos: 7199
Hello,
I'm trying to compile mysql-5.0.22 on Solaris 10 using the Forte Compiler
(cc: Sun C 5.8 2005/10/13). I'm doing this so I can build
the DBI driver for mysql (DBD::mysql). The .pkg versions
are missing libmysqlclient.so required to build DBD::mysql
(http://bugs.mysql.com/bug.php?id=17205).
On Friday 16 June 2006 02:40, Ghaffar wrote:
> The same limitation is also in 4.1.x versions.
> You have to edit the source of the client library and recompile.
I thought so too but fortunately for me we are both wrong...
version: 4.1.15-Debian_1ubuntu5-log
mysql> SHOW FULL FIELDS FROM `user`;
The same limitation is also in 4.1.x versions.
You have to edit the source of the client library and recompile.
Mark Constable wrote:
Howdy. For years I have manually altered mysql.user.User to
64 chars to accommodate email length user IDs but now, after
upgrading to v5.0.21, the "normal" alter
I'm trying to restore a MySQL database in v5.0 (that minor number is in
the teens, I don't have it at hand). I get a bunch of warnings like:
Warning: Do not know how to handle this statement at line 28:
CREATE TEMPORARY TABLE `CHARACTER_SETS` (
`CHARACTER_SET_NAME` varchar(64) NOT NULL default
Look at this previous thread
http://forums.mysql.com/read.php?22,42721,42721
Kishore Jalleda
http://kjalleda.googlepages.com
On 6/15/06, Vitaliy Okulov <[EMAIL PROTECTED]> wrote:
Здравствуйте, .
Hi all. I try to increaseinnodb_buffer_pool_size
There is log file:
mysqld_safe[23845]: sta
Здравствуйте, .
Hi all. I try to increaseinnodb_buffer_pool_size
There is log file:
mysqld_safe[23845]: started
mysqld[23848]: 060615 19:14:52 InnoDB: Error: cannot allocate 2147500032 bytes
of
mysqld[23848]: InnoDB: memory with malloc! Total allocated memory
mysqld[23848]: InnoDB: by Inno
Not natively in 5.0, but MySQL 5.1 has introduced an event schedule feature
embedded into it, but i am not really sure if even that can do what you have
described, but the best way to do this is in Perl with the DBI or the
DBIx::DWIW or the DBD::MySQL modules, if you want some reference then look
Thank you very much for the tips and for the links. I think I have it
working now with a subquery.
cheers,
Andrew Zahn
Peter Brawley wrote:
Andrew Zahn wrote:
I am using MS Access to read from a MySQL database. The query
generated through access listed below returns incorrect data when
execu
Howdy. For years I have manually altered mysql.user.User to
64 chars to accommodate email length user IDs but now, after
upgrading to v5.0.21, the "normal" alter table routine I use
seems to ruin the table altogether. I can't use mysqlcheck to
fix it because the root user can't log in. On a fresh i
On Friday 16 June 2006 00:28, [EMAIL PROTECTED] wrote:
> To confirm that you would like
>
> [EMAIL PROTECTED]
>
> added to the mysql mailing list, please click on
> the following link:
>
> http://lists.mysql.com/s/mysql/44916ea4caaa5c4f/markc=renta.net
>
> This confirmation serves two purpo
On 6/15/06, Lakshmi <[EMAIL PROTECTED]> wrote:
Hi,
The aborted clients seems to be increasing than the connections made.
Any solution
Aborted_clients 67529 where as the connection made is 60462 .
A client is aborted after wait_timeout seconds of inactivity, but as
your app seem to be workin
> I think it's listed by the corresponding SKU numbers - 17 digits. Is
> this what you're asking?
Err...no, I meant pretty much what Martijn said in his reply - the question is
very vague.
There are many ways of achieving...whatever it is you want to achieve.
If you need help with it you need t
> I'm still kind of new to this, so I'm looking for suggestions on how
> to do this one. I need to recode this site that was designed using
> the old WebCatalog program which we will be phasing out soon. Here's
> the link to a page I need help
> on: http://die-broke.com/books.tpl What's the si
At 02:16 PM 6/15/2006 Thursday, Rob Desbois wrote:
> I'm still kind of new to this, so I'm looking for suggestions on how
> to do this one. I need to recode this site that was designed using
> the old WebCatalog program which we will be phasing out soon. Here's
> the link to a page I need help
You have your wait_timeout set to 5 seconds. Which means a client connection will be aborted after 5 seconds of inactivity. Since
your aborted connects is 0, you don't seem to having a problem connecting, just staying connected. 5 seconds is kind of low (default
is 28800 I think), but is fine if
> I'm still kind of new to this, so I'm looking for suggestions on how
> to do this one. I need to recode this site that was designed using
> the old WebCatalog program which we will be phasing out soon. Here's
> the link to a page I need help
> on: http://die-broke.com/books.tpl What's the
Hi All,
I'm still kind of new to this, so I'm looking for suggestions on how
to do this one. I need to recode this site that was designed using
the old WebCatalog program which we will be phasing out soon. Here's
the link to a page I need help
on: http://die-broke.com/books.tpl What's the
On 6/15/06, theo <[EMAIL PROTECTED]> wrote:
Now, there is a new employee "John" with "a job better than Peter's"
His "importance" is one more than peter's, and all other move up +1;
So the list should look like this after inserting "John":
Peter; 24years, some job, 0
John; 28years, somewhat bet
theo schrieb:
Hi
I' m a newbie and I'm sure this question has been answered many times, but
I can't find the appropriate thread.
Example:
I have a table of people's data including a field called say "importance"
like:
NAME; AGE; FUNCTION; IMPORTANCE
Peter; 24years, some job, 0
Anna; 22years
Hi
I' m a newbie and I'm sure this question has been answered many times, but
I can't find the appropriate thread.
Example:
I have a table of people's data including a field called say "importance"
like:
NAME; AGE; FUNCTION; IMPORTANCE
Peter; 24years, some job, 0
Anna; 22years, better job, 1
Hello
I'm looking for mysql 4.1 for Aix 5.3.
I found mysql for aix 5.2 but no where 5.3 package. Is there anyway to
provide this version ?
Other things : the final user use 4.1.10a with Linux and want the same
version for Aix. Why this version of Mysql doesn't exists anymore ?
Thanks,
--
Séba
> *Disclaimer - this will be kind of vague mainly because I only vaguely
> recall the material.
>
> I am trying to create a stored procedure. Now I vaguely recall reading
> something that says I have to match a column type if I am messing with
> one. Something like I want to match a table
At 23:00 +0100 14/6/06, Graham Reeds wrote:
1) You may have a bogus hidden character in your SQL file. If you
look at it with a text editor (BBEdit, TextWrangler, etc), with the
"show invivisbles" feature on, do you see unusual stuff? Sounds
strange but I've seen stranger.
Took a brief look
Hi,
The aborted clients seems to be increasing than the connections made.
Any solution
Aborted_clients 67529 where as the connection made is 60462 .
Here is my server details,
Server : Red Hat Enterprise Linux AS
release 4 (Nahant)
Mysql Server version
25 matches
Mail list logo
