RE: best-practices backups

2004-02-11 Thread Jeffrey Smelser
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,

RE: Question on sub-selects

2004-01-28 Thread Jeffrey Smelser
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

RE: select distinct from two columns

2004-01-02 Thread Jeffrey Smelser
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

RE: mysql.sock permission srwxrwxrwx

2004-01-02 Thread Jeffrey Smelser
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: