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.' at line 6

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 this is the common way it is done

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

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 there is a safe way

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's IP

--- 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 any info

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 MySQL db's... WS Will be using PHP

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 HAND mysql query, :-D

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] Sent: Monday, January 13, 2003 6:53

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 login

# 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 MySql

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

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

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 a web

Re: ISP in UK with MySQL and PHP

2001-12-24 Thread Bogdan Stancescu
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 for at least one hour dial-up time per

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'd have the advantage of learning about configuration as well

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, December 19, 2001 12:15 AM Subject: ISP

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 open file

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

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'' mydomain.com% Could someone

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' failed error: 'Access denied for user

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 %% OR email LIKE %% OR ativo LIKE

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 (and will, as soon

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 has MySQL, any suggestions

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)

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: MySQL ISP

2001-07-09 Thread Nelson Goforth
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, any suggestions

RE: Recommended ISP (query,mysql)

2001-06-06 Thread Jorge Oliveira
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 service

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

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??

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

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

2001-05-18 Thread Steve West
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 the Linux industry. http://www.linuxplanet.com/linuxplanet/ _  The ISP-LINUX

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: 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, doesn

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

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@localh

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 a FAQ or a