If you need to upgrade across MariaDB versions, first dump or export your earlier-version database into a later version of MariaDB in your own environment. The mysql_upgrade command doesn't function in an Azure Database for MariaDB server, and it isn't supported. For example, if your existing MariaDB server is version 10.2, you should migrate to your Azure database for MariaDB that's configured to run version 10.2. To avoid any compatibility issues when you're dumping databases, ensure that you're using the same version of MariaDB on the source and destination systems. INSERT INTO innodb_table SELECT * FROM myisam_table ORDER BY primary_key_columns Use the clause ENGINE=InnoDB to set the engine to use for creating a new table, and then transfer the data into the compatible table before you restore it. If your tables are configured with other storage engines, convert them into the InnoDB engine format before you migrate them to your Azure database for MariaDB.įor example, if you have a WordPress app or a web app that uses MyISAM tables, first convert those tables by migrating them into InnoDB format before you restore them to your Azure database for MariaDB. Azure Database for MariaDB supports only the InnoDB storage engine, and no other storage engines. Make sure that all tables in the database use the InnoDB storage engine when you're loading data into your Azure database for MariaDB. This recommendation holds when you're moving a large amount of data, or when you want to minimize service interruption for live sites or applications. Use database dumps when you're migrating an entire database. You can use MySQL utilities such as mysqldump and mysqlpump to dump and load databases into an Azure database for MariaDB server in several common scenarios. You don't need to move the dump files to any special cloud location when you migrate data to your Azure database for MariaDB. For more information, see Configure SSL connectivity in Azure Database for MariaDB. Use an SSL-encrypted connection as a best security practice. Use these tools on your client machine with an internet connection to connect to the Azure database for MariaDB. Use common utilities and tools such as MySQL Workbench or mysqldump to remotely connect and restore data into your Azure database for MariaDB.
#Phpmyadmin restore database install
Download and install MySQL Workbench or another third-party MySQL tool for running dump and restore commands.Install the mysqldump command-line utility.Create an Azure Database for MariaDB server - Azure portal.Dump and restore by using a command-line tool (using mysqldump).īefore you begin migrating your database, do the following:.This article explains two common ways to back up and restore databases in your Azure database for MariaDB:
0 kommentar(er)
