SQL: Shared hosting and innodb support

2002-11-29 Thread Peter M. Perchansky
Greetings: I've seen posts in a variety of forums where it states a lot of hosting companies do not offer support for Innodb SQL type tables. Is there a reason for this issue? What are the reason(s)? Thank you! - Before

SQL: Shared hosting and innodb support

2002-11-29 Thread Peter M. Perchansky
Greetings: I've seen posts in a variety of forums where it states a lot of hosting companies do not offer support for Innodb SQL type tables. Is there a reason for this issue? What are the reason(s)? Thank you! - Before

Re: SQL: Shared hosting and innodb support

2002-11-29 Thread Peter M. Perchansky
, Nov 29, 2002 at 08:59:22AM -0500, Peter M. Perchansky wrote: I've seen posts in a variety of forums where it states a lot of hosting companies do not offer support for Innodb SQL type tables. AFAIK, there is no easy way to do space management on a per-customer basis with InnoDB tables

Help with delete query

2002-06-25 Thread Peter M. Perchansky
Greetings: Thanks to Jay from this list and doing some reading, I resolved the insert issue when trying to insert records using a select where the tables are the same. Now I'm trying to clean up the old records, and no matter what delete statement I try, it fails: DELETE FROM

mySQL query help please

2002-06-24 Thread Peter M. Perchansky
should I accomplish my insert into statement so I can use the results of the select statement above? Thank you. Peter M. Perchansky, President/CEO Dynamic Net, Inc. Helping companies do business on the Net 420 Park Road; Suite 201 Wyomissing PA

RE: mySQL query help please

2002-06-24 Thread Peter M. Perchansky
' [/snip] You cannot INSERT into a table that you have SELECT 'ed from; INSERT INTO Customer_Equipment SELECT ... FROM Customer_Equipment, Customer Peter M. Perchansky, President/CEO Dynamic Net, Inc. Helping companies do business on the Net 420

Re: Question on mySQL replication

2001-12-17 Thread Peter M. Perchansky
Hi Jeremy: Thank you. At 02:05 AM 12/16/2001 -0800, you wrote: On Fri, Dec 14, 2001 at 06:36:19PM -0500, Peter M. Perchansky wrote: Greetings everyone: RE: http://www.mysql.com/doc/R/e/Replication.html How frequently does each slave get data from the master? The slaves have a thread

Question on mySQL replication

2001-12-14 Thread Peter M. Perchansky
Greetings everyone: RE: http://www.mysql.com/doc/R/e/Replication.html How frequently does each slave get data from the master? If the server the master was on went down unexpectedly, how much data would still be on the master that the slave(s) may not have picked up? Thank you.

Can mySQL log files be located on another server?

2001-12-13 Thread Peter M. Perchansky
Greetings: http://www.mysql.com/doc/B/i/Binary_log.html Is it possible to place this and the error log file generated by mySQLd on the hard drive on another server? If so, how? Thank you. Peter M. Perchansky, President/CEO Dynamic Net, Inc

Linux vs. Sun and getting Linux to behave like Sun

2001-12-06 Thread Peter M. Perchansky
by there is the safe_mysqld and mysqld process only no matter the activity? If so, how? Thank you. Peter M. Perchansky, President/CEO Dynamic Net, Inc. Helping companies do business on the Net 420 Park Road; Suite 201 Wyomissing PA 19610 Non-Toll

Re: Databases and ADODB

2001-08-18 Thread Peter M. Perchansky
good experiences with the ADODB Library for PHP4? Peter M. Perchansky, President/CEO Dynamic Net, Inc. Helping companies do business on the Net 420 Park Road; Suite 201 Wyomissing PA 19610 Non-Toll Free: 1-610-736-3795 Personal Email: [EMAIL

Help with complex SQL Query

2001-04-12 Thread Peter M. Perchansky
you. Peter M. Perchansky, Microsoft FrontPage MVP Dynamic Net, Inc. Helping companies do business on the Net 420 Park Road; Suite 201 Wyomissing PA 19610 Non-Toll Free: 1-610-736-3795 Personal Email: [EMAIL PROTECTED] Company Email

Order by clause for datetime stamp format

2001-04-03 Thread Peter M. Perchansky
. Peter M. Perchansky, Microsoft FrontPage MVP Dynamic Net, Inc. Helping companies do business on the Net 109 East High Street PO Box 86 Womelsdorf, PA 19567 Voice: 1-610-589-2262 Personal Email: [EMAIL PROTECTED] Company Email: [EMAIL PROTECTED] Web

Re: Need examples of companies using mysql

2001-03-30 Thread Peter M. Perchansky
/) Many others... Other: http://www.mysql.com/news/article-57.html http://www.mysql.com/news/article-51.html http://www.mysql.com/news/article-62.html Peter M. Perchansky, Microsoft FrontPage MVP Dynamic Net, Inc. Helping companies do business

Re: Need examples of companies using mysql

2001-03-30 Thread Peter M. Perchansky
but Verio and other companies (including ours) have been using the advanced server monitoring at http://www.wemanageservers.com/ to handle SLA reporting and compliance. ________ Peter M. Perchansky, Microsoft FrontPage MVP Dynamic Net, Inc. Helping co