The old db does not have full UTF-8 support which the new server does.
Do I have to make the old db full UTF-8 compliant before exporting or can I just grab it as it is and import to the new server?
This is my current old db:
mysql> SELECT @@character_set_database, @@collation_database;
+--------------------------+----------------------+
| @@character_set_database | @@collation_database |
+--------------------------+----------------------+
| latin1 | latin1_swedish_ci |
+--------------------------+----------------------+
1 row in set (0.00 sec)
mysql> SHOW GLOBAL VARIABLES WHERE variable_name IN ('innodb_file_format', 'innodb_large_prefix', 'innodb_file_per_table');
+-----------------------+-----------+
| Variable_name | Value |
+-----------------------+-----------+
| innodb_file_format | Barracuda |
| innodb_file_per_table | ON |
| innodb_large_prefix | ON |
+-----------------------+-----------+ 3 rows in set (0.00 sec) mysql>
ShouId maybe use the 'mysql_collation.php' and 'mysql_compressed_rows.php' scripts first?
Any feedback and suggestions are welcome.
Thanks.