Differences

This shows you the differences between two versions of the page.

--- deb12:lamp [2024/04/25 11:48] – [MariaDB 10.11.6 Installation] Bernard Condrau
+++ deb12:lamp [2024/04/25 15:30] – [MariaDB 10.11.6 Installation] Bernard Condrau
@@ Line 88: / Line 88: @@
 ===== MariaDB 10.11.6 Installation =====
-  * Install<file>$ sudo apt install mariadb-server</file>
+  - Install<file>$ sudo apt install mariadb-server</file>
-  * Start MariaDB<file>$ sudo service mariadb start</file>
+  - Start MariaDB<file>$ sudo service mariadb start</file>
-  * Secure the installation following [[https://linuxgenie.net/how-to-install-mariadb-on-debian-12-bookworm-distribution/|How to Install MariaDB on Debian 12 Bookworm Distribution]]<file>$ sudo mariadb-secure-installation</file>
+  - Secure the installation following [[https://linuxgenie.net/how-to-install-mariadb-on-debian-12-bookworm-distribution/|How to Install MariaDB on Debian 12 Bookworm Distribution]]<file>$ sudo mariadb-secure-installation</file>
+  - Assign a password to root
+  - Dump all databases on the old server<file>$ sudo mysqldump --all-databases > sql_file.sql</file>
+  - Copy ''sql_file.sql'' to the new server and remove databases ''mysql'' and ''phpmyadmin'' from the dump file, then import with<file>$ sudo mysql < sql_file.sql</file>
 ===== phpMyAdmin =====

Know How