# Error when exporting

**URL:** https://community.xibo.org.uk/t/error-when-exporting/17835
**Category:** Get Help
**Created:** [February 26, 2019, 4:00pm UTC](https://community.xibo.org.uk/t/error-when-exporting/17835 "2019-02-26T16:00:37Z")
**Posts on this page:** 1
**Showing post:** 4

<div class="post-metadata">

### Author: ![alex](https://community.xibo.org.uk/user_avatar/community.xibo.org.uk/alex/32/5782_2.png) [@alex](https://community.xibo.org.uk/u/alex)
#### Post date: [February 27, 2019, 8:41am UTC](https://community.xibo.org.uk/t/error-when-exporting/17835/4 "2019-02-27T08:41:09Z")

</div>

> [@How can I run a SQL command when using a Docker Install?](https://community.xibo.org.uk/t/how-can-i-run-a-sql-command-when-using-a-docker-install/9946):
>
> While troubleshooting an issue you maybe asked to run a SQL statement on your database Docker container, or you may want to run a statement yourself for another purpose. To do either of these things there are two options. Using the command line Using the GUI called PhpMyAdmin Command Line Before you can run a statement inside the docker container you will need to find the container name. This can be done using the docker ps command. The resulting output will show a list of running docker con…

Follow those notes.

Instead of running `mysql -u cms -p cms` inside the web container, you instead run:

`mysqldump -u cms -p cms > /var/www/cms/library/temp/backup.sql`

That will export the database to your CMS library temp - available as `shared/cms/library/temp` outside the container.

The containers take an automatic daily backup and put that in `shared/backup`, as well as an automatic backup on upgrade.

---

_[View the full topic](https://community.xibo.org.uk/t/error-when-exporting/17835)._