Hello.
General recommendations are available here:
http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html
Nathan Whitington [EMAIL PROTECTED] wrote:
Hello there,
I've searched long and hard, and pestered many people for a solution
and for help however I can not
Hello.
You may use these queries:
select flight_id
,baseline*tan(radians(angle)) as attitude
from flights
where (baseline*tan(radians(angle))) =
( select max(baseline*tan(radians(angle)))
from flights f2);
Hello.
Add --skip-extended-insert to mysqldump options.
Michael Williams wrote:
When performing mysqldump is there any way to ensure that each
record gets an INSERT of it's own? I keep getting the following:
INSERT INTO 'mytable' (1,'test item'), (2,'test item'), (3,'test
Hi,
my mysql always executes case insensitive queries:
SELECT username FROM workflow.user WHERE username = 'NicO' LIMIT 1;
+--+
| username |
+--+
| nico |
+--+
1 row in set (0.01 sec)
that field is of varchar(255) type.
I don't understand the reason for this
The main items to be stored are images and video clips but taking advice
from previous emails on this list, we will be holding these outside MySql so
the tables are to do with loading these, manipulating them, and keeping
details on clients, customers and contacts etc. None of them will be large.
Nico Sabbi wrote:
Hi,
my mysql always executes case insensitive queries:
SELECT username FROM workflow.user WHERE username = 'NicO' LIMIT 1;
+--+
| username |
+--+
| nico |
+--+
1 row in set (0.01 sec)
that field is of varchar(255) type.
I don't understand the
You should use:
SELECT username FROM workflow.user WHERE username LIKE BINARY 'NicO' LIMIT
1;
reference:
http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html
On 12/12/05, Nico Sabbi [EMAIL PROTECTED] wrote:
Hi,
my mysql always executes case insensitive queries:
SELECT
Folks
I am trialling MySQL 5 before we all upgrade, however others need to import
my dump files into their existing MySQL4.x databases
MySQL 5 mysqldump seems exports BIT fields as true = '', false = '\0'.
When that dump file is imported into MySQL 4 these value are not
interpreted
- Original Message -
From: John Mistler [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Monday, December 12, 2005 12:34 AM
Subject: Select Unique?
I have two tables 'table1', 'table2' with a matching column 'column1'. How
can I return all rows from table2 where the entry for
MySQL hangs every 30 minutes, it start to make a big process and when I make a
show variables I get that values:
+-+-+
| Variable_name | Value |
You are most welcome.
As a comment to Fester: sometimes even 40 tables are not enough for a
single application. Once you start dealing in enterprise-level data
systems, 40 tables is how many you wish you had. I am sure there are some
applictions using several hundred tables out there and
I do not have much experience with PHP or MySql although I have used SQL
quite a lot. I am going to set up a relatively small MySQL database
(circa
40 tables) and we are expecting a hit rate of about 40,000 visitors per
annum mostly browsing a relatively low number of pages each. We plan
We have an application that uses the libmysql libraries for email
archival. We have recently been getting killed because of
http://bugs.mysql.com/bug.php?id=4143. It seems that mysql keels over
during a big query on a large database and it will not let our client
write to the db until the
Just to give an example of what Shawn is saying is very TRUE.
My MS-Access databases department-wide, the largest one is - 39 tables.
On MySQL side enterprise-wide database - 340 tables
Best,
Mikhail Berman
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent:
I'm trying to get mySQL installed on my machine but im having a bit of
trouble, obviously :)
When i come to install mySQL server as below:
rpm -ivh MySQL-server-standard-5.0.16-0.rhel3.i386.rpm
I get this result:
warning: MySQL-server-standard-5.0.16-0.rhel3.i386.rpm: V3 DSA signature:
From: Lewis Ashley Foster [EMAIL PROTECTED]
I'm trying to get mySQL installed on my machine but im having a bit of
trouble, obviously :)
When i come to install mySQL server as below:
rpm -ivh MySQL-server-standard-5.0.16-0.rhel3.i386.rpm
I get this result:
warning:
[Apologies for my first post here being semi-off-topic!]
I normally deploys apps I develop (MySQL with Lasso web middleware) with an
ISP, so I have no experience of choosing hardware configurations or sourcing
them.
My current client's application involves a very large amount of data which I
James Harvard [EMAIL PROTECTED] wrote on 12/12/2005
10:26:42 AM:
[Apologies for my first post here being semi-off-topic!]
I normally deploys apps I develop (MySQL with Lasso web middleware)
with an ISP, so I have no experience of choosing hardware
configurations or sourcing them.
My
Subscriptions aka Jenifer wrote:
query: SELECT tblCustomer.*, tblNotes.note FROM tblCustomer LEFT
JOIN tblNotes ON tblCustomer.customerid = tblNotes.noteID WHERE
tblCustomer.customerid = 123
You are joining the customerid from the customer table to the noteID
from your notes table. You
Hi!
We have 2 MySQL servers and now we have purchased one more powerfull server and
want to combine the databases from the two older server into the new server.
Can we just make dumps from older server and make restores into new servers ?
What happen with databases users ? Can be dumped the
Oops, sorry, I was up too late writing that. I knew if I quickly typed in a
test query I would mess it up somewhere. sheesh. Here's the actual query:
SELECT ag_admin_cart.*, ag_paymethod.paymethod,
ag_paymethod.miva_module_id,
Merchant2_0001_customer_dbf.sql_bill_fname,
Rhino wrote:
- Original Message - From: John Mistler
[EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Monday, December 12, 2005 12:34 AM
Subject: Select Unique?
I have two tables 'table1', 'table2' with a matching column
'column1'. How can I return all rows from table2 where the
It doesn't seem like a mission critical app, but I would seriously
consider using redundant RAID (ie, not 0, but 1 or 5). Nothing ruins
your day quite like losing a non-redundant drive, even if you have
good backups.
Also, what sort of workload are you looking at? How responsive does it
need to
Well Roberto,
it could be anything... analyzing your my.cnf file and variables would
be looking through spagetti (i like spagetti ... but not in this flavour).
the time your database hangs, are the intervals random
minutes/seconds/hours? or is there a constant interval like precise on
30
Notes in-line
=C=
www.calevans.com
On Mon, 2005-12-12 at 18:33 +0100, Juan Jose Sanchez Mesa wrote:
Hi!
We have 2 MySQL servers and now we have purchased one more powerfull server
and want to combine the databases from the two older server into the new
server.
Yes, you can. I would shut
On Mon, 2005-12-12 at 15:20 +, Lewis Ashley Foster wrote:
warning: MySQL-server-standard-5.0.16-0.rhel3.i386.rpm: V3 DSA signature:
NOKEY, key ID 5072e1f5
error: Failed dependencies:
perl(DBI) is needed by MySQL-server-standard-5.0.16-0.rhel3
Suggested resolutions:
Hi all,
I'm curious if this is possible in 4.10: I have a table:
+--+-+--+-+---+--+
| Field| Type| Null | Key | Default | Extra|
+--+-+--+-+---+--+
|
Vince LaMonica [EMAIL PROTECTED] wrote on 12/12/2005 01:49:54 PM:
Hi all,
I'm curious if this is possible in 4.10: I have a table:
+--+-+--+-+---+--+
| Field| Type| Null | Key | Default | Extra |
Dear List,
I have mysql server and php apps on the same machine, they worked very well.
The machine's OS is win2k pro
Mysql 5.0.15
Then I access the db from local network area 192.l68 And it worked fine
although I
have to reset my account privileges..
Then I tried to access it remotely by
Could it be the firewall? You might want to open the port 3306 for
external access(or both). In my XP, I did this:
Firewall -- Advance-- Network Connection Settings --Select Local Area
Connection -- Click Setting, then you might want to 'add...', from there
filling your IP, 3306 for both ports.
Is there a tech term for this? User searches for reviews but the
actual word is review. So the search engine code searchs on bolth
words and user gets the hit they want...
What's this called? Is there a MYSQL implementation of this?
Thanks
--
MySQL General Mailing List
For list archives:
I'm sure the answer is You're SOL, but I figured I'd ask
anyway. I have a WHERE condition like:
SELECT *
FROM a
JOIN b
WHERE
(b1 IS NULL OR b1 = u1) AND
(b2 IS NULL OR b2 = u2) AND
(b3 IS NULL OR b3 = u3)
where b is a Very Large table. I have an index on b like
(b1, b2, b3), but obviously that
Hello.
ERROR 2003 (HY000): Can't connect to MySQL server on 'myDomain.com' (10061)
See:
http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html
YL [EMAIL PROTECTED] wrote:
I have mysql server and php apps on the same machine, they worked very well.
The machine's OS is
Hello.
What system load do 'top' and 'free' show? Use 'SHOW PROCESSLIST' to
determine what queries are running on the server if you're able to
connect to it. Check that mysqld isn't swapping.
Roberto Rodriguez Garrido wrote:
MySQL hangs every 30 minutes, it start to make a big
Hello.
Add --hex-blob to mysqldump command line options.
Adam Lipscombe wrote:
Folks
I am trialling MySQL 5 before we all upgrade, however others need to =
import=20
my dump files into their existing MySQL4.x databases
MySQL 5 mysqldump seems exports BIT fields as true
Hello.
Have a look here:
http://dev.mysql.com/doc/refman/5.0/en/log-file-maintenance.html
abdulazeem wrote:
Hi,
Iam running a mysql server version 5.0.15. My mysql query log is
occupying nearly 21 GB of disk space. how do i truncate the same ?
Thanks in advance,
Abdul.
Hello.
rpm -ivh perl-DBI-1.40-5.src.rpm
This rpm installs only the source of perl-DBI, install a binary rpm for
your architecture. You might need to use --force option for rpm command
in case you have a fresher working version of perl-DBI.
Lewis Ashley Foster wrote:
I'm trying
In the last episode (Dec 12), Eamon Daly said:
I'm sure the answer is You're SOL, but I figured I'd ask anyway. I
have a WHERE condition like:
SELECT * FROM a JOIN b WHERE
(b1 IS NULL OR b1 = u1) AND
(b2 IS NULL OR b2 = u2) AND
(b3 IS NULL OR b3 = u3)
where b is a Very Large table. I
In the last episode (Dec 12), Dan Nelson said:
In the last episode (Dec 12), Eamon Daly said:
I'm sure the answer is You're SOL, but I figured I'd ask anyway. I
have a WHERE condition like:
SELECT * FROM a JOIN b WHERE
(b1 IS NULL OR b1 = u1) AND
(b2 IS NULL OR b2 = u2) AND
(b3 IS
Yep, I forgot to mention that I'm using MySQL 4.1, which
does support ref_or_null, but only for the first column.
Eamon Daly
- Original Message -
From: Dan Nelson [EMAIL PROTECTED]
To: Eamon Daly [EMAIL PROTECTED]
Cc:
leegold [EMAIL PROTECTED] wrote on 12/12/2005 03:18:30 PM:
Is there a tech term for this? User searches for reviews but the
actual word is review. So the search engine code searchs on bolth
words and user gets the hit they want...
What's this called? Is there a MYSQL implementation of this?
I have done various searches, and cannot locate the perl dbi for mysql 5.0.16.
I assume that the old one for mysql 4 will not work.
Can someone please provide me the url for mysql 5's perl dbd/dbi bundle?
Thanks, Connie
Connie Logg, Network Analyst
Stanford Linear Accelerator Center
ph:
Just be glad you're not stuck supporting a product that was designed about
6 years ago. Hey, let's have each account get its own table
[db1:~] find -L /usr/local/mysql -name \*.frm | wc -l
8116
The programmer that designed that system is now synonymous with bad
design..
Atle
-
Flying
According to the Mysql online manual, to reset a root password one
procedure is to issue the command:
./mysqladmin --skip-grant-tables
to have full access to the database and update the root password as per
the instructions in the manual.
My problem is when I issue the command
./mysqladmin
does it absolutely HAVE to be 1u?
if you can go 2u we've been really happy w/HP DL385s lately. 2u form (which
is still pretty small for a DB server), redundant power supplies (a good
thing for DB server), six drive bays (so you can RAID5 or three mirror
pairs), remote management card and Opteron
Alfred Vahau wrote:
According to the Mysql online manual, to reset a root password one
procedure is to issue the command:
./mysqladmin --skip-grant-tables
to have full access to the database and update the root password as per
the instructions in the manual.
My problem is when I issue the
Hi mysql-list,
I just installed,
++
| version() |
++
| 5.0.16-log |
++
Here is what I am testing out: (simple table and data)
% echo 'a b c d' testfile
mysql CREATE TABLE `test` (
- `fe` VARCHAR( 2 ),
- `fi` VARCHAR( 2 ),
- `fo` VARCHAR( 2 ),
Michael Stassen wrote:
Alfred Vahau wrote:
According to the Mysql online manual, to reset a root password one
procedure is to issue the command:
./mysqladmin --skip-grant-tables
to have full access to the database and update the root password as
per the instructions in the manual.
My
Hi Elliot,
It is in the docs, just a little bit further down the page 8-)
LOCAL works only if your server and your client both have been enabled
to allow it. For example, if mysqld was started with --local-infile=0,
then LOCAL does not work. See Section 5.6.4, Security Issues with LOAD
DATA
Michael,
Thanks so much for the query. As I am surmising from your email, the
LEFT JOIN is the better way to go for performance. If you have any
reason to think I should go with the subquery, let me know!
Thanks again,
John
On Dec 12, 2005, at 9:57 AM, Michael Stassen wrote:
Rhino
Hello.
Follow instructions from:
http://dev.mysql.com/doc/refman/5.0/en/perl-support.html
Logg, Connie A. wrote:
I have done various searches, and cannot locate the perl dbi for mysql =
5.0.16.
I assume that the old one for mysql 4 will not work.
Can someone please
Best group member,
How can I prevent people from hijacking a query? I read this in an article
about a few months ago, but now I can not find that article again. This
question is maybe not so exact, and I do not know how risky it is to not
protect your system from database hijackers?
Can
Sorry to bother you once more on this David, but I am having trouble
figuring out how to run a query on tables in two different databases.
I normally use
/usr/local/mysql/bin/mysql -h localhost -u username -ppassword -D
databaseName -N -e SELECT ...
as the initial string of the query.
Hi John,
Just do a normal join as you would, for the second table reference it in
this fashion, databasename.tablename as xyz. Here is an example that
I've used myself
use test;
SELECT
s.name,
c.Street_addr_1,
c.Street_addr_2,
c.Town,
c.State,
c.PostCode,
Hi all,
I got this mail Id from mySQL lists.I would like to request you for one help.
Actually I need to track the changes(UPDATE,INSERT,DELETE and others) done on
the database in mySQL by different users. I need to know which user has done
what changes . I am using mySQL 5.0.16-nt.
I would like
Hi Satya,
You might like to look at triggers here
http://dev.mysql.com/doc/refman/5.0/en/triggers.html You can set a
trigger to go off at any of the events you have noted below. This would
allow you to log the userid and any other relevant information you need.
Regards
David Logan
Database
One further question on this topic ... What if I add a third table into
the mix, so that:
database contains -- table1 (column1, column2), table2 (column1,
column2, column3), table3 (column3)
What query will return all rows from table2 where the entry for
table2.column1 does not match any
On Tuesday 13 December 2005 02:25, Peter Lauri wrote:
Best group member,
How can I prevent people from hijacking a query? I read this in an article
about a few months ago, but now I can not find that article again. This
question is maybe not so exact, and I do not know how risky it is to
58 matches
Mail list logo