MySQL question

Have a client who needs their app developed using MySQL. I have never used it before. Anyway I need to get a copy of it and run it on Windows2000. Then When I am done developing I will be putting it on a Linux machine. First where do I get a copy of MySQL and second any pitfalls I need to be concerned about? Eric

You can get all your mysql needs over at http://www.mysql.com I like the applicatoin but you MUST remember that it is mainly command line based. 1) get yourself the applicatoin install it 2) go to c:\mysql\bin and run the mysql admin, this will install it as a service You can do a lot of funky things with mySQL but what you cannot do (yet) is views and store procedures There are a lot of things right and wrong, but for a free bit of kit... it is very nice just my opinions ----- Excess quoted text cut - see Original Post for more -----

> I like the applicatoin but you MUST remember that it is mainly command > line based. <cough> MySQLCC, also free from MySQL.com </cough> -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: tom.chiverton@bluefinger.com BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.***

I meant opposed to MS SQL :) ----- Excess quoted text cut - see Original Post for more -----

> I meant opposed to MS SQL :) See George's reply :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: tom.chiverton@bluefinger.com BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.***

I do like the MySQL Control Center (MySQLCC). A better tool than Enterprise Manager for SQL Server! George At 08:56 AM 6/9/2004, Thomas Chiverton wrote: ----- Excess quoted text cut - see Original Post for more -----

Eric Creese wrote: > > First where do I get a copy of MySQL http://www.google.com/search?q=download+mysql > and second any pitfalls I need to be concerned about? Not if you read the manual 3 times from cover to cover. But else: http://sql-info.de/mysql/gotchas.html Jochem

If I were you, I would test/develop on the Linux machine right from the start.   Have a client who needs their app developed using MySQL. I have never used it before. Anyway I need to get a copy of it and run it on Windows2000. Then When I am done developing I will be putting it on a Linux machine.   First where do I get a copy of MySQL and second any pitfalls I need to be concerned about?   Eric

Does it come with a SQL interface like Query analyzer or SQL Plus?

> Does it come with a SQL interface like Query analyzer or SQL Plus? The included interface is a command line one like iSQL (if you know it) having said that (and I posted about his before) check out the php administration for mysql . very powerful and has a lot of very handy features http://www.phpmyadmin.net/home_page/. You will also be able to find a gui for it to run on windows from http://www.mysql.com I hope this helps Regards -- Mark Drew http://cybersonic.blogspot.com mailto:mark.drew@gmail.com

You can user mysqlfront : www.mysqlfront.de Pat   _____ Sent: June 8, 2004 11:38 To: CF-Talk Subject: RE: MySQL question Does it come with a SQL interface like Query analyzer or SQL Plus?   _____  

I thought My SQL is free? I can not seem to find a free download on their site. You can get all your mysql needs over at http://www.mysql.com I like the applicatoin but you MUST remember that it is mainly command line based. 1) get yourself the applicatoin install it 2) go to c:\mysql\bin and run the mysql admin, this will install it as a service You can do a lot of funky things with mySQL but what you cannot do (yet) is views and store procedures There are a lot of things right and wrong, but for a free bit of kit... it is very nice just my opinions ----- Excess quoted text cut - see Original Post for more -----   _____  

http://dev.mysql.com/downloads/index.html > I thought My SQL is free? I can not seem to find a free download on their site. > -- Mark Drew http://cybersonic.blogspot.com mailto:mark.drew@gmail.com

IT is free http://dev.mysql.com/downloads/mysql/4.0.html ====================================== Our Anti-spam solution works!! http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com http://www.forta.com/cf/isp/isp.cfm?isp_id=1069 ======================================   I thought My SQL is free? I can not seem to find a free download on their site.

thanks and I believe I found the download in the devloper section. I hope this is correct? > Does it come with a SQL interface like Query analyzer or SQL Plus? The included interface is a command line one like iSQL (if you know it) having said that (and I posted about his before) check out the php administration for mysql . very powerful and has a lot of very handy features http://www.phpmyadmin.net/home_page/. You will also be able to find a gui for it to run on windows from http://www.mysql.com I hope this helps Regards -- Mark Drew http://cybersonic.blogspot.com mailto:mark.drew@gmail.com   _____  

Eric, http://dev.mysql.com/downloads/mysql/4.0.html Scroll down to windows section and click on mirrors and then follow the prompts. That's version 4.0. Sincerely, Dave Phillips National Marketing Director Legacy for Life 615-746-3851 Dave@Dave-Phillips.com ________________________________ Sent: Tuesday, June 08, 2004 10:44 AM To: CF-Talk Subject: RE: MySQL question I thought My SQL is free? I can not seem to find a free download on their site. You can get all your mysql needs over at http://www.mysql.com I like the applicatoin but you MUST remember that it is mainly command line based. 1) get yourself the applicatoin install it 2) go to c:\mysql\bin and run the mysql admin, this will install it as a service You can do a lot of funky things with mySQL but what you cannot do (yet) is views and store procedures There are a lot of things right and wrong, but for a free bit of kit... it is very nice just my opinions > > Have a client who needs their app developed using MySQL. I have never used it before. Anyway I need to get a copy of it and run it on Windows2000. Then When I am done developing I will be putting it on a Linux machine. > > First where do I get a copy of MySQL and second any pitfalls I need to be concerned about? > > Eric > >   _____ ________________________________

Is there a user guide casue I have started this thing and I am having troubles. You can user mysqlfront : www.mysqlfront.de Pat   _____ Sent: June 8, 2004 11:38 To: CF-Talk Subject: RE: MySQL question Does it come with a SQL interface like Query analyzer or SQL Plus?   _____   _____  

Eric Creese wrote: > Is there a user guide casue I have started this thing and I am having troubles. http://www.mysql.com/ and type "manual" in the search box. Jochem

Eric I would be glad to help off list as much as I can Regards -- Mark Drew http://cybersonic.blogspot.com mailto:mark.drew@gmail.com

Yah I would use DB tool to connect with your MySQL ( I like Chili Source: SQL Console ) For all around multi-database use   Eric Creese wrote:   > Is there a user guide casue I have started this thing and I am having troubles.   http://www.mysql.com/ and type "manual" in the search box.   Jochem

I have been getting into Aqua Data Studio http://www.aquafold.com/ as I have been using the same DB's (mySQL and MS SQL) from both Mac's and PC's so it has been nice to have a useful interface (I like it ok?) ----- Excess quoted text cut - see Original Post for more -----