Mysql / Sonar Data Migration

• Take mysql dump and copy the sql file to the other machine

> mysqldump -u root -p --opt [database name] > [database name].sql

• Drop and create clean database

> mysql -u root -p
> DROP DATABASE [database name];
> CREATE DATABASE [database name];

• Create the data

> mysql -u root -p [database name] < /path/to/[database name].sql