Differences

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

--- migrating_mariadb_database_from_lxc_to_docker [2024/11/02 04:29] – [3. Ensure Backup File Availability in Docker Container] oso
+++ migrating_mariadb_database_from_lxc_to_docker [2024/11/02 04:36] (current) – oso
@@ Line 8: / Line 8: @@
-  - Connect to the LXC instance running MariaDB (in this example, ''api.facundoitest.space'') and create a backup using ''mysqldump''. Replace ''facundo'' with your username and ''VeeamReports'' with your database name:
+  * Connect to the LXC instance running MariaDB (in this example, ''api.facundoitest.space'') and create a backup using ''mysqldump''. Replace ''facundo'' with your username and ''VeeamReports'' with your database name:
 <code>
@@ Line 14: / Line 14: @@
 </code>
-  - This command creates a backup file named ''veeamreports.bak'' in the current directory.
+  * This command creates a backup file named ''veeamreports.bak'' in the current directory.
 ==== 2. Copy the Backup to Docker Host ====
-  - From your local machine or the LXC instance, use ''scp'' to transfer the backup file to the Docker host (e.g., ''racknerd-vpn.facundoitest.space''):
+  * From your local machine or the LXC instance, use ''scp'' to transfer the backup file to the Docker host (e.g., ''racknerd-vpn.facundoitest.space''):
 <code>
@@ Line 25: / Line 25: @@
 </code>
-  - This will place the file in ''/home/facundo/sql-migration/'' on the Docker host.
+  * This will place the file in ''/home/facundo/sql-migration/'' on the Docker host.
 ==== 3. Ensure Backup File Availability in Docker Container ====
@@ Line 36: / Line 36: @@
 </code>
-  * **Alternative Methods**:
+=== Alternative Methods: ===
-    - **Copy the File Directly into the Container**:
+    * **Copy the File Directly into the Container**:
 <code>
 docker cp /home/facundo/sql-migration/veeamreports.bak mariadb:/veeamreports.bak
 </code>
-    - **Mount the Directory During Container Startup** (to persist the folder as ''/backup'' in the container):
+    * **Mount the Directory During Container Startup** (to persist the folder as ''/backup'' in the container):
 <code>
 docker run -d --name mariadb -v /home/facundo/sql-migration:/backup mariadb
@@ Line 49: / Line 50: @@
-  - With the backup file accessible in the container, import it into the MariaDB instance by connecting to the container:
+  * With the backup file accessible in the container, import it into the MariaDB instance by connecting to the container:
 <code>
@@ Line 55: / Line 56: @@
 </code>
-   - Run the following command to import the database. ''VeeamReports'' is the database name and ''facundo'' the user:
+  * Run the following command to import the database. ''VeeamReports'' is the database name and ''facundo'' the user:
 <code>
@@ Line 63: / Line 64: @@
 ==== 5. Verify the Import ====
-  - Confirm that the database imported successfully by connecting to MariaDB and checking for tables in ''VeeamReports'':
+  * Confirm that the database imported successfully by connecting to MariaDB and checking for tables in ''VeeamReports'':
 <code>
@@ Line 72: / Line 73: @@
 Notes
-  - **Permissions**: Ensure ''facundo'' has the necessary permissions on both the source and destination databases.
+  * **Permissions**: Ensure ''facundo'' has the necessary permissions on both the source and destination databases.
-  - **Container Access**: If ''mariadb'' is not recognized, try ''mysql'' or confirm the correct executable name for MariaDB in your setup.
+  * **Container Access**: If ''mariadb'' is not recognized, try ''mysql'' or confirm the correct executable name for MariaDB in your setup.