After a fun day of attempts at crossgrading one of my machines to 64-bit Lubuntu, I needed to move my old local MySQL data to my new hard drive.

  1. Copy database folders stored in /var/lib/mysql/
  2. Change ownership of all databases to to mysql user: sudo chown -R mysql:mysql /var/lib/mysql/{my_database,my_other_database}

Done!

$ logout

Advertisements