Trace:

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Last revisionBoth sides next revision
deb12:lamp [2024/04/25 13:44] – [MariaDB 10.11.6 Installation] Bernard Condraudeb12:lamp [2024/04/25 15:30] – [MariaDB 10.11.6 Installation] Bernard Condrau
Line 91: Line 91:
   - 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>   - 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>   - 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>

Know How

© 2007-2024 Bernard Condrau - Powered by DokuWiki