A quick guide to moving your local databases from XAMPP's MySQL/MariaDB instance to a standalone MariaDB installation managed via HeidiSQL.
- Open the XAMPP Control Panel and start Apache and MySQL.
- Navigate to
http://localhost/phpmyadminin your browser. - Select your database from the sidebar.
- Click the Export tab.
- Select Quick export and SQL format.