Jeff,
Thursday, October 10, 2002, 5:44:28 PM, you wrote:
JZ I have a MySQL 40 column table where I select an entire row then insert
JZ it into another (different) 40 column table. For some reason the insert
JZ fails and after much troubleshooting I've isolated the cause to a field
JZ heading
hi,
I have a problem with the connections and would appreicate a lot if anyone can provide
a soln..
Our JSP application has connections to both Oracle and MySQL... In each page there are
nearly a dozen queries executing on a MySQL db. at the begining of each page, a
connection is opened and
HI,
I am trying to connect to MySQL using java. I have placed mm.mysql drivers
in jakarta-tomcat/lib folder. but whenever i try to connect to mysql, i
receive this error:
Cannot connect to MySQL server on . Is there a MySQL server running on the
machine/port you are trying to connect to?
Hasan
Try typing your select statement in a text editor.
Open a mysql client connection and copy paste. This
gets around the problem.
For multiple sql statements, put them in a file and
redirect it to the mysql client:
shell mysql -u hasan -p file.sql
David
-Original Message-
From:
--
o The Intel Linux binaries (normal and Max) have now been built against
a glibc with static-nss enabled again. This should resolve the
problem
with mysqld failing to change to another user ID as well as the
notorious
load issue that has been plagueing previous releases. We have
I'm still getting the same error:
/usr/local/mysql/bin/safe_mysqld: line 273: 4963 Segmentation fault
$NOHUP_NICENESS $ledir/$MYSQLD $defaults
--basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION
--pid-file=$pid_file --skip-locking $err_log 21
Number of processes running now: 1
Hi !
the table has about 12.000 rows total but the query should return
a max of about 100. mysql should split the query into two queries
and merge the results.
may be this could be done by joining the same table two times
and query each table only for one of the OR expression.
i'll try but for
Muhammad Farhan wrote:
HI,
I am trying to connect to MySQL using java. I have placed mm.mysql
drivers in jakarta-tomcat/lib folder. but whenever i try to connect
to mysql, i receive this error:
Cannot connect to MySQL server on . Is there a MySQL server running on
the machine/port you are
At 19/10/2002 17:17, Ed Carp wrote:
It's not a MySQL problem, but a problem how you're opening the recordset.
In VB, you would set the DBSQLPassThru flag - I don't know what the
equivalent is in Windows C. The problem is that the client is downloading
the entire record set and oding the
With a similar case I had my problems because the exported database records
from Sage KHK, a german biz management software, had and other special
chars in it that made it not possible to run a proper import from a CSV file and
manual cleaning with 35.000 records was out of question ;o)
I did
Miquel,
I tried what you suggested, but still it didn't work properly.
For the server:
C:\cd mysql\bin
C:\mysql\binmysqld-opt --standalone --console
021020 8:20:30 InnoDB: Out of memory in additional memory pool.
InnoDB: InnoDB will start allocating memory from the OS.
InnoDB: You may get
Hello guys
Here is the problem. You may find it trivial, but it is a serious
obstacle for me. I make a database, a table in mysql and it goes fine.
Then I try to view my table with PHP. I am pretty sure that I can't
connect to the database.
In particular $db = mysql_connect(localhost, root, )
Dear All,
When I tried to install Data-Dumper module for the MySQL-bench module, I
got the following error message, which confused me:
gcc -c -fno-strict-aliasing -I/usr/local/include -O2 -march=i386
-mcpu=i686 -DVERSION=\2.09\ -DXS_VERSION=\2.09\ -fPIC
-I/usr/lib/perl5/5.6.1/i386-linux/CORE
At 13.49 20/10/2002 +0200, you wrote:
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
sql,query
If you just reply to this message, and include the entire text
At 19/10/2002 22:08, Patrick Sherrill wrote:
It sounds like it may be time to look at threads. Set up a thread and open
your recordset there or look at the C or C++ API for MySQL.
It's not a thread problem.
Thanks,
Massimo.
-
This mail
Hi,
does anybody know how to make a delayed update and is this implemented in
mysql 3.23.x ? the update should not block the client (i guess this does
low_priority) if the table is a lot in use. simply update the rows later,
just like insert delayed does.
Thanks,
Corin
I can't seem to figure out the select statement to get the name. Do I need
the the StarID or ActorID in Titles table? Thank you.
I am using PHP and MYSQL.
Studios (StudioName, StudioID)
Genres (GenreName, GenreID)
Titles (VideoTitle, Details, StudioID, GenreID, BitRateID, TitleID)
Actors
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
sql,query
If you just reply to this message, and include the entire text of it in
the
reply, your reply
John,
StudioName?
GenreName?
F_Name?
L_Name?
DatabaseName?
ServerName?
Alan
I can't seem to figure out the select statement to get the name. Do I need
the the StarID or ActorID in Titles table? Thank you.
I am using PHP and MYSQL.
Studios (StudioName, StudioID)
Genres (GenreName, GenreID)
I would take a look at the already available solutions
at http://www.hotscripts.com
http://php.resourceindex.com
(many open source/free)
It may be easier to use (and manipulate) one of these
to what you need.
I am working on a similar project, since I fond many
project management solutions to
At 19/10/2002 19:16, Venu wrote:
Its because of mysql_store_result(), instead you should
check the option 'Don't cache results' to use
'mysql_use_result()'.
I tried to uncheck the option Don't cache results (with MyODBC 3.51.04 it is
Don't cache Results(only for forward-only cursor) ) and
Ok, rebuillding a table, I did (in Perl):
$sth = $dbh - prepare (LOCK TABLES $table WRITE);
die $dbh-errstr if (not defined ($sth - execute));
$sth = $dbh - prepare (DELETE FROM $table);
die $dbh-errstr if (not defined ($sth - execute));
This truncated the table. Then I filled
I've already installed mysql ver. 3.23.49-log on my 686i box, Debian Linux OS.
How to change the value of skip-networking variables from ON to OFF--because
the database server is separated with the Apache Server; both are in the
different computer?
regards,
--
Erwin M Sitorus
TROTOAR IT
I think I've firmed my theoritical understanding of relationships enough
to be dangerous. Now for the logical parthow do you actually define a
relationship in mysql? For instance...
table movies
columns (movie id(pk) , movie title , year filmed)
table directors
columns (director
What is the Title.ID and Actor.ID?
Will this work if someone is doing a text search on a webpage? The results
will go to another page. Does the below go to the first page or the
results page? Thank you.
At 12:20 PM 10/16/2002 -0400, you wrote:
John Chang wrote:
Studios (StudioName,
-Original Message-
From: Postmaster [mailto:Postmaster]
Sent: None
To: [EMAIL PROTECTED]
Subject: Error delivering message to: [EMAIL PROTECTED]!
Your message was not delivered for the following reason:
E-mail Account: lists-mysql is over the limit of 31457280 bytes.
Automated
In the last episode (Oct 20), Peter J. Schoenster said:
A cohort wrote a script to import tab delimited files. He uses
mysqlimport. He uses the -d option to ONLY empty the data from the
table before importing the new data. My cohort believes that
mysqlimport is also dropping the table and then
Hi
Bigger than my experience, so just a suggestion - have you looked at
replication?
If you have a master which does all the processing and (multiple) slaves
which handle all the reads then you might benefit from cheaper Intel
hardware and have a more robust system to boot.
Good luck!
Peter
Thanks to those who replied. It wasn't clear to me that that was the case,
based on the docs. I'll submit a doc change request to make sure that's
more clear to the next person.
Gracias,
Randy
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
Red Hat Network users who have applied all recent critical updates
will experience segmentation faults when accessing MySQL with remote
clients (including MyODBC). Access from localhost seems to be OK.
The solution is to upgrade to MySQL 3.23.53. At this time RedHat does
not have updated
Can someone tell me what the holdup is in getting binaries built for
Mac OS X? I notice on the www.mysql.com web page that the latest
version of the binaries available of the is 4.0.3. Why is this?
If somebody can point to the cause of the logjam, there might be
something I can do about it.
I need to come up with an intra-company system recommendation: We are looking
at a possibly huge system getting data from a LAN(No web-based app or
anything-in fact it will NOT be connected to the web)
handling from 3M to 20M records/day with potentially a lot of processing,
live inserts/
I want to be able to create a Navigation bar on the left (Where I can do
searches, DropDown menu that performs an action) I want this in all my
pages but be able to modify it just once. On the right side I want a way
of dynamically getting data from a database and showing all searched item
You are on the right track.. but kill your relationships as you have them
currently defined... think of it this way... (one to many).. you have
movies and you have directors.. it should be one director to many movies
seeing that a movie normally only has one director.. so take you
Hi There,
Just reciently (after no changes) my MySQL database is automatically
incrementing timestamps by one day.
Timestamp format is timestamp(14).
An example date would be 20021021143513
when I use command such as:
INSERT INTO MyTable SET timestamp = 200210211143513;
and then:
isn't that the month changing?
it's changing from october to january...??
Alan
-Original Message-
From: Jay X [mailto:sparqz50;hotmail.com]
Sent: Monday, 21 October 2002 12:20
To: [EMAIL PROTECTED]
Subject: timestamp bug increments by one day
Hi There,
Just reciently (after
Hi,
A cohort wrote a script to import tab delimited files. He uses
mysqlimport. He uses the -d option to ONLY empty the data from the
table before importing the new data. My cohort believes that
mysqlimport is also dropping the table and then recreating the table
from somewhere and then
Randy,
I think I've firmed my theoritical understanding of relationships enough
to be dangerous. Now for the logical parthow do you actually define a
relationship in mysql? For instance...
http://www.mysql.com/doc/en/SEC447.html
table movies
columns (movie id(pk) , movie title ,
can someone tell me why I get this error back from postings?
Your message was not delivered for the following reason:
E-mail Account: lists-mysql is over the limit of 31457280 bytes.
Automated Postmaster
Alan McDonald
http://www.meta.com.au
[EMAIL PROTECTED] wrote:
Hi,
I have this query problem, I know its not related to MySQL server...
Got this data
Number cost type
1 10 NDD
2 200 LOCAL
1 20 NDD
2 15 NDD
2 30 LOCAL
1 5 LOCAL
2 10 NDD
2 15 LOCAL
how to create a query that the output looks like this
number
Hello I am a brand new user of MySql, and have some questions about
using InnoDB tables.
I noticed in the manual that you can only specify
- ON DELETE SET NULL
Or
- ON DELETE CASCADE
What is the default behaviour if nothing is specified?
Also, does anyone know if there are any plans to
If all works correctly, can I delete replication logs by RESET SLAVE
safely?
I'd like to configure two servers with two-master scheme, each is the
master of
another.
--
Chung Ha-nyung alita@[neowiz.com|kldp.org]
Sayclub http://www.sayclub.com
NeoWiz http://www.neowiz.com
-Original
HI
Probably a silly question, but how can I roll the logs for mysql?
I started it with
safe_mysqld --log-slow-queries --log
So it created two logs in my /var/lib/mysql folder, one holding ALL
queries, and one for only the slow queries.
The general log is growing quite rapidly, and I would like
43 matches
Mail list logo