Undeleting an entire Database?

2006-04-25 Thread clint lenard
anyone might know of any special ways to get some of the data back. Thanks! - Clint Lenard

Need help with a Basic Query.

2006-03-08 Thread clint lenard
had a simple example. Thanks! - Clint -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: users are always the last to know :-)

2005-10-07 Thread clint lenard
Interesting On 10/7/05, Hassan Schroeder <[EMAIL PROTECTED]> wrote: > FYI, from the Silicon Valley Business Journal: > > > Oracle buys Finnish open source company > > Oracle Corp. said Friday it has bought Innobase OY, a software company > based in Finland, for an undisclosed price. > > Innobase m

Re: HTML in MySQL?

2005-09-12 Thread clint lenard
can anyone help me with this question? On 9/12/05, clint lenard <[EMAIL PROTECTED]> wrote: > > Hey Douglass, > > Curious about using Smarty (taking the Crash Course and bookmarked a > couple of other tut's)... One of the advantages of using a DB to store the > H

Re: HTML in MySQL?

2005-09-12 Thread clint lenard
download their site and have their own copy to upload to another domain - would it be possible to do this? Sorry, my mind is tired along with my eyes... I guess I'm still not 100% sure how Smarty works! Thanks, Clint On 9/12/05, clint lenard <[EMAIL PROTECTED]> wrote: > > Dougla

Re: HTML in MySQL?

2005-09-11 Thread clint lenard
o this! It'd probably make my life much easier if what I think you're saying is what you're actually saying lol On 9/12/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > clint lenard wrote: > > Hi guys, I'm fairly new to MySQL and I've searched fo

Re: HTML in MySQL?

2005-09-11 Thread clint lenard
I learn as much as I can before I get a major problem on my hands... I know it may be resource intensive - but it just seems to be easier to delete unused sites through a DB rather than a File System I may not have full control over? Anyways, Thanks again guys! This is helping alot! anymore fee

Re: HTML in MySQL?

2005-09-08 Thread clint lenard
David and Jasper - thank you both! I will play around with this more now that you have explained my biggest questions! Thanks guys, Clint :-) On 9/9/05, Jasper Bryant-Greene <[EMAIL PROTECTED]> wrote: > > clint lenard wrote: > > Thanks Jasper for the info! This may sound s

Re: HTML in MySQL?

2005-09-08 Thread clint lenard
.. thanks! On 9/9/05, Jasper Bryant-Greene <[EMAIL PROTECTED]> wrote: > > clint lenard wrote: > > Hi guys, I'm fairly new to MySQL and I've searched for about a week > looking > > for an answer to this... > > > > I'm trying to design a Databas

HTML in MySQL?

2005-09-08 Thread clint lenard
been reading an MySQL Manual for over a week now trying to get it down 110%! Thanks, Clint

RE: create indexes for temporary table

2005-01-23 Thread Clint Edwards
Sam, Remove the double quotes and semi-colon out of this statement: $tmp_sql = qq{alter table tmp_pastsales add index(salescode,basename,prodcode)}; Clint From: sam wun <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Subject: create indexes for temporary table Date: Sun, 23 Jan 2005 18:49:51

RE: show temporary table

2005-01-23 Thread Clint Edwards
Sam, You can use 'show tables' with a like clause if you prefix your temporary tables with a string such as 'tmp_'. See the manual for syntax: http://dev.mysql.com/doc/mysql/en/show-tables.html Clint From: sam wun <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Subject:

Re: mysql.sock file exists, but still cannot connect to server

2005-01-19 Thread Clint Edwards
The postmaster is a Postgres daemon, and pg_shadow is the user table for postgres. Clint From: Michael Stassen <[EMAIL PROTECTED]> To: Alex Majora <[EMAIL PROTECTED]> CC: mysql@lists.mysql.com Subject: Re: mysql.sock file exists, but still cannot connect to server Date: Wed, 19 Jan 2

Re: sub query is extermely slow

2005-01-19 Thread Clint Edwards
Sam, Can you create an index on transaction.date, then run your query again? If that is not better send me the output of 'explain ' again. This index may not be a good idea, depending on how many transaction are in the table on a specified date. Clint From: sam wun <[EMAIL P

Re: sub query is extermely slow

2005-01-19 Thread Clint Edwards
Sam, Can you send the following information: When was the last time 'analyze table ' (inventory, transaction, customer) was executed? OS: MySQL Version: Available Ram: Output from 'SHOW CREATE TABLE ' (inventory, transaction, and customer): Output from "SHOW VARIABLES

RE: sub query is extermely slow

2005-01-19 Thread Clint Edwards
Sam, Can you send the output of the following: #>explain \G Clint From: sam wun <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Subject: sub query is extermely slow Date: Wed, 19 Jan 2005 20:02:37 +0800 Hi list, The following sql statement takes 3 mintues to complete the query. How can

RE: getting error with mysql_fix_privilege_tables

2005-01-19 Thread Clint Edwards
r, because that is likely the same case as "Duplicate column". Clint From: scohen <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Subject: getting error with mysql_fix_privilege_tables Date: Tue, 18 Jan 2005 17:40:24 -0500 (EST) When I run mysql_fix_privilege_tables it tells me to i

Re: Rollback and INSERT_ID() or LAST_INSERT_ID()

2005-01-18 Thread Clint Edwards
_increment the table you are inserting the record into. This should be a little less resource intensive than to put all data into temporary tables. Clint From: Joerg Bruehe <[EMAIL PROTECTED]> To: mysql@lists.mysql.com CC: Andre Matos <[EMAIL PROTECTED]>, Paul DuBois <[EMAI

Sun Cobalt Web Server RTX

2003-07-17 Thread Clint S. Jones
What type of MySql can I install on a cobalt web server??? Please help... not sure... Clint S. Jones Computer Teks, Inc. President 1520 East Sunrise Blvd. Suite: 202 Fort Lauderdale, FL 33304 (954) 465-5516 (954) 767-6150 fax [EMAIL PROTECTED] www.webingenuity.net <h

Segmentation Fault when connecting via TCP/IP

2002-10-15 Thread clint
>Description: Recently the server had to be hard-booted... a safe shutdown was not possible. After the server came back up, mysql has been acting very funny. When the server first boots, mysql wont respond to anything. I restart mysql and all works fine when connecting to Localhost, ho

Re: [PHP-DB] any good web hosting with php and mysql support?

2002-01-14 Thread clint
Try www.aletiahosting.com $9.95 a month -- Original Message -- From: Gurhan Ozen <[EMAIL PROTECTED]> Date: Mon, 14 Jan 2002 13:17:59 -0500 Hi All, I am currently looking for a reliable web host to host my personal website. I know there are millions of