No big deal. You can install MySQL in any directory or drive.
(B
(BYou just have to set path of your installation in the mySQL conf file.
(B
(BUnder MySQL Server Section -- Location, you point the directory to where the
(BDb is installed.
(B
(Be.g.
(B# location
(Bbasedir =
From: jim
To: [EMAIL PROTECTED]
Subject: mysqladmin generates a segmentation error
Description:
getting segmentation error during execution of mysqladmin
have recompiled using gcc3 with all the flags suggested
in detail:
tried to initialize with
safe_mysql
mysqladmin -u root -h Jungles.au
ok i found the troubled table
DROP TABLE IF EXISTS `activity`;
CREATE TABLE `activity` (
`int_activity_id` int(11) NOT NULL auto_increment,
`vch_uniqid` varchar(50) NOT NULL default '',
`int_user_id` int(11) NOT NULL default '0',
`ts_time` int(50) NOT NULL default '0',
`vch_page_viewed`
Hi,
I didn't get your code but I haven't read all mails received through the night...
But I these days don't find the time to analyze it.
I've only once experimented with libmysqld so far and didn't enjoy it very much since
the INNO-tables storing the table-linking-information, the transactions
Hi,
I am having a problem with Mysql 3.23.39 for solaris 2.6. I can do
anything from the console command line but any connections from any
other hosts causes a host xxx.xxx.xxx.xxx not allowed to connect to
this mysql server. I have updated the host table to include a % for all
hosts.
Any
Hello listers
My reason for emailing is this - I want
to know how to
upload a csv file via php to a mysql
database. I have
found a few examples but they are all
much to advanced for
my needs. I just want the bear basics
so I can understand
it.
I can see that phpMyAdmin does this,
Hi,
I am running MySQL 3.23.41 on a FreeBSD 4.4, and I experience very high
loads of the machine, without any apparent reason. We have a new project
using this MySQL engine, with lots of inserts/deletes. But it happens that
in the mornings, when nobody makes any kind of access to the
See links form mail list.
http://jeremy.zawodny.com/blog/archives/000203.html#000203
http://jeremy.zawodny.com/blog/archives/000264.html#000264
Simon
-Original Message-
From: Bogdan TARU [mailto:bgd;icomag.de]
Sent: 07 November 2002 10:35
To: [EMAIL PROTECTED]
Subject: MySQL CPU
Hi - I have read extensively the MySQL database security chapter in SAMS TY
MySQL - and I must be missing something.
I have allowed myself to connect from any host by adding a % kev record to
my users file and a 10.0.0.142 % record to my hosts file and a % % kev
to my db file - when I try and
CoastResearch,
Thursday, November 07, 2002, 3:26:59 AM, you wrote:
Caadc Description:
Caadc If I launch MySQL 3.23.38, everything is fine. If I open tables,
Caadc creat db,
Caadc add records whatever, no problem. When I close MySQL my hard
Caadc drive is ? alot and I can do nothing
Oluwagbamila,
Thursday, November 07, 2002, 10:04:10 AM, you wrote:
OO No big deal. You can install MySQL in any directory or drive.
OO You just have to set path of your installation in the mySQL conf file.
OO Under MySQL Server Section -- Location, you point the directory to where the
OO Db is
Dan,
Thursday, November 07, 2002, 9:11:10 AM, you wrote:
DR mysqldump: Got error: 1030: Got error 127 from table handler when retrieving
DR data
DR from server
DR for some reason i get this when i dump all databases
DR using mysqldump -p --all-databases --add-drop-table --quote-names
DR
Timothy,
Thursday, November 07, 2002, 11:42:13 AM, you wrote:
TV I am having a problem with Mysql 3.23.39 for solaris 2.6. I can do
TV anything from the console command line but any connections from any
TV other hosts causes a host xxx.xxx.xxx.xxx not allowed to connect to
TV this mysql server. I
Sage,
Wednesday, November 06, 2002, 3:31:21 PM, you wrote:
S I'm running MySQL 3.23.49 on Red Hat 7.3, with the latest kernel
S (2.4.18-17.7.x) installed. It is running in smp mode on a dual P3 1.0
S gHz.
S MySQL works perfectly fine when connecting from the localhost. However,
S I have another
Hello Tim,
Are you getting this regardless of what you put in user,host and db tables.
If you are I am getting the same thing. Any access to my database is denied
except from the console.
How did you install - from the rpm's ??
I will watch this thread as I am at a complete standstill with
Hi all,
It now works
I did the following
Under the command line I did insert into user (Host) values
('192.168.8.19') and restarted mysql. I can now connect.
Thanks for the help.
Tim
-
Before posting, please check:
What I want to do is display to the user a list of files that
require a
security level that is less than or equal to the user's
security level, with
formatted last name and first name and date if the file is
checked out.
Checked out by is a foreign key refering to username in the
systems
sys_nameID
Abrams 202
Patriot 544
Stinger 229
... and ...
new_req
proj_name ID
Test Bed Alpha 344
Tracked
Unidux (S) - Han Lin wrote:
I wanna know what the steps MySQL perform when we do INSERT in Database?
Anyone can explain? Or anyone here have some reference about how MySQL
works?
The source code is freely available from the website; download it and
take a read -- if you don't read C code,
Ok, we know that FreeBSD has problems with its thread implementation;
however, I'd like to know if the MySql guys know exactly what causes the
problems to which Mr Zawodny refers.
I'm running FreeBSD 4.6.2, and have seen the 'rogue thread' problem before
which leads me to believe that either
Brad wrote:
A programming environment;
Python comes to mind immediately; very easy to learn, especially
compared to VB, and its even Windows compatible (MFC even).
A database maintenance utility;
To what end?
A database query tool;
Visual query tools exist for MySQL already; someone
Hi Michael,
Thanks for your suggestion, but I didn't read C code, and I don't think so
someone in this list will:) Maybe short explanation from you also can:)
Regards,
Han Lin
- Original Message -
From: Michael T. Babcock [EMAIL PROTECTED]
To: Unidux (S) - Han Lin [EMAIL PROTECTED]
Cc:
If the data contains \, then database will automatically takes \
away and shift 1 byte left.
My data will mass up. That is why I still need \
Does your data actually include backslash characters? If you want to import them as
they are, you definitely don't want to ESCAPE BY them.
Escaping is
Michelle,
Wednesday, November 06, 2002, 4:25:32 PM, you wrote:
MdB If I want to create a database with an arabic
MdB character-set, will only the data-cells be affected by
MdB this or will the table names, column names etc also be
MdB in arabic?
You can use characters from current character set
Andrew,
Wednesday, November 06, 2002, 7:39:16 PM, you wrote:
AS SELECT ... FROM table o WHERE o.date = 2002090100 AND o.date=2002110624
AS MySQL 3.23.xx - work (returns 0 rows)
AS MySQL 4.0.4 - not work (returns 0 rows)
AS P.S. also in 4.0.4 not work BETWEEN in this case (but as i can
Heikki Tuuri wrote:
if you have on tape old images of ibdata files and ib_logfile's, you can try
crash recovery from them, possibly using innodb_force_recovery=6.
Unfortunately, as mentionned, I only have the data files on tape, no log
files.
Are the data files 'dumpable' ??
SQL
--
I've done a specialized, high-volume FIFO queue implementation using MySql that
performs extremely well - if your concern is speed I think you'll likely do fine. Of
course, speed is relative to each solution - what kind of response time for
enqueue/deque operations do you require? In my
-Original Message-
From: Fernando Grijalba [mailto:fernando;ggtours.on.ca]
Sent: Wednesday, November 06, 2002 11:41 AM
To: MySQL Help
Subject: InnoDB row level locking?
In the documentation it says that InnoDB supports row level
locking. How
can I ensure that rows are locked using ADO
Yes, that is what I meant. Thank you for the clarification and response.
Any ideas on maximizing *server* performance besides the usual db-specific
optimizations like indexing? If not too much trouble, could you give me a
brief explanation why I would not see a performance boost if running
On Wed, 2002-11-06 at 23:25, Richard Forgo wrote:
Sorry for being vague. I think the closest thing I can find to it is,
possibly, a three-way join. I'm trying to figure out how to write the
query.
I've got the following tables:
systems
sys_nameID
Michael,
- Original Message -
From: Michael T. Babcock [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, November 07, 2002 4:36 PM
Subject: Re: InnoDB recovery
Heikki Tuuri wrote:
if you have on tape old images of ibdata files and
Has anyone else using Snort with CERT's ACID (Analysis Console for
Intrusion Databases) reporting software (PHP) done work on optimizing
their tables? I've found a few instances where TEXT was used instead of
VARCHAR unnecessarily and prevented indexes from being created, etc.
Any other tips?
Heikki Tuuri wrote:
log files are as important a part of a database as ibdata files.
Trust me, I know; they didn't get backed up I've realized too late
though ...
You can try using some dummy log files from another installation and set
force recovery to 6 to skip the log scan.
... what's
Hi,
if you dont understand the language mysql is written in you
are probably not interested in how it works, technically. this
perspective can only be explained by using terms from the
programming language. i guess you are interested in learning
more about the user-level, like how to set it up
aha! sure. you weren't being vague. you just
needed to educate me.
some of us have used intersecting entities
through the years, but didn't know that there was
a fancy name for what we were doing. if my
memory weren't so bad, i'd use it to impress
people in the next interview.
in this
Hi,
I have configured a master slave ring architecture. Can anyone suggest
me how to load test this architecture ?
I am using three MySQL servers in the following fashion :
A -- B -- C -- A
where A is the Master to B, B is the Master to C and C is the Master to A.
My aim is
i've been hesitant to respond because i'm not
sure that this is a head on solution for you, but
take a look at http://corereader.com
it's certainly easier to use than access queries.
simple point and click to build complex output.
however, it's not designed for the fancy
formatted output
That looks like a windows-only solution
John Ragan ([EMAIL PROTECTED]) wrote*:
i've been hesitant to respond because i'm not
sure that this is a head on solution for you, but
take a look at http://corereader.com
it's certainly easier to use than access queries.
simple point and click to
i want to add a user to my system that has permissions to backup all the
databases using mysqlhotcopy. i don't want to use the root user. so what
permissions (minium set) should i give the user in order to accomplish this.
thanks in advance,
shon
John,
You're making sense.
If you wanted to find all the systems used on project Test Bed Alpa, you'd
do something like this:
Select sys_name, s.id, project_name
FROM systems s, new_req n,ie_sys_req i
WHERE s.id = i.sys_id
AND n.id = i.proj_name_id
AND n.id = 344;
Hope this helps,
Andy
mysql
Brad.
Not sure if you got my last mail but did you try Omnis Studio from
www.omnis.net (trial download available).
It is available for MacOS Classic, OSX, Windows, Solaris and Linux. Never
used the Solaris/Linux versions but I do use the Mac and Windows versions
every day.
HTH
Kev.
--
Ok, here we are, in much detail. There is a table called translations
and another one called poems. Their structure is given in the end. The
query (given by a php script by the way) is:
select poems.poem_id, language, translation_title,made_by_id from
poems,translations where
Description:
checking size of char...
configure: error: No size for char type.
A likely cause for this could be that there isn't any
static libraries installed. You can verify this by
checking if you have libm.a
in /lib, /usr/lib or some other standard place. If
this is the problem,
install
My last post wasn't titled accurately. Sorry for the repost.
I have 3 tables. Ticket Pipeline_Dept, and Ticket_Matrix. Ticket_Matrix
matches tickets to pipeline depts. A ticket can be posted to multiple pipeline
depts. I want to select all tickets and the pipeline departments they are
posted
Nikolas Galanis wrote:
and with this I intend to retrieve the 10 latest additions of
translations. However, when running the script, I noticed that always,
on the top of the results was the translation link I had clicked last.
And this happens all the time. Now that I think of it again, the
[EMAIL PROTECTED] wrote:
This is what I want:
+--+--+
| ticketID | pipelineName |
+--+--+
| 163 | IT, Adv.Tech, RD|
| 164 | IT, RD |
| 165 | Video, Multimedia|
| ...
Philipp Steinkrueger wrote:
if you dont understand the language mysql is written in you
are probably not interested in how it works, technically. this
I've actually had any number of people ask me how to do things that they
think they can understand without knowing anything about
At 11:41 + 11/7/02, Nikolas Galanis wrote:
Ok, here we are, in much detail. There is a table called
translations and another one called poems. Their structure is given
in the end. The query (given by a php script by the way) is:
select poems.poem_id, language, translation_title,made_by_id
John Coder wrote:
right, let me know so I can breath a sigh of relief. And if the
structure is right, could someone offer some guidance on how a query
that allows me to query new_req using the intersecting entity (or
three-way join, whatever it's called) would be written.
That looks right
Make sure /etc/hosts has this line
127.0.0.1 localhost
~Kelly W. Black
-Original Message-
From: Kevin Passey [mailto:kpassey;kdpsoftware.co.uk]
Sent: Thursday, November 07, 2002 4:38 AM
To: 'Timothy Venn'; Mysql (E-mail)
Subject: RE: Host not allowed to connect problem
Hello Tim,
Are
I've got a query that selects the count of distinct rows in a table; the
table has 453632 rows and 24 distinct class_id's.
mysql SELECT count(DISTINCT(sig_class_id)) FROM acid_event;
+---+
| count(DISTINCT(sig_class_id)) |
+---+
|
Thank you, Egor! It looks like Red Hat released an update to its glibc
libraries yesterday which fix this, so if anybody else is having
problems, they should be able to fix it by updating. :)
Sage
On Thu, 2002-11-07 at 17:46, Egor Egorov wrote:
Sage,
Wednesday, November 06, 2002, 3:31:21 PM,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 07 November 2002 17:46, ktran wrote:
Configure command: ./configure
--with-unix-socket-path=/var/tmp/mysql.sock
--with-low-memory --with-mit-threads=yes
--without-perl
--enable-thread-safe-client --with-berkeley-db
Either you are not referencing the correct library for the database access
or you cannot doit from the Learning Edition.
HTH
JFernando
** sql ***
-Original Message-
From: Oliver Gottwald [mailto:goto1;enteract.com]
Sent: November 6, 2002 22:26
To: [EMAIL PROTECTED]
Subject: ActiveX
Hi!
MySQL AB is pleased to announce that it has settled its lawsuit with
Progress Software Corporation and NuSphere Corporation. For more
information, see the joint press release at
http://www.mysql.com/press/release_2002_14.html
Regards,
Monty
--
__ ___ ___ __
/ |/ /_
Hello all, I'm a newbie to Mysql. I just installed mysql 3.23.53 on
Solaris 7. I am running Apache 2.0.42 and PHP 4.2.3.
I am trying to connect to my Mysql DB via Apache and PHP, but I get the
following error: Warning: Unknown MySQL Server Host '' (1) in
helloSql.php on line 3 Warning: MySQL
On Thu, 7 Nov 2002, Michael Widenius wrote:
MySQL AB is pleased to announce that it has settled its lawsuit with
Progress Software Corporation and NuSphere Corporation. For more
information, see the joint press release at
http://www.mysql.com/press/release_2002_14.html
The press release
Hi.
I have some problems to retrieve the doubles I write in my tables.
I use MySQL server 4.0.3-beta-max.
I have not found the solution of my problem on the mailing-lis archive.
Following is the problem:
mysql create table double_test (d double);
mysql insert into double_test
Can someone post the piece of News, for the folks that cant get into the
page (I dont have access to web from where I am now...) Thanks, Leo.
- Original Message -
From: Christopher Hicks [EMAIL PROTECTED]
To: Michael Widenius [EMAIL PROTECTED]
Cc: Mysql List [EMAIL PROTECTED]
Sent:
MySQL AB and Nusphere Corporation Announce Settlement07 Nov 2002
UPPSALA, Sweden and BEDFORD, Massachusetts, (November 7, 2002) - MySQL AB, developer
of the world's most popular open source database, and NuSphere Corporation, an
independent operating company of Progress Software Corporation,
On that page, it says:
You can't connect to the embedded server from an
outside process with sockets or TCP/IP.
... not the other way around, which is what I'm trying
to do. I'm trying to connect to another (remote)
server from the same app as is using an embedded
server. It doesn't say
I would like to know if the MySQL has any command where I get the queries
requested by the application.
SQL Server has Profiler.
Oracle has any command that I don´t know
With Delphi I run SQLMonitor.
Regards
Alexander
sql,query
Using 4.0.2 for both server and client, replicating the following query
seems to have caused a crash on the client:
CREATE TEMPORARY TABLE tmp1 (
day DATE NOT NULL,
campaign_id INT NOT NULL,
clicks INT,
clicked FLOAT,
approved FLOAT,
users_raw INT,
users_coreg INT,
Hi Alexander.
If you specify option log in section mysqld of my.cnf configuration file you
get a log file of all queries
and sql operations (inserts, updates, deletes) executed in the MySQL server.
This log file is created by default at $DATADIR/$HOSTNAME.log.
Iago.
-Mensaje original-
In the last episode (Nov 07), Michael T. Babcock said:
I've got a query that selects the count of distinct rows in a table;
the table has 453632 rows and 24 distinct class_id's.
mysql SELECT count(DISTINCT(sig_class_id)) FROM acid_event;
| count(DISTINCT(sig_class_id)) |24 |
1 row in
sql,query
How do I do that? The contaxt is that I want to get somebody's age based
upon the current date.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
At 11:14 -0800 11/7/02, Steven Webb wrote:
On that page, it says:
You can't connect to the embedded server from an
outside process with sockets or TCP/IP.
... not the other way around, which is what I'm trying
to do. I'm trying to connect to another (remote)
server from the same app as is
I am a new customer and have a question about mysqldump recovery, but cannot
seem to be able to logon. My user name is probusine8359 and my support
contract is 2002-1428. Would you please correct this anomaly? I need to get
my questions answered. My phone number is 925.737.3458.
Thanks.
Ian
John Meyer wrote:
sql,query
How do I do that? The contaxt is that I want to get somebody's age based
upon the current date.
There are several examples in the mailing list archives; but try
subtracting the UNIX_TIMESTAMP of each date (which is the time in
seconds) and then divide by the
Dan Nelson wrote:
Yes, with only 24 values, MySQL will probably never use that index for
paring down records in a regular SELECT. But for your count() case it
should.
According to the EXPLAIN output, it does; but its still horrifically slow.
mysql explain SELECT
Hi everyone,
How do I select a group of records in a table and automatically duplicate
them into the same table while modifying 1 or 2 columns without having to
re-insert each record individually?
Thanks,
Doug
MySQL
-
Hi,
I have the following SQL query, that returns the correct records on Access,
but when I use it with MySQL, it returns duplicate records, and it skips the
required records.
SearchSQL=select
MarketData.CustID,Contacts.ContactID,Contacts.CustID,MarketData.Nickname,Marke
Actually figured out one of my own:
FLOOR(PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM NOW()),EXTRACT(YEAR_MONTH FROM
UserDOB))/ 12) as Age
It's amazing what you can think of as soon as you ask the question.
-Original Message-
From: Michael T. Babcock [mailto:mbabcock;fibrespeed.net]
Sent:
I sent this sometime ago and never got a response, so I will send it
again
I want to change my option to subscribe to this list as a digest, is the
following command below correct, or is this
list not setup has a digest?
subscribe mysql-digest EMAILADDRESS
END
--
Kory Wheatley
Academic
On Thu, Nov 07, 2002 at 08:48:15AM -0500, Grigor, Peter wrote:
Ok, we know that FreeBSD has problems with its thread implementation;
however, I'd like to know if the MySql guys know exactly what causes the
problems to which Mr Zawodny refers.
The problem is the MySQL (by default) uses name
On Thu, Nov 07, 2002 at 12:32:58PM -0500, Michael T. Babcock wrote:
I've got a query that selects the count of distinct rows in a table; the
table has 453632 rows and 24 distinct class_id's.
mysql SELECT count(DISTINCT(sig_class_id)) FROM acid_event;
+---+
|
there is a Profiler similar to SQL server Profiler ,only for windows
i wrote it myself , availiable at http://amr.activechannel.net/myprofiler.htm
so sorry its not free :(
Amr Salah
--- Iago Sineiro [EMAIL PROTECTED] wrote:
Hi Alexander.
If you specify option log in section mysqld of my.cnf
Is this line correct?
MarketData INNER JOIN Contacts on MarketData.CustID=Contacts.ContactID WHERE
Or should it be:
MarketData INNER JOIN Contacts on MarketData.CustID=Contacts.CustID WHERE
JFernando
** sql **
-Original Message-
From: [EMAIL PROTECTED] [mailto:Sam4Software;aol.com]
I've got a query that selects the count of distinct rows in a table; the
table has 453632 rows and 24 distinct class_id's.
mysql SELECT count(DISTINCT(sig_class_id)) FROM acid_event;
+---+
| count(DISTINCT(sig_class_id)) |
+---+
|
I just installed onto a solaris 8 machine.
I've run mysql_install_db
The script says to change the root password by doing this:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h myhost password 'new-password'
When I do that I get ./bin/mysqladmin: No match.
Is
Grigor, Peter wrote:
If you are using a version of MySql that has the query cache you can turn it
on and those queries will run very fast after the initial query. The query
cache is cleared whenever the underlying table(s) are modified so you'll get
the initial time hit again after
John, Michael, Andy and James,
Thanks for the informative responses. I was hoping I was on the right
track. Thanks for the query help, too. It looks like this is going to
work just fine.
Cheers,
Rik Forgo
JIST3
Army Test, Training and Technology Integration Office (T3I)
Diverse Technologies
On Thu, 2002-11-07 at 16:17, [EMAIL PROTECTED] wrote:
Hi,
I have the following SQL query, that returns the correct records on Access,
but when I use it with MySQL, it returns duplicate records, and it skips the
required records.
SearchSQL=select
how is there a way to retain the user privileges in the mysql table when
dumping from mysql 3.23 to 4.0 ? i dont want to have to reset these
individually , let me know thanks
-
Before posting, please check:
Well, actually I always use the Unix date format because is easier to
use with PHP... and makes easier to do this kind of calculations... ;)
-Mensaje original-
De: John Meyer [mailto:johnmeyer_1978;yahoo.com]
Enviado el: jueves, 07 de noviembre de 2002 15:20
Para: Michael T. Babcock
CC:
Hi all,
Sorry to jump in the middle of this thread but there is a much simpler
way to generate sequence numbers:
You create an auxiliary table with a one row:
CREATE TABLE sequence (
code int(11) DEFAULT '0' NOT NULL
);
INSERT INTO sequence VALUES (0);
And, each time you need a new sequence
I think you can set a max quota for a table.
Insane
- Original Message -
From: Henry Umansky [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, October 21, 2002 8:08 PM
Subject: mysql quota
I want to let users on my system use MySQL, but I want them to have some
sort of quota. Is
I have a Redhat linux box which has MySQL 3.23.52 loaded on it. I have
mysql front loaded on a windows xp box which I am trying to use to
connect to the mysql server. The error I am getting when trying to make
a connection is 2013 - lost connection to MySQL server during query. I
have checked
hi,
MySQL AB is pleased to announce that it has settled its lawsuit with
Progress Software Corporation and NuSphere Corporation. For more
information, see the joint press release at
http://www.mysql.com/press/release_2002_14.html
Here's some background-info on the lawsuit:
I was reading through the docs and it says:
The following SELECT statements will not use indexes:
mysql SELECT * FROM tbl_name WHERE key_col LIKE %Patrick%;
mysql SELECT * FROM tbl_name WHERE key_col LIKE other_col;
I am using MYSQL on windows. So is that true?
When I use the below statement
Hi,
What does ERROR 1030: Got error 124 from table handler mean when
trying to select a single value from a table created as a UNIOn of
another table ?
When selecting just the primary key from a UNION table, with MySQL
3.23.53 I get the following error - however if I select the primary key
Pada Fri, 08 Nov 2002 01:59:20 +
David Herring [EMAIL PROTECTED] menulis:
What does ERROR 1030: Got error 124 from table handler mean when
trying to select a single value from a table created as a UNIOn of
another table ?
root@slimmer:~# perror 127
Error code 127: Unknown error 127
Hi,
In fact, it's :
joce@forum:~$ perror 124
Error code 124: Wrong medium type
124 = Wrong index given to function
but the solution to resolve the problem remains the same ;)
Regards,
Jocelyn
- Original Message -
From: Dicky Wahyu Purnomo [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Dicky,
Thank you for the quick response - but it appears tables created as
unions do not support these repair commands:-
# bin/mysqlcheck -r -p test Collaborate
Enter password:
test.Collaborate
error: The handler for the table doesn't support check/repair
# mysql -uroot test
Welcome to
Pada Fri, 08 Nov 2002 02:29:49 +
David Herring [EMAIL PROTECTED] menulis:
Dicky,
Thank you for the quick response - but it appears tables created as
unions do not support these repair commands:-
# bin/mysqlcheck -r -p test Collaborate
Enter password:
test.Collaborate
error
What is the handler for Collaborate ?? (What does show create table
Collaborate display ?)
- Original Message -
From: David Herring [EMAIL PROTECTED]
To: Dicky Wahyu Purnomo [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, November 08, 2002 2:29 AM
Subject: Re:
Pada Fri, 8 Nov 2002 02:20:56 -
Jocelyn Fournier [EMAIL PROTECTED] menulis:
Hi,
In fact, it's :
joce@forum:~$ perror 124
Error code 124: Wrong medium type
124 = Wrong index given to function
but the solution to resolve the problem remains the same ;)
ups ... sorry ... :))
my
Hi everyone,
I'm still learning MySQL. I have a database of 600 items. I am still
adding products. Several of these products are identical in nature, but
have maybe one or two columns that are different. Is there a way to write a
SQL command that selects these items and then inserts them, and
Pada Wed, 6 Nov 2002 15:44:58 +
[EMAIL PROTECTED] menulis:
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
(61) any suggestions on this
check your mysqld process, is it running or not ? ps ax
Pada Thu, 7 Nov 2002 12:10:21 -0500
[EMAIL PROTECTED] menulis:
Hello all, I'm a newbie to Mysql. I just installed mysql 3.23.53 on
Solaris 7. I am running Apache 2.0.42 and PHP 4.2.3.
I am trying to connect to my Mysql DB via Apache and PHP, but I get the
following error: Warning:
1 - 100 of 110 matches
Mail list logo