On Sat, Jul 13, 2002 at 11:12:11PM -0300, Alexander Burbello wrote:
> Hi,
>
> I need to make a presentation about MySQL (structure,
> etc.)
>
> Anybody can help me. If anybody have a presentation
> (powerpoint, etc) would you be so kind to send me by
> e-mail, please.
Can you be a little more s
Hi. I have this error message in MySQL using Create Index
create index indice on products(productid(7))
Error on rename of '.\video\products.MYI' to '.\video\#sql2-fffa66cd-11.MYI'
(Errcode: 13)
The ProductID fields is text type
Carlos
>From: David Kramer <[EMAIL PROTECTED]>
>To: 'Carlos R
Hello,
This is similar to my post earlier...(I'm really racking my brains over this).
I'm going to try and rephrase (shorten) my question:
I've created a database that multiple users can search from. The results that USER1
returns must be unique even if USER2 uses the exact same lookup. So, I'
you need to start the service.
service mysqld start
JM
On Sat, Jul 13, 2002 at 08:16:30PM -0700, Haany Boyke wrote:
> Hi,
> i am just installing the new mysql 3.23.51 for my
> linux 7.3.
> The problem is after unzipping the tar.gz file and
> running the mysql_install_db (which runs perfect
three BUGS are reported here that have cropped up in mysql-4.0.2-alpha
current system has a SUCCESSFUL install of:
>Server: /usr/local/mysql/bin/mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for
apple-darwin5.4 on powerpc
the 3 bugs:
(1) poll.h not present in BSD variants; HAVE_POLL set to #define
Hi,
Maybe I'm missing something but I tried solution someone posted for
someone else's problem concerning finding out # of days between 2 dates.
I have 2 sets of dates I'm working with in my sample DB.
order_date completion_date
2002-07-03 2002-07-09
and
2002-06-27 2002-07-08
Now the query
though not for your OS, I'd look for clues here:
http://www.entropy.ch/software/macosx/
Ll
on 7/13/02 11:16 PM, Haany Boyke, typed:
> Hi,
> i am just installing the new mysql 3.23.51 for my
> linux 7.3.
> The problem is after unzipping the tar.gz file and
> running the mysql_install_db (which r
hi all,
three BUGS are reported here that have cropped up in mysql-4.0.2-alpha on
OSX 10.1.4 Server
current system has a SUCCESSFUL install of:
>Server: /usr/local/mysql/bin/mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for
apple-darwin5.4 on powerpc
the 3 bugs:
(1) poll.h not present in BSD vari
Hi,
i am just installing the new mysql 3.23.51 for my
linux 7.3.
The problem is after unzipping the tar.gz file and
running the mysql_install_db (which runs perfectly),
when i tried to run the safe_mysql &, the mysqld is
ended immediately.
[1] 3207
# Starting mysqld daemon with database from
Hello,
I need help. I am trying to insert into TABLEA records from TABLEB where the records
do not exist in TABLEA (the primary key in TABLEA works fine). I am trying to limit
the result set each time (as an example to 10 records from TABLEB).
The first time I perform the query, I get the numb
Hi people,
I'm new to the list.
I'm writing because I've been having trouble with table corruption. I'm
using isam tables and i've been using myisamchk under linux to check them.
alot of the time it just reports that some of the tables were'nt closed
properly so i repair them but after doing that
Hi,
I need to make a presentation about MySQL (structure,
etc.)
Anybody can help me. If anybody have a presentation
(powerpoint, etc) would you be so kind to send me by
e-mail, please.
Regards
Alexander
sql, query
___
Michael,
thank you for noticing this. I tested the mysqld binary which is in the
4.0.2 rpm distribution, and it did not recognize InnoDB startup options.
Obviously the MySQL AB build master has made an error in the building of the
4.0.2 rpm distribution.
heikki@hundin:~/usr/sbin> ls -l
Hello all,
I have a question about threading with MySQL I hope you can help me with.
Here's the situation:
I am developing a driver to allow MySQL to be used as a database for a
server. The server operates on Windows and many *nix variants. The server
CAN run in single and multi-threaded mode
Hello,
My MySQL slave (3.23.51) stopped with the error:
Last_errno: 1146
Last_error: error 'Table 'bts.tmp_na' doesn't exist' on query 'insert into
name_address select * from tmp_na '
It is possible that this occured because of inopportune timing in stopping
and restarting of the slave. Bu
Hello All,
I have a varchar column containing number and words (not in any specific
format) that needs to be separated into two columns. Is there a way to
select only the numeric characters from a varchar column in MySQL?
Thanks,
Daniel Lamb
---
Hi-
Please forgive cross-post.
I have been using PHPTriad-installed Apache, PHP, and MySQL with no problems
on Win98 machine.
I want to upgrade MySQL from 3.23.something to 4.0.2 to use boolean fulltext
search capabilities.
I created a backup of my database and put it outside the C:\apache\mysql
Heikki,
I actually upgraded from Max-3.23.51 to the 4.0.2
server. The only way I could get it to start was to
comment out all of the innodb variables in the my.cnf
file. After it started I noticed that InnoDB was
disabled when I typed:
show variables like "have_%".
The contents of the my.cnf f
You shouldn't have a problem if you list each foreign
key separately, as follows:
foreign key (MenuName) references MenuDetails
(MenuName)on update restrict on delete restrict,
foreign key (MenuParentName) references MenuDetails
(MenuParentName)on update restrict on delete restrict,
That's how
Thank you, I hope this is the right place to be asking these questions. If
there is a more "newbie" place please let me know. Here's more output I
need help with, I think it's self-explanatory except that I don't how to
rectify it. The following is a continuation my original message and a
reply
Hmm, this all sounds indeed like a terrific feature .. if it would work !
So, I decided to try it and just see what'll happen. I did the following
things:
* first I created a table:
mysql> create table autoIncrement (
-> id int(11) NOT NULL AUTO_INCREMENT,
-> thingie varchar(20) NOT NU
At 6:28 -0400 7/13/02, <[EMAIL PROTECTED]> wrote:
>Can anyone translate this for me, please? TIA
This will happen if yu try starting the server from an unprivileged
account that is not the owner of the MySQL data directory. Try starting
the server from that account.
>Welcome to Darwin!
>[zbase:
>I Have a question relating to setting up users for our customers on a shared
>server environment. I can not find this answer in the documentation so I am
>trying here.
>
>Is it standard practice to give the user of the database (site owner) one
>set of permissions which I figure should be:
>
>se
Hiya,
Why would you want to? Any time you need days elapsed, just compute it.
Never store summary data without a good reason. (making things go faster is
a good reason) :)
select (orderdate-shipdate) as dayselapsed from ...
should work.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calev
At 05:25 AM 7/13/2002 +, toby - wrote:
>1.
>i ve a page that picks up random records from mysql database and displays them
>now i want to limit the display to 5 or 6 records per page
>that is if it could pickup ALL the records in the db and disolay only 5 or
>6 on each page
select blah from
At 03:53 13/7/2002 -0500, MonoTeK wrote:
Hi,
>I recently made a script that uses raw TCP sockets to connect to a mysql
>server and communicate directly (bypassing any ODBC or DLLs). I had
>success at first with both linux and win32 based servers, but recently I
>am being unable to connect due to
I need help, I am new to mysql and am trying to work with a table. I
already have some fields called order number, orderdate, and shipdate. I am
trying to create a new field called dayselapsed and have it subtract the
order date from the ship date. It would need to look like this:
Ordernumber
3.23.51-max if you are using Windows.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Ki Mien [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 13, 2002 10:17 AM
To: [EMAIL PROTECTED]; Heikki Tuuri
Subject: Innodb
Hi all,
Can anyone out there
Hi all,
Can anyone out there tell me which version of mysql is more stable or preffered for
using Innodb. I am currently using mysql version 3.23.49-max-nt-log.
cheers,
Ki Mien
Take part in the Penning on Squares Chinese
Can anyone translate this for me, please? TIA
Welcome to Darwin!
[zbase:~] lloyd% /usr/share/mysql/mysql.server start
[zbase:~] lloyd% touch: /Users/mysql/Documents/dbs/zbase.err: Permission
denied
chown: /Users/mysql/Documents/dbs/mbase.err: Permission denied
Starting mysqld daemon with database
Jeremy Zawodny wrote:
>On Sat, Jul 13, 2002 at 09:25:32AM +0100, Richard Clarke wrote:
>
>>Heikki & Others,
>>
>> I read through the 4.0.2 Changelog but I couldn't find indication of
>>the following bug fixes.
>>
>>1. Was the bug with drop/create tables causing assertaion errors fixed.
>>I th
If you are on the same OS and rsync happens fine, then you should not loose
any data. A more graceful way might be too look into setting up a slave
server which will be in sync with the master.
Regards,
Bhavin.
- Original Message -
From: "Charitha" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTE
I recently made a script that uses raw TCP sockets to connect to a mysql
server and communicate directly (bypassing any ODBC or DLLs). I had
success at first with both linux and win32 based servers, but recently I
am being unable to connect due to an incorrect password being sent from
my scri
B.K.R.,
Saturday, July 13, 2002, 7:08:54 AM, you wrote:
BKRS> The below mentioned sql makes an error when created
BKRS> with two foreign key constraints under MySQL/Innodb
BKRS> table type. Any help to solve this problem?
BKRS> create table UserMenuRestrictions
BKRS> (
BKRS> CompanyCode
hollen,
Saturday, July 13, 2002, 7:07:30 AM, you wrote:
h> In using MySQLGui v 1.75, I get the following message when I try to
h> connect to the database:
h> Can't connect to local MySQL server through socket "(111)
h> What can I do in addition to following the configuration for .my.sql
h>
On Sat, Jul 13, 2002 at 09:25:32AM +0100, Richard Clarke wrote:
> Heikki & Others,
>
>I read through the 4.0.2 Changelog but I couldn't find indication of
> the following bug fixes.
>
> 1. Was the bug with drop/create tables causing assertaion errors fixed.
> I think that the latest 3.x re
Heikki & Others,
I read through the 4.0.2 Changelog but I couldn't find indication of
the following bug fixes.
1. Was the bug with drop/create tables causing assertaion errors fixed.
I think that the latest 3.x release has this bug fixed but I know
4.0.1 certainly doesn't.
2. Do Unions
Hi Craig,
you wrote---
> select B.name,C.name
> from lookuptable A, user B, cat C
> where A.user = B.id
> and A.category = C.id
> and A.category in (3,5);
>
> The problem I see is that records come back where a user is in category
> 3 or
> category 5. How do I limit
BKR,
you can have any number of foreign keys in a single table.
But you have not created the necessary indexes on foreign keys:
...
Both tables have to be InnoDB type and there must be an index where the
foreign key and the referenced key are listed as the first columns. InnoDB
does not auto-cr
James,
- Original Message -
From: ""James Kelty"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Saturday, July 13, 2002 12:43 AM
Subject: Error 150 on 3.23.51
> Hello,
>
> We have compiled in InnoDB support for MySQL 3.23.51. We would LOVE to
take
> advantage of the trans
Hello all,
Can i do rsync with the mysql db as a whole from one machine to other.
If i can do then will there be any loss of data while doing rsync.
Thanks in advance.
--
Regards,
Charitha
-
Before posting, please check:
Michael,
what is your my.cnf like? Which my.cnf options did not work in the plain
4.0.2 rpm?
The difference between 4.0 and Max-4.0 is that Max supports also BDB tables.
Regards,
Heikki
- Original Message -
From: "Michael Ivanyo" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
42 matches
Mail list logo