RE: php version
Contents are Direct Alliance Corporation CONFIDENTIAL - Your best bet is to grab 4.3.1 or greater Windows version even has gui installer... http://us2.php.net/get/php-4.3.3-installer.exe/from/a/mirror This message is for the designated recipient(s) only and contains Direct Alliance Corporation privileged and confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of this email is prohibited.
RE: Mysqlcc vs Phpmyadmin
Contents are Direct Alliance Corporation CONFIDENTIAL - - For writing long sql statements I prefer mysqlcc, and the tab feature is nice. - Phpmyadmin also has some handy feature. Most of it is preference... If learn to use both then all the better... -Original Message- From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 1:15 PM To: 'Ola Ogunneye'; [EMAIL PROTECTED] Subject: RE: Mysqlcc vs Phpmyadmin No. Ones a client application the other is a web app. The client application has SQL completion, the web app does not. ---Original Message- --From: Ola Ogunneye [mailto:[EMAIL PROTECTED] --Sent: Thursday, July 31, 2003 11:52 AM --To: [EMAIL PROTECTED] --Subject: Mysqlcc vs Phpmyadmin -- --Hello again people, -- --Can someone tell me if mysqlcc does the same thing as phpmyadmin. -- --Thank you all -- --Ola -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] This message is for the designated recipient(s) only and contains Direct Alliance Corporation privileged and confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of this email is prohibited.
SQL Syntax
Contents are Direct Alliance Corporation CONFIDENTIAL - How do you type check in mysql. I have a column of type varchar(20) with both floats and strings. Is there a way to check the type? Example: Select If(is_float(col1), 'is a float', 'not a float') as type From table Thxs Cory This message is for the designated recipient(s) only and contains Direct Alliance Corporation privileged and confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of this email is prohibited.
RE: CF MySQL
Contents are Direct Alliance Corporation CONFIDENTIAL - Andrew, I have setup all the environments you are talking about. CF with MS SQL is much easier to setup and get going than PHP and mysql. However I have see twice the speed and stability with my applications that are written in PHP and MYSQL. I admit that struggling through all the setup can be cumbersome, but in the end it pays off. If you can get both PHP and MYSQL up on a Linux box even better. I have been certified in CF and used it for over 4 years. CF does have a rapid deployment phase and works well with mysql. But I believe php has a much more robust set of function, system, and networking capability that CF. Plus the key. Is that it's all FREE... CF + MS SQL + MS= $3000 + PHP + MYSQL + Linux = Freedom :) -Original Message- From: Andrew [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 9:24 AM Cc: MySQL-Lista Subject: RE: CF MySQL Thanks Curtis, interesting indeed... presumably MySQL is in a different location as CF runs off NT4 or is MySQL a win version? The reason I am asking is because a solution has been presented to me in CF and MS SQL which I think will restrict future development and wondered whether a conversion to PHP and MySQL in the future be smooth or a waste of time. Not necessarily a full conversion but addons to the site at least. Andrew -Original Message- From: Curtis Maurand [mailto:Curtis Maurand] Sent: 15 July 2003 17:02 To: [EMAIL PROTECTED] Subject: Re: CF MySQL Set up your ODBC DSN using the MyODBC driver. Set up your database. declare your dsn as normal in cold fusion. have fun. On Tuesday 15 July 2003 12:01, Andrew wrote: Hi All I've had a quick scoot about and could see anything about cold fusion and mysql is it possible to use this combination successfully if at all? Thanks Andrew --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.500 / Virus Database: 298 - Release Date: 10/07/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] This message is for the designated recipient(s) only and contains Direct Alliance Corporation privileged and confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of this email is prohibited.
RE: mysql startup script problem
Contents are Direct Alliance Corporation CONFIDENTIAL - Duane, Does mysql actually start back up? Or just get hung on step(4)? I know I have had problems running scripts over ssh because the sudo environment user wasn't being executed as root. (where a cron_tab was actually executing the script). Maybe make sure the env is trying to start the script as the correct user. -Original Message- From: Duane Winner [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 11:27 AM To: [EMAIL PROTECTED] Subject: mysql startup script problem Hello all - I'm having a small problem with the mysql startup script that ships with MySQL-3.23.56-1. I'm running on RedHat Linux. It works fine, but I have a backup server that runs a script that passes these commands remotely through ssh: (1) ssh dbsys-dc sudo /etc/init.d/mysql stop (2) ssh dbsys-dc sudo tar czpf - /var dbsys-dc.var.$(date -I).tgz (3) ssh dbsys-dc sudo tar czpf - /db dbsys-dc.db.$(date -I).tgz (4) ssh dbsys-dc sudo /etc/init.d/mysql start Essentially, what I'm doing is stopping the mysql server, then backing up the directories, the starting the server again. The problem is that I have additional commands in my backup script following line 4 above (backup additional filesystems and server, then write all the tarballs to tape), but the mysql start script does not exit properly after starting the mysql server, and I come in the next morning and find that my backup script is stuck on line 4 above, so the rest of my filesystems and servers never get backed up, nor get written to tape. If I do a ps aux and find the PID for that task and kill it, then the rest of my script will proceed. mysql stop seems to exit fine -- it's just mysql start that seems to keep the shell locked. Does anybody know how to fix this or a workaround? Thanks so much. Duane Winner [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] This message is for the designated recipient(s) only and contains Direct Alliance Corporation privileged and confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of this email is prohibited.