Questions tagged [back-up]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
1answer
23 views

Deleted rows from elements_sites hunting stray slugs now I can't login

Working on a migration up/down testing I went through and deleted TOO much from the element_sites table to remove unwanted slugs, not understanding really what's in there. Now I understand many ...
1
vote
0answers
23 views

Craft cannot backup - Azure

When attempting to backup with Craft, the system returns the following error: The shell command "mysqldump --defaults-extra-file="D:\local\Temp\my.cnf" --add-drop-table --comments --...
1
vote
1answer
135 views

Database backup fails

I'm building my Craft site locally, but need to make it live. When I go into Utilities -> Database Backup and try to create a backup, I get the error "There was a problem backing up your ...
1
vote
2answers
30 views

Enupal Backup not backing up assets

I am testing Enupal Backup. In the settings, I can choose to back up assets, templates, etc. But when I run the backup, only the database is acutally backed up. What am I missing here? I submitted an ...
1
vote
1answer
40 views

Download database in gzip

With using the CraftCMS builtin database export feature, is it possible to specify the export config to have the file in .gzip instead of just .zip? If, yes, then how can I do it?
1
vote
1answer
153 views

Craft CMS 3 - Manual database backup

Since my hosting provider is blocking mysqldump on its server, I'm trying to do a manual backup of my database in order to import the DB into my test environment. I'm stuck on the elements to ignore ...
2
votes
1answer
274 views

Can't backup DB locally with MAMP PRO 5.5.1

I have followed the instructions for this article (https://craftcms.com/guides/database-backups-in-craft-3-with-mamp) to get local backups working with MAMP. However, when I attempt a backup, I get ...
1
vote
1answer
258 views

Craft backup “mysqldump: not found…”

I'm getting an error message when trying to back up the Craft DB. 2019-09-04 10:21:09 [-][1][6eba342acf082a62ea47300d68faddf4][error][yii\base\Exception] yii\base\Exception: Could not create backup: ...
1
vote
1answer
147 views

ERROR: relation “assetindexdata_id_seq” already exists on new database

I'm using PostgreSQL locally and everything is working as expected. However, when I decided to move/restore the database to the staging environment I am getting this error (even through the tables do ...
1
vote
1answer
343 views

Can't Backup Database - “Failed with exit code 1” (WAMP Server)

I'm running Craft 3 on a local windows machine, but every time I try to update certain plugins (or Craft itself) I get a message "Couldn't back up the database. How would you like to proceed". The ...
1
vote
1answer
195 views

Can't login after restoring production DB locally

I'm attempting to restore a postgres DB backup on to my local dev environment but I encounter an error when trying to login as the admin user (the salient parts being): SQLSTATE[23502]: Not null ...
1
vote
2answers
456 views

Import database backup when using docker

I am trying to import a database backup into a craft instance running on Docker, but none of the fields or content from the latest backup are importing. Here are the steps I took I used these ...
0
votes
0answers
309 views

Setting up Craft 3 database backup command for a remote database server

I have my Craft 3 database on a separate server than my Craft webserver (load balancing) and when I use the download database backup function in Craft 3, it doesn't know where to look. I haven't ...
0
votes
1answer
1k views

How do I restore a site from backup

I broke permissions in a critical craft install. My solution was to install a new version of the craft, move all of the templates from the old site to the new site and restore the MySQL database. ...
1
vote
0answers
348 views

Craft 3 : Can't backup database (“failed with exit code -1”)

I can't backup database, the log says : [error][yii\base\Exception] yii\base\Exception: Could not create backup: The shell command "mysqldump {{...blablabla...}} failed with exit code -1. in /...
1
vote
1answer
910 views

Craft 3 Database Backup

Why do I have to activate the PHP functions: "proc_open" and "proc_close" to backup the database? I got the error logs: [error][yii\base\Exception] yii\base\Exception: Could not ...
1
vote
1answer
432 views

Back-up doesn't work in Craft CMS 3 on MAMP locally

I installed Craft CMS 3.0.1 locally on MAMP (Apache/PHP7.0.22), but when I want to do a backup of the database it says: "There was a problem backing up your database. Please check the Craft logs. Back-...
1
vote
1answer
209 views

Is there a way to clear old database files from storage|backups folder automatically?

We require a way to remove old db files from the storage|backups folder and I was wondering if there is a way to do this automatically or if someone has written a plugin that does it via a cron job?
2
votes
1answer
303 views

DB back-up gives syntax errors on import in new DB

I had this issue on two different sites on two different occasions and hosts. When creating a database back-up through the Craft CMS admin and importing that SQL file into a new database through PhP ...
16
votes
2answers
3k views

Best practice on importing Craft db backups?

Our team's typical workflow is pull from repo, delete craft tables, import latest db backup, work locally. We don't want everyone working on the dev server db for early development, because we'll be ...