---
title: "Magento database dump on live site"
date: "2013-01-25"
modified: "2013-03-04"
path: "/87-magento-database-dump-on-live-site.html"
section: "/ramblings"
aliases:
  - "/87"
  - "/87-magento-database-dump-on-live-site"
  - "/87.html"
  - "/ramblings/87-magento-database-dump-on-live-site.html"
---

On a live Magento store you need to be careful not to run any command that could affect the operation of the site, especially if the site is busy 24/7. The suggested solution is to perform the following mysqldump command:

```
mysqldump --single-transaction --skip-lock-tables -u root -ppass dbname > dump.sql
```

This combination attempts to extract the complete database without locking, i.e. the client can still save products and perform most admin area functionality without being blocked for any reason.
