Differences

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

--- computing:migratewp [2022/07/31 18:53] – oemb1905
+++ computing:migratewp [2022/09/03 23:11] (current) – oemb1905
@@ Line 47: / Line 47: @@
     DROP USER 'olddbuser'@'localhost';
-That should be all there is to it!
+In cases of large databases, you might get an error that the shell lost connection to the database or that it vanished, etc. In that case, adjust your packet and timeout settings:
- --- //[[jonathan@haacksnetworking.org|oemb1905]] 2022/07/31 12:46//
+  nano /etc/mysql/mariadb.conf.d/50-server.cnf
+  <wait_timeout = 28800>
+  <interactive_timeout = 28800>
+  <max_allowed_packet=2G>
+ --- //[[jonathan@haacksnetworking.org|oemb1905]] 2022/09/03 17:10//

Haack's Wiki