Hot answers tagged

2

This is what I do to solve this problem: Database & Asset Syncing Between Environments in Craft CMS I've found that this KISS technique of just declaring one environment as the "gold master" and pulling changes to all other environments works really well for me.


1

The database backup from Craft is slightly different to the SQL export in phpMyAdmin. Craft’s export (presumably) assumes you’re going to want to import that data into an existing site, whereas phpMyAdmin’s default (presumably) assumes you’ll want to import it into an empty database. However you can do exactly as you suggest — export from phpMyAdmin locally, ...


1

Nope, the UtilitiesController is hard-coded to use .zip: $zip = new ZipArchive(); if ($zip->open($zipPath, ZipArchive::CREATE) !== true) { throw new Exception('Cannot create zip at ' . $zipPath); } $filename = pathinfo($backupPath, PATHINFO_BASENAME); $zip->addFile($backupPath, $filename); $...


1

I would highly advise against trying to import anything directly into tables. I don't know when it was added, but everything now has a global identifier (UID) which you cannot add manually. FeedMe sounded like the right approach; I'd look at running that import on the production site and letting FeedMe import the content for you through the control panel ...


1

The typical way to do this would be to use something like https://plugins.craftcms.com/feed-me, where you could setup a feed of the data you want to export, map it to the proper fields in Craft 3, then import the data from a feed.


1

I did install the Sprout Reports but found the user interface to be very challenging, not at all obvious to me how to go about getting what I wanted. In the end, I installed Boboldehampsink Export plugin for Craft 2. This was much easier to use and I got most of my data out that way. The missing piece I was able to export direct from the database using SQL. ...


1

Most people are going the other way. Is there a particular reason you want to downgrade? ;-) Being serious though... If you need the entries in a CSV format then yes you could use an export plugin such as Sprout or Export. Or you could make a template that outputs your content in the format required. If you choose a plugin, then you'd need to read the ...


1

Assuming you want to export to a CSV, I'd recommend trying the Sprout Reports plugin... https://sprout.barrelstrengthdesign.com/craft-plugins/reports


Only top voted, non community-wiki answers of a minimum length are eligible