Also, how did you transfer your databases? The correct way is a table dump and import, you can't usually just transfer the binary files, particularly between different versions of mysql.
On Tue, Feb 9, 2016 at 8:34 AM, steve <[email protected]> wrote: > Hi Barry, > > Obviously this isn't the best way to run mysql, as you've removed the > security layer! Mysql is very touchy ( and rightly so! ) about > fileownership. > > sudo chown -R mysql:mysql /var/lib/mysql > > will ensure it's not going to trip up on any of that. > > Once you've got mysql running, > > mysqlcheck --all-databases --auto-repair > > and > > mysql_upgrade > > may help ensure that your database is both healthy and fully compatible > with the installed software version. > > Good luck! > > Steve > > > > > On 02/05/2016 09:55 PM, Barry wrote: > >> On 04/02/16 23:02, Eliot Blennerhassett wrote: >> >>> lsof /var/lib/mysql/aria_log_control >>> >> >> Thanks for your reply. this is result, 1st command after reboot.... >> >> COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME >> mysqld 2147 mysql 3uW REG 8,8 52 1270518 >> /var/lib/mysql/aria_log_control >> >> As root tried 'kill xxxx', it does not seam to work every time. Then I >> tried other juggling around. >> >> I seem to have it starting ok now - by using mysqld_safe >> --skip-grant-tables so I think there is an error in my setup somewhere, but >> thats enough for tonight. Will try it in the morning. >> >> Ta, Barry. >> >> _______________________________________________ >> Linux-users mailing list >> [email protected] >> http://lists.canterbury.ac.nz/mailman/listinfo/linux-users >> > > -- > Steve Holdoway BSc(Hons) MIITP > http://www.greengecko.co.nz > Linkedin: http://www.linkedin.com/in/steveholdoway > Skype: sholdowa > > > _______________________________________________ > Linux-users mailing list > [email protected] > http://lists.canterbury.ac.nz/mailman/listinfo/linux-users >
_______________________________________________ Linux-users mailing list [email protected] http://lists.canterbury.ac.nz/mailman/listinfo/linux-users
