Tag Archives: MySQL

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

Step-By-Step Guide to Install and Configure MySQL on a VPS

Are you looking to harness the potential of a US-based VPS (Virtual Private Server) for your database needs? You’re in the right place! This comprehensive step-by-step guide will walk you through the process of installing and configuring MySQL on your VPS, ensuring top-notch performance and robust security. This guide is crafted with the example of utilizing a US-based VPS to highlight the possibilities it offers.

Step 1: Embrace the Power of a US-Based VPS

Before we dive into MySQL installation, let’s start by selecting a dependable VPS provider. We recommend exploring Vsys Host’s exceptional US based VPS solutions. Discover their range of plans tailored to suit your requirements at Vsys Host VPS. With their reliable infrastructure, you’re off to a…


Source link