Re: MysqlDump destination file

2008-12-19 Thread Amit Sharma
Hi Nanu, According to me You could use 1. --result-file=file, -r file 2. file (complete path or present working directory would be the place where your file would be saved) Since you are not mentioning the output to be in any different format apart from SQL, it would be a sql file. You can

Inno Setup script for MySQL and MySQL ODBC?

2008-12-19 Thread Menachem Bazian
Does anyone have an inno setup script so I can automatically install MySQL with an application? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Distinct Query Problem

2008-12-19 Thread Tompkins Neil
Hi, I've the following query which I'm having problems with. Basically I have a 5 tables as follows : MasterTB - Contains list of master records LookupTB - Contains relationship between MasterTB to ProductTB ContentTB - Contains description of product, and location of data files PriceTB -

Re: Distinct Query Problem

2008-12-19 Thread Jochem van Dieten
On Fri, Dec 19, 2008 at 7:03 PM, Tompkins Neil wrote: Basically each product is listed in the master table, and can have a number of suppliers linked to it (ProductTB). The query above will show me a list of products for all suppliers for a particular product. However I want to be able to

installation nightmare

2008-12-19 Thread PJ
Do what I can, there seems to be no way to install mysql 5.1.30 on FreeBSD 7.0 I even removed all files in reference to mysql5.0, 5.1, 6.0.8 from the Ports collection, cvsup'd the Ports, deinstalled php5, php5-mysql, phpMyAdmin, Webmin and followed the documentation as closely as possible (a

Re: installation nightmare

2008-12-19 Thread ceo
First of all, you are using a ports distribution system from BSD which means that you are not dealing with MySQL directly but with a BSD API layer on top of MySQL for installation. So much of your issues may end up being a BSD problem, not a MySQL problem at all. If the BSD scripts that

Re: installation nightmare

2008-12-19 Thread John Daisley
Take a look at the online documentation, it will give you all the info you could dream of regarding error files, installation procedures and configuration issues. I have never installed MySQL on Freebsd so can't help you there but I have installed it on Redhat, Centos, Solaris, windows and Mac

Re: Inno Setup script for MySQL and MySQL ODBC?

2008-12-19 Thread Steve Holmes
2008/12/19 Menachem Bazian gro...@bcconsultingservices.com Does anyone have an inno setup script so I can automatically install MySQL with an application? http://lists.mysql.com/mysql?unsub=sholme...@gmail.com I don't know about anyone else, but I don't know what you mean by inno setup

Re: installation nightmare

2008-12-19 Thread PJ
John Daisley wrote: Take a look at the online documentation, it will give you all the info you could dream of regarding error files, installation procedures and configuration issues. I have been looking at this stuff until my eyes pop out - perhaps there is too much of it. It certainly is very

Re: installation nightmare

2008-12-19 Thread Chaim Rieger
PJ wrote: longer a problem... but noweven pgsql was a breeze to install and update... the only reason I'm trying to install mysql is because my ISP Web host is using that... maybe not if I can help it no offense but at this time, perhaps its operator error i've installed

Re: installation nightmare

2008-12-19 Thread John Daisley
I have read through your message again because I really could not believe you were having so many issues then it struck me... You installed MySQL 6.0.8, an Alpha release on to what seems like a production box and now you are having trouble getting other versions to work? Well this isn't going to