Because mysql needs 'rx' permissions to read and search the directory.
755 should have been sufficient.
Menard, Inc. Information Systems wrote:
>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
>Permiss
Richard,
Friday, May 24, 2002, 5:04:49 PM, you wrote:
RD> I'm rather new to MySQL and trying to figure out GRANT and REVOKE so a
RD> password is required for access.
RD> Both GRANT and REVOKE give errors saying "Table 'User' is read only". A text
RD> search in the manual for "read only" did not y
Rick:
I believe this is a faq, but check permissions.
bash-2.05$ ls -lrtd /mysql/
drwxr-x--- 42 mysqlmysql4096 May 1 11:34 /mysql/
[root@winslow RPMS]# ls -lrt /var/lib/mysql/
total 12
drwx--2 mysqlmysql4096 May 24 22:01 test
-rw-rw1 mysqlmysql
Don't use 'more'. It adds characters to the output.
Instead:
mysql --host=host --user=user --password=pwd < error_repeat.sql
Elliot Smith wrote:
>Description:
>I used mysqldump to create an SQL file containing a dump of all databases on
>the server, including all tables and data (using --a
Hello,
The documentation often mentions that foreign key support in mysql is
not implemented because it slows down the database server. The argument
is that since the applications built on top of mysql have to check for
database integrity constraints (ICs) it is redundant for the database
to pe
> At 21:27 -0500 5/23/02, Andrew Lietzow wrote:
> >Dear MySQL wizards,
> >I have two tables, call them a and b. The database structure is
> > identical. I want the records in b to overwrite the records in (REPLACE
> > INTO) a.
> >This is the statement that does NOT work.
> >REPLACE INTO a SELECT
Dear Curtis,
RE:>> How do I log in and see the table layout and data? How do I create a
connection to access the tables and data from my ASPs?
The first question is a popular one, asked and answered multiple times in the
FAQ's.
I would also recommend that you look into a GUI front end, lik
Dear Jake and MySQL listers,
RE:>> I had to change permissions on user1 to 777 in order for it to work. If
I'm logged in as that user, why would I have to do that???
I can't say for certian, though I would imagine that the mysqld actually does
the processing on this type of a table load, i.e.
I had a weird problem similar to this on an older version of Red Hat.
Debuging init.d etc...I found that the socket was being created in one
location and mysql was trying to use it in a different locationThe
process of launching is kinda complicated, so rather then spend a whole
bunch
Hello,
I have a script with INSERT statements. I run it quite often and
today for the first time I got the following message while inserting
from the mysql client:
BUG IN DYNAMIC LINKER ld.so: rtld.c: 621: dl_main: Assertion
`_dl_rtld_map.l_libname' failed!
I simply reran the script and it wo
Hi!
First of all I would like to congratulate you for MySQL, which I, among many
users, have found a both useful and powerfull tool.
My name is Dennis Bekatoros. I am a pretty new user of MySQL but having some
experience with other SQL platforms I managed to get used to MySQL
environment in s
When I try to install Php like this:
./configure --with-mysql=/usr/local/lib/mysql
I get:
configure: error: Cannot find header files under /usr/local/lib/mysql
I have installed:
http://www.mysql.com/Downloads/MySQL-4.0/MySQL-4.0.1-2.i386.rpm
http://www.mysql.com/Downloads/MySQL-4.0/MySQL-clie
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 contributions being under the GPL? It seems like an interesting
bus
Greets Folks,
I am trying to get an online database set up and running, but I keep getting
error messages at login.
Here are two sample scripts I have been running (both are from Paul DuBois'
book MySQL and Perl for the Web).
## SCRIPT 1 ##
#! /usr/bin/perl -w
# intro4.pl - generate
I am just checking to see if the mysql server is down I haven't gotten any
e-mails today?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Do I need to uninstall the old Apache before installing the newer version?
How do I uninstall the old Apache in linux? Do I just use the package
manager to remove the package? What does make do? I don't know how linux
work. Please advise. Thanks.
>From: Andrew Lietzow <[EMAIL PROTECTED]>
saraswathy saras wrote:
> 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.
Not sure from your message if you already know this, but ORDER BY ID
DESC LIMIT 1 gives you what you want.
-myk
Hi,
We have identified a rather serious bug in "libmysqlclient" of v3.23.49.
The client we are using is RIPE 3.1.0 (an Internet Routing Registry server) proivded
by RIPE. This latest version uses threaded libraries.
Upon starting this server it would very shortly thereafter crash.
This occure
Hi all.
I've just been forced to install a hardware firewall by our parent company.
We now have our MySQL server in a DMZ zone, and I am having trouble
opening up access to it.
The firewall doesn't have an entry for the MySQL service, so I create a
user-defined service and fill in the following
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
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.
-
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
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
(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
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
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
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
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:
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
- 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
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
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
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
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:
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
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 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
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
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
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
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
> -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
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,
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
> 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
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
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
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
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
>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:
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
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]
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.
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,
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,
> 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.
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.
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
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
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
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
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
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
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
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
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
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
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> ---
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),
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
> 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
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
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
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
--
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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'
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 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
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'
- 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
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
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).
>
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
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
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
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
1 - 100 of 119 matches
Mail list logo
