Thanks to all for your suggestions
just have to try all now
Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
For backup purposes I have what amounts
to a complete clone of a live server.
During the process of copying
everything, the MySQL data was copied
over in its entirety. My problem is that
the mysqld won't start now on this
second machine. I don't need the
databases to be preserved here
Hi!
On Oct 06, Christopher L. Everett wrote:
I've also found a problem with myisamchk --sort-keys:
I recently fixed one bug in myisamchk --sort-keys where fulltext indexes
are present. Try 4.1.7 release.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei
Is there any plan to release a 32-bit binary 4.1.6 MySQL max for Solaris 9 and
Solaris 8? I see all the other binaries for Solaris for everything - any reason
to exclude the 32 bit?
Thx,
R
Hi!
On Oct 06, Christopher L. Everett wrote:
I have an application where I create a faily large table (835MB) with a
fulltext index. One of our development workstations and our production
server will run the script to load the table, but afterwards we have a
pervasive corruption, with out of
Hi,
I have a table called Bookings which holds information for bookings(!) for
staff members in my database:
mysql DESCRIBE Bookings;
+---+-+--+-+++
| Field | Type| Null | Key | Default| Extra
I think what Harald is saying ( if he's not, then I say this):
You could have an alternative table structure like this: - it should
make queries much quicker:
create table raddata_2004_10_ONE (
granID integer not null,
scanID tinyint unsigned not null,
fpID
You are INNER JOINING the country table to the query twice without giving
the query separate aliases for each. Also, you are providing only one set
of join conditions so you are going to make a Cartesian product with one
of those joins.
Looks to me like you only need the table once. Here's my
Quoting Tom Cunningham [EMAIL PROTECTED]:
I think what Harald is saying ( if he's not, then I say this):
You could have an alternative table structure like this: - it should
make queries much quicker:
create table raddata_2004_10_ONE (
granID integer not null,
scanID
G'Day All,
When I try to connect to my mysql/php through Apache I get the following
error:
Warning: mysql_pconnect(): Can't connect to local MySQL server through
socket '/var/lib/mysql/mysql.sock' (13) in
/var/www/html/taxes/db_mysql.php on line 99
Database error: pconnect(localhost:3306, root,
This is usually one of two things...
1) MySQL is not running on that machine
2) Permissions for accessing the socket via PHP.
More likely this first, but try both. Check you [HOST].err file to be sure.
J.R.
-Original Message-
From: Ferguson, Michael [mailto:[EMAIL PROTECTED]
Sent:
J.R. Bullington replied but when I click on the message I get a popup
box that says:
Can't open this item. Your Digital ID name can not be found by the
underlying security system.
J.R. please send me another reply. Thanks
-Original Message-
From: Ferguson, Michael
Sent: Monday, October
This is usually one of two things...
1) MySQL is not running on that machine
2) Permissions for accessing the socket via PHP.
More likely this first, but try both. Check you [HOST].err file to be sure.
J.R.
-Original Message-
From: Ferguson, Michael [mailto:[EMAIL PROTECTED]
Sent:
I can't tell you how *glad* I am to get this running! Big hugs to you,
Shawn!
It's running beautifully. My only question is, after I run the queries,
I notice it won't let me create the temporary table again (saying
'tmpCandidates' already exists). Do I just need to then log out of my
client
Hello,
When I execute a LOAD DATA INFILE statment.. mySQL
returns a result with info like:
Records: 1 Deleted: 0 Skipped: 0 Warnings: 0
How can I get more information about deletions,
warnings etc?
Karam
__
Do You Yahoo!?
Tired of spam?
Thanks very much. I appreciate it.
-Original Message-
From: J.R. Bullington [mailto:[EMAIL PROTECTED]
Sent: Monday, October 25, 2004 12:46 PM
To: [EMAIL PROTECTED]
Subject: FW: Error connecting to mysql db
This is usually one of two things...
1) MySQL is not running on that machine
2)
I am so happy to get you working. Hopefully we helped some other along the
way ,too :-)
It's a good idea when working with data that you should always clean up
after yourself, regardless of what language you are using. Not only does
it free up resources faster it helps to make sure that you
I think this will be my last question on the matter.
I was reading previous messages to the list regarding the boolean search
function, and its problems when searching with 3-letter search terms.
I'll need to search for sap as an ERP term. Is there an efficient way
to avoid getting something
Hi
I seem to be having problems returning the expected results when using
the mysql ROUND() function.
Rounding 3.565 to 2 decimal places i would expect to return 3.57
however using
SELECT ROUND(3.565, 2);
it returns 3.56. While using
SELECT ROUND(3.575, 2);
works as expected returning 3.58.
I
I'm having a difficult time getting a query to work
correctly.
I'm not sure, if this is proprietary to Dreamweaver or
not (that is what I do my application development in)
Anyway I have created a search page that is dynamic
(meaning up to the user to choose the criteria)
It all works fine
I cant tell if this is a bug or a feature.
Select from table where col 'blah'
I use this all the time with other databases, works great, gives me
everything that's not blah
but in mysql, it wont work if there's null records in the table
I have to do this, select from table where ( col 'blah or
[snip]
I cant tell if this is a bug or a feature.
Select from table where col 'blah'
I use this all the time with other databases, works great, gives me
everything that's not blah
but in mysql, it wont work if there's null records in the table
I have to do this, select from table where ( col
matt_lists wrote:
I cant tell if this is a bug or a feature.
Select from table where col 'blah'
I use this all the time with other databases, works great, gives me
everything that's not blah
In SQL (not just MySQL), any comparisons involving NULL return NULL,
so if that was working in some
At 14:51 -0400 10/25/04, matt_lists wrote:
I cant tell if this is a bug or a feature.
Select from table where col 'blah'
I use this all the time with other databases, works great, gives me
everything that's not blah
but in mysql, it wont work if there's null records in the table
That is the
MySQL also has a work around. You might try to rephrase your comparison as
WHERE not col = 'blah'
the = operator is documented as a null-enabled equality check. That
way if you are comparing null to null, you get a true or false and not
another null. This comparator is available as of 3.23.0
Hmmm, peculiar... Tried it on 4.1.6-gamma-nt and works fine:
SELECT ROUND(3.575, 2); = 3,57
SELECT ROUND(3.565, 2); = 3.56
The round() function probably cuts off the last bit...
More info: http://lists.mysql.com/myodbc/8
Regards,
Edgar
-Oorspronkelijk bericht-
Van: Tom Butterworth
Razor Fish mailto:[EMAIL PROTECTED]
on Thursday, October 21, 2004 3:19 PM said:
i need consulting help for optimizing a database with
1.2 million records to handle 3-4 million hits a day.
this is going to be a 'duh' question on my part but i just had to ask
anyway.
my largest table
This must be a bug that was fixed in the 4.1 version. I see the same
thing as Tom, using both 3.23.49 and 4.0.20...
Oh, wait. The ever-helpful manual comes through again:
From the manual documentation on ROUND():
Note that the behavior of ROUND() when the argument is halfway between
two
I have multiple databases running tables with thousands of records in them. Some of my
tables have
as many as 130 million records in them. Memberships and patient data can easily run
from thousands
to tens of thousands of records. If you are looking into things like DNA/Genome
mapping, you can
Okay, I'm at my wit's end on this one. Suppose I have a
(grossly simplified) table like so:
mysql select * from filter;
++--+---+---+--++---+
| id | name | value | in_method | in_value | out_method | out_value |
Hi all,
I have been struggling to get MySql to accept Unicode characters for a while
now with no success. I am attaching a small example program as well as a
mySql dump in hopes that someone can help.
The expected behavior is that the program should insert a curly quote and a
'one quarter'
Hi Everyone. My problem is that i want to create 2 instances of a
sub-query. For Example:
SELECT DISTINCT V4.* FROM (SELECT v2.* FROM cell v1,cell v2 WHERE v1.name
= 'reviews' AND v2.sal = v1.sal ) v3 , v4
This query will gives an error as V4 is not allowed, i.e. not more than 1
instance of a
Hi all ,
I am currently experiencing an issue with a query I would have thought to be somewhat
straightforward. Perhaps someone could shed some light on what might be causing this?
The below example was running by itself , not waiting for any other queries. It just
took a bloody long time to
Hello,
I am new in mysql and I woul like to ask what is the best way to import
data from a file.
Cheers,
Manuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
There's a tool called mysqlimport. I recommend using that. Or, if you
have to extract data from a larger set, you could write a program. But,
mysqlimport is the easiest way. If you're on a UNIX machine, run 'man
mysqlimport' for more information.
Good luck,
Brian
-Original Message-
I managed to do it using
mysql load data infile '/home/manuel/databases/import.txt'
- into table countries
- fields terminated by ';';
Query OK, 240 rows affected (0.01 sec)
Records: 240 Deleted: 0 Skipped: 0 Warnings: 18
(I will check the warnings...)
I guess my system do not have
I've used the 'load data infile' command to import data from a file and it
worked well for my purposes. See
http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html for the full syntax.
Rhino
- Original Message -
From: Manuel J. Contreras Maya [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
In the MySQL documentation, it says that: Boolean full-text searches
have these characteristics:
* They do not use the 50% threshold.
* They do not automatically sort rows in order of decreasing
relevance. You can see this from the preceding query result: The row
with the highest
From: lrpbfd
To: [EMAIL PROTECTED]
Subject: [50 character or so descriptive subject here (for reference)]
Description:
precise description of the problem (multiple lines)
How-To-Repeat:
from mysql:
With EXPLAIN SELECT ... ORDER BY, you can check whether MySQL can use
indexes to resolve the query. It cannot if you see Using filesort in the
Extra column.
. further :
In MySQL 4.1 and up, a filesort optimization is used that records not only
the sort key value and row
HI everyone,
Sorry if this question doesn't belong here...
I tried to compile several open-source UDF's (downloaded from
http://mysql-udf.sourceforge.net/) and got a warning. Could someone please elaborate
on this:
/usr/include/asm/atomic.h:40:2: warning: #warning Using kernel header in
41 matches
Mail list logo