[ubuntu-in] mysql database files

Mehul Ved mehul.n.ved at gmail.com
Fri Jul 13 18:12:59 UTC 2012


On Thu, Jul 5, 2012 at 11:05 AM, Alok Singh Mahor <alokmahor at gmail.com> wrote:
> Hi all,
> yesterday I formated my / partition. before formating I just copied the
> content of /var/lib/mysql (instead of backing up databases using mysqldump).
> after instating Ubuntu again I reinstalled apache. mysql and php. and I
> copied the backed up files and folder of /var/lib/mysql to same place and I
> have set proper owner and group (mysql:mqsql) still I am unable to access my
> tables from databases. I can just list my all databases and tables.
> what I should do now to view table?

Have you checked the datadir in /etc/my.cnf?
It should be datadir=/var/lib/mysql

Else you seem to have followed correct procedure, see
http://ailoo.net/2011/03/restore-mysql-databases-from-raw-frm-files/
-- 
With Regards,
Mehul Ved



More information about the ubuntu-in mailing list