Building 5.0 under Windows - new set of detailed instructions published
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://dev.mysql.com/doc/refman/5.0/en/installing-source-tree.html But that page lists the key steps only; you can't actually build from it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
database theory book recommendations?
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 Charles A. Bell (which looks more practical rather than theoretical). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Losing indexes after building from dump.
I finally figured out that we had been running large databases without indexes working at all. It turns out that if I use mysqldump to dump out a database, then drop/create the database and build from the dump, none of the indexes work. Things slow to a crawl. I found inadvertantly that by 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
hay ross i had ot pick up data rows for the dates between from-date and to-date user selection u know i went about the problem with a loop . heres the code for($loop_mon=$frm_mon; $loop_mon=$to_mon ; $loop_mon++){ $ftch_rprt_dta_qry = select sum($rprt_col) from $rprt_tbl, tbl_chw where month($rprt_tbl.date) = $loop_mon and year($rprt_tbl.date) = $year and tbl_chw.pu_id=$SelectedPuID and $rprt_tbl.chw_id=tbl_chw.chw_id; - do some varibale assignment - generate a report } as u can see all this to generate 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: Unusual Date Query Date: Fri, 10 Oct 2003 17:02:42 -0700 That will only return the number of rows in Table1 What I want to return 1 to n rows based on the number of days between date1 and daten with each row having the date filled in. Ross Davis DataAnywhere.net 250-470-9192 ChaletsOnline.com is coming soon Don't you deserve a vacation! -Original Message- From: mos [mailto:[EMAIL PROTECTED] Sent: Friday, October 10, 2003 2:00 PM To: Ross Davis - DataAnywhere.net Cc: [EMAIL PROTECTED] Subject: Re: Unusual Date Query At 12:59 PM 10/10/2003, you wrote: I want know if there is a way to return every date between 2 date ranges regardless if there is a row in a table. I have a table that contains daily pricing information and I want to be able to do a mass updated/insert records. I know how to write the updates/inserts if I have table that contains EVERY date between the date ranges, but I don't want to keep a table around that has one row for every possible date. I can't use the replace into command because of a foreign keys on the table. The insert will look something like this Insert into daily_rate from select date,123.45 from allpossibledates left join daily_rate on allpossibledates.date=daily_rate.date where date between 20030901 and 20031010 and daily_rate.date is null The problem is I don't know how to generate allpossibledates easily on the fly. I am running 3.23.58 and can't upgrade to the latest versions yet due to incompatibilties with the timestamp formats that were changed. TIA Ross Ross, This should get you started: set @n=0; select date_add(CurDate(), INTERVAL (@n := @n + 1) DAY), col1 from table1; Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ Instant message in style with MSN Messenger 6.0. Download it now FREE! http://msnmessenger-download.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
access denied .... php my admin .....
hay guyz im a bit stuck first i couldnt get any user but root to log into mysql on command prompt and myadmin now i can ,et my user to log in through command prompt but i get this weired error for myadmin Error MySQL said: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) zaban is my user ofcourse kwexchange is the machine i have installed all my php, apache, mysql on kwdomain is the domain we use here at ma work place another thing : winmysqladmin shows the local ip address to be kwexchange.kwdomain.com 192.168.x.xxx where it should only be 192.168.y.z there aint anything of the sort in my.ini where do i make changes for this o and another thing this machine has two cards 192.168.y.z and 192.168.x.xxx are the ips 192.168.x.xxx i can not use . i should ot infact . and i am running Win 2K Server PHP 4.2.2 apache 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 list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: access denied .... php my admin .....
thnx rory the thing is kwexchange is localhost you know . so it should work alwayz has before this dammed day . anywayz . i did install mysql on another machine and installed all the rest , php, apache, phpmyadmin on another when it gave me these access denied errors the very bloody same . i thought there was somethin the matter with keepin these things on two separate machines u know but now i have got em all on the same thing . but to no use . do you or anyone else on this list think it could be the two network cards running on the machine 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 McKinley [EMAIL PROTECTED] To: toby - [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: access denied php my admin . Date: Thu, 9 Oct 2003 11:09:06 +0200 Hi Toby I am not an expert on permissions within mysql - boy, do I wish I was - but could the problem be that you have only granted permissions to [EMAIL PROTECTED] and not '[EMAIL PROTECTED]' ? Here endeth my knowledge of MySQL permissions Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] There are 10 kinds of people in this world, those who understand binary and those who don't (Unknown) - Original Message - From: toby - [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 8:57 AM Subject: access denied php my admin . hay guyz im a bit stuck first i couldnt get any user but root to log into mysql on command prompt and myadmin now i can ,et my user to log in through command prompt but i get this weired error for myadmin Error MySQL said: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) zaban is my user ofcourse kwexchange is the machine i have installed all my php, apache, mysql on kwdomain is the domain we use here at ma work place another thing : winmysqladmin shows the local ip address to be kwexchange.kwdomain.com 192.168.x.xxx where it should only be 192.168.y.z there aint anything of the sort in my.ini where do i make changes for this o and another thing this machine has two cards 192.168.y.z and 192.168.x.xxx are the ips 192.168.x.xxx i can not use . i should ot infact . and i am running Win 2K Server PHP 4.2.2 apache 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 list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: access denied .... php my admin .....
sorry for this late reply rory i just got back to work .. i am trying to connect to 192.168.x.y but the jerk connects to 192.168.xx.xxx the other ip yeha it connects to an ip . not the loop back adrs am i supposed to connect to loop back adrs thinggy ? im all screwed with 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 via the command line on the hosting machine it says [EMAIL PROTECTED] ... therefore, stating the obvious :) it doens't think you're connecting from localhost - this may be because of the two NICs but I don't know enough to be sure .when you connect to the mysql server (when php, apache and mysql are all on the same box) do you connect to 127.0.0.l (loopback address) or do you connect to the IP address of one of the two NICs (e.g. 192.168.y.z)? Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] There are 10 kinds of people in this world, those who understand binary and those who don't (Unknown) - Original Message - From: toby - [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:18 AM Subject: Re: access denied php my admin . thnx rory the thing is kwexchange is localhost you know . so it should work alwayz has before this dammed day . anywayz . i did install mysql on another machine and installed all the rest , php, apache, phpmyadmin on another when it gave me these access denied errors the very bloody same . i thought there was somethin the matter with keepin these things on two separate machines u know but now i have got em all on the same thing . but to no use . do you or anyone else on this list think it could be the two network cards running on the machine 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 McKinley [EMAIL PROTECTED] To: toby - [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: access denied php my admin . Date: Thu, 9 Oct 2003 11:09:06 +0200 Hi Toby I am not an expert on permissions within mysql - boy, do I wish I was - but could the problem be that you have only granted permissions to [EMAIL PROTECTED] and not '[EMAIL PROTECTED]' ? Here endeth my knowledge of MySQL permissions Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] There are 10 kinds of people in this world, those who understand binary and those who don't (Unknown) - Original Message - From: toby - [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 8:57 AM Subject: access denied php my admin . hay guyz im a bit stuck first i couldnt get any user but root to log into mysql on command prompt and myadmin now i can ,et my user to log in through command prompt but i get this weired error for myadmin Error MySQL said: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) zaban is my user ofcourse kwexchange is the machine i have installed all my php, apache, mysql on kwdomain is the domain we use here at ma work place another thing : winmysqladmin shows the local ip address to be kwexchange.kwdomain.com 192.168.x.xxx where it should only be 192.168.y.z there aint anything of the sort in my.ini where do i make changes for this o and another thing this machine has two cards 192.168.y.z and 192.168.x.xxx are the ips 192.168.x.xxx i can not use . i should ot infact . and i am running Win 2K Server PHP 4.2.2 apache 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 list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com
Re: Unicode
hay rob i used unicode with mysql 3.23.39 i never activated any support for my unicode data true dos will convert it into alian characters . so what u do is inzert ur unicode data into longtext fields if u want to make them full text if not keep it in blob fields i ve been workin with the 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 Howdy All! How do I activate unicode support for my tables? I searched the mysql manual and found a section that says MySQL software now offers extensive Unicode (UTF8) support but I could not find a section that went through how to do it. Secondly, if I turn on unicode support for a tables, what is the best way to get the unicode data into and out of the database in such a way that it stays as unicode? For example, when I paste unicode characters into a DOS screen, they are translated into some other characters. Thanks for any advice! Rob :) :- :-} -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: converting from foxpro to mysql ???????
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 wrote: ok guyz i need some inside info . plz help me with: 2. if i ve to conver a db in foxpro to mysql or sql which one should i preffer and y pz do nt use thz hax0r w0rdz It is really hard to read. Many people here do not speak english natively and even just using plain english is complicated. I am not going to read further about your problem. Sorry. Tonu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
converting from foxpro to mysql ???????
ok guyz i need some inside info . plz help me with: 1. there aint no foreign keys in mysql then what can i do about cascading updates, deletes and all 2. if i ve to conver a db in foxpro to mysql or sql which one should i preffer and y 3. and while im converting the foxpro db to 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 .. _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: search query crashing mysql ..... :S
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] Subject: Re: search query crashing mysql . :S Date: Mon, 25 Nov 2002 09:17:43 -0600 You did not run the quote() funcion on $arch. If $arch contains any special characters, it will break your query. toby z wrote: hay guyz im havin a weired problem i ve this search query $srch_qry = select ctnt_inf.* from ctnt_inf . where (match (firstName ) against (\.$srch.\) . or match (lastName ) against (\.$srch.\) . or match (summary ) against (\.$srch.\) . or match (body) against (\.$srch.\) . or match (title ) against (\.$srch.\) ); $srch_qry_hndl = mysql_query ($srch_qry) or die ('qry failed ! DA tbl must xixt in DA db specifyd bov :s'); n im gettin bizzar results . i)sometimes it works perfect showin all the results ii)n some times it missbehavez . shows a sorry note for the strings i KNOW exist in the full text fields im serchin on . iii)but most of 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 plz hlp thnx a mill toby .. _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
search query crashing mysql ..... :S
hay guyz im havin a weired problem i ve this search query $srch_qry = select ctnt_inf.* from ctnt_inf . where (match (firstName ) against (\.$srch.\) . or match (lastName ) against (\.$srch.\) . or match (summary ) against (\.$srch.\) . or match (body) against (\.$srch.\) . or match (title ) against (\.$srch.\) ); $srch_qry_hndl = mysql_query ($srch_qry) or die ('qry failed ! DA tbl must xixt in DA db specifyd bov :s'); n im gettin bizzar results . i)sometimes it works perfect showin all the results ii)n some times it missbehavez . shows a sorry note for the strings i KNOW exist in the full text fields im serchin on . iii)but most of 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 plz hlp thnx a mill toby .. _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
making two fields primary key ????
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 worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: storing PDF files in mysql ?????
thnx jan vat im planning to do NOW is ill store path to the pdf file in the db as i ve been told the files r gonna take a hell lotta space (n i ve planty of them) secondly i ll keep the TEXT of these pdf files in the db for indexing n them compare search keywordz with these n throw out the 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 .. From: Jan Steinman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: storing PDF files in mysql ? Date: Wed, 9 Oct 2002 12:58:33 -0700 From: Sqlcoders.com Programming Dept [EMAIL PROTECTED] You should look into (via google.com) some doc to pdf converters. An example is this com object: http://www.convertzone.com/doc2pdfcom/help.htm#HowtoBuy, it costs $219 and converts .doc to .pdf. That's $219 saved if you're on MacOS X, since PDF conversion is universally available to any application that can print. Once you have the document in PDF, it's a relatively trivial action to store the documents in your MySQL database. Using BLOBs, I assume? I believe the original quester also wanted to be able to search them, which I believe is non-trivial! You can't simply slap a FULLTEXT index on them, right? It seems to me one would have to create an index BEFORE putting the PDFs in MySQL, then add that index as a separate FULLTEXT field. SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL -- : Jan Steinman -- nature photography: http://www.Bytesmiths.com : Bytesmiths -- artists' services: http://www.Bytesmiths.com/Services : Join the forums at http://www.Bytesmiths.com/wiki - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: storing PDF files in mysql ?????
thnx guyz 1) i m tryin to put the pdf file into a blob field but i cant insert it like normal text how shall i go about inserting it 2) i m in the process of converting the word doccuments to pdf got this acrobat disteller n m havin a million probz with that alone like the security 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 [EMAIL PROTECTED],list mysql [EMAIL PROTECTED] Subject: RE: storing PDF files in mysql ? Date: Tue, 8 Oct 2002 21:47:23 -0600 Toby, If I understand correctly you want to perform two distinct actions: 1. Convert Microsoft Office Word .doc files into .pdf 2. Store those pdf's in MySQL. You should look into (via google.com) some doc to pdf converters. An example is this com object: http://www.convertzone.com/doc2pdfcom/help.htm#HowtoBuy, it costs $219 and converts .doc to .pdf. If you can convert the .doc's into .html files, you might be able to get away with using Adobe's free email converter service. Email the HTML document to [EMAIL PROTECTED], wait an hour or so, and you'll find a pdf version in your inbox. (There's also a [EMAIL PROTECTED] address if you dont want to use html, but I think you wanted to keep formatting). Once you have the document in PDF, it's a relatively trivial action to store the documents in your MySQL database. HTH, William. -Original Message- From: kayamboo [mailto:[EMAIL PROTECTED]] Sent: 08 October 2002 18:20 To: toby z Cc: list mysql Subject: Re: storing PDF files in mysql ? I think if you decide to store in the blob, whatever it is, a pdf or jpeg or bmp, it is going to be in binary format. While you need to display it back, just convert them back to whatever format you like. Else there is always the choice of just storing the path in your database. By the way, which language you are using to write your applications. If it is delphi, I can send you some sample code regards - Original Message - From: toby z [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, October 09, 2002 1:14 AM Subject: Re: storing PDF files in mysql ? thnx rich but u see the problem iz my clients want their text IN pdf format to be displayed with all these colors on the page in other words they want their sites layout to be maintained on the pages showing this pdf text as they are pretty concerned bout security so what do i do now 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) don't store the file actually in the db but store the path to it. b)use the function LOAD_FILE(filename) to get the contents of a file as a string value and store as a blob. decide which to use depending on how many pics you have cheers Rich toby gibbson wrote: 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 . _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Richard Dobson Database Administrator MRC Bright Study Clinical Pharmacolgy St Bartholomew's and the Royal London School of Medicine and Dentistry Charterhouse Square London EC1M 6BQ Tel: 020-7882-5670 Mob: 07711-522926 Fax: 020-7882-5672 [EMAIL PROTECTED] _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Unicode Support with MySQL
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 .. From: Dean Harding [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: Unicode Support with MySQL Date: Mon, 7 Oct 2002 17:44:08 +1000 According to the website, it'll be in version 4.1. You can already use Unicode now, though, you just can't sort on it or stuff like that... Dean Harding. -Original Message- From: Schmid Manfred [mailto:[EMAIL PROTECTED]] Sent: Monday, 7 October 2002 5:24 pm To: [EMAIL PROTECTED] Subject: Unicode Support with MySQL Dear Ladies and Gentleman, we are very interested in using MySQL with our machines, but we need a full Unicode-support with the database. Can you give us information's about the time, when MySQL will com with a full Unicode Support? Mit freundlichen Grüßen / Gest Regards Manfred Schmid Software-Entwicklung Abt./Dep.: KT 243 Krauss-Maffei Kunststofftechnik GmbH Bereich Reaktionstechnik / Division Reaction Technology Krauss-Maffei-Straße 2 D - 80997 München Phone: +49 - 89 - 8899-4884 Fax: +49 - 89 - 8899-4024 Mobile:+49 - 172 - 84 83 254 E-Mail:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
storing image in the db ????
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 the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
storing PDF files in mysql ?????
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 . _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Unicode Support with MySQL
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 Unicode with MySQL as well. All I was saying is that you can't sort on Unicode fields. And I have a feeling they might not be indexed correctly, either. Dean Harding. -Original Message- From: toby gibbson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 8 October 2002 8:28 pm To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Unicode Support with MySQL 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 .. From: Dean Harding [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: Unicode Support with MySQL Date: Mon, 7 Oct 2002 17:44:08 +1000 According to the website, it'll be in version 4.1. You can already use Unicode now, though, you just can't sort on it or stuff like that... Dean Harding. -Original Message- From: Schmid Manfred [mailto:[EMAIL PROTECTED]] Sent: Monday, 7 October 2002 5:24 pm To: [EMAIL PROTECTED] Subject: Unicode Support with MySQL Dear Ladies and Gentleman, we are very interested in using MySQL with our machines, but we need a full Unicode-support with the database. Can you give us information's about the time, when MySQL will com with a full Unicode Support? Mit freundlichen Grüßen / Gest Regards Manfred Schmid Software-Entwicklung Abt./Dep.: KT 243 Krauss-Maffei Kunststofftechnik GmbH Bereich Reaktionstechnik / Division Reaction Technology Krauss-Maffei-Straße 2 D - 80997 München Phone: +49 - 89 - 8899-4884 Fax: +49 - 89 - 8899-4024 Mobile: +49 - 172 - 84 83 254 E-Mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: storing PDF files in mysql ?????
thnx rich but u see the problem iz my clients want their text IN pdf format to be displayed with all these colors on the page in other words they want their sites layout to be maintained on the pages showing this pdf text as they are pretty concerned bout security so what do i do now 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) don't store the file actually in the db but store the path to it. b)use the function LOAD_FILE(filename) to get the contents of a file as a string value and store as a blob. decide which to use depending on how many pics you have cheers Rich toby gibbson wrote: 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 . _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Richard Dobson Database Administrator MRC Bright Study Clinical Pharmacolgy St Bartholomew's and the Royal London School of Medicine and Dentistry Charterhouse Square London EC1M 6BQ Tel: 020-7882-5670 Mob: 07711-522926 Fax: 020-7882-5672 [EMAIL PROTECTED] _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
users and privileges and heaer.inc.php errors ?????
hi guyz (pardon me fo this loong mail) my mysql s runnin finally accepting my user login n all thank heavens now i m havin a bit of a prob with php myadmin i found a backup of my last configuartion n i ve copied it on (since the new one just wouldn work with me) im gettin all these errors when i click on my sirDb database i get the error : Error SQL-query : SHOW TABLE STATUS FROM `sirDb` MySQL said: Access denied for user: 'sir@localhost' to database 'sirDb' --- all though i CAN login thru these but it aint letting me even select a row from any table and when i try to access any user(thru php myadmin): --- Warning: mysql_result(): supplied argument is not a valid MySQL result resource in e:\final project\zroot\myadmin\user_details.php on line 989 Warning: Cannot add header information - headers already sent by (output started at e:\final project\zroot\myadmin\user_details.php:989) in e:\final project\zroot\myadmin\libraries\ob.lib.php on line 53 Warning: Cannot add header information - headers already sent by (output started at e:\final project\zroot\myadmin\user_details.php:989) in e:\final project\zroot\myadmin\header.inc.php on line 19 Warning: Cannot add header information - headers already sent by (output started at e:\final project\zroot\myadmin\user_details.php:989) in e:\final project\zroot\myadmin\header.inc.php on line 20 Warning: Cannot add header information - headers already sent by (output started at e:\final project\zroot\myadmin\user_details.php:989) in e:\final project\zroot\myadmin\header.inc.php on line 21 Warning: Cannot add header information - headers already sent by (output started at e:\final project\zroot\myadmin\user_details.php:989) in e:\final project\zroot\myadmin\header.inc.php on line 22 Warning: Cannot add header information - headers already sent by (output started at e:\final project\zroot\myadmin\user_details.php:989) in e:\final project\zroot\myadmin\header.inc.php on line 23 Warning: Cannot add header information - headers already sent by (output started at e:\final project\zroot\myadmin\user_details.php:989) in e:\final project\zroot\myadmin\header.inc.php on line 25 Any host - Any user Error MySQL said: No user(s) found. --- and i HAVE these two users their separate databases aswell now when i ran this thing fo the first time it worked showd me both my users and their privileges (ive given em both ALL ) but now its beyond me to figure whats rong with it here r lines 18 thru to 28 of header.inc.php // Don't use cache (required for Opera) $now = gmdate('D, d M Y H:i:s') . ' GMT'; header('Expires: 0'); // rfc2616 - Section 14.21 header('Last-Modified: ' . $now); header('Cache-Control: no-store, no-cache, must-revalidate'); // HTTP/1.1 header('Cache-Control: pre-check=0, post-check=0, max-age=0'); // HTTP/1.1 header('Pragma: no-cache'); // HTTP/1.0 // Define the charset to be used header('Content-Type: text/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 _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql all messedup ... :'( .....
ok guys i ve actually done it fo myslf ... :'( mysql s all screwedup ... i reinstalled it last night and myadmin too ... now ... ive created two users and databases n ... wolla i cnt even login ... :'( i feel like banging my head against da walls vat in earth is with this thing workin prefect last week n ever since i had my hard disk formatted its all out i made the users at cmd mode o i ve win 2k pro, apache 1.3.24 , php 4.2.2 mysql 3.23.39 (now) and phpmyadmin 2.2.6 (installed from binary) and plz ... id b eternally gratefull if any one of 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/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql all messedup ... :'( .....
u think that d make much of a difference :( ... i cant work with the thing any more yaar rather cant make it work . the thing that i waz actually playin with last week ... :S and i jst cannot recall how i handled it last time i installed it on n all ... though i had my myadmin's config files saved on my disk and i ve copied them bak but still nuthin this is the error i keep gettin now Error MySQL said: Access denied for user: 'sir@localhost' (Using password: YES) nomatter where i try to acess it from ... from cmd i can do this : mysql --user sir@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 it toby . From: Iikka Merilinen [EMAIL PROTECTED] To: toby - [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: mysql all messedup ... :'( . Date: Thu, 26 Sep 2002 16:59:11 +0300 (EEST) Hi again, Sorry, you _did_ mention your MySQL version... wrote the reply in quite a hurry. Why aren't you using the latest version (3.23.52)? Iikka On Thu, 26 Sep 2002, toby - wrote: ok guys i ve actually done it fo myslf ... :'( mysql s all screwedup ... i reinstalled it last night and myadmin too ... now ... ive created two users and databases n ... wolla i cnt even login ... :'( i feel like banging my head against da walls vat in earth is with this thing workin prefect last week n ever since i had my hard disk formatted its all out i made the users at cmd mode o i ve win 2k pro, apache 1.3.24 , php 4.2.2 mysql 3.23.39 (now) and phpmyadmin 2.2.6 (installed from binary) and plz ... id b eternally gratefull if any one of 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/worldwide.aspx ** * Iikka Merilinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql all messedup ... :'( .....
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 list? After starting mysqld with --skip-grant-tables you should be able to connect with this: mysql -u root on the server, otherwise use mysql -u root -h your.server.ip.address It won't be of much help if you can't get 'root' working. Please try to get that right first and then check your own account. Best regards, Iikka hay i aint gettin no messeges except fo urs n anothr NUN ... nobodys not even the regular mails ... i even mailed gor a day or two bak but got no response ... what on earth is goin on is hotmail screwin me too :S :| anyway ive just done this : c:\mysqld --skip-grant-tables ENTER n its been 5 minutes and the cursor s till stuck at the next line blinkin n doin nuthin jeeez this is really sumthin ... shall i format my hard disk all over again ... im really fedup guys thnx a zillion . givin up toby ... :( _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: access denied ????
thnx guyz i ve win2k pro, apache 1.3.24 n php 4.2.2 i dont know how you managed to configure your system on the root only since i need multiple users each with its own set of database and tables .. heres a piece from my config.inc file . $i++; $cfgServers[$i]['host'] = 'localhost'; $cfgServers[$i]['port'] = ''; $cfgServers[$i]['socket']= ''; $cfgServers[$i]['connect_type'] = 'tcp'; $cfgServers[$i]['controluser'] = 'zaban'; $cfgServers[$i]['controlpass'] = 'orbidy'; $cfgServers[$i]['auth_type'] = 'http'; (config, http or cookie based)? $cfgServers[$i]['user'] = 'root'; $cfgServers[$i]['password'] = ''; $cfgServers[$i]['only_db'] = 'zabanDb'; $cfgServers[$i]['verbose'] = ''; $cfgServers[$i]['bookmarkdb']= ''; $cfgServers[$i]['bookmarktable'] = ''; $cfgServers[$i]['relation'] = '' $i++; $cfgServers[$i]['host'] = 'localhost'; $cfgServers[$i]['port'] = ''; $cfgServers[$i]['socket']= ''; $cfgServers[$i]['connect_type'] = 'tcp'; $cfgServers[$i]['controluser'] = 'sir'; $cfgServers[$i]['controlpass'] = 'xomby'; $cfgServers[$i]['auth_type'] = 'http'; $cfgServers[$i]['user'] = 'root'; $cfgServers[$i]['password'] = ''; $cfgServers[$i]['only_db'] = ''; $cfgServers[$i]['verbose'] = ''; $cfgServers[$i]['bookmarkdb']= ''; $cfgServers[$i]['bookmarktable'] = ''; $cfgServers[$i]['relation'] = 'sirDb'; and im stuck ... i cant even add or drop a field from a table plz plz hlp . :'( . distressed .. toby .. From: Bruce Lewis [EMAIL PROTECTED] To: toby - [EMAIL PROTECTED],[EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: access denied Date: Mon, 23 Sep 2002 10:10:59 -0500 I don't know how you have your system configured, but mine has the root only functional on the localhost. Bruce - Original Message - From: toby - [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, September 23, 2002 9:22 AM Subject: Re: access denied 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: access denied Date: Mon, 23 Sep 2002 09:02:55 -0500 mysql does not own its files. toby - wrote: 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\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 _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: access denied ????
thnx iikkaa im bsorry ... i ve win2k pro, apache 1.3.24 n php 4.2.2 all workin fine . my mysql4.0.1 alfa is givin me these night-mares cud this be the problem 4.0.1 ALFA ? it was a win zip file i guess not the source but a binary . plz do lemme know what can i do 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 platform, use this: chown mysql * in your data directory. To make things sure, chown every data file to mysql user (I assume you've created it during install). On Windows, check the permissions. I apologize for being inaccurate, but you didn't specify what operating system you're using and whether you have installed MySQL from source or from a binary package. Regards, Iikka On Mon, 23 Sep 2002, toby - wrote: 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: access denied Date: Mon, 23 Sep 2002 09:02:55 -0500 mysql does not own its files. toby - wrote: 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\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 _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ** * Iikka Merilinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: access denied ????
thnx Iikka pardon my ignorance but i ve no clue as how to give RWXD except through phpmyadmin and this is the situation there on the home of phpmyadmin ... Edit Delete Grants % root No Select Insert Update Delete Create Drop Reload Shutdown Process File Grant References Index Alter Edit Delete Grants localhost root No Select Insert Update Delete Create Drop Reload Shutdown Process File Grant References Index Alter Edit Delete Grants % sir Yes Select Insert Update Delete Create Drop Reload Shutdown Process File Grant References Index Alter Edit Delete Grants localhost zaban Yes Select Insert Update Delete Create Drop Reload Shutdown Process File Grant References Index Alter --- some how i ve got 2 roots instead of 1 n both my users ... zaban sir given me the same accessdenied error ... code 13 :s i HAVE given them all the rights i possibbly cud ... editting the grants and even revoking them ... but nothing seem to b workin n im lost at sea :'( n no clue vat to do ... i feel like takin the whole thing out n reinstallin it ... :S vat 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 - wrote: thnx iikkaa im bsorry ... i ve win2k pro, apache 1.3.24 n php 4.2.2 all workin fine . my mysql4.0.1 alfa is givin me these night-mares cud this be the problem 4.0.1 ALFA ? it was a win zip file i guess not the source but a binary . plz do lemme know what can i do n thnx a lot again toby .. Error on rename of '.\zabandb\ctnt_inf.MYI' to '.\zabandb\#sql2-5b0-7e.MYI' (Errcode: 13) perror 13 -- Permission denied So it's probably due to your NTFS file/directory permission on Windows. Please try this if _nothing_ else seems to help: grant Everyone RWXD (full) rights to the whole data directory. This has, of course, a major problem with security but that way you could check if it's really a permissions problem. Also, a more secure way to accomplish this is to run the MySQL service as a ordinary user (rather than the SYSTEM account) and grant that user full rights to the whole data directory structure (make sure the subdirectories and files get their correct permissions, too). Regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: access denied ????
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: access denied Date: Mon, 23 Sep 2002 09:02:55 -0500 mysql does not own its files. toby - wrote: 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\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 _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
access denied ????
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\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 _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
access denied ????
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\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 receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
errors while uploading my php site ...... ! ! ! !
hi guys this is a weired problem . my site s almost done and workin fine on my machine ive just uploaded it and it AINT worin on the host i confirmed php and mysql support ve made all the tables and everything the errors im getting are : Warning: Cannot send session cookie - headers already sent by (output started at /home/zabannet/public_html/styl.php:25) in /home/zabannet/public_html/lgn3.php on line 87 Warning: Cannot send session cache limiter - headers already sent (output started at /home/zabannet/public_html/styl.php:25) in /home/zabannet/public_html/lgn3.php on line 87 Warning: Cannot add header information - headers already sent by (output started at /home/zabannet/public_html/styl.php:25) in /home/zabannet/public_html/lgn3.php on line 99 i cnt imagine WHY im gettin these errors on the net and whyNOT from my system . id really appriciate any help with this muckup thnx a MILLION . toby .. _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: a newserver would be better than this mailing list
correct me if i am wrong.. with pleasure - with a newsgroup you only select the messages that you want to read or where you can give an answer on. - with this email list my mailbox fills with too many single messages, replys are not threaded (no plus sign to expand thread) - when i go on vacation, and return, i would have a mailbox that is flooded causing that my other messages could not be delivered. u could get an other account for the mailling list pal So my question, why this mailing list, why not a newsserver? i believe thers something in the world called common curtesy thats why not not EVERYbody on this planet are rude u know people do help out mewbies like myself and its thnx to this list along with php_help list that ive been able to work on my project and meet my dead lines and i just dunno how i can be 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 toby .. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: a newserver would be better than this mailing list
correct me if i am wrong.. with pleasure - with a newsgroup you only select the messages that you want to read or where you can give an answer on. - with this email list my mailbox fills with too many single messages, replys are not threaded (no plus sign to expand thread) - when i go on vacation, and return, i would have a mailbox that is flooded causing that my other messages could not be delivered. u could get an other account for the mailling list pal So my question, why this mailing list, why not a newsserver? i believe thers something in the world called common curtesy thats why not not EVERYbody on this planet are rude u know people do help out mewbies like myself and its thnx to this list along with php_help list that ive been able to work on my project and meet my dead lines and i just dunno how i can be 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 toby .. (mysql,query) _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: How to get timestamp of inserted record
jenny suppose I have added one field time_stamp of type timestamp in any existing table. it will show the current timestamp of all records. If i update any record after sometime It will also update the timestamp of updated record with current timestamp. but for insertion of any record...what i have to do...i have to mention the current timestamp value with values of all fields of a record or is there any way to insert new record so that it will automatically take current timestamp for that record. Plz specify the sql query also, if u know right now. $sql = insert into ctnt_inf (cat_id, lang_id, memb_id, firstName, lastName, title, body,summary,date_time, day, month, year ) . values ( . $cat_opt_name . , . $lang_opt_name . , . $memb_id[0]. ,' . $firstName . ', ' . $lastName . ',' . $title . ',' . $body . ',' . $summary . ', . time() . , . date(d). , . date(m). , . date(Y). ) ; this is my perfectly workin queryit inserts the timestamp along with all the other fields perfect ! !! ! hope it hlps good luck toby . _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
cant store checkbox vale ..... ?????
hi guys im stuck with check boxes now n id b really gratefull if anyone d help plx the thing is i cnt get the cheked value from a checkbox input type=checkbox name=news_letter_subs sign me up fo weekly news letter and updates/input the processing for this is: $isql = insert into usr_inf (email, firstName, lastName, news_letter_subs) . values (' . $email . ', ' . $firstName . ', ' . $lastName . ',' . $news_letter_subs . ') ; after a million checks on the passed data all the fileds get stored in my 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/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
display stuck .... ! ! ! !
hi guyx i ve a lil problem i run this query n get a result set $query = SELECT lang_id,strng_id, strng FROM strngx where pg_id = 6 and lang_id = '$lang_id '; $query_result_handle = mysql_query ($query) or die ('qry failed ! DA tbl must xixt in DA db specifyd bov '); exe and store it in $row for( $v=1; $v mysql_num_rows($query_result_handle); $v++) { $row = mysql_fetch_row($query_result_handle); $str[ $row[0] ][ $row[1] ] = $row; } alls well but i want to get a single record displayed when i do echo($row[2].br); 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 receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: question about varchars
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 the following: values are stored using only as many characters as are needed, plus one byte to record the length. Values are not padded; instead, trailing spaces are removed when values are stored. So, then would there be anything wrong with making all my varchar's up to 255. That is defining most of my fields to be varchar(255) even when i know they may only go 100? Thanks Desmond _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
redirection limit display accross multi pages .... ????
hi guyz 2 problems 1. i ve a page that picks up random records from mysql database and displays them now i want to limit the display to 5 or 6 records per page that is if it could pickup ALL the records in the db and disolay only 5 or 6 on each page my project supervisor wants something like goole search results n i tried 2 reed thru one of the source codes there but its too terrabble couldnt make anythin outta it 2. i want to redirect a link from the summary of an article to the full article the article is in mysql db how do i do dat ... or shall i PICK up 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 the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
email address authentification .....
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 . _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
rand() ... limit by .... my retrivals
hi guys im trying to retrieve 5 record each page from my db my code iz : $query_nme = SELECT firstName, lastName, title, summary FROM ctnt_inf where ctnt_id ORDER BY RAND() LIMIT 5; $query_result_handle_nme = mysql_query ($query_nme) or die ('qry failed ! DA tbl must xixt in DA db specifyd bov '); echo(pfont align=RIGHT); for ($cnt=0; $cnt=5; ++$cnt ) { $row_nme = mysql_fetch_row ($query_result_handle_nme); echo (brbr); $tID = $row_id[0]; $tName = $row_nme[0]; echo ( $tID ); echo ( $tName ); } // echo (brbr); echo(/font/p); problem: it only displays firstName n nothing else though 5 random first names but i guess i'll ve to make seperate query fo each field in the table or will i thnx a million . toby . _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RAID
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.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
time stamp ......
hi guyz im trying to save user uploaded files each with a unique name now 1. for some strange reason this piece of code aint working :S if (is_uploaded_file($HTTP_POST_FILES['$userfile']['$name'])) { copy($HTTP_POST_FILES['$userfile']['$name'],c:/tmp uploadz/); } else { echo Possible file upload attack. Filename: . $HTTP_POST_FILES['$userfile']['$name']; } neither does this : move_uploaded_file($HTTP_POST_FILES['$userfile']['$name'], c:/tmp uploadz/); i get a msg: file submitted .NeedsUPDATED.doc. file sixe .23552. file type .application/msword. Possible file upload attack. Filename: and nothing gets saved on disk 2. while this works fine $name = $firstName.$lastName.$title.$cat.$lang.$unique_id; if (copy($userfile, c:/tmp uploadz/ . $unique_id.-.$name)) echo(b file successfully uploaded /b); else //(!$userfile_size) echo( Either you did not upload any file, or you uploaded an empty file! ); whats with the first code 3. i want the file to be save as $name but it doesnt do dat it either saves the file as its original name or it saves it as its original name :( 4. the most horribale thing 1026114031-getStart.zip this is the horrid time stamp i get fo my file name whats wrong with it i cant make anything outta it where m i messing up now 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 worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
file upload ..... ????
hi everyone function calls is workin fine now thnx a million :( a new problem im trying to upload a file from client and i want it to be stored in mysql db table type myisam is that possible right now my code only copies the file on the disk simple text but i want it in my data 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 Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
function call ????
hi guyz how do i call a phpfile into another phpfile like i wanna call cat_disply.php from within article.php so dat it displays all the categories WHERE im giving it a call now i did this in c/c++ i CALLED files as i call functions but is this possible in php ? thnx a million 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 (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to create tables ....isam .... ????
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 . sql, query _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how to create tables ....isam .... ????
thnx a million paul got that :) So ... why do you want to do this? well i get really irretated of seein row# 66 right after 5 but seriously i dont know the + or - points of the types besides my project supervisor just declared v DONT NEED isam since v dont NEED row 6 after 5 n 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.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
phpmyadmin .... ?????
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 way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
cant create tables .....
hi guyz im stuck bad i cant create tables, the tables which had NO foreign keys or they didmt refer to another table were created fine but the ones WITH foreign key ... refferring to fieldz in other table(s) cant be created mysqlcreate table lang ( lang_id int auto_increment primary key, lang_ char(20) ); query ok, 0 rows effected mysqlcreate table usr_inf ( foreign key lang_id refrences lang(lang_id), ); gives me this error : error 1064: u ve an error in ur sql syntex near 'refrences lang(lang_id)'at line 1 i even tried this without (lang_id) but it still 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.msn.com/intl.asp. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
bizzar display .....
guyz all is down now i cant even get my explorer to display the unicode it was displaying till yesterday now its giving me ALL BOXES for the unicode im trying to store till yesterday it gave me boxes only for a few characters but the rest were FINE ! ! ! ! has this somethin to do with 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 worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: bizzar display .....
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 ... _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
garbage data stored .....
hi guys im working with some unicode data , store it in mysql db and retrieve it now its storing the data fine when i use longtext or mediumtext EXCEPT for a few characters it gives BOXes fo those characters in the web-browser the boxes suddenly increase their numbr of existance if i change the encoding in the web-browser to unicode ( from arabic or auto ) gives garbage charactes when i check the stored data in mysql prompt . now i NO mysql supports unicode . well sort of though thnx to u guys it iS storin most part of the unicode which proves 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.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
garbage data stored ! ! ! !
hi guys im working with some unicode data , store it in mysql db and retrieve it now its storing the data fine when i use longtext or mediumtext EXCEPT for a few characters it gives BOXes fo those characters in the web-browser the boxes suddenly increase their numbr of existance if i change the encoding in the web-browser to unicode ( from arabic or auto ) gives garbage charactes when i check the stored data in mysql prompt . now i NO mysql supports unicode . well sort of though thnx to u guys it iS storin most part of the unicode which proves 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.msn.com/intl.asp. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Unicode
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), but you can still store Unicode text in fields. Just use a BLOB or you can even use VARCHAR(), et al, but remember that you only get half as many Unicode characters as you specify in the field width... If you're using the native mysql API, you've also got to remember to escape all your text properly (i.e. cast it to a char * and convert any NULs to \0, etc). Some of the other APIs out there (JDBC or ODBC, etc) might have better binary support (i.e. you might not have to worry about it for them, just give a data pointer and field length to them) but I don't use them, so I'm not sure... Also realise that almost all the client tools out there don't recognise Unicode and so will only display the first character of your string (or something similar, depending on what's actually stored in the string). My application uses Unicode for almost everything (though I don't need to sort on any text fields so it's OK) and I've not had any problems... Dean Harding. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql and unicode ....
does mysql 32.23.51 support unicode thnx a million ... toby . _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: errors 2006 and 2000
hi just to say thanks for your help. it appears my problems were caused by different versions of myql. apparently UNIQUE command was introduced in MYSQL3.23 and my server is running MYSQL3.22.25 the code that worked in the end was: mysql create table saveMovie ( - id int not 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 15:06 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: errors 2006 and 2000 create table saveMovie ( - id int not null auto_increment, You attempted to create a table without telling MySQL which database to use (or without creating a database in the first place). Either: \u MyDatabaseName -OR- create database MyDatabaseName; \u MyDatabaseName; before trying to create a table. Jay Fesco Magical Mystery Words: database,sql,query,table - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
errors 2006 and 2000
hi i'm totally new to this so you'll have to forgive these questions if they are really basic. the situation with my server is that i have a user name that is associated with a mysql database i logged in (after telnetting in) as the user using: mysql -u username -p i then entered my password i got Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 930616 to server version: 3.22.25 Type 'help' for help. mysql as a reply which i took as a good sign. i then entered: create table saveMovie ( - id int not null auto_increment, - Name varchar(30) not null unique, - Object1 varchar(60), - Object2 varchar(60), - Object3 varchar(60), - Comment text, - primary key (id)); as a reply i got ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id:930844 Current database: databasename ERROR 2000: You have an error in your SQL syntax near 'unique, Object1 varchar(60), Object2 varchar(60), Object3 varchar(60), Comment t' at line 3 as error messages i am not sure why i am getting the error 2000 as i have got the code 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 there an error with my mysql database? thanks toby - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: errors 2006 and 2000
thanks for that i tried doing that (\u mydatabasename;) but same results: ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id:937749 Current database: databasename ERROR 2000: You have an error in your SQL syntax near 'unique, Object1 varchar(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 PROTECTED] Subject: RE: errors 2006 and 2000 create table saveMovie ( - id int not null auto_increment, You attempted to create a table without telling MySQL which database to use (or without creating a database in the first place). Either: \u MyDatabaseName -OR- create database MyDatabaseName; \u MyDatabaseName; before trying to create a table. Jay Fesco Magical Mystery Words: database,sql,query,table - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
LIMIT
Hey all, I've been using the LIMIT feature for paginating in MySQL for a long time now. It's really nice and makes paginating extremely simple. Up until now I've been using a dictionary object to get the same effect out of Microsoft SQL Server. Do any of you know a LIMIT equivalent for SQL Server? I would much rather grab the number of records I need rather than grabbing a reference to all of the records and only displaying the ones that I need. It seems redundant and I really hate the fact that LIMIT is not supported. Any ideas? By the way, suggestions for SQL Server 6.5 or SQL Server 7.0 are both appreciated. Thanks, Toby
Re: LIMIT
Believe me, it's not my first choice I hate working with M$ as much as the next guy. Unfortunately, not every project leans in the direction I want it to. As far as the LIMIT function goes I think MySQL has spoiled me. The only easy way to do pagination in ASP is through the ADO Object. The problem is that I won half the battle by getting to use PHP, but I lost the MySQL battle so I'm left with this dilemma. I think using the TOP declaration that I'll be able to come up with some workarounds in Stored Procedures. Sorry for mentioning M$ here, but it seemed like a question 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 seems redundant and I really hate the fact that LIMIT is not supported. Any ideas? By the way, suggestions for SQL Server 6.5 or SQL Server 7.0 are both appreciated. M$??.. thought this was about MySQL :-) I wouldn't know.. I do know you can find a few newsgroups somewhere at news.microsoft.com this question will fit nicely there.. Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Insert Problem
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 Hmmm I don't believe you can have a where in an insert statement. You either do or you don't. Perhaps you are thinking of update? - Original Message - From: "Toby Miller" [EMAIL PROTECTED] To: "Liste mysql" [EMAIL PROTECTED] Sent: Tuesday, January 30, 2001 6:28 AM Subject: Insert Problem I have a record being inserted and I don't see what the problem is. This is the insert statement: insert into auth_users (username, password, firstname, lastname, address1, address2, city, state, zip, phone, fax, email, hint) values ("username", "password", "firstname", "lastname", "Address1", "", "City", "ST", "12345", "444-555-", "", "[EMAIL PROTECTED]", "password hint") where username = "username" and password = "cd6c8f619fe02d9ea5d283cea1dfdefc" Here is the error that I am getting: You have an error in your SQL syntax near 'where username = "tobymiller" and password = "cd6c8f619fe02d9ea5d283cea1dfdefc"' at line 1 I am using a MD5 encrypted string for the password, that's what that is. Here is the table that this record is being inserted into: CREATE TABLE auth_users ( username varchar(20) NOT NULL, password varchar(120) NOT NULL, firstname varchar(36) NOT NULL, lastname varchar(36) NOT NULL, address1 varchar(60), address2 varchar(60), city varchar(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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php