<p>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.</p>
<p>However you can do exactly as you suggest — export from phpMyAdmin locally, create a new Craft installation on your live server, use phpMyAdmin on the live server to delete the new database’s contents, then import the original data with phpMyAdmin.</p>
<p>I did this a few months ago (long story); it worked fine, nothing has exploded so far.</p>

CC BY-SA 4.0
2020-06-25T01:29:14.977Z
I will give that a shot, thank you!
Jake1293
CC BY-SA 4.0
2020-06-24T23:53:03.317Z
2020-06-24T23:53:03.317Z
mitrol
<p>I'm building my Craft site locally, but need to make it live. When I go into Utilities -&gt; Database Backup and try to create a backup, I get the error &quot;There was a problem backing up your database. Please check the Craft logs.&quot;</p>
<p>I checked the log and see this:</p>
<pre><code>  Could not create backup: The shell command &quot;mysqldump --defaults-extra-file=&quot;C:\wamp64\www\craft\storage\runtime\temp\my.cnf&quot; --add-drop-table --comments --create-options --dump-date --no-autocommit --routines --default-character-set=utf8 --set-charset --triggers --single-transaction --no-data --result-file=&quot;C:\wamp64\www\craft\storage\backups/build-your-firm_200624_180437_9nnsavzxmh_v3.4.24.sql&quot; stw &amp;&amp; mysqldump --defaults-extra-file=&quot;C:\wamp64\www\craft\storage\runtime\temp\my.cnf&quot; --add-drop-table --comments --create-options --dump-date --no-autocommit --routines --default-character-set=utf8 --set-charset --triggers --no-create-info --ignore-table=stw.stw_assetindexdata --ignore-table=stw.stw_assettransformindex --ignore-table=stw.stw_sessions --ignore-table=stw.stw_templatecaches --ignore-table=stw.stw_templatecachequeries --ignore-table=stw.stw_templatecacheelements --ignore-table=stw.stw_cache --ignore-table=stw.stw_templatecachecriteria stw &gt;&gt; &quot;C:\wamp64\www\craft\storage\backups/build-your-firm_200624_180437_9nnsavzxmh_v3.4.24.sql&quot;&quot; failed with exit code 1. in C:\wamp64\www\craft\vendor\craftcms\cms\src\controllers\UtilitiesController.php:340
</code></pre>
<p>I don't really know how to resolve that. Can I get around this by making a database backup in PhpMyAdmin?Is there any difference?</p>
<p>Thanks in advance.</p>

<database><back-up><export>
Database backup fails
# Database backup fails

(Asked by: username_0 on 2020-06-24)

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 database. Please check the Craft logs."
I checked the log and see this:
  Could not create backup: The shell command "mysqldump --defaults-extra-file="C:\wamp64\www\craft\storage\runtime\temp\my.cnf" --add-drop-table --comments --create-options --dump-date --no-autocommit --routines --default-character-set=utf8 --set-charset --triggers --single-transaction --no-data --result-file="C:\wamp64\www\craft\storage\backups/build-your-firm_200624_180437_9nnsavzxmh_v3.4.24.sql" stw && mysqldump --defaults-extra-file="C:\wamp64\www\craft\storage\runtime\temp\my.cnf" --add-drop-table --comments --create-options --dump-date --no-autocommit --routines --default-character-set=utf8 --set-charset --triggers --no-create-info --ignore-table=stw.stw_assetindexdata --ignore-table=stw.stw_assettransformindex --ignore-table=stw.stw_sessions --ignore-table=stw.stw_templatecaches --ignore-table=stw.stw_templatecachequeries --ignore-table=stw.stw_templatecacheelements --ignore-table=stw.stw_cache --ignore-table=stw.stw_templatecachecriteria stw >> "C:\wamp64\www\craft\storage\backups/build-your-firm_200624_180437_9nnsavzxmh_v3.4.24.sql"" failed with exit code 1. in C:\wamp64\www\craft\vendor\craftcms\cms\src\controllers\UtilitiesController.php:340

I don't really know how to resolve that. Can I get around this by making a database backup in PhpMyAdmin?Is there any difference?
Thanks in advance.

**Tags:** database, back-up, export

---

## 1 answers

### Answer by username_1 on 2020-06-24. Score: 1 | Accepted answer

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, create a new Craft installation on your live server, use phpMyAdmin on the live server to delete the new database’s contents, then import the original data with phpMyAdmin.

I did this a few months ago (long story); it worked fine, nothing has exploded so far.

> **Comments:**
> **username_0**: I will give that a shot, thank you!  

---

