Re: Can't find file: './mysql/(database_name).frm'

On Tuesday 30 October 2007, Warren Young wrote:
> Tim Johnson wrote:
> > Can't find file: './mysql/(database_name).frm' for numerous databases.
>
> That's the file the actual table data is stored in. Unless you're on a
> shared machine and are trying to run a private copy of MySQL, you
> probably don't mean to put store table data in a subdirectory of the
> current directory ("./mysql"). Typically this stuff goes in
> /var/lib/mysql If that's what you want, you can either override the
> defaults by setting up a custom my.cnf or get a build of MySQL that has
> the defaults set sanely for your needs.
>
> Perhaps the Ubuntu 6.06 LTS binaries you can download from mysql.com
> will work on your newer system. If so, you can be sure they'll be
> configured sanely.

Oops! Wrongly worded subject and problem.

The file pattern is *not* as I expressed it above. It should be
./(database_name)/(table_name).frm
IOWS:
If it is a problem with the mysql database and the time_zone_name table the error references './mysql/time_zone_name.frm' If it is a problem with database 'project' and table 'customer' then the error references './project/customer.frm' I hope that is clearer.
thanks
tim

-- 
MySQL General Mailing List
For list archives: 
http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/mysql?unsub=lists@pantek.com