After having see how we can import data from PostgreSQL and Amazon Redshift, this time we will see how we can export data from Microsoft SQL Server and import it into MySQL HeatWave Database Service in OCI. This time we will use something extra (for fun but also because it’s practical): OCI Object Storage ! […]

Thank you so much for reading OpenLampTech and making it the success it is today. Wow! 600 developers reading each week! I am humbled to say the very least.

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

In OpenLampTech issue #60, we are looking at some fantastic articles covering:

• Laravel Eloquent and Query Builder tips
• Drupal’s updated CKEditor 5
• How Symfony powers Drupal
• Best SQL Editors
• WooCommerce Payment Gateways
• And much more

Want to help OpenLampTech be a success …

If you have data stored in a Microsoft SQL Server database and you want to import it into MySQL HeatWave Database Service in OCI, you can use the procedure described in this article.

There are several ways you can try to speed up a MySQL replica. Here are some ideas:

When performing physical backup on system that are heavily used, it can happen that the backup speed cannot keep up with the redo log generation. This can happen when the backup storage is slower than the redo log storage media and this can lead in inconsistency in the generated backup. MySQL Enterprise Backup (aka MEB) […]

What is MySQL InnoDB Redo Log Archiving ? How does it work ? Discover this important MySQL InnoDB feature reading this blog post.

In this article we will see how to perform a live migration from Azure/MySQL to OCI/MySQL HeatWave. As Azure allows public connections directly to the database, this is what I will use to migrate and replicate the data between both clouds. Also, since this content is focused on data migration, I won’t explore all the […]

Live Migration from Azure Database for MySQL to MySQL HeatWave Database Service on Oracle Cloud (OCI)

Recently, I wrote several articles on how to load data from CSV files to migrate from different databases to MySQL Database Service: We saw that the most complicate is to write the CREATE TABLE statement that matches the data. I also received some questions about how to generate the table’s definition when only the CSV […]

MySQL Shell is a command-line interface for interacting with MySQL servers. It allows you to run SQL queries and perform various tasks related to MySQL databases. In this post we will see how we can use MySQL Shell and a plugin to generate table's create statement from a CSV file containing records.