Downloading old version of MySQL ?

Hi all,

I'm trying to drag a database through the upgrade process from 5.0.32
but I keep running into small cross-version compatibility issues.

At present my live database is running 5.0.32 and is large enough that
it would take too long (read days) to perform an upgrade on, and
drives an important application for us that can't tolerate a
significant outage. It's also gets frequent writes.

The plan I'm pursuing involves taking a db dump I have from a while
back, importing it into a newer version of MySQL, then letting
replication bring that newer version up to date. This way I can bring
things along jump by jump until I make it to current. However I keep
hitting replication bugs that mean I have to do this is small jumps -
for example I was working on 5.0.32 to 5.0.81 and hit this one
http://bugs.mysql.com/bug.php?id=24432.

So it looks like I now need a 5.0.34 install to transition through,
but I can't find anywhere on the MySQL site that offers access to
previous releases like that, does anyone know where I can find them ?

I'm equally open to better solutions to my upgrade approach if anyone
has any :-)

Cheers
Dave

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Downloading old version of MySQL ?

Hi David, all,


David Harrison wrote:
> Hi all,
>=20
> I'm trying to drag a database through the upgrade process from 5.0.=
32
> but I keep running into small cross-version compatibility issues.
>=20
> [[...]]
>=20
> So it looks like I now need a 5.0.34 install to transition through,
> but I can't find anywhere on the MySQL site that offers access to
> previous releases like that, does anyone know where I can find them=
?
>=20
> I'm equally open to better solutions to my upgrade approach if anyo=
ne
> has any :-)
>=20
> Cheers
> Dave
>=20

I'm not sure you really need all these intermediate steps (leave it t=
o
others to comment on that), but access to old community packages is h=
ere:

http://dev.mysql.com/downloads/mysql/5.0.html

click "Archives" (top-left dark blue box, close to the end of the lis=
t)

click "MySQL Database Server 5.0" and find your way further.


Note that these are the Community packages only.

If you use the (paid-for) Enterprise packages, you should know your
access path.


HTH,
Jörg

--=20
Joerg Bruehe, MySQL Build Team, Joerg.Bruehe@Sun.COM
Sun Microsystems GmbH, Komturstraße 18a, D-12099 Berlin
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Wolf Frenkel
Vorsitzender des Aufsichtsrates: Martin Haering Muenchen: HRB1610=
28


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Database design - help

As a complete newbie in MySQL, I need a database
to store URLs related to Tenpin Bowling.

There are several Categories ... Equipment Manufacturers, Organistations,
(UK) ProShops, (UK) Bowling Centres, Personal Websites, Misc., Coaching &
Instructional websites, etc.

There will be some sub-categories.
eg: Organistions will have ... Zones of WTBC, National Organisations
within
the Zones, UK organisations, Disabled Bowling organisations, ...
eg: Personal Website might have ... Bowler's, Pro Bowler's, Leagues, etc.

Can anyone suggest how I should set out tables for this database ?






--
I am using the free version of SPAMfighter.
We are a community of 6 million users fighting spam.
SPAMfighter has removed 13876 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len

The Professional version does not have this message



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Database design - help

BobSharp wrote:
> As a complete newbie in MySQL, I need a database
> to store URLs related to Tenpin Bowling.
>
> There are several Categories ... Equipment Manufacturers,
> Organistations, (UK) ProShops, (UK) Bowling Centres, Personal
> Websites, Misc., Coaching & Instructional websites, etc.
>
> There will be some sub-categories.
> eg: Organistions will have ... Zones of WTBC, National Organisations
> within
> the Zones, UK organisations, Disabled Bowling organisations, ...
> eg: Personal Website might have ... Bowler's, Pro Bowler's, Leagues,
> etc.
>
> Can anyone suggest how I should set out tables for this database ?


Here's one suggestion

Table:

URLs:
URL_ID
URL_TEXT

CATEGORY
CATEGORY_ID
CATEGORY_TEXT

SUBCAT
SUBCAT_ID
CATEGORY_ID
SUBCAT_TEXT

URL_CATEGORY
URL_ID
CATEGORY_ID
SUBCATEGORY_ID
PK: (URL_ID, CATEGORY_ID)

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Database design - help

------=_NextPart_000_04CB_01CA2D7C.29092420
Content-Type: text/plain; format="flowed"; charset="iso-8859-15"; reply-type="original"
Content-Transfer-Encoding: 7bit

Hi

Thanks for all the responses. However I am still stuck for a MySQL db I
can create
and code in PHP. Attached is a brief example of data to be used.

One problem I have is with providing a listing that includes ...
WTBC (Category without SubCats) and the 3 Zones (also, Cats without
SubCats ??? )
(This is for a complete WTBC listing, in practice it may list depending on
selected Zone)


The example Schema is interesting, but is there another way of storing all
links
in one table and join them to Category and SubCat tables ?
An example of the ER Diagram would also be helpful to me.


cheers





----- Original Message -----
From: "John Meyer"
To: "BobSharp"
Cc:
Sent: Monday, August 31, 2009 4:56 PM
Subject: Re: Database design - help


> BobSharp wrote:
>> As a complete newbie in MySQL, I need a database
>> to store URLs related to Tenpin Bowling.
>>
>> There are several Categories ... Equipment Manufacturers,
>> Organistations, (UK) ProShops, (UK) Bowling Centres, Personal
>> Websites, Misc., Coaching & Instructional websites, etc.
>>
>> There will be some sub-categories.
>> eg: Organistions will have ... Zones of WTBC, National Organisations
>> within
>> the Zones, UK organisations, Disabled Bowling organisations, ...
>> eg: Personal Website might have ... Bowler's, Pro Bowler's, Leagues,
>> etc.
>>
>> Can anyone suggest how I should set out tables for this database ?
>
>
> Here's one suggestion
>
> Table:
>
> URLs:
> URL_ID
> URL_TEXT
>
> CATEGORY
> CATEGORY_ID
> CATEGORY_TEXT
>
> SUBCAT
> SUBCAT_ID
> CATEGORY_ID
> SUBCAT_TEXT
>
> URL_CATEGORY
> URL_ID
> CATEGORY_ID
> SUBCATEGORY_ID
> PK: (URL_ID, CATEGORY_ID)


------------------------------------------------------------ --------------------



No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.409 / Virus Database: 270.13.72/2337 - Release Date: 08/31/09
05:50:00


--
I am using the free version of SPAMfighter.
We are a community of 6 million users fighting spam.
SPAMfighter has removed 13901 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len

The Professional version does not have this message


------=_NextPart_000_04CB_01CA2D7C.29092420
Content-Type: text/plain; charset=us-ascii


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
------=_NextPart_000_04CB_01CA2D7C.29092420--

RE: Database design - help

--_7b7ea326-ab94-4dc4-ba2b-4e1ab7659aa8_
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64

DQo+IGdpdmVuIHRoZSBmb2xsb3dpbmcgdGFibGUgbGF5b3V0cw0KPiBVUkxz Og0KPiBVUkxfSUQg
KHByaW1hcnkga2V5IGZvciBVUkwpDQo+IFVSTF9URVhUDQo+DQo+IFVSTF9D QVRFR09SWQ0KPiBV
UkxfSUQgICAgICAgKGtleSB3aGljaCBwb2ludHMgdG8gVVJMLlVSTF9JRCkN Cj4gQ0FURUdPUllf
SUQgIChrZXkgd2hpY2ggcG9pbnRzIHRvIENBVEVHT1JZLkNBVEVHT1JZX0lE KQ0KPiBTVUJDQVRF
R09SWV9JRA0KPiBQSzogKFVSTF9JRCwgQ0FURUdPUllfSUQpDQoNCj4gQ0FU RUdPUlkNCj4gQ0FU
RUdPUllfSUQgKHByaW1hcnkgS2V5IGZvciBDYXRlZ29yeSkNCj4gQ0FURUdP UllfVEVYVA0KPg0K
PiBTVUJDQVQNCj4gU1VCQ0FUX0lEICAgIChjb25jYXRlbmF0ZWQga2V5IGZv ciBTdWJDYXQpDQo+
IENBVEVHT1JZX0lEICAoY29uY2F0ZW5hdGVkIGtleSBmb3IgU3ViY2F0KQ0K PiBTVUJDQVRfVEVY
VA0KPg0Kc28gdGhlIGRpYWdyYW0gd291bGQgbG9vayBzb21ldGhpbmcgbGlr ZSBsaWtlIA0KDQog
ICAgICAgICAgICAgICAgICAgICAgICAgICBVUkxfQ0FURUdPUlkgVGFibGUg ICAgICAgICAgICAg
KFVSTCBUYWJsZSkNCiAgIChDQVRFR09SWSBUQUJMRSkgICAgICAgIFVSTF9J RCAgICAgICAgICAg
IDEtLS0tLS0tLS0+MSBVUkwuVVJMX0lEDQogQ0FURUdPUlkuQ0FURUdPUllf SUQxPC0tLTFDQVRF
R09SWV9JRCAgICAgICAgICAgICAgICAgICAgVVJMX1RFWFQNCiAgICAgICAg ICAxICAgICAgICAg
ICAgIA0KICAgICAgICAgICAgICAgIOKGkw0KICAgICAgICAgICAgICAgIDEN ClNVQkNBVC5DQVRF
R09SWV9JRA0KU1VCQ0FULlNVQkNBVF9URVhUDQoNCnRoaXMgaXMgbGFib3Vy LWludGVuc2l2ZSB3
b3JrIHRoYXQgZXZlcnkgREJBIG11c3QgcGVyZm9ybSB0byBjcmVhdGUgYSBE YXRhYmFzZQ0KTWFy
dGluIEdhaW50eSANCl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19f
X18gDQpWZXJ6aWNodCB1bmQgVmVydHJhdWxpY2hrZWl0YW5tZXJrdW5nL05v dGUgZGUgZMOpbmkg
ZXQgZGUgY29uZmlkZW50aWFsaXTDqQ0KIA0KRGllc2UgTmFjaHJpY2h0IGlz dCB2ZXJ0cmF1bGlj
aC4gU29sbHRlbiBTaWUgbmljaHQgZGVyIHZvcmdlc2VoZW5lIEVtcGZhZW5n ZXIgc2Vpbiwgc28g
Yml0dGVuIHdpciBob2VmbGljaCB1bSBlaW5lIE1pdHRlaWx1bmcuIEplZGUg dW5iZWZ1Z3RlIFdl
aXRlcmxlaXR1bmcgb2RlciBGZXJ0aWd1bmcgZWluZXIgS29waWUgaXN0IHVu enVsYWVzc2lnLiBE
aWVzZSBOYWNocmljaHQgZGllbnQgbGVkaWdsaWNoIGRlbSBBdXN0YXVzY2gg dm9uIEluZm9ybWF0
aW9uZW4gdW5kIGVudGZhbHRldCBrZWluZSByZWNodGxpY2hlIEJpbmR1bmdz d2lya3VuZy4gQXVm
Z3J1bmQgZGVyIGxlaWNodGVuIE1hbmlwdWxpZXJiYXJrZWl0IHZvbiBFLU1h aWxzIGtvZW5uZW4g
d2lyIGtlaW5lIEhhZnR1bmcgZnVlciBkZW4gSW5oYWx0IHVlYmVybmVobWVu Lg0KQ2UgbWVzc2Fn
ZSBlc3QgY29uZmlkZW50aWVsIGV0IHBldXQgw6p0cmUgcHJpdmlsw6lnacOp LiBTaSB2b3VzIG4n
w6p0ZXMgcGFzIGxlIGRlc3RpbmF0YWlyZSBwcsOpdnUsIG5vdXMgdGUgZGVt YW5kb25zIGF2ZWMg
Ym9udMOpIHF1ZSBwb3VyIHNhdGlzZmFpcmUgaW5mb3JtZXogbCdleHDDqWRp dGV1ci4gTidpbXBv
cnRlIHF1ZWxsZSBkaWZmdXNpb24gbm9uIGF1dG9yaXPDqWUgb3UgbGEgY29w aWUgZGUgY2VjaSBl
c3QgaW50ZXJkaXRlLiBDZSBtZXNzYWdlIHNlcnQgw6AgbCdpbmZvcm1hdGlv biBzZXVsZW1lbnQg
ZXQgbidhdXJhIHBhcyBuJ2ltcG9ydGUgcXVlbCBlZmZldCBsw6lnYWxlbWVu dCBvYmxpZ2F0b2ly
ZS4gw4l0YW50IGRvbm7DqSBxdWUgbGVzIGVtYWlsIHBldXZlbnQgZmFjaWxl bWVudCDDqnRyZSBz
dWpldHMgw6AgbGEgbWFuaXB1bGF0aW9uLCBub3VzIG5lIHBvdXZvbnMgYWNj ZXB0ZXIgYXVjdW5l
IHJlc3BvbnNhYmlsaXTDqSBwb3VyIGxlIGNvbnRlbnUgZm91cm5pLg0KDQoN Cg0KDQo+IEZyb206
IGJvYnNoYXJwQG50bHdvcmxkLmNvbQ0KPiBUbzogbXlzcWxAbGlzdHMubXlz cWwuY29tDQo+IEND
OiBqb2huLmwubWV5ZXJAZ21haWwuY29tDQo+IFN1YmplY3Q6IFJlOiBEYXRh YmFzZSBkZXNpZ24g
LSAgaGVscA0KPiBEYXRlOiBGcmksIDQgU2VwIDIwMDkgMTY6MjQ6MjIgKzAx MDANCj4gDQo+IEhp
DQo+IA0KPiBUaGFua3MgZm9yIGFsbCB0aGUgcmVzcG9uc2VzLiAgIEhvd2V2 ZXIgSSBhbSBzdGls
bCBzdHVjayBmb3IgYSBNeVNRTCBkYiBJIA0KPiBjYW4gY3JlYXRlDQo+IGFu ZCBjb2RlIGluIFBI
UC4gICAgIEF0dGFjaGVkIGlzIGEgYnJpZWYgZXhhbXBsZSBvZiBkYXRhIHRv IGJlIHVzZWQuDQo+
IA0KPiBPbmUgcHJvYmxlbSBJIGhhdmUgaXMgd2l0aCBwcm92aWRpbmcgYSBs aXN0aW5nIHRoYXQg
aW5jbHVkZXMgLi4uDQo+IFdUQkMgIChDYXRlZ29yeSB3aXRob3V0IFN1YkNh dHMpICBhbmQgdGhl
IDMgWm9uZXMgKGFsc28sIENhdHMgd2l0aG91dCANCj4gU3ViQ2F0cyA/Pz8g KQ0KPiAoVGhpcyBp
cyBmb3IgYSBjb21wbGV0ZSBXVEJDIGxpc3RpbmcsICBpbiBwcmFjdGljZSBp dCBtYXkgbGlzdCBk
ZXBlbmRpbmcgb24gDQo+IHNlbGVjdGVkIFpvbmUpDQo+IA0KPiANCj4gVGhl IGV4YW1wbGUgU2No
ZW1hIGlzIGludGVyZXN0aW5nLCAgIGJ1dCBpcyB0aGVyZSBhbm90aGVyIHdh eSBvZiBzdG9yaW5n
IGFsbCANCj4gbGlua3MNCj4gaW4gb25lIHRhYmxlIGFuZCBqb2luIHRoZW0g dG8gQ2F0ZWdvcnkg
YW5kIFN1YkNhdCB0YWJsZXMgPw0KPiBBbiBleGFtcGxlIG9mIHRoZSBFUiBE aWFncmFtIHdvdWxk
IGFsc28gYmUgaGVscGZ1bCB0byBtZS4NCj4gDQo+IA0KPiBjaGVlcnMNCj4g DQo+IA0KPiANCj4g
DQo+IA0KPiAtLS0tLSBPcmlnaW5hbCBNZXNzYWdlIC0tLS0tIA0KPiBGcm9t OiAiSm9obiBNZXll
ciIgPGpvaG4ubC5tZXllckBnbWFpbC5jb20+DQo+IFRvOiAiQm9iU2hhcnAi IDxib2JzaGFycEBu
dGx3b3JsZC5jb20+DQo+IENjOiA8bXlzcWxAbGlzdHMubXlzcWwuY29tPg0K PiBTZW50OiBNb25k
YXksIEF1Z3VzdCAzMSwgMjAwOSA0OjU2IFBNDQo+IFN1YmplY3Q6IFJlOiBE YXRhYmFzZSBkZXNp
Z24gLSBoZWxwDQo+IA0KPiANCj4gPiBCb2JTaGFycCB3cm90ZToNCj4gPj4g QXMgYSBjb21wbGV0
ZSBuZXdiaWUgaW4gTXlTUUwsICBJIG5lZWQgYSBkYXRhYmFzZQ0KPiA+PiB0 byBzdG9yZSBVUkxz
IHJlbGF0ZWQgdG8gVGVucGluIEJvd2xpbmcuDQo+ID4+DQo+ID4+IFRoZXJl IGFyZSBzZXZlcmFs
IENhdGVnb3JpZXMgLi4uICBFcXVpcG1lbnQgTWFudWZhY3R1cmVycywNCj4g Pj4gT3JnYW5pc3Rh
dGlvbnMsIChVSykgUHJvU2hvcHMsIChVSykgQm93bGluZyBDZW50cmVzLCBQ ZXJzb25hbA0KPiA+
PiBXZWJzaXRlcywgTWlzYy4sIENvYWNoaW5nICYgSW5zdHJ1Y3Rpb25hbCB3 ZWJzaXRlcywgZXRj
Lg0KPiA+Pg0KPiA+PiBUaGVyZSB3aWxsIGJlIHNvbWUgc3ViLWNhdGVnb3Jp ZXMuDQo+ID4+IGVn
OiAgT3JnYW5pc3Rpb25zIHdpbGwgaGF2ZSAuLi4gWm9uZXMgb2YgV1RCQywg IE5hdGlvbmFsIE9y
Z2FuaXNhdGlvbnMNCj4gPj4gd2l0aGluDQo+ID4+IHRoZSBab25lcywgVUsg b3JnYW5pc2F0aW9u
cywgIERpc2FibGVkIEJvd2xpbmcgb3JnYW5pc2F0aW9ucywgLi4uDQo+ID4+ IGVnOiAgUGVyc29u
YWwgV2Vic2l0ZSBtaWdodCBoYXZlIC4uLiBCb3dsZXIncywgIFBybyBCb3ds ZXIncywgTGVhZ3Vl
cywNCj4gPj4gZXRjLg0KPiA+Pg0KPiA+PiBDYW4gYW55b25lIHN1Z2dlc3Qg aG93IEkgc2hvdWxk
IHNldCBvdXQgdGFibGVzIGZvciB0aGlzIGRhdGFiYXNlID8NCj4gPg0KPiA+ DQo+ID4gSGVyZSdz
IG9uZSBzdWdnZXN0aW9uDQo+ID4NCj4gPiBUYWJsZToNCj4gPg0KPiA+IFVS THM6DQo+ID4gVVJM
X0lEDQo+ID4gVVJMX1RFWFQNCj4gPg0KPiA+IENBVEVHT1JZDQo+ID4gQ0FU RUdPUllfSUQNCj4g
PiBDQVRFR09SWV9URVhUDQo+ID4NCj4gPiBTVUJDQVQNCj4gPiBTVUJDQVRf SUQNCj4gPiBDQVRF
R09SWV9JRA0KPiA+IFNVQkNBVF9URVhUDQo+ID4NCj4gPiBVUkxfQ0FURUdP UlkNCj4gPiBVUkxf
SUQNCj4gPiBDQVRFR09SWV9JRA0KPiA+IFNVQkNBVEVHT1JZX0lEDQo+ID4g UEs6IChVUkxfSUQs
IENBVEVHT1JZX0lEKQ0KPiANCj4gDQo+IC0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tDQo+IA0KPiAN
Cj4gDQo+IE5vIHZpcnVzIGZvdW5kIGluIHRoaXMgaW5jb21pbmcgbWVzc2Fn ZS4NCj4gQ2hlY2tl
ZCBieSBBVkcgLSB3d3cuYXZnLmNvbQ0KPiBWZXJzaW9uOiA4LjUuNDA5IC8g VmlydXMgRGF0YWJh
c2U6IDI3MC4xMy43Mi8yMzM3IC0gUmVsZWFzZSBEYXRlOiAwOC8zMS8wOSAN Cj4gMDU6NTA6MDAN
Cj4gDQo+IA0KPiAtLSANCj4gSSBhbSB1c2luZyB0aGUgZnJlZSB2ZXJzaW9u IG9mIFNQQU1maWdo
dGVyLg0KPiBXZSBhcmUgYSBjb21tdW5pdHkgb2YgNiBtaWxsaW9uIHVzZXJz IGZpZ2h0aW5nIHNw
YW0uDQo+IFNQQU1maWdodGVyIGhhcyByZW1vdmVkIDEzOTAxIG9mIG15IHNw YW0gZW1haWxzIHRv
IGRhdGUuDQo+IEdldCB0aGUgZnJlZSBTUEFNZmlnaHRlciBoZXJlOiBodHRw Oi8vd3d3LnNwYW1m
aWdodGVyLmNvbS9sZW4NCj4gDQo+IFRoZSBQcm9mZXNzaW9uYWwgdmVyc2lv biBkb2VzIG5vdCBo
YXZlIHRoaXMgbWVzc2FnZQ0KPiANCg0KX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18NCldpbmRvd3MgTGl2 ZTogS2VlcCB5b3Vy
IGZyaWVuZHMgdXAgdG8gZGF0ZSB3aXRoIHdoYXQgeW91IGRvIG9ubGluZS4N Cmh0dHA6Ly93aW5k
b3dzbGl2ZS5jb20vQ2FtcGFpZ24vU29jaWFsTmV0d29ya2luZz9vY2lkPVBJ RDIzMjg1OjpUOldM
TVRBR0w6T046V0w6ZW4tVVM6U0lfU0Jfb25saW5lOjA4MjAwOQ==

--_7b7ea326-ab94-4dc4-ba2b-4e1ab7659aa8_--

Re: Database design - help

------=_NextPart_000_0632_01CA2E05.A3CB14F0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Thanks

Not sure how I'm reading this, but shouldn't the URL be linked to SubCate=
gory =3F


----- Original Message -----
From: Martin Gainty
To: bobsharp@ntlworld.com ; mysql@lists.mysql.com
Cc: john.l.meyer@gmail.com
Sent: Friday, September 04, 2009 6:09 PM
Subject: RE: Database design - help


> given the following table layouts

> URLs:> URL=5FID (primary key for URL)> URL=5FTEXT>> URL=5FCATEGORY> URL=5FID =
(key which points to URL.URL=5FID)> CATEGORY=5FID (key which points to CATEG=
ORY.CATEGORY=5FID)> SUBCATEGORY=5FID> PK: (URL=5FID, CATEGORY=5FID)> CATEGORY> CATE=
GORY=5FID (primary Key for Category)> CATEGORY=5FTEXT>> SUBCAT> SUBCAT=5FID (c=
oncatenated key for SubCat)> CATEGORY=5FID (concatenated key for Subcat)> SU=
BCAT=5FTEXT>so the diagram would look something like like =
URL=5FCATEGORY Table (URL Table) (CATEGORY TABLE) =
URL=5FID 1--------->1 URL.URL=5FID CATEGORY.CATEGORY=5FID1<---1CATEG=
ORY=5FID URL=5FTEXT 1 =E2=
†“
1
SUBCAT.CATEGORY=5FID
SUBCAT.SUBCAT=5FTEXT

this is labour-intensive work that every DBA must perform to create a Dat=
abase
Martin Gainty
____________________ ____________________ ______
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialit=C3=
=A9


Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfae=
nger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiter=
leitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient l=
ediglich dem Austausch von Informationen und entfaltet keine rechtliche Bin=
dungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen w=
ir keine Haftung fuer den Inhalt uebernehmen.

Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas=
le destinataire prévu, nous te demandons avec bonté que pour satisfaire =
informez l'expéditeur. N'importe quelle diffusion non autorisée ou la cop=
ie de ceci est interdite. Ce message sert à l'information seulement et n'a=
ura pas n'importe quel effet légalement obligatoire. Étant donné que les=
email peuvent facilement être sujets à la manipulation, nous ne pouvons =
accepter aucune responsabilité pour le contenu fourni.




> From: bobsharp@ntlworld.com
> To: mysql@lists.mysql.com
> CC: john.l.meyer@gmail.com
> Subject: Re: Database design - help
> Date: Fri, 4 Sep 2009 16:24:22 +0100
>
> Hi
>
> Thanks for all the responses. However I am still stuck for a MySQL db I=

> can create
> and code in PHP. Attached is a brief example of data to be used.
>
> One problem I have is with providing a listing that includes ...
> WTBC (Category without SubCats) and the 3 Zones (also, Cats without
> SubCats ??=3F )
> (This is for a complete WTBC listing, in practice it may list depending=
on
> selected Zone)
>
>
> The example Schema is interesting, but is there another way of storing =
all
> links
> in one table and join them to Category and SubCat tables =3F
> An example of the ER Diagram would also be helpful to me.
>
>
> cheers
>
>
>
>
>
> ----- Original Message -----
> From: =22John Meyer=22
> To: =22BobSharp=22
> Cc:
> Sent: Monday, August 31, 2009 4:56 PM
> Subject: Re: Database design - help
>
>
> > BobSharp wrote:
> >> As a complete newbie in MySQL, I need a database
> >> to store URLs related to Tenpin Bowling.
> >>
> >> There are several Categories ... Equipment Manufacturers,
> >> Organistations, (UK) ProShops, (UK) Bowling Centres, Personal
> >> Websites, Misc., Coaching & Instructional websites, etc.
> >>
> >> There will be some sub-categories.
> >> eg: Organistions will have ... Zones of WTBC, National Organisations
> >> within
> >> the Zones, UK organisations, Disabled Bowling organisations, ...
> >> eg: Personal Website might have ... Bowler's, Pro Bowler's, Leagues,
> >> etc.
> >>
> >> Can anyone suggest how I should set out tables for this database =3F
> >
> >
> > Here's one suggestion
> >
> > Table:
> >
> > URLs:
> > URL=5FID
> > URL=5FTEXT
> >
> > CATEGORY
> > CATEGORY=5FID
> > CATEGORY=5FTEXT
> >
> > SUBCAT
> > SUBCAT=5FID
> > CATEGORY=5FID
> > SUBCAT=5FTEXT
> >
> > URL=5FCATEGORY
> > URL=5FID
> > CATEGORY=5FID
> > SUBCATEGORY=5FID
> > PK: (URL=5FID, CATEGORY=5FID)
>
>
> ------------------------------------------------------------ -----------=
---------
>
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 8.5.409 / Virus Database: 270.13.72/2337 - Release Date: 08/31=
/09
> 05:50:00
>
>
> --
> I am using the free version of SPAMfighter.
> We are a community of 6 million users fighting spam.
> SPAMfighter has removed 13901 of my spam emails to date.
> Get the free SPAMfighter here: http://www.spamfighter.com/len
>
> The Professional version does not have this message
>


------------------------------------------------------------ ---------------=
---
Windows Live: Keep your friends up to date with what you do online. Find =
out more.


------------------------------------------------------------ ---------------=
---



No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.409 / Virus Database: 270.13.76/2344 - Release Date: 09/03/0=
9 18:05:00


--
I am using the free version of SPAMfighter.
We are a community of 6 million users fighting spam.
SPAMfighter has removed 13901 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len

The Professional version does not have this message

------=_NextPart_000_0632_01CA2E05.A3CB14F0--

Re: Database design - help

------=_NextPart_000_0776_01CA2E38.9BC166F0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Please forgive my total ignorance.

URL-Category linking ... with Foriegn Keys or Primary Keys =3F

Have been trying to create the ER Diagram with =22MySQL Workbench=22,
and getting very frustrated.


cheers




----- Original Message -----
From: Martin Gainty
To: bobsharp@ntlworld.com ; mysql@lists.mysql.com
Cc: john.l.meyer@gmail.com
Sent: Friday, September 04, 2009 6:09 PM
Subject: RE: Database design - help


> given the following table layouts

> URLs:> URL=5FID (primary key for URL)> URL=5FTEXT>> URL=5FCATEGORY> URL=5FID =
(key which points to URL.URL=5FID)> CATEGORY=5FID (key which points to CATEG=
ORY.CATEGORY=5FID)> SUBCATEGORY=5FID> PK: (URL=5FID, CATEGORY=5FID)> CATEGORY> CATE=
GORY=5FID (primary Key for Category)> CATEGORY=5FTEXT>> SUBCAT> SUBCAT=5FID (c=
oncatenated key for SubCat)> CATEGORY=5FID (concatenated key for Subcat)> SU=
BCAT=5FTEXT>so the diagram would look something like like =
URL=5FCATEGORY Table (URL Table) (CATEGORY TABLE) =
URL=5FID 1--------->1 URL.URL=5FID CATEGORY.CATEGORY=5FID1<---1CATEG=
ORY=5FID URL=5FTEXT 1 =E2=
†“
1
SUBCAT.CATEGORY=5FID
SUBCAT.SUBCAT=5FTEXT

this is labour-intensive work that every DBA must perform to create a Dat=
abase
Martin Gainty
____________________ ____________________ ______

> From: bobsharp@ntlworld.com
> To: mysql@lists.mysql.com
> CC: john.l.meyer@gmail.com
> Subject: Re: Database design - help
> Date: Fri, 4 Sep 2009 16:24:22 +0100
>
> Hi
>
> Thanks for all the responses. However I am still stuck for a MySQL db I=

> can create
> and code in PHP. Attached is a brief example of data to be used.
>
> One problem I have is with providing a listing that includes ...
> WTBC (Category without SubCats) and the 3 Zones (also, Cats without
> SubCats ??=3F )
> (This is for a complete WTBC listing, in practice it may list depending=
on
> selected Zone)
>
>
> The example Schema is interesting, but is there another way of storing =
all
> links
> in one table and join them to Category and SubCat tables =3F
> An example of the ER Diagram would also be helpful to me.
>
>
> cheers
>
>
>
>

--
I am using the free version of SPAMfighter.
We are a community of 6 million users fighting spam.
SPAMfighter has removed 13901 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len

The Professional version does not have this message

------=_NextPart_000_0776_01CA2E38.9BC166F0--

Re: Database design - help

Again, please forgive my total ignorance.


My ERD shows that the web links (URL table) are connected, via the
sub-categories (SubCat table),
to the main categories (Categories table). Is this correct for what I
am trying to achieve ?
Or should I also link the URL table to the Categories table ?


Have been trying to create the ER Diagram with "MySQL Workbench",
and getting very frustrated.
So far I have this .... www.ProBowlUK.co.uk/files/ERD_00.pdf


cheers



----- Original Message -----
From: Martin Gainty
To: bobsharp@ntlworld.com ; mysql@lists.mysql.com
Cc: john.l.meyer@gmail.com
Sent: Friday, September 04, 2009 6:09 PM
Subject: RE: Database design - help


> given the following table layouts

> URLs:> URL_ID (primary key for URL)> URL_TEXT>> URL_CATEGORY> URL_ID
> (key which points to URL.URL_ID)> CATEGORY_ID (key which points to
> CATEGORY.CATEGORY_ID)> SUBCATEGORY_ID> PK: (URL_ID, CATEGORY_ID)>
> CATEGORY> CATEGORY_ID (primary Key for Category)> CATEGORY_TEXT>> SUBCAT>
> SUBCAT_ID (concatenated key for SubCat)> CATEGORY_ID (concatenated key
> for Subcat)> SUBCAT_TEXT>so the diagram would look something like like
> URL_CATEGORY Table (URL Table) (CATEGORY TABLE)
> URL_ID 1--------->1 URL.URL_ID
> CATEGORY.CATEGORY_ID1<---1CATEGORY_ID URL_TEXT
> 1 ↓
1
SUBCAT.CATEGORY_ID
SUBCAT.SUBCAT_TEXT

this is labour-intensive work that every DBA must perform to create a
Database
Martin Gainty
______________________________________________

> From: bobsharp@ntlworld.com
> To: mysql@lists.mysql.com
> CC: john.l.meyer@gmail.com
> Subject: Re: Database design - help
> Date: Fri, 4 Sep 2009 16:24:22 +0100
>
> Hi
>
> Thanks for all the responses. However I am still stuck for a MySQL db I
> can create
> and code in PHP. Attached is a brief example of data to be used.
>
> One problem I have is with providing a listing that includes ...
> WTBC (Category without SubCats) and the 3 Zones (also, Cats without
> SubCats ??? )
> (This is for a complete WTBC listing, in practice it may list depending
on
> selected Zone)
>
>
> The example Schema is interesting, but is there another way of storing
all
> links
> in one table and join them to Category and SubCat tables ?
> An example of the ER Diagram would also be helpful to me.
>
>
> cheers
>
>
>
>

--
I am using the free version of SPAMfighter.
We are a community of 6 million users fighting spam.
SPAMfighter has removed 13901 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len

The Professional version does not have this message





No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.409 / Virus Database: 270.13.77/2346 - Release Date: 09/04/09
17:51:00


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org