Replication testing?

Hi All One of the managers requested me to find out about the replication testing on MySQL as one of our clients need this to be done soon. Basically what they want to do is the following: . Currently a master slave replication is in place. .

Access denied for phpmyadmin

Hi all, when i m trying to access phpmyadmin it gives the error * #1045 - Access denied for user 'pma'@'localhost' (using password: NO) ** *How could i fix the problem olease help me, Advanced thanx to you. -Regards Ganeswar Mishra Junior Programmer TathyaSoft pvt. ltd. (+91)9438014761

Re: High MySQL sleep count

In infinite wisdom Brent Clark brentgclarkl...@gmail.com wrote: All servers are in datacentres. Im not 100% sure if its latency related, but I see a load or SLEEP when I do mysqladin proc, which appears to be hogging mysql. My question is. Would adjusting timeout values address this

load data in php

Hi all, I have the following script: Load data Local infile ‘myData.csv’ Into table myTable Fields terminated by ‘,’ Enclosed by ‘’ Lines terminated by ‘\r\n’ (field1, field2, …) When this is sourced directly from mysql it works fine, but when invoked from php, I get the error The

Re: load data in php

If you are using v4 of php this will never work On Tue, Jun 1, 2010 at 10:24 AM, memo garcia mgar...@cistrans.cl wrote: Hi all, I have the following script: Load data Local infile ‘myData.csv’ Into table myTable Fields terminated by ‘,’ Enclosed by ‘’ Lines terminated by ‘\r\n’

Re: Security issues

In infinite wisdom Jerry Schwartz je...@gii.co.jp wrote: Back when this was a day-to-day concern of mine, I used to check CERT's website (the section now known as their Vulnerability Notes Database, http://www.kb.cert.org/vuls). If securing the database is your job, then you really need to

RE: load data in php

Nike, I’m using PHP 5.2.3 with Suhosin-Patch 0.9.7 (cli) (built: May 7 2010 08:41:40) Thanks, Memo García Sir CIS Asociados Consultores en Transporte S.A. Austria 2042 Providencia Santiago de Chile F: 56-2- 2051033 Fax: 56-2-2051029 www.cisconsultores.cl _ De: Mike

Strange GREATEST() result in 5.0.32

Hello all I have a stored procedure that probably does a lot more than it should, but it works fine on my test server (which is running 5.0.67). When I moved it over to the production server, (which is running 5.0.32 and I never thought to check that the versions were the same before) it works

Temporary tables created on disk: 99%

On my db server, mysql has 2 gigabytes for temporary tables and yet its creating 99% of temporary tables on disk. According to mysqltuner, 99% of temporary tables are created on disk. I've confirmed this via the show global status like 'created%' command. This is in spite of having the

Re: load data in php

This sounds like a matter to take up with whoever supports the particular PHP/MySQL interface you are using. Are you using the mysql, mysqli or dbo? The restriction very likely originates from that layer. - michael dykman On Tue, Jun 1, 2010 at 11:11 AM, memo garcia mgar...@cistrans.cl wrote:

Re: Temporary tables created on disk: 99%

On Tue, Jun 1, 2010 at 8:40 AM, John G. Heim jh...@math.wisc.edu wrote: On my db server, mysql has 2 gigabytes for temporary tables and yet its creating 99% of temporary tables on disk. According to mysqltuner, 99% of temporary tables are created on disk. Probably blobs: Instances of BLOB or

MySQL has gone - with python and blobs

Hi! I want to test my program that coded into PGSQL, and PySQLite. With these DBs I have problem on many blob deletion (2 hours) and compact/vacuum (1 hours)... So I'm trying to port my program, and before that making a test to check, which time needs to delete 1 GB of blobs. I installed

Re: MySQL has gone - with python and blobs

See http://dev.mysql.com/doc/refman/5.0/en/gone-away.html Mike At 12:37 PM 6/1/2010, durumdara wrote: Hi! I want to test my program that coded into PGSQL, and PySQLite. With these DBs I have problem on many blob deletion (2 hours) and compact/vacuum (1 hours)... So I'm trying to port my