which method is better to do.
I have 5 tables. They represent sections/parts of a companies
standards. There are 13 main categories, each of those categories
has subsections (some with 3, some with 10 or more), those
subsections have subsections, etc.
Which table design is better to do.
T
http://mysql.com/news-and-events/sun-to-acquire-mysql.html
--
/Brett C. Harvey;
/Creative-Pages.Net, President;
/Facility Management Systems, CTO (www.waldo.com/www.fmsystems.biz);
/Lasso Professional Alliance Member
http://www.reuters.com/article/mergersNews/idUSWNAS661820080116
--
/Brett C. Harvey;
/Creative-Pages.Net, President;
/Facility Management Systems, CTO (www.waldo.com/www.fmsystems.biz);
/Lasso Professional Alliance Me
Does not having a Primary Key and No indexes really speed up inserts
significantly?
We have a log table. it has the fields, cart_id, referer, remote_ip,
server_name, user_agent, company, action, type, and value that we are
tracking vistor log information for our ecommerce site. Every page
is
David,
that error is only when doing a stop/shutdown. So it doesnt make a
lot of sense that would be the problem.
Here's the log where I did a stop and start.
060724 20:54:25 [Note] C:\Program Files\MySQL\MySQL Server
5.0\bin\mysqld-nt: Normal shutdown
060724 20:54:25 [ERROR] Error readin
David,
It is pointing correctly. Plus, I can use a mysql browser and 3rd
party tools on the slave server and read the databases/tables
properly.
I've tried stopping and restarting. I've rebooted... I'm baffled
too, obviously. lol
Thanks!
Brett
I am absolutely baffled as to how the
David,
Thanks for attempting to help.
When I look at my show slave status, its updating. When I look at
the FMSbuilding-relay-bin, its updating! It has the information
that's taken place on the master server. I can see information in
the FMSbuilding-relay-bin on the slave server that I did
Australia
invent
---
-----Original Message-
From: Brett Harvey [mailto:[EMAIL PROTECTED]
Sent: Monday, 24 July 2006 9:51 PM
To: mysql@lists.mysql.com
Subject: RE: Repli
David,
mysql> show master status\g
+---+--+--+--+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+---+--+--+--+
| FMSweb-bin.01 | 903763 | |
nt
---
-Original Message-
From: Brett Harvey [mailto:[EMAIL PROTECTED]
Sent: Monday, 24 July 2006 1:49 PM
To: mysql@lists.mysql.com
Subject: RE: Replication Problem
Hello David,
Reset ho
5001
Australia
invent
---
-Original Message-
From: Brett Harvey [mailto:[EMAIL PROTECTED]
Sent: Monday, 24 July 2006 1:36 PM
To:
Hi,
Thanks for the response.
Yes - I have that in my config also.
replicate-do-db=FMS
Thanks
Brett
Hi,
Did u mention what all databases has to be replicated in ur cnf file
as (replicate-do-db=database-name).
Thanks & Regards
Dilipkumar
--
-
Well, I successfully setup replication for one server/slave. Now I'm
trying to do the same for another set.
I've tried both the tar method and load data from master and can't
seem to get either to work.
Nothing replicates to the slave.
I'm running Mysql 5.022.
===
My error
Hello David,
Thanks for the response. I don't know which version yet. I just
started a month ago with the company and am just starting on this
project. I will find out. The site has not been updated in 5 years
though... so the Unidata database must be at least 6 years old.
Brett
At 06:5
Has anyone converted from Unidata db to Mysql? How easy/difficult
is it to do? Does the Mysql Migration toolkit help with that process?
an old consulting company setup a website with Unidata and perl... we
want to convert to mysql...
Thanks!
--
--
Both methods are "commonly" used.
Another method used is to have multiple pages like you've mentioned
but save all the data into a session (of just pass it from page to
page) until all 3 pages are complete and then write all the data at
once
The question to ask yourself is, do you want just
"Rhino" <[EMAIL PROTECTED]> wrote:
Second, you're using the HAVING clause incorrectly in your query.
HAVING only works with GROUP BY, i.e. you MUST have a GROUP BY to be
able to use HAVING. (Note: You can have a GROUP BY without using
HAVING but you cannot use HAVING unless a GROUP BY is prese
Love it - use it all the time. Saw it at the Mysql conference, bought
it that night. Use it every day. Well worth $50.
I'm contemplating buying SQLyog Enterprise for $49 dollars (non-commerical)
for personal use. Do anyone use it and how does it fare in your opinion?
--
Power to people, Linux
Hello,
I went through the install for mysql 4.1.11 on the mac. Two different macs.
When I leave the password empty (don't make changes), I can connect
with CocoaMysql and the Mysql Administrator without any problem.
Obviously, I don't want to leave the root (or any user) without a
password. So,
I have a query that worked just fine in Mysql 3.x and 4.0. It no
longer works in 4.1. I receive the "The SELECT would examine more
than MAX_JOIN_SIZE rows; check your WHERE and use SET
SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay"
error
My max_join_size is set at the defa
> Has anyone had any experiences running MySQL on a Xserve G5 with Macintosh
OSX?
We are thinking of purchasing some new hardware to run our MySQL
server. The
> 64-bit architecture is something we would like to take advantage of.
I've had great success running it on my 4-year old Mac laptop
Roger,
Not sure if I understood your problem, but have you tried combining your ON
clause with a WHERE clause with an OR condition:
Unfortunately, that wouldn't do it. the "client type" would be
changing based on the client. I see I goofed up however. Below is
the corrected version. The Join h
Is it possible to basically do a conditional within a join (or
perhaps this is where a subquery is needed)?
I have a workorder table that I'm doing a join with. Each Client may
be a different client type and thus needs to be joined from one of
two different tables. Also, each client may choose
23 matches
Mail list logo