Re: database problems.

2005-07-20 Thread Devananda
Hi Chris, I have run into this myself before as well, where the partition housing the bin log filled up. In our case, there weren't failed queries on the master; the integrity of data on the master was fine, and the slave was simply out of date, but not error-full. However, even in that case (

database problems.

2005-07-20 Thread Chris Knipe
Hi all, The moral of the story, is don't run out of disk space, but it's a bit to late for that now. A quick scenario One master server, two backups replicating from the master. Our data and bin logs are on two different partitions, and the partition holding the bin logs, ran out of disk spa

Re: mysql database problems

2005-05-18 Thread Gleb Paharenko
Hello. > with php scripts. Now I am getting the message Unable to load database > indicated by configuration file or something similiar when trying to connect > to > any database running on the server when the mysql user is running @localhost. Please, send the exact error messages and wa

Re: mysql database problems

2005-05-17 Thread Kristen G. Thorson
Are your php scripts by any chance called phpWebSite? If so, you might find more help here: http://www.phpwsforums.com/ What you're getting is almost definitely a PHP script catching some kind of error trying to connect to the database server. You should have a file called configure.php or so

mysql database problems

2005-05-16 Thread Dwayne Hottinger
Greetings all, Im new to mysql and have inherited several mysql databases and everything has been going well until lately. Most of my webpages come from mysql databases with php scripts. Now I am getting the message Unable to load database indicated by configuration file or something similiar whe

database problems

2002-04-15 Thread HITESH PATEL
respected sir/madam, i had to recently encounter of entering the movie files in a database using the blob datatype. the problems i faced are: 1) while creating the table how do i mention the size of the blob field. say.. create table test (name varchar(8),movie blob()); how

Re: database problems

2001-05-04 Thread Webmaster
I have a similar problem to this.. What happens is somehow something is causing mysql to hang which forces it to reach max connections.. if i shutdown and restart mysql using safe_mysqld --skip=networking it starts fine.. will do selects fine but not inserts because the tables that were being in

Re: database problems

2001-05-04 Thread Gerald Clark
Shut down the server before repairing tables. Robert Clugston wrote: > List, > I'm having some serious problems with MySQL. I have some PHP and perl > scripts that do INSERTs into MySQL. Multiple times during the day various > tables become corrupted. > Repairing the table using myisamch

RE: database problems

2001-05-04 Thread Robert Clugston
List, I'm having some serious problems with MySQL. I have some PHP and perl scripts that do INSERTs into MySQL. Multiple times during the day various tables become corrupted. Repairing the table using myisamchk with "-r" usually fixes the problem, but sometimes I have to restart mysqld to