Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Search Engine Software
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. -
Search Engine Software
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... -
Can't add field Error Code 13
Forgot to mention this is on WIN2K with MYSQL 4.017 Chris -
Can't add field Error Code 13
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...
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 -
MySQL Variables
Uptime: 7 hours, 54 minutes and 19 seconds Threads created: 18 Open tables: 35 Open files: 70 Open streams: 0 Opened tables: 4492 select: 29,909 Key reads: 4726 Key write requests: 9684712 Key writes: 108618 Max_Connections: 300 Table_Cache_Size: 300 Thread_Cache: 5....don't ask me I... -
Replace Root User
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
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... -
Getting around sub-queries
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... -
Getting around sub-queries
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. -
Getting around sub-queries
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... -
Getting around sub-queries
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...
