Undeleting an entire Database?

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

Need help with a Basic Query.

2006-03-08 Thread clint lenard
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 makes open

Re: HTML in MySQL?

2005-09-12 Thread clint lenard
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: Douglass, thanks for the tips! As far

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 HTML Sites was the opportunity to give

Re: HTML in MySQL?

2005-09-11 Thread clint lenard
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 feedback would be great! - Clint P.S. - Sorry Jasper

Re: HTML in MySQL?

2005-09-11 Thread clint lenard
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 for about a week looking for an answer to this... I'm trying to design a Database

HTML in MySQL?

2005-09-09 Thread clint lenard
trying to get it down 110%! Thanks, Clint

Re: HTML in MySQL?

2005-09-09 Thread clint lenard
! 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 Database that would hold HTML sites in the DB itself and use PHP to call

Re: HTML in MySQL?

2005-09-09 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 stupid - but I just want

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: show temporary table Date

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 +0800

RE: getting error with mysql_fix_privilege_tables

2005-01-19 Thread Clint Edwards
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 ignore a lot of errors. But it doesn't tell me about this error

RE: sub query is extermely slow

2005-01-19 Thread Clint Edwards
Sam, Can you send the output of the following: #explain your query\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 I

Re: sub query is extermely slow

2005-01-19 Thread Clint Edwards
'%buffer%';: Clint From: sam wun [EMAIL PROTECTED] To: Clint Edwards [EMAIL PROTECTED] CC: mysql@lists.mysql.com Subject: Re: sub query is extermely slow Date: Wed, 19 Jan 2005 20:39:41 +0800 Clint Edwards wrote: Sam, Can you send the output of the following: #explain your query\G Thanks

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 query' 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 PROTECTED

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 2005 17:42:34

Re: Rollback and INSERT_ID() or LAST_INSERT_ID()

2005-01-18 Thread Clint Edwards
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 [EMAIL PROTECTED] Subject: Re: Rollback

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 http

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,

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