DEV Community

Discussion on: Appwrite In Production: Backups and Restores

Collapse
 
elreyes profile image
Fabian Reyes

Hi, I have tried to replicate this guide and everything works fine except the database restore, I get this error: ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'mysqldump: Got error: 1045: "Access denied for user 'user'@'localhost' (using...' at line 1

Collapse
 
eldadfux profile image
Eldad A. Fux

I think you need to make sure your target database has the same user credentials.

Collapse
 
elreyes profile image
Fabian Reyes • Edited

For now, I managed to restore the files and the database without any problems. Now, there is a problem. The files do not work, apparently they were restored but it is not possible to access or download them.

dev-to-uploads.s3.amazonaws.com/up...
dev-to-uploads.s3.amazonaws.com/up...

Thread Thread
 
eldadfux profile image
Eldad A. Fux

Make sure you use the same encryption key in your env file

Thread Thread
 
elreyes profile image
Fabian Reyes

You mean, this one? _APP_OPENSSL_KEY_V1

Thread Thread
 
eldadfux profile image
Eldad A. Fux

Yep :)