On Thu, Jul 5, 2012 at 11:05 AM, Alok Singh Mahor <alokma...@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 -- ubuntu-in mailing list ubuntu-in@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-in
