Re: Query OK in localhost, error on ISP server

2008-04-17 Thread contiw
Complementing the post above: I have found that SUM(DISTINCT xxx) is valid with v.5x, not so in v.4x. While I am trying to convince my ISP to switch the database to a v.5x server, I would like some help with a workaround - please excuse my newbness. I have tried : (select sum

Re: Query OK in localhost, error on ISP server

2008-04-17 Thread contiw
Complementing the post above: I have found that SUM(DISTINCT xxx) is valid with v.5x, not so in v.4x. While I am trying to convince my ISP to switch the database to a v.5x server, I would like some help with a workaround - please excuse my newbness. I have tried : (select sum

Query OK in localhost, error on ISP server

2008-04-16 Thread contiw
The following query run flawlessly in localhost but produces error on ISP server: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'distinct sf_threads.views) as views, ((count(distinct sf_messages.'

Re: ISP and users

2004-01-19 Thread William R. Mussatto
Donald Henson said: > On Fri, 2004-01-16 at 17:05, Bryan Koschmann - GKT wrote: >> Hello, >> >> I run an ISP where our web customers have access to the MySQL server. >> When they want a database, they request it through me and I add it. I >> was just curious if

Re: ISP and users

2004-01-16 Thread Donald Henson
On Fri, 2004-01-16 at 17:05, Bryan Koschmann - GKT wrote: > Hello, > > I run an ISP where our web customers have access to the MySQL server. When > they want a database, they request it through me and I add it. I was just > curious if this is the common way it is done, or if ther

ISP and users

2004-01-16 Thread Bryan Koschmann - GKT
Hello, I run an ISP where our web customers have access to the MySQL server. When they want a database, they request it through me and I add it. I was just curious if this is the common way it is done, or if there is a safe way they can add their own? Thanks, Bryan -- MySQL General

Local Host vs ISP Host Name In Connect Command

2003-08-24 Thread AMEVANS
I'm new to MySql and I'm having a problem figuring out how to configure my Connect command so I can test on my PC and upload scripts to my ISP without constantly changing the Connect command to reflect the applicable host. I use LocalHost on my machine and then change it to my ISP

Re: --- Best ISP for MySQL & PHP ???

2003-01-17 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Will, et al -- ...and then Will Standley said... % % I'm looking for an ISP to host a couple of MySQL db's... Well, you could drop me a note :-) I live here, I work here, and I host here. You'd fit right in. HTH & HAN

RE: --- Best ISP for MySQL & PHP ???

2003-01-17 Thread Hoffman, Geoffrey
I've had great luck with both: http://linuxwebhost.com and http://onsmart.net WS> From: Will Standley [mailto:[EMAIL PROTECTED]] WS> Sent: Friday, January 17, 2003 7:45 AM WS> Subject: --- Best ISP for MySQL & PHP ??? WS> I'm looking for an ISP to host a couple of

--- Best ISP for MySQL & PHP ???

2003-01-17 Thread Will Standley
Gang, I'm looking for an ISP to host a couple of MySQL db's... Will be using PHP as the scripting language... Want to use PhpMyAdmin to administer the db. Are there certain ISP's who specialize in hosting such sites? Thanks for

Re: My ISP has mySQL:how do I link to it?

2003-01-14 Thread Octavian Rasnita
No, you should contact your ISP and ask them to create you a MySQL account. Probably you don't have one. Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [EMAIL PROTECTED] - Original Message - From: "christina" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>

My ISP has mySQL:how do I link to it?

2003-01-13 Thread christina
My isp is Omnis.com. They have mySQL on my host server, and I have entered some contact info for a password login system. The system they already have doesn't let me use email addresses for logins. This is my first time using mySQL, how do I get it to link? Will it let me use email for

# Could not open database 'C:\My Documents\sps mini utility.mdb' with Mysql-frontI have been creating a M$ Access Front-end database with a MySql Back-end that im about to upload onto a ISP that supports Mysql/Php thus i have just downloaded MySql-Front . My problem is how does one connect to a previously created and complete M$ Access 2000 Database as i have a fullt functional Access thatis in my C:\My Documents So i have tried various notations in accessing ie Database (S); SEPARTED BY SEMICOLON (;)C:\My Documents\sps mini utility.mdb; 1st attempt error as below# Could not open database 'C:\My Documents\sps mini utility.mdb' - will be ignored.C;My Documents;sps mini utility.mdb; 2nd attempt error as below# Could not open database '# Could not open database 'C' - will be ignored.# Could not open database 'My Documents' - will be ignored.# Could not open database 'sps mini utility.mdb' - will be ignored.med Cheers

2002-07-09 Thread chuck amadi
Hi all im aware this might not be the correct forum but i believe it's the same beast and it should be ansewered quite easily . I have been creating a M$ Access Front-end database with a MySql Back-end that im about to upload onto a ISP that supports Mysql/Php thus i have just downloaded

browser connects to home-Windows server but not to ISP- Unix server

2002-03-30 Thread Henry de Jong
This is my first crack at mysql. I am already connecting easily to parallel mysql databases on Windows98 and on my ISP's server. I have linked to both from Access97 via ODBC and I can connect to both from command lines. I have also installed perl DBI and DBD::mysql at home. The ISP did no

ISp Setup

2002-03-01 Thread Harjit Gill
Hi all, I am a newbie to mysql and I want to setup a web server that also has MySQL on it, with several user accounts, each user has their own home directory and a virtual host entry in Apache for their website. I also want to have each users MySQL database(s) physically located within their hom

ISP Setup

2002-03-01 Thread Chris Smith
Hi, I'm sure this has been asked before, but I couldn't find it in the archives, so here goes... I want to setup a web server that also has MySQL on it, with several user accounts, each user has their own home directory and a virtual host entry in Apache for their website. I also want to have ea

Re: ISP in UK with MySQL and PHP

2001-12-24 Thread Leon Heller
>From: Bogdan Stancescu <[EMAIL PROTECTED]> >To: Leon Heller <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: Re: ISP in UK with MySQL and PHP >Date: Mon, 24 Dec 2001 23:08:07 +0200 > >Why don't you install a Linux box at home instead? You

Re: ISP in UK with MySQL and PHP

2001-12-24 Thread Bogdan Stancescu
dual-boot mode -- obviously, you'll need a free partition though. HTH Bogdan Leon Heller wrote: > MySQLers in the UK might be interested in this ISP I came across: > > http://www.uklinux.net/ > > They offer free hosting for non-commercial use with MySQL and PHP in return &

ISP in UK with MySQL and PHP

2001-12-24 Thread Leon Heller
MySQLers in the UK might be interested in this ISP I came across: http://www.uklinux.net/ They offer free hosting for non-commercial use with MySQL and PHP in return for at least one hour dial-up time per month. I've registered with them, in order to get some experience setting up

exporting from a local MySQL to remote ISP/MySQL

2001-12-23 Thread Henry-Paul Benveniste
I have installed and configured MySQL server on my local win 98 machine How may I export the locally created DB to my remote ISP/MySQL? Any third party tool? My site is set on Linux/Apache my local machine is Win 98 Thank you Henry

Re: ISP problems with 3.22.32

2001-12-19 Thread Patrick Sherrill
Have your ISP check permission on the file and parent directories. Something has changed. Pat... [EMAIL PROTECTED] SW Florida's 1st ISP www.coconet.com - Original Message - From: "Bruce Hodo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, Decembe

ISP problems with 3.22.32

2001-12-18 Thread Bruce Hodo
My ISP, WebHosting, has been hosting one of my sites for about 5 years. I use MySQL to support the site and build the pages. About a month ago, I started getting the following message when I tried to use the command line interface: mysql> select * from Properties; ERROR 1016: Can't o

ISP Usage

2001-09-05 Thread System Administrator a.k.a. The Root of the Problem
IS their and ISP tracking list for MySQL adopters? -- contact: Dave Yadallee NetLine 2000 The Edmonton Internet Service Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - Before posting, please check: http

Re: Problem creating a database with my ISP

2001-08-13 Thread Tonu Samuel
On 13 Aug 2001 21:36:47 -0700, Manuel Velasco wrote: > I am trying to create a database in my account at an > ISP with a Unix Solaris server. > > The error message: > > mydomain.com% mysqladmin create newdb > /usr/local/mysql/bin/mysqladmin: create of 'newdb' &

Problem creating a database with my ISP

2001-08-13 Thread Manuel Velasco
I am trying to create a database in my account at an ISP with a Unix Solaris server. The error message: mydomain.com% mysqladmin create newdb /usr/local/mysql/bin/mysqladmin: create of 'newdb' failed error: 'Access denied for user: '@localhost' to database 'newdb&

RE: isp complains about query...

2001-07-25 Thread Chris Bolt
> SELECT * FROM listaemail WHERE id LIKE "%%" OR nome LIKE "%%" OR empresa > LIKE "%%" OR email LIKE "%%" OR ativo LIKE "%%" ORDER BY nome; > > Time: 11 Lock_time: 0 Rows_sent: 30567 Rows_examined: 30568 > > before anyone jumps out and points it out, it is far > from being optimized. it should (an

isp complains about query...

2001-07-25 Thread portasio
to all, warm regards from brazil. here's the plot: my isp has been complaining for last couple of days about this query, generated automatically by a query generator (no, duh??)... SELECT * FROM listaemail WHERE id LIKE "%%" OR nome LIKE "%%" OR empresa LIKE "%

Re: MySQL ISP

2001-07-10 Thread Kinney Baughman
http://www.westhost.com offers a MySQL database for only $8.95 a month. -Kinney Baughman - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

Re: MySQL ISP

2001-07-10 Thread Ken Sommers
i like www.Missoulweb.com check em out.. Ken - Original Message - From: "Ohannes Murat Berin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 09, 2001 5:12 PM Subject: MySQL ISP > I am searching for an ISP which h

Re: MySQL ISP

2001-07-09 Thread Nelson Goforth
connection speed or anything): http://www.cfva.com http://www.coloradofilm.org (currently developing Perl/MySQL database) http://www.cprgonline.com(uses Perl driven flat datafile) Nelson >I am searching for an ISP which has MySQL, an

MySQL ISP

2001-07-09 Thread Ohannes Murat Berin
I am searching for an ISP which has MySQL, any suggestions? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e

Re: Recommended ISP

2001-06-06 Thread David Stubbings
Hi, Check out PHP4Hosting at : http://www.php4hosting.com They give what you want for about $10 including root access to Mysql. Regards, David Stubbings - Before posting, please check: http://www.mysql.com/manual.php

RE: Recommended ISP (query,mysql)

2001-06-06 Thread Jorge Oliveira
e.com wap: http://www.webfroggie.com - Original Message - From: mscworld To: [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 10:38 AM Subject: Recommended ISP Hello, My current Domain hosting company charges me US$28.95 for hosting with MYsql support. I am looking a lower cost se

Recommended ISP (query,mysql)

2001-06-05 Thread mscworld
- Original Message - From: mscworld To: [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 10:38 AM Subject: Recommended ISP Hello, My current Domain hosting company charges me US$28.95 for hosting with MYsql support. I am looking a lower cost service provided who can provide normal

Recommended ISP

2001-06-05 Thread mscworld
Hello, My current Domain hosting company charges me US$28.95 for hosting with MYsql support. I am looking a lower cost service provided who can provide normal domain hosting with MYSQL , PERL and PHP support without sacrificing server stablity or up-time. Any recommendation from you all?? reg

[isp-linux] Apache make fails (apache, ssl, php, mysql)

2001-05-18 Thread Steve West
n correct this problem? P.S. I'm trying to do this on a RedHat 7.0 box with a working version of apache 1.3.14 already installed. Thanks! SW Penguinistas! Find out the latest news, tips and opinions making its way through t

Re: ISP

2001-03-26 Thread Lindsay Adams
On 3/26/01 2:54 PM, "Curtis Maurand" <[EMAIL PROTECTED]> wrote: > > I would give you root access to your database, but not to Mysql as a whole > unless you want a dedicated server. Too dangerous. > > Curits > > > On 26 Mar 2001, Daniel Mercury wrote:

Re: ISP

2001-03-26 Thread Peter J. Schoenster
On 26 Mar 2001, at 17:54, Curtis Maurand wrote: > I would give you root access to your database, but not to Mysql as a > whole unless you want a dedicated server. Too dangerous. I have used iserver.com for about the last 4 years. I can start mysql,create databases etc. I find the entire

Re: ISP

2001-03-26 Thread Peter J. Schoenster
On 26 Mar 2001, at 19:48, Daniel Mercury wrote: > Who knows any good ISP giving root access to Mysql? Best I know of is iserver.com. http://www.iserver.com/support/virtual/mysql/install.html Peter --- "Reality is that which, when you stop believing in it, do

ISP

2001-03-26 Thread Daniel Mercury
Hi! Who knows any good ISP giving root access to Mysql? Get free email and a permanent address at http://www.netaddress.com/?N=1 - Before posting, please

Re: Working on mysql on ISP site

2001-02-21 Thread Ed Carp
Denis L. Menezes ([EMAIL PROTECTED]) writes: > I am hosting a website at an ISP(Verio) with mysql support. Whenever I = > use the standard mysql commands, I get an "access denied" error. I = > presume one of the following is wrong : Every ISP I've hosted at has either

Working on mysql on ISP site

2001-02-21 Thread Denis L. Menezes
hello Friends. I am very new to mysql and web site work, so please help me. I am hosting a website at an ISP(Verio) with mysql support. Whenever I use the standard mysql commands, I get an "access denied" error. I presume one of the following is wrong : 1. Maybe the user@localhost

Re: Setting up MySQL Database hosted by ISP

2001-01-13 Thread Peter Troll
more specific questions. Regards, Hello, My associate wants me to setup a MySQL database which will be hosted by his ISP. Unfortunately, they have no one (the ISP) that I can give me specific instructions on setting up the database. They know how to create it, but can tell me how to

Setting up MySQL Database hosted by ISP

2001-01-12 Thread Lee Jenkins
Hello, My associate wants me to setup a MySQL database which will be hosted by his ISP. Unfortunately, they have no one (the ISP) that I can give me specific instructions on setting up the database. They know how to create it, but can tell me how to get our data/tables into it. I