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
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 looking at the file I found that
certain
columns that are strings were
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 are
--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
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:
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 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(
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 easy
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,
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
with
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
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
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) FROM
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,
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:
16 matches
Mail list logo