It's possible that there is an .htaccess file in phpMyAdmin that has
Magic Quotes on that is messing you up...
Other than that, it's specific to phpMyAdmin, so maybe ask those guys
what they did...
On Sat, March 1, 2008 7:38 pm, Dave M G wrote:
> PHP List, MySQL List
>
> In my PHP environment, I
On Thu, March 1, 2007 1:37 pm, Brian Dunning wrote:
> I host at Rackspace, and one thing that their monitoring service does
> NOT catch is a problem when too many connections hit MySQL, and for
> some reason it remains hung up until the service is manually
> restarted. In the meantime, this is happ
On Wed, November 9, 2005 11:05 am, Chris W wrote:
> Richard Lynch wrote:
>
>>On Sun, November 6, 2005 2:17 am, Chris W wrote:
>>
>>
>>>I just tried to use the output of the export function on phpmyadmin
>>>and
>>>got a million errors. After look
On Sun, November 6, 2005 2:17 am, Chris W wrote:
> I just tried to use the output of the export function on phpmyadmin
> and
> got a million errors. After looking at the file I found that certain
> columns that are strings were not quoted at all. I can't find any
> reason why some are and some ar
--with-mysql is supposed to be the directory in which configure can find
the mysql header (.h) files and the mysql library (mysql.so) underneath
that directory.
/usr/bin/mysql_config is a program -- a "binary" if you will
It's incredibly unlikely that your MySQL header files and the mysql.so
libr
On Wed, May 25, 2005 11:59 pm, David said:
> Does anyone know what the range for server-id can be?
>
> Is it a 16 bit number? 32 bit?
>
> I can't seem to find it in the documentation or via google.
I did dogpile.com for "my.cnf format server-id" and found:
http://mysqld.active-venture.com/Replica
On Mon, April 18, 2005 9:16 pm, Hank said:
>> Let's say you've got, oh, 2000 records to search through.
>> You're gonna end up doing a JOIN with:
>> 2,000 X 65,000 == 130,000,000 tuples (records/results).
>> 130 MILLION tuples is *way* too many for your basic $20/month site.
>
> I'd say take some e
On Tue, April 19, 2005 8:55 am, Hank said:
> Talk about over complicating things... here's the above query simplifed.
>
> I can not figure out why they were self joining the table three times:
>
> SELECT b.zip_code, b.state,
>(3956 * (2 * ASIN(SQRT(
>POWER(SIN(((a.lat-b.lat)*0.01745
On Tue, April 19, 2005 11:55 am, Hank said:
> Except that the zip code field is not (and should not be) numeric, so
> the qualification test fails.
*IF* your zip codes are all US zip 5-digit, and
*IF* performance is really crucial, and
*IF* you are 100% certain you'll never need non-US nor zip+4,
On Wed, April 20, 2005 3:20 pm, [EMAIL PROTECTED] said:
> I have a table with a field that has a field of type LONGTEXT. I try to
> insert a utf8 string with a length of 114544 and I get a warning that
> text got truncated. According to the doc, the size of LONGTEXT is much
> bigger than this. Any
On Sun, April 24, 2005 5:20 am, Mike Blezien said:
> we started getting these table handler errors 12, not all the time, but
> just now
> then. this is a FreeBSD 4.9-RELEASE O/S, w/MySQL 4.0.24 installed. The
> database
> in question is used by this vBulletin BBS system. Not sure it's a problem
> w
On Sun, April 24, 2005 3:51 pm, Schalk Neethling said:
> Hope someone can give me some pointers here. I have six tables in the
> database and I need to JOIN them on a row that appears in all of the
> tables. How do I do this? I have so far done the normal 'cross-join'
> saying SELECT * FROM table1,
You can buy up-to-the-minute zips, or snag TIGER (or gazateer?) data
that's a bit old for free.
It's a 1-1 mapping of zip to long/lat.
The tricky bit is this.
There's about 65,000 zips, even in the out-dated list for free.
Let's say you've got, oh, 2000 records to search through.
You're gonna
Apologies if this comes through twice...
I *think* I fargled the To: the first time...
My boss is claiming that having multiple 1-1 tables, with an index on the
keys, is better performance.
Example of his claim:
table_1: person_id, name, phone
table_2: person_id, address, city, state, zip, count
> mysql> SELECT COUNT(RadAcctId) FROM RadiusAccounting;
> +--+
> | COUNT(RadAcctId) |
> +--+
> |1144320 |
> +--+
> 1 row in set (1.69 sec)
>
> [EMAIL PROTECTED]:~# mysql --host=mysqldb02 --database=DB -p
> mysql> SELECT COUNT(RadAcctId) FR
Matt Babineau wrote:
> Ok I installed PHP 4.3.10 and it still has not fixed the problem. If I
> remove the SQL_CALC_FOUND_ROWS from the query, it works no problems! This
> is
> very strange behavior!
Not really that strange, I think...
While you might want to read this:
http://us4.php.net/manual
16 matches
Mail list logo
