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:31] (current) – [Links] Bernard Condrau
@@ Line 91: / Line 91: @@
   - 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>
+  - 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 =====
@@ Line 127: / Line 130: @@
   * [[https://webmasters.stackexchange.com/questions/126557/what-is-the-difference-of-certbot-and-certbot-auto|What is the difference of certbot and certbot-auto?]]
   * [[https://www.jesusamieiro.com/remove-revoke-a-domain-in-lets-encrypt/|Remove a domain in Let’s Encrypt]]
+  * [[https://linuxgenie.net/how-to-install-mariadb-on-debian-12-bookworm-distribution/|How to Install MariaDB on Debian 12 Bookworm Distribution]]
 ===== SSL for localhost =====
 ==== Ignore invalid certificates ====

Know How