Back

Backup database error

  • 0
  • Self Hosted
hortigado
26 Oct, 2024, 04:57

docker-compose exec mariadb sh -c 'exec mysqldump --all-databases --add-drop-database -u"$MYSQL_USER" -p"$MYSQL_PASSWORD"' > ./dump.sql Hi, is there a way to create a backup without this command since it gives me the following error: appwrite._console_authenticators doesn't exist in engine when using LOCK TABLES. Thanks

TL;DR
Developers ran into an issue generating a backup using a specific command due to an error with 'LOCK TABLES'. To create a backup without this error, 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```
Reply

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more