> > 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 replic
> 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-radi
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://
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 disti
