On 02/11/2016 04:21 PM, 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.

You can normally get away with the binary method if going lower to higher versions, and running mysql_upgrade afterwards. Even if moving away from Larry... eg Percona MySQL or MariaDB.

But in essence you're right, and a full mysqldump as a backup is always a good idea!

Steve

--
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

Reply via email to