Copy MariaDb from One server to another

Direct container shell

TL;DR

TL;DR: To copy MariaDb from one server to another, make sure to use the same docker-compose.yml and .env files. If you have a 0kb Backup.sql file, try using the command "docker compose exec mariadb sh -c 'exec mysqldump --all-databases --add-drop-database -u"$MYSQL_USER" -p"$MYSQL_PASSWORD"' > ./dump.sql" in the same directory as appwrite's docker-compose.yml to create a dump.sql file for restore. Use the command "docker compose exec -T mariadb sh -c 'exec mysql -u"$MYSQL_USER" -

do you still have access to the old server?

and the old db?

Yeah

okay try these commands. I'm not a docker expert, so please bear with me lol

No Problem

docker compose exec mariadb sh -c 'exec mysqldump --all-databases --add-drop-database -u"$MYSQL_USER" -p"$MYSQL_PASSWORD"' > ./dump.sql

make sure to run this in the same directory as appwrite's doker-compose.yml

docker compose exec -T mariadb sh -c 'exec mysql -u"$MYSQL_USER" -p"$MYSQL_PASSWORD"' < dump.sql use this to restore on your other server

Doing now

let me know

add a sudo if you're not root

LOCK TABLES _console_webhooks_perms WRITE; /*!40000 ALTER TABLE _console_webhooks_perms DISABLE KEYS /; /!40000 ALTER TABLE _console_webhooks_perms ENABLE KEYS /; UNLOCK TABLES; /!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE /; /!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS /; /!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS /; /!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /; /!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /; /!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION /; /!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;