Hello, layman here. Having MariaDB database (v. 10.6.18) on a shared hosting.
If my new hosting provider has no MariaDB but MySQL and I will be importing using PHPMyAdmin, how to spot the issues?
https://blogs.oracle.com/mysql/post/how-to-migrate-from-mariadb-to-mysql-80 says:
“Before migration (from MariaDB to MySQL), you will need to convert data in other storage engines to InnoDB”
List storage engines (SQL tab of the PHPMyAdmin):
SELECT COUNT(*) as '# TABLES',
CONCAT(ROUND(sum(data_length) / ( 1024 * 1024 * 1024 ), 2), 'G') DATA,
CONCAT(ROUND(sum(index_length) / ( 1024 * 1024 * 1024 ), 2), 'G') INDEXES,
CONCAT(sum(ROUND(( data_length + index_length ) / ( 1024 * 1024 * 1024 ), 2)), 'G') 'TOTAL SIZE', ENGINE
FROM information_schema.TABLES
WHERE TABLE_SCHEMA
...
Source link