Tag Archives: aware

What to be aware before importing MariaDB .sql into a MySQL database? – Databases – SitePoint Forums

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

DreamHost reviews 2021: 7 things you should be aware of

Disclosure: This content is reader-supported, which means if you click on some of our links that we may earn a commission.

Creating a thriving online presence is not rocket science; you need a good web host to provide you with everything you need to build and run a successful website – performance, security, and 24/7 support. There are hundreds of options for finding a web hosting provider for your business site, but we will help you choose the one that stands out from the crowd.

DreamHost has been around for nearly 25 years, helping individuals and organizations accelerate their online business growth. With over 400,000 customers across 100 countries, the company currently powers over 1.5 million websites worldwide.


DreamHost offers a variety of web hosting products and…


Source link