Hello everybody!
How can I do a fulltext search on several tables
with just one SQL query?
Best regards
/Peter
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
> sql,query
>
> Hello,
>
> i've tried the foreign key-example out of the documentation(3.5.6 Using
> Foreign Keys) on W2K (3.23.49 + 3.23.50) and LINUX (3.23.49). The tables
> persons and shirts are created as innodb-tables.
>
> I could insert a shirt for a non-existing person. Also i could de
On Mon, May 27, 2002 at 03:48:51PM -0400, Philip Mak wrote:
> I have a bunch of processes running on the same machine that should
> be able to send unicast, multicast and broadcast messages to each
> other. Messages should be received in the same order that they were
> sent.
>
> I'm trying to f
On Mon, May 27, 2002 at 10:31:06AM -0700, jim hopp wrote:
> Greetings,
>
> We plan to use the binary update log plus backups to enable us to
> restore databases and then re-apply updates when necessary. It
> appears to me that the binary update log contains updates to all
> databases on the mysq
Sorry I wasn't really awake, and didn't notice which list you'd posted on
:-) Here's an example in PHP (not tested):
==
$cat_list = array();
$sql = "select id, parent_id, category from your_table where order by
parent_id, category ";
$res = mysql_db_que
saraswathy saras wrote:
> Hi everybody,
>
> Can anybody help me?
I'll give it a shot.
> is there any other specific command instead order by ID DESC to select
> all the record from table where the ID is the last ID.The ID is
> autoincrement.
Try this:
select last_insert_id() as ID from TA
hi! im a newbie.. ive installed both mysql and php
under windows 2000.. and ive tried the command
mysqld-nt -install.. and it didnt work, only the net
start mysql worked.. and i cant run php or browse in
IE ..
pls help..
Thanks..
__
Do You Yahoo!
I created two users with grant; obdba with select,insert,index,file and
other privileges and obdbu with select only privileges. Flushed
privileges. Mysqlaccess shows the correct perms for database
'properties' (the only database) for each user although when I try
logging in as either user to tes
Open up MySQL and run this:
SELECT 'foobar' = 0;
It turns up as "1" (MySQL 4.0.1-alpha). Now, the reason is fairly obvious:
atof("foobar") is 0. I tried similar SELECT's in MSSQL and Postgres, and neither said
'foobar' = 0 was true.
In my humble opinion, it isn't. But I don't have any standar
Hi, I'm currently working on a project in which I need to store row
information into various data structures with the function automatically
casting the proper values and the ability to apply it to multiple
structures(so not hard coding the structures attribute names).
e.g..
my_table has the colu
I am new to mysql and having trouble understanding the installation procedures for
linux (Mandrake).
I have downloaded the "mysql-3.23.49a-pc-linux-gnu-i686.tar.gz" and unpacked it in
/usr/local as root.
I then issued the following commands as per the install procedures:
groupadd mysql
us
Hi.
IMHO using MySQL as for inter-process-communication is the wrong thing
to do. Just use traditional IPC mechanisms provided by your operating
system.
If you want to do this anyhow, you could use GET_LOCK with high
timeouts to avoid the polling at cost of idling connections.
At program start:
Yeah, that didn't help and I spelled "skip-innodb" correctly the first time,
moved it into the 'mysqld' section and it didn't change a thing. Same thing
happens still.
As for your statement about reading the manual, I don't think that
installing default should take reading a 615 page manual. I
take a look in the user table (database mysql). There should be a row like
this...
HostUserPassword
localhost root ...
means that the user root can connect from localhost (the mysql server) only.
replace localhost by % or (better) insert a new row
%
- Original Message -
From: "Matt Hargraves" <[EMAIL PROTECTED]>
To: "Mark" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, May 27, 2002 11:19 PM
Subject: Re: Fw: Problem starting server
> I tried adding skip-innodb to the my.cnf file under safe_mysqld.
> Here is my current my.cnf f
- Original Message -
From: "Matt Hargraves" <[EMAIL PROTECTED]>
To: "Mark" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, May 27, 2002 5:19 PM
Subject: Re: Fw: Problem starting server
OK, there really is nothing more to my install, installed it during the OS
install. I clicked
OK, there really is nothing more to my install, installed it during the OS
install. I clicked on 'Next' a bunch, selected all of the mysql options
under 'applications/databases' during install, specified IP addresses,
rebooted and tried to start 'safe_mysqld'.
I tried adding skip-innodb to the m
On 27/5/02 at 16:53, [EMAIL PROTECTED] (Matt Hargraves) wrote:
> OK, that helps a lot.
>
> There is no '/usr/local/mysql directory' Any chance that this is
> different
> in RedHat?
>
> There is very little in the rc.local file and nothing having to do
> with
> mysql.
Try etc/rc.d/init.d
Th
On Sun, May 26, 2002 at 01:35:00PM -0700, Jeremy P. McKay wrote:
>
> I haven't seen a mysql question since friday?
It was, yes.
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 4.0.2: up 3 days, pr
On Mon, May 27, 2002 at 01:33:30PM -0600, Sherzod B. Ruzmetov wrote:
>
>
> Guys, i get the following error. What does this mean?
>
> DBI->connect(myskycastle) failed: Can't connect to local MySQL server
> through socket '/var/lib/mysql/mysql.sock' (2) at teamstats.pl line 16
Please *don't* hi
Hi,
I tried to connect to a mysql database running on a
linux server using an odbc connection in windows 98. I
get the following message:
[TCX][MyODBC]Host x.x.x.x is not allowed to connect to
this MySQL server
(#1130)[Microsoft][ODBC Driver Manager] Connection not
open (#0)
The username speci
OK, that helps a lot.
There is no '/usr/local/mysql directory' Any chance that this is different
in RedHat?
There is very little in the rc.local file and nothing having to do with
mysql.
Matt
- Original Message -
From: "Phil Dobbin" <[EMAIL PROTECTED]>
To: "Matt Hargraves" <[EMAIL PRO
I think most of the data modeling tools (ERwin, SilverRun RDM, for example)
will reverse engineer your schema into them. Have not tried the two I
specifically mention with MySQL, but they have reverse engineering
functionality.
HTH
Mike
- Original Message -
From: "Yegor N. Bryukhov" <[E
I'm using PHP
From: "Carsten Gehling" <[EMAIL PROTECTED]>
> Well you'll neew to do some coding in your application language. What are
> you using to connect to MySQL? Perl? PHP? Java?
>
> Tell me, and I'll give you an example where you only query the database
once
> (for optimum performance).
>
Hi,
I tried to connect to a mysql database running on a
linux server using an odbc connection in windows 98. I
get the following message:
[TCX][MyODBC]Host x.x.x.x is not allowed to connect to
this MySQL server
(#1130)[Microsoft][ODBC Driver Manager] Connection not
open (#0)
The username speci
- Original Message -
From: "Matt Hargraves" <[EMAIL PROTECTED]>
To: "Phil Dobbin" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, May 27, 2002 8:39 PM
Subject: Re: Fw: Problem starting server
> Been there, done that. Didn't change a thing.
>
> [root@server mysql]# safe_mysqld
Hello.
On Mon, May 27, 2002 at 10:31:52AM -0700, [EMAIL PROTECTED] wrote:
> Is this approach still of use if many more tables are
> added?
As I said (in the not-quoted part) "[This] is the standard approach
for implementing a M to N relationship."
> so basically you create a lot of 'relations'
On Fri, May 24, 2002 at 06:17:09PM -0300, João Paulo Vasconcellos wrote:
> Wow, what happened today ?
> Never saw that list so quiet.
The machine hosting the lists was unavailable for the past several
days.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Des
Hi.
On Mon, May 27, 2002 at 05:21:20PM +0200, [EMAIL PROTECTED] wrote:
> > CREATE TABLE places (
> > idp INT(8) NOT NULL,
>
> Contex: SQL, database
>
> Just curious, but is this a 8-bit (smalint maybe?) or approximate 8-byte integer?
That is an 4 byte integer with an supposed display-w
On 27/5/02 at 14:39, [EMAIL PROTECTED] (Matt Hargraves) wrote:
> Been there, done that. Didn't change a thing.
>
> Guess I should have changed the e-mail before resending it, but I'm
> not
> really sure what the problem is. The server won't start for more than
> a
> tenth of a second. Here'
I have a bunch of processes running on the same machine that should be
able to send unicast, multicast and broadcast messages to each other.
Messages should be received in the same order that they were sent.
I'm trying to figure out how to implement that. These processes are
already sharing the s
Guys, i get the following error. What does this mean?
DBI->connect(myskycastle) failed: Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (2) at teamstats.pl line 16
-
Before posting, please che
ata) VALUES(1),(2),(3),(4);
Query OK, 4 rows affected (0.00 sec)
Records: 4 Duplicates: 0 Warnings: 0
mysql> SELECT * FROM test;
++--+--+
| id | dd | data |
++--+--+
| 1 | 20020527 |1 |
| 2 | 20020527 |2 |
| 3 | 20020527 |3
Hello,
I have a couple of questions regarding InnoDB logs' structure.
-Are the innodb logs stored in the main innodb tablespace?
-How is the information stored in the logs? Does it look like SQL queries
as the mysql binary update logs do?
-What is the difference between the mysql binary logs and
Been there, done that. Didn't change a thing.
Guess I should have changed the e-mail before resending it, but I'm not
really sure what the problem is. The server won't start for more than a
tenth of a second. Here's what happens when I try to start mysqld:
[root@server mysql]# safe_mysqld
Sta
Well you'll neew to do some coding in your application language. What are
you using to connect to MySQL? Perl? PHP? Java?
Tell me, and I'll give you an example where you only query the database once
(for optimum performance).
- Carsten
> -Oprindelig meddelelse-
> Fra: Sagi Bashari [mail
Yeah, thats exactly what I wanted to do. But how do I make MySQL sort it
like that? Show the parent first, and then all its childs, so the
application can determite if it's subcategory by checking if the parent is
was changed.
Sagi
From: "olinux" <[EMAIL PROTECTED]>
> create a table like this
create a table like this:
id | parent_id | category
parent_id points to the parent categories id. Top
level categories get parent_id of '0'
ex:
1 | 0 | auto
2 | 1 | repair
3 | 2 | body
4 | 2 | windshields
5 | 1 | detailing
6 | 2 | tires
Tree would look like:
auto
repair
body
wi
On 27/5/02 at 12:47, [EMAIL PROTECTED] (Matt Hargraves) wrote:
> I keep getting the following error:
>
> error: 'Can't connect to MySQL server through the socket
> '/var/lib/mysql/mysql.sock' (111) 'Check that mysqld is running and
> that the
> socket: '/var/lib/mysql/mysql.sock' exists!
Try t
Is this approach still of use if many more tables are
added?
so basically you create a lot of 'relations' tables to
store key relations rather than store the relation in
each table?
olinux
--- Benjamin Pflugmann <[EMAIL PROTECTED]>
wrote:
> Hi.
>
> If FULLTEXT indexes are out of question, wha
Greetings,
We plan to use the binary update log plus backups to enable us to
restore databases and then re-apply updates when necessary. It appears
to me that the binary update log contains updates to all databases on
the mysqld-max process, and that there is no way to keep a separate
binary
Ki,
Monday, May 27, 2002, 6:41:02 PM, you wrote:
KM> I would like to find out if anyone here has any experience writing stored prods
and triggers in mySQL.
KM> Hopefully someone can tell me which version of mySQL is more stable if I want to
write stored prods and triggers.
Stored procedures
andy,
Monday, May 27, 2002, 4:48:24 PM, you wrote:
a> I am wondering if there is a software (free or shareware) which is
a> visualizing the shema (table strukture) of the mysql database.
What about MyCC?
http://www.mysql.com/downloads/gui-mycc.html
a> thanx for any hint,
a> Andy
a> query
I keep getting the following error:
error: 'Can't connect to MySQL server through the socket
'/var/lib/mysql/mysql.sock' (111) 'Check that mysqld is running and that the
socket: '/var/lib/mysql/mysql.sock' exists!
This wouldn't be a problem, but mysql.sock does exist and when I try to run
either
Hi all,
I would like to find out if anyone here has any experience writing stored prods and
triggers in mySQL.
Hopefully someone can tell me which version of mySQL is more stable if I want to write
stored prods and triggers.
cheers,
Ki Mien
--
And one of the built-ins work on totally general cases: they restrict you to
duplication of unique keys. If you want a general insert-if-not-condition
format, you can do your full insert into a temporary table, left join that
table against the real table on your general condition and selecting tho
did you try MAX(ID)?
cheers,
Ki Mien
-Original Message-
From: "Myk Melez" <[EMAIL PROTECTED]>
Sent: Saturday, May 25, 2002 1:41 AM
To: "saraswathy saras" <[EMAIL PROTECTED]>, "mysql" <[EMAIL PROTECTED]>
Subject:Re: query
saraswathy saras wrote:
> is there any other spec
> CREATE TABLE places (
> idp INT(8) NOT NULL,
Contex: SQL, database
Just curious, but is this a 8-bit (smalint maybe?) or approximate 8-byte integer?
-
Before posting, please check:
http://www.mysql.com/manual.php
On Mon, 27 May 2002, Solomon John HART wrote:
> How much third party software is incorporated into the non-GPL version of
> MySQL. Obviously the included software can't itself be under the GPL. How
> does MySQL get around this? Does MySQL have contracts with contributors
> instead of contributi
view this article, it's work fine with vb6 :
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q194975
' insert
Dim ts As String, Sql As String
Dim RS
Set RS = CreateObject("ADODB.Recordset")
RS.CursorLocation = adUseServer
RS.Open "tbl_test", CreateConnexionString(CnxSGDB),
Hello andy,
http://www.datanamic.com/
a> Hi there,
a> I am wondering if there is a software (free or shareware) which is
a> visualizing the shema (table strukture) of the mysql database.
a> thanx for any hint,
a> Andy
a> query
a> ---
Hi!
I still can not reproduce your case.
I first ran this script:
create database xx;
use xx;
CREATE TABLE `t1` (
`titre` char(80) NOT NULL default '',
`numeropost` mediumint(8) unsigned NOT NULL auto_increment,
`ouvert` tinyint(1) unsigned NOT NULL default '1',
`date` datetime N
My replication became out of sync. (Which in turn seems to rewrite my master.info with
some garbage) In this particular instance, the LOG_FILE name had a bunch of spaces
appended to it, and the PORT got changed to 0. The slave was running, but not going
anywhere of course. Usually I can just r
Wow, what happened today ?
Never saw that list so quiet.
SQL.
--
João Paulo Vasconcellos
Gerente de Tecnologia - NetCard
Tel. 21 3852-9008 Ramal 31
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com
These are binary update log files. They keep track of all updates to your
database. They are often used when restoring from a backup and also are
required for replication. You can doa "FLUSH LOGS" and then move away the
old logs or delete them if that is what you want to do. Be sure to always
Hi.
AFAIK, a table is considered read only, if either the underlying
filesystem says so (what you called OS attribute) or it is a
compressed table.
If it would be a problem with the privileges, you would rather get an
error like "Access denied for ... to ...".
So your problem is quite probably
Neil,
Friday, May 24, 2002, 8:14:08 PM, you wrote:
NZ> I have a script with INSERT statements. I run it quite often and
NZ> today for the first time I got the following message while inserting
NZ> from the mysql client:
NZ> BUG IN DYNAMIC LINKER ld.so: rtld.c: 621: dl_main: Assertion
NZ> `_dl_r
Matt,
Monday, May 27, 2002, 9:20:32 AM, you wrote:
MH> I keep getting the following error:
MH> error: 'Can't connect to MySQL server through the socket
MH> '/var/lib/mysql/mysql.sock' (111)'
MH> Check that mysqld is running and that the socket:
MH> '/var/lib/mysql/mysql.sock' exists!
MH> This w
Markus,
Monday, May 27, 2002, 4:59:30 PM, you wrote:
ML> Is there a simple way to do something like INSERT IF NOT EXISTS,
ML> other than first doing a SELECT and checking if it returns any rows?
ML> If not, that would be pretty high up on my whish-list : )
You can use IGNORE keyword in INSERT st
Batara,
Sunday, May 26, 2002, 11:11:25 AM, you wrote:
BK> I have some very big files in my /var/lib/mysql.
BK> [root@nias mysql]# ls -l nias-bin*
BK> -rw-rw1 mysqlmysql1073741921 5$B7n(B 8 04:33 nias-bin.001
BK> -rw-rw1 mysqlmysql875448838 5$B7n(B 9 18:31 n
Hi.
Sounds as if you should start with reading the manual or a good
tutorial (some are listed in the manual):
http://www.mysql.com/documentation/index.html
Regards,
Benjamin.
On Fri, May 24, 2002 at 09:34:28AM -0400, [EMAIL PROTECTED] wrote:
> I just got ViewPoint, which generates w
Hi.
If FULLTEXT indexes are out of question, what your suggestion is the
way to go. Although I would usually use an additional table:
CREATE TABLE places (
idp INT(8) NOT NULL,
place CHAR(32), /* Ex: "New York" */
PRIMARY KEY(idp)
);
CREATE TABLE tokens (
Hi,
> The firewall doesn't have an entry for the MySQL service, so I create a
> user-defined service and fill in the following details:
>
> SourcePort Low: 3306
> SourcePort High: 3306
> DestPort Low: 3306
> DestPort High: 3306
> Transport: TCP (choices are TCP-6, UDP-17, and Other)
Your problem
Hi,
I am running MySQL 3.23.44 and MyODBC 2.50.39.
I am developing a client application that submits queries to MySQL. The queries are
threaded. The Win2000 version runs great, but I have problems
running on Win95 and WinNT. I was curious to see if anyone has created a threaded
client on those p
Hi.
As I have seen no answer yet, just a wild guess:
Maybe you have some query which used both databases, something like
INSERT INTO fdf.whatever SELECT FROM access.pagespromo ...
You can always use the binlog utilities and have a look at the query
which caused the failure.
Regards,
Hi there,
I am wondering if there is a software (free or shareware) which is
visualizing the shema (table strukture) of the mysql database.
thanx for any hint,
Andy
query
-
Before posting, please check:
http://www.mysql.
Dear Jack,
If (date/time) field means the last time updated or inserted,
how about this;
"select * from [the table] order by (date/time) desc limit 1, 5;"
-Original Message-
From: Jack [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 27, 2002 6:05 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Hello.
On Thu, May 23, 2002 at 11:53:49AM -0400, [EMAIL PROTECTED] wrote:
> Hello,
> I'm new to MySql. I plan to switch my Java/JDBC web application to use
> MySql. The application requires transactions so, as I understand it, I need
> the table types to be BDB or InnoDB. Can anyone offer comment
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
Why not have the application check for existing usernames, if one
exists,present the info the admin user and ask if this is the user they
are trying to create, if yes, then change the active flag, if not, tell
them they need to choose a different username. That way your auditing
and your unique i
Since I been working implementing some triggers in my system
recently this suggestion first came into my mind:
create a delete trigger for the user table. Every time a user it deleted,
the trigger fires and could for example moves this information to a history
table, with date of deletion, etc. T
Hi Jack
select * from TableName order by DateTimeField DESC limit 5
Should do it.
Peter
At 05:04 PM 5/27/2002 +0800, Jack wrote:
>Dear all
> I had a table which containing (date/time) field, now i want to retrieve 5
>most latest update / insert record from that table, what query should i us
Greetings!
Has anyone ever had the following problem with ADO ODBC connection:
I create a table with a BLOB field. From MySQL shell I update that field
using insert into statement and all works perfectly. But when I try to
execute that query from VB usnig ADO and ODBC connection (MyODBC 2.50 or
> It gave me an error saying error in SQL syntaz at CREATE TABLE..
I think that's because your query does not look to me like valid MS Access
SQL syntax.
> is the SQL sytnax exactly the same as 'normal' SQL syntax?
Both Access and MySQL implement quite a lot of standard SQL syntax (if
that's wh
On Monday 27 May 2002 10:59, Markus Lervik wrote:
> (filter fodder: sql, query)
>
> Hello group!
>
>
> Quick question:
>
> Is there a simple way to do something like INSERT IF NOT EXISTS,
> other than first doing a SELECT and checking if it returns any rows?
> If not, that would be pretty high up
Hi!
I've watched the development of replication on mysql with great joy.
However I haven't been able to understand when og if mysql is going to
support 2 way replication. In other words.
Will it be possible to have 2 databases on 2 different locations, that
synchronize with each other in a way,
Hi!
I've watched the development of replication on mysql with great joy.
However I haven't been able to understand when og if mysql is going to
support 2 way replication. In other words.
Will it be possible to have 2 databases on 2 different locations, that
synchronize with each other in a way,
> -Original Message-
> From: Menard, Inc. Information Systems
> Sent: Friday, May 24, 2002 3:44 PM
> I figured it out but I'm a bit confused as to why it happened.
> I'm running the load as user1. The file resides at
> /home/user1/data/filename
> Permissions:
> filename 666
> data 777
> us
Placed At :
Hi..
I'm facing another problem with replication..I have jus one table with over 4
million records in it. I run mysql-3.23.49 on both my master and slave.following
is the problem am facing..
I had taken a consistent dump from the mast
Will,
In your $dbh connection handler, you need to change the host=localhost and
database= to just localhost and the database name.
$dbh = DBI->connect ("DBI:mysql:localhost;database_name",
"**", "***", {PrintError => 0, RaiseError => 1});
>>On Fri, 24 May 2002 16:4
I note by experiment (by observing the content of the binary log) that I get
the following actions when trying to use a temporary table during a
transaction:
-- on creating a temporary table, the create (only) is committed
-- on dropping a temporary table, the current transaction is committed
Al
HI,
>For trees you need self joins.
Could You please explain that ?
Regards,
At 19:11 23/05/02, Georg Richter wrote:
>On Thursday, 23. May 2002 16:16, Sagi Bashari wrote:
>Hi,
>
>
> >
> > How can I get MySQL to sort it like that? I tried to use group/order by,
> > but I cannot get it
Hi all,
I have developed a system that lets people send messages to each other, with
a MySQL database and PHP.
Among the tables that exist, one is called "Users" and contains information
such as Username, password (md5'd of course), email address etc. This table
has a primary key "UserID" that i
I keep getting the following error:
error: 'Can't connect to MySQL server through the socket
'/var/lib/mysql/mysql.sock' (111)'
Check that mysqld is running and that the socket:
'/var/lib/mysql/mysql.sock' exists!
This wouldn't be a problem, but mysql.sock does exist and when I try to run
either
Hi!
Thank you for your test case.
However, with latest 4.0.2 code I am getting correct results with
it. Difference in number of rows in select and delete are stemming
from the fact that select reports number of rows in result set, while
delete reports total number of rows deleted.
These are r
Dear all
I had a table which containing (date/time) field, now i want to retrieve 5
most latest update / insert record from that table, what query should i use?
Thx a lot!
Jack
[EMAIL PROTECTED]
-
Before posting, please check:
Placed At :
Hi..
I'm facing another problem with replication..I have jus one table with over 4
million records in it. I run mysql-3.23.49 on both my master and slave.following
is the problem am facing..
I had taken a consistent dump from the mast
Hi!
> "Luciano" == Luciano Barcaro <[EMAIL PROTECTED]> writes:
Luciano> Hi Monty,
Luciano> Michael Widenius wrote:
>>> Hi!
Jeremy> Is that supposed to happen in 4.0.x? I don't recall having seen a
Jeremy> commit that affected the key cache yet.
>>> Sanja has been trying to do improve
Hi!
> "Glenn" == Glenn Hancock <[EMAIL PROTECTED]> writes:
Glenn> I also have had trouble with the script that creates my user access tables.
Glenn> I am assuming those tables should get created in the ./var/mysql folder.
Glenn> Its my fault but I removed those tables just to see if they h
- Original Message -
From: "Jocelyn Fournier" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, May 25, 2002 3:35 PM
Subject: Re: multi-table delete bug
Hi,
Yes, you're right, but to see the problem, you have to restart mysql
bet
What happened to this MySQL list?? For the last two days all I got was a
"Connecyion deferred," and I have not received mail from it for the last two
days either.
- Mark
-
Before posting, please check:
http://www.mysql.com/m
I have some very big files in my /var/lib/mysql.
[root@nias mysql]# ls -l nias-bin*
-rw-rw1 mysqlmysql1073741921 5$B7n(B 8 04:33 nias-bin.001
-rw-rw1 mysqlmysql875448838 5$B7n(B 9 18:31 nias-bin.002
-rw-rw1 mysqlmysql 86 5$B7n(B 9 19:
Hey guys,
I have some questions concerning ODBC, I'm doing a job on a server which
requires me to access a MS Access DB and write a front end for it, so
employees of the company can run query's. I just have some questions.
I'm using mysql w/ odbc drivers and php.
Does teh server (NT 4) need to hav
The embedded server of 4.0.1 for win32 leaks one thread (the server thread
to be exact) per mysql_server_init / mysql_server_end pair. I've
experimented
with mysql_shutdown and mysql_thread_end as well, but they do not resolve
the issue. Eventually (after 10 times or so starting/ending the serve
I haven't seen a mysql question since friday?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PRO
(filter fodder: sql, query)
Hello group!
Quick question:
Is there a simple way to do something like INSERT IF NOT EXISTS,
other than first doing a SELECT and checking if it returns any rows?
If not, that would be pretty high up on my whish-list : )
Cheers,
Markus
--
Markus Lervik
Linux-ad
Yesterday my server died abruptly. I can't even guess the reason.
Fortunately there remain error messages, following are the messages
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this
binary
or one of the libraries it was linked agaist is corrupt, improperly
I am hoping that a MySQL person will give a definite answer to my question.
Thanks,
Stephen
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Monday, May 20, 2002 3:18 PM
Subject: Re: [7241] Indexes on columns that are declared differen
I understand all of the reasons given by Alexander.
Yet I think that in 99% of cases, it would be best for myisamchk to do as
Mark suggest, and not run when a MySQL server is active.
Safety would be the default.
There could be a special option (--no-safety) for myisamchk to override that
check.
-
Re Gunnar Helliesen e-mail
I have FreeBSD4.2 and MySQL 3.23.49.
I two have hi cpu (99%) on a twin cpu system. (Compaq DL380)
After making the suggested changes to my.cnf we rebooted the system.
For 3 days all ran fine (low cpu) then at 2am cpu went back up to 99%.
Has any body know why FreeBSD wit
1 - 100 of 119 matches
Mail list logo
