In the last episode (May 14), Tim Johnson said:
> I have MySQL version 5.0.84 on linux slackware 13.0 32-bit.
>
> I am working with a relatively new API written in a programming language
> with a small user base (newlisp). The newlisp API imports a number of C
> API functions from the system My
I have MySQL version 5.0.84 on linux slackware 13.0 32-bit.
I am working with a relatively new API written in a programming
language with a small user base (newlisp). The newlisp API imports a
number of C API functions from the system MySQL shared object.
If I were to issue a count(*) query fr
Hi Kris, all,
Kris wrote:
> Joerg, thanks again for the help.
>
> I disagree with you.
that's perfectly fine - combining our two different viewpoints, we will
be able to show more of the issue at hand than from one point alone.
>
>>> I doubt many more users try to create a clean test installa
>Do not install software in /tmp in Linux.
>/tmp is not guaranteed to survive a reboot.
Thank you for the heads up. Well... there is *another* bug
where if one specifies in their my.cnf filepaths that are over 100 characters,
the filenames are truncated at 100, hence making it impossible to really
Joerg, thanks again for the help.
I disagree with you.
> > I doubt many more users try to create a clean test installation of
> > MySQL, in a specific directory, on a machine that already has MySQL
> > installed.
>
> Correct - but if really the occurrence in "mysql_install_db" were the
> issue,
I have faced the same issue in past. *
key name must be a unique*.
On Fri, May 14, 2010 at 11:33 PM, wrote:
> Nope, that wasn't the problem. I wasn't aware that the foreign key name
> must be unique. So, if you have a foreign key named "fk_lesson", that same
> name cannot exist already, even if
Nope, that wasn't the problem. I wasn't aware that the foreign key name
must be unique. So, if you have a foreign key named "fk_lesson", that same
name cannot exist already, even if on a different table. I named the
foreign key something completely different and that solved the problem.
Jesse
-
Interesting. Thanks for that tip on showing the INNODB STATUS. It turned up
the error:
A foreign key constraint of name `cc/fk_lessons` already exists.
...which tells me that a foreign key name cannot already be in use even if
on a different table (at least that's what it appears to be saying).
Haven't done this in a while, but I'm guessing that you can't create
both a constraint and an index with the same name?
Type mismatch will in my experience most often generate an errno 150.
/ Carsten
j...@msdlg.com skrev:
I'm trying to create a foreign key by executing the following statement
Perror 121 says:
OS error code 121: Remote I/O error
Which I'm not too sure why an ALTER to add an constraint would give that error.
Normally though, foreign key errors are shown in the SHOW ENGINE INNODB STATUS
\G output, look for more details there.
Regards,
Gavin Towey
-Original Messag
I'm trying to create a foreign key by executing the following statement:
ALTER TABLE `cc`.`takenlessons`
ADD CONSTRAINT `fk_lessons`
FOREIGN KEY (`LessonID` )
REFERENCES `cc`.`lessons` (`id` )
ON DELETE CASCADE
ON UPDATE NO ACTION
, ADD INDEX `fk_lessons` (`LessonID` ASC) ;
I'
Kris, all,
Kris wrote:
> On Fri, 2010-05-14 at 10:28 +0200, Joerg Bruehe wrote:
>>> The following error just won't go away:
>>>
>>> 100513 21:53:35 [ERROR] /tmp/msource/libexec/mysqld: unknown option
>>> '--skip-bdb'
>>>
>>> ... even after I manually search for the location where this flag is
>>>
James W. McKelvey wrote:
According to the 5.1 docs, I can have multiple key caches for MYISAM on
a 32-bit host, each with up to 4G.
But that means that each cache can take the entire address space of a
process. How does the MySQL server get around the limitation?
If the OS fails to allow t
Kris wrote:
Hello,
I am trying to produce an automated, reliable, and repeatable way of
testing mysql releases, and I am finding an error that makes this
impossible to accomplish.
I am trying to compile mysql and install it in a non-standard directory.
I do notwant mysql installed in /usr or /u
According to the 5.1 docs, I can have multiple key caches for MYISAM on
a 32-bit host, each with up to 4G.
But that means that each cache can take the entire address space of a
process. How does the MySQL server get around the limitation?
--
MySQL General Mailing List
For list archives: http:
On Fri, 2010-05-14 at 10:28 +0200, Joerg Bruehe wrote:
> > The following error just won't go away:
> >
> > 100513 21:53:35 [ERROR] /tmp/msource/libexec/mysqld: unknown option
> > '--skip-bdb'
> >
> > ... even after I manually search for the location where this flag is
> > passed, and manually edi
Hi,Nitin
Below information for your reference.
for my.cnf
[mysqld5129]
port=5506
socket=/tmp/mysql5129.sock
basedir=/opt/MySQL5129
datadir=/opt/MySQL5129/var
user=mysql
log-error=/var/log/mysqld5129.log
pid-file=/tmp/mysqld5129.pid
#log
Hi Samrat, all!
Samrat Kar wrote:
> Hello,
>
>
>
> How to store multiple values in a single field? Is there any array data type
> concept in mysql?
"Multiple values in a single field" would be an explicit violation of
the relational model (on which the SQL language is based) and cause all
ki
There are SETs and ENUMs, but I've always found that dealing with them is
annoying.
YMMV
/ Carsten
On Fri, 14 May 2010 13:54:29 +0530, "Samrat Kar"
wrote:
> Hello,
>
>
>
> How to store multiple values in a single field? Is there any array data
> type
> concept in mysql?
>
Hi Kris, all,
what you describe here seems to be related to MySQL bug# 50336
http://bugs.mysql.com/bug.php?id=50336 :
Kris wrote:
> [[...]]
>
> I am trying to compile mysql and install it in a non-standard directory.
> I do notwant mysql installed in /usr or /usr/local. For example, I am
> tryi
Hello,
How to store multiple values in a single field? Is there any array data type
concept in mysql?
Regards,
Samrat Kar
FRD, BARC
Tel: 022-25597295
Alternate Email: esam...@yahoo.com
Hi!
Peng Yu wrote:
> I seems that mysql and may SQL has only two levels databases->tables.
> Where there many tables, it become hard to properly name the tables
> and databases. I'm wondering if there is any variant of SQL or some
> other database that support arbitrary levels of complexity.
Whe
Hello,
I am trying to produce an automated, reliable, and repeatable way of
testing mysql releases, and I am finding an error that makes this
impossible to accomplish.
I am trying to compile mysql and install it in a non-standard directory.
I do notwant mysql installed in /usr or /usr/local. For
23 matches
Mail list logo