RE: best-practices backups
> > Is there any "best-practices" wisdom on what is the most preferable > > method of backing up moderately (~10-20,000 record) MySQL 4 > > databases? A mysql dump to store records as text, the > format provided > > by the BACKUP sql command, or some other method? I am not asking > > about replication, rotating backups, or remote storage, and I am not > > concerned about the size of the backup files. Replication might be > > the best scenario for some sites but this case is not high finance. I read this over and over.. I am curious why replication is such high finance?? I run it here. The Production system is a high finance machine and the replicated box is a old clunker basically.. It doesn't take much for the stuff to be replicated over.. The high dollar has queries, this and that. The replicated machine is just simply keeping up with the changes.. That's it. You could do that with just about any decent machine.. I would think.. sure, there is going to be the few that load and change data constantly.. But I still think that would be ok.. (have to test it). Do you guys agree? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Question on sub-selects
> Hello, > > I have a question that someone here may or may not be > able to answer (I > think perhaps MySQL is incapable of a solution). I have a > program which > uses a MySQL database to help create a playlist for a > ShoutCast stream. > There is a web site associated with the web-radio. Users of > the web site > can rate songs which are contained in the database. The rating system > works such that users can rate songs from +3 to -2. Now, what I would > like to accomplish is to create a query that allows me to randomly > select a song from the database to add to the queue while taking into > account the ratings. For example: > > There are 2400 songs listed > One song has been rated three times as follows: > +3 > +1 > -1 > I would like that song to have a 3/2400 chance of being > selected for the > queue. > Secondly, I need the database to store who voted for waht so > that users > cannot continually vote +3 over and over for their favorite song. Are you trying to mimic launchcast?? I be interested in this.. I am looking for a player like that. > I know how I can accomplish this in Postgres using VIEWs, but I have > not yet been able to find a good solution in MySQL. Can > anyone recommend > a viable option? My current database structure is irrelevant, > as I will > change the structure if I can find a good solution. well, first, why the numbering scheme? I would think it be hard to devise it with negative numbers.. or is -1 basically x'ing it out?? Thanks, Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql.sock permission srwxrwxrwx
yeah, if its owned by mysql with no write privs. That doesn't mean you cant change it using root.. > I'm trying to open mysql.sock file as a ROOT and receive the > error message > permission denied. > Why mysql.sock has such permission? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: select distinct from two columns
select distinct(col1,col2) should work.. Group by most certainly will... Select col1,col2 from table group by col1, col2.. Same thing > Hello, > > The two columns of my table are name and city. I am trying to > do a list which contains only the different names. This can > be done this by distinct keyword. But all the same names > which have different cities also have to be included in my > list. So I can not do this with a distinct keyword. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
