Sounds like you have any empty database, from the messages
below.
Try adding a new dummy database, and some test data.
See if you can do some selects on that test data.
Keith
In theory, theory and practice are the same;
In practice they are not.
On Fri, 24 Feb 2006, Rithish Saralaya wrote:
solved :)
Thanks :-)
Peter wrote:
Hello,
I read the manual(http://dev.mysql.com/doc/refman/5.0/en/mysqlhotcopy.html)
and especially:
" Back up tables in the given database that match a regular expression:
shell> mysqlhotcopy db_name./regex/
The regular expression for the table name can be n
Hello,
I read the manual(http://dev.mysql.com/doc/refman/5.0/en/mysqlhotcopy.html)
and especially:
" Back up tables in the given database that match a regular expression:
shell> mysqlhotcopy db_name./regex/
The regular expression for the table name can be negated by prefixing it
with a tilde
>Now this query is run over two tables and the ab_members table
contains
>around 302 rows. Around 1/3 of these will be where cup=kids.
However,
>when this query is run it returns 20,700 results
That's because your ...
FROM ab_leader_board ablb, ab_members abm
calls for a cross join--it a
Hello.
The tables were working perfectly fine a week back. The database was created
from a sql file generated through the mysqldump utility. So there was
nothing wrong with the database. This irregularity happened this week
onwards.
Our system admins tell us that the server was restarted last wee
Hi,
How can I keep the account of MySQL independent in replication?
We have two MySQL 4.1.18 nodes: A and B. B replicate A. We want that the
account in A is independent. That is to said, it would not affect the
account in B when we add or delete the account in A.
We add the following option in B
I have tried giving 777 permissions on the files. Nothing happens.
All mysql processes run as 'mysql' except mysqld-safe, runs as root.
I am not on Windows. All the table names are in upper case. I don't have the
lower case setting in my.cnf also.
The 'datadir' is /var/lib/mysql/ This is where t
On Thu, 2006-02-23 at 21:46 -0600, Walter Johnson wrote:
> >> #chown mysql:mysql /var/mysql-data
> >> #chmod 770 /var/mysql-data
Try this, assuming the files are in there for the database.
$chown -R mysql:mysql /var/mysql-data/*
$chmod -R 770 /var/mysql-data/*
Hope that helps.
--
Best regards
On Thu, 2006-02-23 at 22:04 -0500, Mathieu Bruneau wrote:
> Ok I got 2 informations for you:
>
> 1) IPv4 address are actually 32 bit integer, easily store in 32 bits
> fast search etc etc etc (You can google for more on this storage
> format). Normally you could find a way to goes from the string
Dan Trainor wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Walter Johnson wrote:
This is probably a simple question. I installed MySQL about a month ago
on Mac OS X and I am new to this. During the installation (as root) I
created a directory /var/mysql-data. Then, following the ins
Hi, there,
I am new to Mysql world, please forgive me if the question sounds dumb.
I am looking for if it is possible, that upon a record operation at the
database table, a event/notification is sent to a client process. The
database we are currently using implement this feature by post a event
CodeHeads a écrit :
> On Wed, 2006-02-22 at 16:49 -0600, Ariel Sánchez Mora wrote:
>> So far i've been able to store ip addresses as strings like you would
>> type them in DOS, for ex, '192.168.0.1'. This serves me great since my
>> application uses IP addresses as strings in all cases. I've done
>
Hi all...
I have some OLD programs I don't have the source for that were built with
the MySQL 3.23.55 client libraries. They still work great, even when using
those libraries to connect to 4.1.18 Mysql (I have a copy of the old lib in
the new lib dir)
However, is there some way I can build a 3.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Walter Johnson wrote:
> This is probably a simple question. I installed MySQL about a month ago
> on Mac OS X and I am new to this. During the installation (as root) I
> created a directory /var/mysql-data. Then, following the installation
> instruc
This is probably a simple question. I installed MySQL about a month ago
on Mac OS X and I am new to this. During the installation (as root) I
created a directory /var/mysql-data. Then, following the installation
instructions:
#chown mysql:mysql /var/mysql-data
#chmod 770 /var/mysql-data
Th
A simple search on google for
mysql fulltext indexing
provided many links, including:
http://jeremy.zawodny.com/blog/archives/000576.html
http://epsilondelta.wordpress.com/2006/02/08/dissecting-mysql-fulltext-indexing/
(overviews of how it works)
and
http://dev.mysql.com/doc/refman/5.0/en/full
What are the permissions on the files? Which user runs mysql? If
you're not on Windows, is the case the same? When you type "mysqld
--print-defaults" (or whatever your mysql server binary is), what
directory shows up under "datadir"? Is it the same directory?
Sincerely,
Sheeri
On 2/23/06, Ri
Denis Solovyov wrote:
If I compile mysql from sources with gcc 3.3.4 on linux 2.4 with glibc
2.3.2, how stable will mysqld be with lots (more than 500) of
simultaneous connections?
Does the issue described in the documentation for glibc 2.2 (big default
STACK_SIZE causes mysqld in
Scott,
If you Left Join to o and oi, and add 'OR oi.product_id IS NULL) to the
WHere clause, I think you have it.
SELECT p.id, oi.prod_name, sum(oi.quantity) as qty
FROM products as p
LEFT JOIN order_items as oi
ON (p.id = oi.product_id)
LEFT JOIN orders as o
ON (o.id = oi.order_id)
WHERE ( o
* [EMAIL PROTECTED] <[EMAIL PROTECTED]> [060223 09:09]:
> Tim Johnson <[EMAIL PROTECTED]> wrote on 02/23/2006 12:26:35 PM:
> > I need the most efficient way to do this: examples, keywords, and
> > URLs to relevant documentation are all welcome.
<>
> First off, columns can either be numeric or
Actually I am looking for duplicates (vedor_no, date), but I think I can
hopefully adapt the solution you have given me.
[EMAIL PROTECTED] wrote:
If you are looking just for duplicate (ID,vendort_no) combinations, this will
find them:
SELECT ID, vendor_no, count(1) as dupes
FROM table_name
I hate remembering crap like this AFTER I hit send...
Because we want to limit our sum() to only those rows that match the ORDER
conditionals, we have to change our formula to recognized when to count
and when to not count an order_item.
SELECT p.id, p.prod_name, sum(if(o.id is null,0,oi.quanti
If you are looking just for duplicate (ID,vendort_no) combinations, this
will find them:
SELECT ID, vendor_no, count(1) as dupes
FROM table_name_here
GROUP BY ID, vendor_no
HAVING dupes >1;
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Richard Reina <[EMAIL PROTECTED]> wr
Sorry - I am trying to cut back to just 2 pots of coffee per day and I the
lack of caffeine can make me a little fuzzy :-) Thank you for being
patient with me.
You have a working query, we just need to convert your INNER JOINs to
LEFT JOINs and move your join-specific WHERE conditions into th
I's so sorry. You are very correct. The sample data is bad. ID should be
unique. Here it is corrected.
|ID| vendor_no| date|
|2354 | 578 | "2005-12-23"|
|2355 | 334 | "2005-12-24"|
|2356 | 339 | "2005-12-26"|
|2357 | 339
Tim Johnson <[EMAIL PROTECTED]> wrote on 02/23/2006 12:26:35 PM:
> Let's say I have a query that performs
>
> "select * from Account"
>
> one of the columns from "Account" (city) is actually a key which may
> be either numeric or character.
>
> There is a table called "City" which contains keys
> You're right. It was a dumb cut-and-paste mistake.
>
> LEFT JOIN orders as o
> on o.product_id = p.id
>
> If fixing this doesn't give the correct results: What's missing? What's
> incorrect? Please help us to help you.
Orders does not have a product_id column.
Let me see if I can expla
Yeah, I know about that... But the 4.1.18 client/server isn't there.. Only
4.0.7 or some such older version.
Thanks!
-Original Message-
From: Julian C. Dunn [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 23, 2006 9:39 AM
To: Don O'Neil
Cc: mysql@lists.mysql.com
Subject: Re: MySQL 4.
On Thu, 2006-02-23 at 09:28 -0800, Don O'Neil wrote:
> Where are the client libraries and such for the FreeBSD 4.x Build of MySQL
> 4.1.18? I downloaded the MAX binary yesterday, and tried to install it, but
> none of the libmysqlclient files are present in the distribution.
>
> Do I need to dow
On Thu, 2006-02-23 at 10:49 -0600, Ariel Sánchez Mora wrote:
> Probably the problem is in php, or, more probably, in how you store first and
> then look for the IP address in your query. You should try your query in the
> mysql console; varchars work almost with anything and I put this example
>
Where are the client libraries and such for the FreeBSD 4.x Build of MySQL
4.1.18? I downloaded the MAX binary yesterday, and tried to install it, but
none of the libmysqlclient files are present in the distribution.
Do I need to download the sources and build it, or are the client files
located
Let's say I have a query that performs
"select * from Account"
one of the columns from "Account" (city) is actually a key which may
be either numeric or character.
There is a table called "City" which contains keys and names of cities.
and I want the City.Name value where Account.city matches C
Richard,
If you mean with _both_ the same id _and_ vendor id, try this:
Select id, vendor_id, count(*) from tablename group by id, vendor_id;
If you just want separate counts for id and vendor_id, use:
Select id, count(*) from tablename group by id;
Select vendor_id, count(*) from tablename gr
> I am a novice when it come to queries such as this and was hoping
> someone could help me write a query that tells me how many records
> have the same ID and vendor number.
>
> |ID| vendor_no| date|
> |2354 | 578 | "2005-12-23"|
> |2355 | 334 |
Probably the problem is in php, or, more probably, in how you store first and
then look for the IP address in your query. You should try your query in the
mysql console; varchars work almost with anything and I put this example where
I look for an IP address with your table, and it finds it corr
I am a novice when it come to queries such as this and was hoping someone
could help me write a query that tells me how many records have the same ID and
vendor number.
|ID | vendor_no | date|
|2354 | 578 | "2005-12-23"|
|2355 | 334 | "2005-12-24
> Again, I implore all SQL coders to use the explicit JOIN syntax on all
> platforms that support it (Oracle being a well-known exception). It makes
Oracle supports the ANSI JOIN syntax from v9 and up.
> Shawn Green
As for the rest, I fully agree.
Martijn Tonies
Database Workbench - development
Schalk <[EMAIL PROTECTED]> wrote on 02/23/2006 08:55:01 AM:
> George Law wrote:
> > Schalk ,
> >
> > You need to specify the unifying column between your ablb and abm
tables.
> >
> > ie - in your where, "and ablb.id=abm.id"
> >
> > Once you get this so it returns expected results, you can run the
James Harvard <[EMAIL PROTECTED]> wrote on 02/22/2006
08:53:56 PM:
> At 5:08 pm -0800 22/2/06, Scott Haneda wrote:
> >I think we are close, thanks
> >ERROR 1120: Cross dependency found in OUTER JOIN. Examine your ON
> >conditions
>
> > > SELECT p.id, p.prod_name, sum(oi.quantity) as qty
> >> FR
Yoed Anis wrote:
Hi all,
I'm trying to do the following.
I have three table:
Table a has address information:
address_id | City | State | Zip
1Austin TX 78758
2 Dallas TX 77000
3 Galveston TX 77550
Table b has information about the location:
address_id | Location_id | Location_na
After some problem on the index of a tables defined therefore:
CREATE TABLE `artmain` (
`art_codice` varchar(22) character set latin1 collate latin1_bin NOT
NULL default '',
`art_descr` varchar(60) NOT NULL default '',
`art_suppl` int(8) NOT NULL default '0',
`art_origi` char(1) NOT NULL d
Rithish,
the table definition does not exist in the ibdata file. You have the
.frm file and the .ibd file, but that does not help if the table
definition is not stored in the ibdata file.
How did you end up in this situation? Did you move .frm and .ibd files
around? Did you recreate the ibda
I'm in doubt. What binary (not RPM) should I choose for linux 2.4 with
glibc 2.3.2?
Actually, I believe that 'Linux (x86, glibc-2.2, "standard" is static,
gcc)' (mysql-standard-5.0.18-linux-i686.tar.gz)and 'Linux (x86)'
(mysql-standard-5.0.18-linux-i686-glibc23.tar.gz) will both wor
If I compile mysql from sources with gcc 3.3.4 on linux 2.4 with glibc
2.3.2, how stable will mysqld be with lots (more than 500) of
simultaneous connections?
Does the issue described in the documentation for glibc 2.2 (big default
STACK_SIZE causes mysqld instablity) affect glibc 2
George Law wrote:
Schalk ,
You need to specify the unifying column between your ablb and abm tables.
ie - in your where, "and ablb.id=abm.id"
Once you get this so it returns expected results, you can run the
query, prefaced with
"explain" and it will give you an idea on the way mysql is runni
"ls -l" results for the file.
-rwxrwxrwx1 mysqlmysql5863636992 Feb 19 05:20
TBL_FORUM_MSG_BODY.ibd
Tried su to mysql user. able to cat the above file.
"lsattr" results for the file.
- TBL_FORUM_MSG_BODY.ibd
Hope that helps.
Regards,
Rithish.
-Original Message-
When 5.0 came out, I saw an article or white paper or something with an
example of a stored procedure (I think, maybe a trigger) that allowed
you to transparently encrypt a column so that even if a database backup
was stolen, that column wouldn't be exposed to the thieves. I believe
that the examp
Try to help
Please give us the "ls -l" result of this file, also make sure that the
owner of mysql process could read this file
how to test?
Try to "su" to mysql user, and try to open the file, using "cat" or
other command
If you can't, maybe parent directory is not permitted this user to rea
Hi Rithish,
I'm all out of ideas with this one, sorry I can't be of more help.
Perhaps Mr Tuuri or others with more nouse than myself can help.
Regards
---
** _/ ** David Logan
*** _/ *** ITO
Schalk ,
You need to specify the unifying column between your ablb and abm tables.
ie - in your where, "and ablb.id=abm.id"
Once you get this so it returns expected results, you can run the query,
prefaced with
"explain" and it will give you an idea on the way mysql is running the
query. Thi
Greetings All,
Please have a look at the following query:
SELECT abm.mem_number, abm.first_name, abm.last_name,
abm.area_represented, abm.age, abm.sex, abm.cup,
ablb.*, ablb.jp + ablb.rc + ablb.fsmgp + ablb.gmc + ablb.saly +
ablb.nwgp + ablb.ecgp + ablb.sams + ablb.wcc + ablb.kzngp + ablb.emc
51 matches
Mail list logo
