Building 5.0 under Windows - new set of detailed instructions published

2008-03-24 Thread Toby Douglass
Hi - I've written a page on how to build MySQL 5.0 under Windows. http://www.45mercystreet.com/computing/mysql/index.html It covers every step in detail - you should be able to build fully by following the instructions. I was originally using the MySQL 5.0 manual page of instructions; http:/

database theory book recommendations?

2008-01-16 Thread Toby Douglass
I'm currently applying for a developer job with mySQL. I want to improve my database theory knowledge. Any book recommendations? Searching on-line is surprisingly unhelpful; the only things I've found so far which looks half-sensible are "Database is Depth" by Chris Date, and "Expert mySQL" by C

Losing indexes after building from dump.

2004-02-27 Thread Toby
issuing any "alter table" query to a table, the indexes start working again. Is there any reason for this? Thanks, Toby -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Unusual Date Query

2003-10-11 Thread toby -
te a report o i fogot to tell you i had a date field in every table im not sure if this is what you r actually looking for but i hope this helps you ..... good luck toby From: "Ross Davis - DataAnywhere.net" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Subject:

Re: access denied .... php my admin .....

2003-10-09 Thread toby -
this thing .. :'( thnx a bill toby From: "Rory McKinley" <[EMAIL PROTECTED]> To: "toby -" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> Subject: Re: access denied php my admin ..... Date: Thu, 9 Oct 2003 11:47:25 +0200 Hi toby If I log in to mysql

Re: access denied .... php my admin .....

2003-10-09 Thread toby -
that are actually screwin this all up fo me all though i have tried ma best to some how change this ip thinggy to the one i want mysql server to user .. can anyone tell me where to go and what to do as im at ma wits end now .. thnx a mill rory .. :) toby From: "Rory McK

access denied .... php my admin .....

2003-10-08 Thread toby -
che 1.3.24 mysql 3.23.58 i would really appriciat any help with this thnx a million toby _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- MySQL General Mailing List For lis

Re: Unicode

2003-06-06 Thread toby -
thing fo last one year so if u need anyothr thing ping me hope this helps good luck toby From: "Robert Mark Bram" <[EMAIL PROTECTED]> Reply-To: <[EMAIL PROTECTED]> To: "Mysql" <[EMAIL PROTECTED]> Subject: Unicode Date: Sun, 1 Jun 2003 12:23:47 +1000

Re: converting from foxpro to mysql ???????

2002-11-28 Thread toby z
thnx fo takin the time to reply anyways . :( toby .. From: Tonu Samuel <[EMAIL PROTECTED]> To: toby z <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED] Subject: Re: converting from foxpro to mysql ??? Date: 28 Nov 2002 11:47:45 +0200 On Wed, 2002-11-27 at 17:05, toby z wro

converting from foxpro to mysql ???????

2002-11-27 Thread toby z
mysql what will i ve to loose the common pitfalls .. 4. n finally do i have anyother choice of open source database (cheapest if not completely free) for this conversion ? id be eternally gratefull if anyone cud guide me thru this .. thnx a billion zillion guyz . toby

Re: search query crashing mysql ..... :S

2002-11-26 Thread toby z
thnx gerald plz tell me how can i run the qoute() function on $srch i tried to look the function up in mysql doccumentation online but no luck . thnx a million toby .. From: gerald_clark <[EMAIL PROTECTED]> To: toby z <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED]

search query crashing mysql ..... :S

2002-11-24 Thread toby z
the times it crashes mysql . :S i get thid msg box declaring mysql is gonna shut down now 1. i ve got win 2K pro, php 4.2.2, mysql 3.23.39 , apache 1.3.24 2. im workin with unicode text n most of the fulltext fields im searching on are unicode guyz im all stuck with this query

making two fields primary key ????

2002-10-12 Thread toby z
hi guyz i ve to alter my table n make two fields primary key (well the combination of the two to be xact) any idea how to do dis ? thnx a mill toby :S:S:S:S:S:S:S mysql query :S:S:S:S:S:S:S _ Join the world’s largest

RE: storing PDF files in mysql ?????

2002-10-10 Thread toby z
matching pdf file (no other way i can see about it) third pal if u ve ever worked with these thinggyz i cant figure out how to disabble text selection while im cpnverting word to PDF so that nobdy can copy the files (im using acrobat dissteller for conversion if this helps) thnx a mill toby

RE: storing PDF files in mysql ?????

2002-10-09 Thread toby z
issue I NO THIS IS THE WRONG LIST SORRY FOR THIS Q BUT .. has anyone worked with this thing n wouldnt mind me mailin him/her plz do lemme no guyz plz hlp . thnx a billion toby >From: "Sqlcoders.com Programming Dept" <[EMAIL PROTECTED]> >To: "toby z" <[EMA

Re: storing PDF files in mysql ?????

2002-10-08 Thread toby z
thnx a mill toby >From: "R.Dobson" <[EMAIL PROTECTED]> >To: toby gibbson <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: Re: storing PDF files in mysql ? >Date: Tue, 08 Oct 2002 16:35:56 +0100 > > >hi, >2 ways to do this: > >a

RE: Unicode Support with MySQL

2002-10-08 Thread toby gibbson
awww jeeez. tell me bout dat i still ve to work on the indexing n sortin toby >From: "Dean Harding" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Subject: RE: Unicode Support with MySQL >Date: Tue, 8 Oct 2002 20:47:17 +1000 > >Yeah, I've used

storing PDF files in mysql ?????

2002-10-08 Thread toby gibbson
ok guyz more trouble now im supposed to convert all the text (from ms word) to PDF and put the pdf files in mysql db now i ve really got myslf stuck havent i can anyone plz hlp thnx a million stuck az usual toby

storing image in the db ????

2002-10-08 Thread toby gibbson
hi guyz i ve these images of text n i ve to store em in mysql database ALONG WITH some TEXT n im storing the text in a longtext field vat do i do can n will some1 plz help ? thnx a million guyz toby .. _ Join

RE: Unicode Support with MySQL

2002-10-08 Thread toby gibbson
schmid n dean . fellaz . i AM using mysql for UNICODE data all my database is unicode its all stored there i retieve all my unicode data n play round with it all the time n so far i ve had NO problemx . :D any more questions id b glad 2 help all i can good luck toby

users and privileges and heaer.inc.php errors ?????

2002-09-27 Thread toby -
t/html; charset=' . $charset); /** * Sends the beginning of the html page then returns to the calling script */ ---- can n will somebdy plz help me with this thnx a million toby __

Re: mysql all messedup ... :'( .....

2002-09-27 Thread toby -
ith phpmyadmin i ve to fill in the data base with a dump from my site . n i cant get into myadmin thinggy ... with or without da password ... :S Error MySQL said: Access denied for user: 'zyyn@localhost' (Using password: YES) thnx a million guyz ...

Re: mysql all messedup ... :'( .....

2002-09-26 Thread toby -
>From: Iikka Meriläinen <[EMAIL PROTECTED]> >To: toby - <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: Re: mysql all messedup ... :'( . >Date: Thu, 26 Sep 2002 17:26:10 +0300 (EEST) > >Did you check Egor's last message to you on the lis

Re: mysql all messedup ... :'( .....

2002-09-26 Thread toby -
@localhost n it letts me in but not mysql --user sir --pass password * i get the same error: Access denied for user: 'zaban@localhost' (Using password: YES) n im lost and ve a demo tomorrow aftrnoon n im doomed :'( thnx a million anyway fo ur time n concern i really appriciate

mysql all messedup ... :'( .....

2002-09-26 Thread toby -
u guys cud come online on msn n hlp me plz . all screwedup . toby _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worl

Re: access denied ????

2002-09-25 Thread toby -
at else can i do thnx a zillion guyz ... toby . >From: Iikka Meriläinen <[EMAIL PROTECTED]> >To: toby - <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: Re: access denied >Date: Wed, 25 Sep 2002 15:08:04 +0300 (EEST) > >On Wed, 25 Sep 2002, toby - w

Re: access denied ????

2002-09-25 Thread toby -
n thnx a lot again toby .. >From: Iikka Merilinen <[EMAIL PROTECTED]> >To: toby - <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: Re: access denied >Date: Mon, 23 Sep 2002 18:19:00 +0300 (EEST) > >Hello, > >If you're on *NIX plat

Re: access denied ????

2002-09-25 Thread toby -
x27;controlpass'] = 'xomby'; $cfgServers[$i]['auth_type'] = 'http'; $cfgServers[$i]['user'] = 'root'; $cfgServers[$i]['password'] = ''; $cfgServers[$i]['only_db'] = ''; $cfgServ

Re: access denied ????

2002-09-23 Thread toby -
thnx gerald but i still dont know what to do to fix this thing up will someone pleez enlighten me on how to thnx a million ... toby . >From: gerald_clark <[EMAIL PROTECTED]> >To: toby - <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: Re: a

access denied ????

2002-09-21 Thread toby -
bandb\ctnt_inf.MYI' to '.\zabandb\#sql2-5b0-7e.MYI' (Errcode: 13) ACCESS DENIED ! ! ! ! ! what the hell is rong with this thing ? cud anyone help me plz thnx a million toby . _ Send and rec

access denied ????

2002-09-21 Thread toby -
ok guyz im lost im creating my tables and after i ve created em i tried to change two of the fields to FULLTEXT and this is what i get : Database zabanDb running on localhost Error SQL-query : ALTER TABLE `ctnt_inf` ADD FULLTEXT(`summary`) MySQL said: Error on rename of '.\zabandb\c

errors while uploading my php site ...... ! ! ! !

2002-08-13 Thread toby -
with this muckup thnx a MILLION . toby .. _ Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please

RE: How to get timestamp of inserted record

2002-07-30 Thread toby -
stName . "', '" . $lastName . "','" . $title . "','" . $body . "','" . $summary . "'," . time() . ", " . date("d"). ", " . date("m"). ", " . date("Y&qu

Re: a newserver would be better than this mailing list

2002-07-30 Thread toby -
gratefull enough for the support of all these people their help and time which they take outta thier paid hours to help to share what ever they can and pal if u are so full of messeges im sure there must be some mysql-list archives u can always get ... find what u want there

Re: a newserver would be better than this mailing list

2002-07-30 Thread toby -
gratefull enough for the support of all these people their help and time which they take outta thier paid hours to help to share what ever they can and pal if u are so full of messeges im sure there must be some mysql-list archives u can always get .

cant store checkbox vale ..... ?????

2002-07-29 Thread toby -
db except fo news_letter_subs i get a 0 fo it in my db :S where m i mucking it up guyz plz hlp thnx a million toby . _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/w

Re: question about varchars

2002-07-27 Thread toby -
desmond one of my teachers at college once told me to give as less a digit as possible that is give it jst a BIT more den i need coz it takes up space . :S ... will someone correct me if im rong here . pleez toby >Hello there > > >Mysql documentation says t

display stuck .... ! ! ! !

2002-07-27 Thread toby -
""); i get all the records in $row[2] but i want jst 1 what should i do ? how should i go about it ? plx plx help m stuck ... :( thnx a million . billion stuck toby _ Send and

redirection & limit display accross multi pages .... ????

2002-07-12 Thread toby -
the article from the db when the user cliks on the link and wont i need some kindda script like in java script onclick{(pick up da article )} id really appricaite any help with these gratefull as ever toby . _ Join

email address authentification .....

2002-07-10 Thread toby -
hi guys im sure theres a function to check for a valid email address entered by user before storing it into the db but i cant locate it in php manuel NOR in mysql manuel will someone plz tell me bout it ? thnx a million toby

Re: RAID

2002-07-09 Thread toby -
ismaeel >Do you have good link for documentation ? http://www.mysql.com/doc/C/o/Configuring_MySQL.html good luck toby . _ Send and receive Hotmail on your mobile device: http://mobile.msn.

rand() ... limit by .... & my retrivals

2002-07-09 Thread toby -
= $row_nme[0]; echo ( $tID ); echo ( $tName ); } // echo (""); echo(""); problem: it only displays firstName n nothing else though 5 random first names but i guess i'll ve to make seperate query fo

time stamp ......

2002-07-08 Thread toby -
n YES its related to THIS list ... since i ve to store the uploaded file in mysql database id really appriciate any help with this stuck as usual toby .. _ Join the world’s largest e-mail service with MSN Hotmail. http://ww

file upload ..... ????

2002-07-01 Thread toby -
base and then : its going to be in unicode so how do i get about it id really appriciate any help with this plz if there is some meterial on this do direct me to it thnx a million toby . _ Send and receive

function call ????

2002-06-29 Thread toby -
toby . sql,query _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php

Re: how to create tables ....isam .... ????

2002-06-28 Thread toby -
not 66 :S :( so thnx again awhole bunch toby sql, query _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.a

how to create tables ....isam .... ????

2002-06-28 Thread toby -
hi guyz i va all my tables " myisam " since its da default type how can i make isam tables 1. will someone plz guide me with about the syntex 2. how can i change the type of my myisam tables to isam :( without having to drop them thnx a million toby .

phpmyadmin .... ?????

2002-06-25 Thread toby -
hi guyz i have downloaded phpmyadmin & i have configured it by the book but i dont know how to use it for mysql database :$ will someone pleez tell me how to thnx a million toby . _ MSN Photos is the easiest wa

Re: bizzar display .....

2002-06-24 Thread toby -
thnx van ... its workin now it was no bug ... no mysql problem no explorer problem my mistake i changed the fontdisplay in my t.htm file from unicode to user defined n its workin fine now thnx n im terrabbly sorry all of u a bit better now ... toby

bizzar display .....

2002-06-24 Thread toby -
mysql. is it some bug can anyone help me about what it is thnx a million counting on all of u exasperated toby _ Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.com

cant create tables .....

2002-06-23 Thread toby -
till doesnt work where m i messing it up guyz id really appriciate any help on this thnx a million ... all of u stuck bad toby . _ Get your FREE download of MSN Explorer at http://explorer.

garbage data stored .....

2002-06-22 Thread toby -
this too now id be eternally gratefull if someone could pleez help me out with the rest of storing the unicode thnx a million billion in advance .... toby _ Chat with friends online, try MSN Messenger: http://messenger

garbage data stored ! ! ! !

2002-06-22 Thread toby -
this too now id be eternally gratefull if someone could pleez help me out with the rest of storing the unicode thnx a million billion in advance .... toby _ Get your FREE download of MSN Explorer at http://explorer

remote mysql access ?????

2002-06-21 Thread toby -
.cnf what should i do ? but mysql seems to be working fine even without it i ve win2k, apache 1.3.24 , mysql 3.23.51 thnx a million .... toby . _ Send and receive Hotmail on your mobile device: http://mobile.msn

Re: Unicode

2002-06-20 Thread toby -
i asked the same very question just yesterday & heres the reply i got for it ... i hope it helps u too good luck ... toby Not natively (i.e. you can't sort on a Unicode field, for example), bu

mysql and unicode ....

2002-06-18 Thread toby -
does mysql 32.23.51 support unicode thnx a million ... toby . _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before

RE: errors 2006 and 2000

2001-09-14 Thread toby coffey
t null auto_increment, -> Name varchar(30) not null , -> Object1 varchar(60), -> Object2 varchar(60), -> Object3 varchar(60), -> Comment text, -> primary key (id), -> unique(Name)); toby -Original Message- From: Jay Fesco [mailto:[EMAIL PROTECTED]] Sent: 13 September 2001

RE: errors 2006 and 2000

2001-09-13 Thread toby coffey
ar(60), Object2 varchar(60), Object3 varchar(60), Comment t' at line 3 is it me? or is there a problem with the mysql server on my server? thanks very much toby -Original Message- From: Jay Fesco [mailto:[EMAIL PROTECTED]] Sent: 13 September 2001 15:06 To: [EMAIL PROTECTED]; [EMAIL

errors 2006 and 2000

2001-09-13 Thread toby coffey
from a mysql tutorial but the error 2006 worries me as it looks as though i am not connected to any database also i am not sure if the error 2006 is causing the error 2000. can you help? am i doing something wrong or is t

Re: LIMIT

2001-04-19 Thread Toby Miller
estion that has most likely terrorized at least a few other people on the list so I figured it was worth a try. --Toby - Original Message - From: "B. van Ouwerkerk" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 19, 2001 11:31 AM Subject: Re: LIMIT &

LIMIT

2001-04-19 Thread Toby Miller
rver 6.5 or SQL Server 7.0 are both appreciated. Thanks, Toby

Re: Insert Problem

2001-01-30 Thread Toby Miller
My bad, not enough sleep I guess. Thanks, Toby - Original Message - From: "Roger Ramirez" <[EMAIL PROTECTED]> To: "Toby Miller" <[EMAIL PROTECTED]> Cc: "MySQL List" <[EMAIL PROTECTED]> Sent: Tuesday, January 30, 2001 6:33 AM Subject: Re:

Insert Problem

2001-01-30 Thread Toby Miller
rchar(60), state char(2), zip varchar(10), phone varchar(12), fax varchar(12), email varchar(120) NOT NULL, hint varchar(120), ipaddress varchar(15), hash varchar(120), created timestamp(14), createdby varchar(20) DEFAULT 'byhand' NOT NULL, loggedin timestamp(14), UNIQUE username (username) ); Any ideas? Thanks, Toby