4.0.19
ingres. Trying to avoid MSSQL. We produce everything here on Mac. While there are MSSQL clients for Mac I've never heard much good said about them. Also I would like to stay on a platform that I can develop and test on for free.
I manage http://www.motherearthnews.com/ <--not much to look at yet I know.
I am currently using PHPMYSearch to search through our database of almost 7000 archived stories. The problem I'm runnning into is that now and then the MySQL server will crash on large searches. It goes down with a pop...
I keep getting an error whenever I try to modify a table.
Actual Error:
"Couldn't add field te.
MySQL said: Error on rename of '.\test\test.MYI' to '.\test\#sql2-368-47.MYI' (Errcode: 13)"
I have checked the permissions on the MYSQL folder, mysql data folder, and each of the individual...
32763 Opened tables in 3 days...
The MySQL Manual says "If the value is quite big" you should increase your table_cache. What is quite big for 7 sites running PHP MySQL?
What should my table_cache be set to.
This is a repeat of my earlier post with new numbers.
Chris
Obviously everyone knows that mysql ships with the default root user. I was wondering (for security) if it was possible to replace the root user with another user account or if the root user had certain privaliges that others could not have.
Application popup: mysqld-nt.exe - Application Error : The
memory could not be "read".
I have gotten this error twice now. I can't seem to find any rhyme or reason to why though. Our sites are all based on php and mysql. The Server load at the time of the crash was minimal. The only common...
The issue numbers are relative to the web site. It is asigned when I get it to post. So they will always go in order. Each has an issue number in order so the math is always constant. I apreciate the feedback, but my main concern was the 2 seperate queries and not as much how the 2 where...
Now I know that I can always jump to the third, but that would mean having to change the value in 2 places if I ever needed to go back further. I would have to change my limit clause and my result in the second query.
The reason I didn't do that was because that gets me 3 numbers, I only need two, I need the first and the last for my where clause. In php I simply did this
$maxnum = result from max query
$minnum = $maxnum - 3
Then I used the $maxnum and $minnum to fill my where clause in the query.
select...
Ok, here is the situation. We are on mysql 4.0.17 and are waiting to update to 4.1 until it is out of alpha. What I have is a biweekly magazine that could run any number of stories an issue. We are currently displaying the last 3 issues. They had limited to 3 stories per issue online but are...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.