Restore Roller Mydql Database

• use ubuntu live cd  and choose " fix broken installation"
• mount a usb to /media/external by choose the use from "sudo fdisk -l"
• installed new ubuntu server 12.04 LTS from burned cd(tried usb and DVD not working).
• installed mysql server after server started(LAMP won't work because of  dns issue of home).
• mount usb and copy roller dir to /var/lib/mysql
• sudo service mysql stop
• sudo  chmod -R 660 /var/lib/mysql/roller/
• sudo chmod 700 /var/lib/mysql/roller
• sudo chown -R -f mysql:mysql /var/lib/mysql/roller
• service mysql start
• mysqlcheck --repair --all-databases
• need to dump the roller db regularly, the weblogentry table is the most important.