Thanks for your Replies everyone.
The application files were copied as necessary from /var/www/html/* to
the new ptn and the mysql database was copied and installed using
mysqldump. It went very smoothly.
Barry
--------------------------------------------
On 11/02/16 16:21, Nick Rout wrote:
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
_______________________________________________
Linux-users mailing list
[email protected]
http://lists.canterbury.ac.nz/mailman/listinfo/linux-users
