Marvin Cummings wrote:
Have a strange problem where only one of my databases shows up in the
MySQLCC console, yet if I look in the MySQL Admin console all databases
are seen. Anyone experience this before?
If you right-click the server entry in MySQLCC and select Edit, there
is a Databases tab
Mos forgot to populate the url_id column in your user table. I would use
his same process but re-arrange it like this:
1) create table BIG_TABLE
2) load data infile
3) create table URL_TABLE (
url_id bigint not null auto_increment,
url varchar(25) not null primary key,
From a Windows2000 machine, I use ODBC Data Source Administrator to
connect to mysql server on RedHat ES 3. I got the following message.
[MySQL][ODBC 3.51 Driver] Host 'IP_address' is not allowed to connect to
this MySQL server
Any idea?
Thanks,
Joseph
--
MySQL General Mailing List
For list
You should check your privileges in mysql server. Look at the Host field in
mysql.user table. Probably that is the problem and change the value to the
Windows IP address. And don't forget to make FLUSH PRIVILEGES..
Ref: http://dev.mysql.com/doc/mysql/en/User_Account_Management.html
Best
Hi, ppl!
I have a MySQL-server on FreeBSD-5.2.1 computer and a client on another
computer under windows xp.
I have the following simple query SELECT internal_number,page_no FROM
pages WHERE docs=307 ORDER BY page_no
that results in 587 lines with two integers only.
Simple query with low
Losing some message body too :-?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: 18 June 2004 13:11
To: [EMAIL PROTECTED]
Subject: Losing some records
Disclaimer
http://www.shoprite.co.za/disclaimer.html
--
MySQL General Mailing List
For list
Hi,
The following table produces a query that shows all bookings that user has
made and groups the number of bookings by the users location code.
mysql SELECT COUNT(B.Booking_ID), User_Location FROM Bookings B, Users U
WHERE U.User_ID = B.User_ID GROUP BY(U.User_Location);
At the momnet if no
Hi,
you can use:
SELECT COUNT(B.Booking_ID), User_Location
FROM Users U
LEFT JOIN Bookings B ON U.User_ID = B.User_ID
GROUP BY(U.User_Location);
/Johan
shaun thornburgh wrote:
Hi,
The following table produces a query that shows all bookings that user
has made and groups the number of bookings by
You can use a Left Outer Join. Left Outer Join will include all that
matches as well as that which doesn't. The resulting NULL entries for the
count will evaluate to 0.
SELECT COUNT(B.Booking_ID), U.User_Location FROM
Users U
LEFT OUTER JOIN
Bookings B
ON
U.User_ID = B.User_ID GROUP
I recieve a delimited file whose fields are:
day,slot,subject,room
An example of this file is:
2,1,Mat,R1
3,1,Sci,R6
1,2,Sci,R6
3,2,Mat,R3
1,3,Eng,R2
2,3,Eng,R5
1,4,Mat,R7
3,4,Eng,R9
I need a mysql query that will generate a timetable which looks like:
Day1Day2Day3
Your explain plan should not change based on the client you are using. The
explain plan is the path for the query not the return of data to the client.
Are you using sockets when connecting locally on the Free-BSD machine?
Sockets are normally faster than using the tcp/ip port.
-Original
No problem!!
Please post the structures of your big_table and your url_table
(whatever you called them) and I will help you to rewrite step 4 to count
how many times a URL appears in the big_table.
Is this bulk import a process you need to do repeatedly? if so we need to
worry about updating
Shawn,
Thanks for helping on this. I really appreciate it.
No problem!!
Please post the structures of your big_table and your url_table
(whatever you called them) and I will help you to rewrite step 4 to count
how many times a URL appears in the big_table.
mysql desc internet_usage;
Hi All,
We have recently acquired some new machines for our ASP service, and I
am investigating different options and setups to optimize everything.
We currently have one large DB server, with RAID5, etc, running mysql
and a few smaller servers for web applications, and e-mail. These
smaller
What you are trying to do is an example of what is called pivoting a
table or creating a pivot table.
SELECT slot
, max(if(day=1, concat(subject,' ',room), '')) as day1
, max(if(day=2, concat(subject,' ',room), '')) as day2
, max(if(day=3, concat(subject,' ',room), '')) as day3
I would need log-bin and log-slave-updates enabled on the slave, correct?
So to automate the process it would be better to start both servers
without the Master-host info in the conf file, letting Heartbeat issue the
commands on startup to convert one box to slave. During a fail-over,
If the server has log-bin enabled it will log writes. If you have a
daisy-chained master, one that serves as a master to other slaves, you will
need to have log-slave-updates enabled. If this server is just another
machine pulling from the master it is not necessary to log slave updates but
it is
Hi all,
i try to simulate dBase-like record-skips through a compound
(dbf-) order. Anybody did that before? Please give me a hint.
thx in advance,
TomH
--
PROSOFT EDV-Lösungen GmbH Co. KG phone: +49 941 / 78 88 7 - 121
Ladehofstraße 28, D-93049 Regensburg cellphone: +49 174 / 41 94 97 0
Go for a simple MySQL master - slave configuration. I'm runing 1
master 3 slaves for performance issues and doesn't have any problem at all
for 1 year.. Of course in this case you should change some code in your
webservers to direct SELECT queries to slave machine to gain performance on
the
In article [EMAIL PROTECTED],
Sam Russo [EMAIL PROTECTED] writes:
I recieve a delimited file whose fields are:
day,slot,subject,room
An example of this file is:
2,1,Mat,R1
3,1,Sci,R6
1,2,Sci,R6
3,2,Mat,R3
1,3,Eng,R2
2,3,Eng,R5
1,4,Mat,R7
3,4,Eng,R9
I need a mysql query that will
JS,
I need one more piece of information to help make that query work for you,
I need the structure of the table that you use (or would use) to bulk
import those logs into.
If you are running out of room you may consider further normalizing you
data (which saves space, but creates more data
Shawn,
Thanks for the email below - I will go through it over later tonight in more
detail (going home time now!) although I can already see good points there.
JS,
I need one more piece of information to help make that query work for you,
I need the structure of the table that you use (or would
Hi,
yesterday I installed the 4.0.20 binaries, compiled with Intel C++ Compiler from
mysql.com.
I tried to transfer one of our (small) databases from the production-system (4.0.20
gcc binaries installed) to the test-system and came across the following problem:
I did a mysqldump --opt ... |
[EMAIL PROTECTED] wrote on 18/06/2004 15:09:58:
I would need log-bin and log-slave-updates enabled on the slave,
correct?
So to automate the process it would be better to start both servers
without the Master-host info in the conf file, letting Heartbeat issue
the
commands on startup
I currently run LVS (pre-distribution) on my farm, which gets about 100M
hits/month.
Good points about LVS are that it is completely rock solid, and runs on
minimal hardware.
I have never run MySQL behind it, as I think that would be a bit flaky for
a live site. Probably
worth checking out
I'm using mysql-3.23.58-1.9 installed from RPM on Red Hat Linux release
9 (Shrike). First, I create a database and user to connect to this
database using the following commands:
mysql CREATE DATABASE foo;
mysql GRANT ALL PRIVILEGES ON foo.* TO foo@'%'
IDENTIFIED BY 'password' WITH GRANT
Harald Fuchs wrote:
Sam Russo [EMAIL PROTECTED] writes:
I recieve a delimited file whose fields are:
day,slot,subject,room
An example of this file is:
2,1,Mat,R1
3,1,Sci,R6
1,2,Sci,R6
3,2,Mat,R3
1,3,Eng,R2
2,3,Eng,R5
1,4,Mat,R7
3,4,Eng,R9
I need a mysql query that will generate a timetable which
Unless you have a specific need for it, you could save yourself a lot of
trouble by putting select tables or databases or even clients on each
server. This also means you don't incur the added overhead of keeping the
database in sync, creating actions if a master goes down, etc. Then just
Hi list. Can someone give me a working example of a SQL CASE statement(in
SELECT)? I have examples for stored procedures, but none for use within the
DML side of SQL.
I am trying to in my SELECT (used in PHP) create a variable/col for example:
status='high' where value in a other col is
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 18 June 2004 11:05 am, Mike Miller wrote:
Unless you have a specific need for it, you could save yourself a lot of
trouble by putting select tables or databases or even clients on each
server. This also means you don't incur the added
Cao, Wenhong wrote:
I am trying to select the records where the field activationtimestamp is
within a certain range. Unfortunately the field activationtimestamp is
defined as character(14) in the table.
Perhaps you should change the type of activationtimestamp:
ALTER TABLE SubscriptionVersion
I have used the CASE statement for ordering many times. It's very useful...
SELECT
myDATA,
CASE
WHEN data2 = SomeValue
THEN 0
ELSE
WHEN data2 = SomeOtherValue
THEN 1
ELSE
2
END
AS mySort
from MyTable Where myConstraints.
God Bless
Paul C. McNeil
Developer in Java, MS-SQL, MySQL, and web
The meaning of that was client-side being sending inserts/updates to the
master server. This would be done in the program/script upon an insert
query.
A daemon could forward insert/update requests to a master and all others
round-robin and simply pass packets. This is if you have to make it
The CASE function is documented in the manual
http://dev.mysql.com/doc/mysql/en/Control_flow_functions.html.
SELECT CASE
WHEN other_col 100 THEN 'low'
WHEN other_col BETWEEN 100 AND 1000 THEN 'medium'
WHEN other_col 1000 THEN 'high'
END AS col
FROM your_table;
Michael
Rafi
Hi,
Can someone explain how the data is stored in a table using a clustered
index.
Does this mean that the data is inserted in the .myd file in sorted
index order ?
If so, how is space made to insert the new records ?
Does this make inserting records slow because data is being inserted in
Hi,
If I have a table with 100 - 200 million rows and I want to search
For records with specific characteristics.
Ex.
Skills varchar(300)
Skill id's 10 15
Accounting finance etc.
Is it advisable to created a field with skill ids and then use the
Hi all,
I want to load a Master table millions of rows for other sources with a
unique index on e.g. ssn social sec number.
If inserted records have a duplicate SSN I don't want to insert those
but put them in a duplicate table or flag them.
.
The primary key will be an auto-increment
Ivan,
- Original Message -
From: Ivan Latysh [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, June 17, 2004 7:44 PM
Subject: Dying query
Hello!
I am running:
Server version 4.1.2-alpha-max-log
On linux RedHat.
When I execute a simple select,
Hello List,
I have done some googling around but can't find an answer to this one. Brand new box,
installed with RedHat 9 and trying to run 4.1.2. This is what I get.
--ja
[EMAIL PROTECTED] mysql]# scripts/mysql_install_db --user mysql --log
Installing all prepared tables
040618 11:06:51
Hi,
I guess since it is documented, it is a new feature - I agree with the
principal of not backporting it.
Many thanks for the reply - can't wait for 4.1 to mature :-)
Thanks,
Mike
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]
Sent: 15 June 2004 13:00
To: Mysql
Dear Mark,
You should be tweaking your mailer such that your mails originate fom
[EMAIL PROTECTED], and not my own email address.
Thanks,
Mike
-Original Message-
From: Michael McTernan
Sent: 27 May 2004 10:00
To: [EMAIL PROTECTED]
Subject: Mysqld stalls
I've been trying to fine
Dear Mark,
Is anyone experiencing problems with MySQL 4.0.17-max (other
versions) and a
lot of I/O type errors on large databases or especially running phpBB?
This can be fixed by sending emails from your own email address
([EMAIL PROTECTED]), and not mine.
Thanks,
Mike
-Original
I took the certification exam this morning and passed. When should I
expect to receive the certificate (and other items) in the mail?
--bmansell
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dear Mark,
Please set your from address to [EMAIL PROTECTED], and don't
use my email address.
Thanks,
Mike
-Original Message-
From: Michael McTernan
Sent: 16 April 2004 10:21
To: Joseph A. Nagy, Jr.; MySQL General
Subject: Re: PHP + MySQL Not Playing Nice Any More
On 4/15/04
Dear Mark,
And when I go to move them to the new db, I do use the mysqldump command
since I am dumping to the new db?
You need to correctly setup your mailer such that the from address is
[EMAIL PROTECTED], and not my email address.
Thanks,
Mike
-Original Message-
From: Michael
Dear Mark,
I think your emailer has also experienced corruption since your from address
is actually mine. Please set it to your own email address, such as
[EMAIL PROTECTED]
Thanks,
Mike
-Original Message-
From: Michael McTernan
Sent: 09 April 2004 12:18
To: [EMAIL PROTECTED]
Dear Mark,
You also seem to have used my email address before. Please correctly
configure your mailer such that the from address is correctly reported as
[EMAIL PROTECTED], and not mine.
Thanks,
Mike
-Original Message-
From: Michael McTernan
Sent: 08 April 2004 18:36
To: [EMAIL
Dear Mark,
The best way to fix this is by correctly setting your from address in your
mailer to [EMAIL PROTECTED]
Thanks,
Mike
-Original Message-
From: Michael McTernan
Sent: 08 April 2004 10:33
To: [EMAIL PROTECTED]
Subject: Too Many Connections
What is the best way to
Hello All,
I have a design question
I have a table that represents a Newsletter page.
This newsletter can be single or 2 columns
Here is my question.
Currently the table is defined as
Int articleID
Int pagenum
Texttitle
Textbody
Texttitle2
Textbody2
So here is my
welcome to a basic overview of bulk importing and normalizing as
you go
[ author's note: if you are seeing this thread for the first time and
certain items seem to be
introduced out of context, please review all previous posts in this thread.
There has been
a lot of
Hi John,
Depending on the size of your datasets, you could merge the data into a
TEMPORARY table and then compute from there? If the temp table is small
enough it will fit in RAM as a heap table, and will probably be more
efficient than fetching all the results and computing them in code. Of
Hi Mike,
This is a good suggestion. We ended up changing the requirements to not
require the functionality I was trying to develop at the time. However,
I did just change a temporary table I'm using for a similar process to
HEAP and saw a very nice perfomance improvement. Should have thought
I agree with Mike.
In order to use the aggregate functions across both tables' worth of data
you will have to combine them into one large table. That can be a real
table or a temporary one but in either case you are stuck combining them
BEFORE the calculations or MySQL won't be able to crunch
I am unable to install DBD::mysql in my environment shown below
RedHat Linux 9
perl v5.8.0
DBI-1.42
mysqld Ver 4.0.18-standard
After unzipping and untarring the DBD-mysql-2.9003.tar.gz ( obtained from CPAN ), in
the DBD-mysql-2.9003 directory
I tried the following
mkdir /tmp/mysql-static
cp
Hello,
I need some help tuning mysql. I'm running 3.23.58-Max-log on a Red Hat
Linux Enterprise server with 1 gig of memory and 4 cpus. The database is
used by a web application which runs on a separate machine. The performance
is not so good. Can anybody tell me if my configurations are
It looks like mysql does not own the data directory.
[EMAIL PROTECTED] wrote:
Hello List,
I have done some googling around but can't find an answer to this one. Brand new box,
installed with RedHat 9 and trying to run 4.1.2. This is what I get.
--ja
[EMAIL PROTECTED] mysql]#
I really like the Certification Study Guide we just ordered last week.
Great info that I'd wish I had when I started. I have no plans to take the
test, but I love the way the info is presented and the questions at the end
help ensure I got it.
Lou
- Original Message -
From: Bartis,
Hi, I'm trying to figure out how to apply these from the manual, but to
no avail. Is it possible that my version (4.0.18) does not implement
these?
I have two tables: products and products_by_product_area. Both have a
field product. I try
SELECT product from products WHERE NOT EXISTS (SELECT
First, you'll get more help if you post to the list (Mysql General mailing
list [EMAIL PROTECTED])
All the --console does is directs error messages to the console, i.e., the
dos window you have open.
If you leave it off the error messages go to a file.
What you describe below
without --console
You are using a subquery. Subqueries are only supported in version 4.1 and
later. You will eithe rneed to rewrite your query so that it doesn't use a
subquery, or upgrade.
Cheers
Andrew.
- Original Message -
From: Anton Ivanov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June
Subqeries require mysql 4.1.
The manual offers some suggestions on rewriting subqueries as JOINs
http://dev.mysql.com/doc/mysql/en/Rewriting_subqueries.html.
In your case, you want something like:
SELECT product FROM products p
LEFT JOIN products_by_product_areas a ON p.product = a.product
I hope someone can help me with a problem. I recently changed one of my web
servers over to a new box and this server has an internal MySQL server which
is used to store several web queried databases. My old server ran Apache
1.3.27 and my new one is running 2.0.49 - Old MySQL was 3.2.23 and
Thanks, I just found that relevant section in the manual, too. I wish
it was clearer what version the manual documents -- I am using (almost)
the latest stable release, and I should expect that the manual documents
that.
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
I hope someone can help me with a problem. I recently changed one of my web
servers over to a new box and this server has an internal MySQL server which
is used to store several web queried databases. My old server ran Apache
1.3.27 and my new one is running 2.0.49 - Old MySQL was 3.2.23 and
Sorry about the characters in the last post. Spambots didn't like it
I hope someone can help me with a problem. I recently changed one of my web
servers over to a new box and this server has an internal MySQL server which
is used to store several web queried databases. My old server ran Apache
We have a table with a primary index which is INT NOT NULL
AUTO_INCREMENT.
After inserting ~87,000,000 entries, we started seeing error 1062,
ER_DUP_ENTRY.
We can get going again after doing an ALTER TABLE to reset the
auto_increment starting point, but this takes about an hour...
I've seen
on 06/18/2004 05:16 PM, Kevin Brock at [EMAIL PROTECTED] wrote:
We have a table with a primary index which is INT NOT NULL
AUTO_INCREMENT.
After inserting ~87,000,000 entries, we started seeing error 1062,
ER_DUP_ENTRY.
We can get going again after doing an ALTER TABLE to reset the
Appreciate any help at all
Thanks, Paul
-Original Message-
From: Paul Chu [mailto:[EMAIL PROTECTED]
Sent: Friday, June 18, 2004 10:16 AM
To: [EMAIL PROTECTED]
Subject: Fastest way to load a master table removing duplicates
Hi all,
I want to load a Master table millions of rows
Appreciate any help at all
Thanks, Paul
-Original Message-
From: Paul Chu [mailto:[EMAIL PROTECTED]
Sent: Friday, June 18, 2004 10:16 AM
To: [EMAIL PROTECTED]
Subject: Full Text Index on Large Tables
Hi,
If I have a table with 100 - 200 million rows and I want to search
For
Appreciate any help at all
Thanks, Paul
-Original Message-
From: Paul Chu [mailto:[EMAIL PROTECTED]
Sent: Friday, June 18, 2004 10:16 AM
To: [EMAIL PROTECTED]
Subject: Clustered Index - Where is data inserted ?
Hi,
Can someone explain how the data is stored in a table using a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 18 June 2004 12:52 pm, Michael McTernan wrote:
Dear Mark,
The best way to fix this is by correctly setting your from address in your
mailer to [EMAIL PROTECTED]
Your email software seems to be wrong. All these people can't be doing
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 18 June 2004 03:00 pm, Kairam, Raj wrote:
After unzipping and untarring the DBD-mysql-2.9003.tar.gz ( obtained from
CPAN ), in the DBD-mysql-2.9003 directory I tried the following
mkdir /tmp/mysql-static
cp /usr/lib/mysql/*.a
Hi! I'm trying to build MySQL 4.0.20 on RedHat 5.2 (I think) Linux
system with glibc-2.2.5 and gcc-3.4.0 (which I recently upgraded to).
The compile runs smoothly, but make test fails. Here is my configure
command:
$ ./configure --prefix=/usr/local/mysql-4.0.20 --enable-assembler
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 18 June 2004 11:48 pm, Tom Williams wrote:
Hi! I'm trying to build MySQL 4.0.20 on RedHat 5.2 (I think) Linux
system with glibc-2.2.5 and gcc-3.4.0 (which I recently upgraded to).
The compile runs smoothly, but make test fails. Here is
75 matches
Mail list logo