Change mysql data dir

[Anon]

I have mysql installed with the data dir

/var/lib/mysql

However var is @ 95% usuage:

I did the following:

• stopped Apache and Mysql
• mv /var/lib/mysql /home/mysql/
• ln -s /home/mysql/mysql /var/lib/mysql
• started apache and mysql

Mysql seemed to start OK [with using databases in /var/lib/mysql]but apache couldsn't connect saying 'can't connect to mysql@localhost'

I reversed the process and everything worked.

Did I miss something?

[tasistro]

Does mysql have read/write permits on /home/mysql?

can you?

%shell%>mysql

mysql>use %yourdbasename%
mysql>show tables;

Saludos
Gerardo

[tasistro]

Since each isbn is on different rows and a mysql dump call will return each row in a different line it is better to:

$result = mysql_query ("SELECT isbn FROM items WHERE is_recommended='1'");
$i=0;
while ($sql_row=mysql_fetch_array($result)) {
if ($i==0) {
$isbns = $sql_row["isbn"];
$i=1;
} else {
$isbns = $isbns.",".$sql_row["isbn"];
}

}

[Anon]

Yes mysql is writable by mysql user