Title: SQL dump not working
Last modified: August 20, 2016

---

# SQL dump not working

 *  Resolved [cyberetto](https://wordpress.org/support/users/cyberetto/)
 * (@cyberetto)
 * [13 years, 3 months ago](https://wordpress.org/support/topic/sql-dump-not-working/)
 * After updating to backwpup 3.0.1, when running the job, the SQL dump fails, saying“
   ERROR: Can not set DB charset to “
 * [28-Feb-2013 10:37:56] 1. Try for database dump …
    [28-Feb-2013 10:37:56] ERROR:
   Can not set DB charset to [28-Feb-2013 10:37:59] 2. Try for database dump … [
   28-Feb-2013 10:37:59] ERROR: Can not set DB charset to [28-Feb-2013 10:38:00]
   3. Try for database dump … [28-Feb-2013 10:38:00] ERROR: Can not set DB charset
   to
 * The backup has to include the DB for it to be successful! How can I fix this?
 * [http://wordpress.org/extend/plugins/backwpup/](http://wordpress.org/extend/plugins/backwpup/)

Viewing 7 replies - 1 through 7 (of 7 total)

 *  [Liew Cheon-Fong](https://wordpress.org/support/users/lcf/)
 * (@lcf)
 * [13 years, 3 months ago](https://wordpress.org/support/topic/sql-dump-not-working/#post-3512026)
 * I have the same error.
 *  [mll](https://wordpress.org/support/users/mll/)
 * (@mll)
 * [13 years, 3 months ago](https://wordpress.org/support/topic/sql-dump-not-working/#post-3512035)
 * Same here
 *  Plugin Contributor [Daniel Hüsken](https://wordpress.org/support/users/danielhuesken/)
 * (@danielhuesken)
 * [13 years, 3 months ago](https://wordpress.org/support/topic/sql-dump-not-working/#post-3512038)
 * ok, fixed with next update.
 *  [mikeemesser](https://wordpress.org/support/users/mikeemesser/)
 * (@mikeemesser)
 * [13 years, 3 months ago](https://wordpress.org/support/topic/sql-dump-not-working/#post-3512196)
 * Nope, this is not fixed yet, I’m getting the same error still in 3.0.4…
 *  [chrispix](https://wordpress.org/support/users/chrispix/)
 * (@chrispix)
 * [13 years, 3 months ago](https://wordpress.org/support/topic/sql-dump-not-working/#post-3512208)
 * If you go to /wp-admin/admin.php?page=backwpupsettings and click the Information
   tab, you’ll see that Blog charset is set to ‘DB_CHARSET’, which is the root of
   the problem.
 * To fix this, you need to set the DB_CHARSET environment variable in your wp-config.
   php, with the rest of your database settings. For example:
 * define(‘DB_CHARSET’, ‘utf8’);
 *  [Ov3rfly](https://wordpress.org/support/users/ov3rfly/)
 * (@ov3rfly)
 * [13 years, 3 months ago](https://wordpress.org/support/topic/sql-dump-not-working/#post-3512209)
 * Be careful with that…
 * > WARNING: Those performing new installations: There usuallly should be no reason
   > to change the default value of DB_CHARSET. If your blog needs a different character
   > set, please read [Character Sets and Collations MySQL Supports](http://codex.wordpress.org/Converting_Database_Character_Sets)
   > for valid DB_CHARSET values.
   > WARNING: Those performing upgrades (especially blogs that existed before 2.2):
   > If DB_CHARSET and DB_COLLATE do not exist in your wp-config.php file, DO NOT
   > add either definition to your wp-config.php file unless you read and understand
   > [Converting Database Character Sets](http://codex.wordpress.org/Converting_Database_Character_Sets).
   > Adding DB_CHARSET and DB_COLLATE to the wp-config.php file, for an existing
   > blog, can cause major problems.
 * Source: [http://codex.wordpress.org/Editing_wp-config.php#Database_character_set](http://codex.wordpress.org/Editing_wp-config.php#Database_character_set)
 *  [Gabe](https://wordpress.org/support/users/gabrielwhite/)
 * (@gabrielwhite)
 * [13 years, 3 months ago](https://wordpress.org/support/topic/sql-dump-not-working/#post-3512210)
 * Same issue here, and I’m using a wp-config.php that doesn’t include a definition
   of the charset (per the post of [@chrispix](https://wordpress.org/support/users/chrispix/)
   above).
 * I’m getting backup files, but they don’t include the database dump.
 * Gabe

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘SQL dump not working’ is closed to new replies.

 * ![](https://ps.w.org/backwpup/assets/icon-256x256.png?rev=3236141)
 * [BackWPup – WordPress Backup & Restore Plugin](https://wordpress.org/plugins/backwpup/)
 * [Support Threads](https://wordpress.org/support/plugin/backwpup/)
 * [Active Topics](https://wordpress.org/support/plugin/backwpup/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/backwpup/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/backwpup/reviews/)

 * 7 replies
 * 8 participants
 * Last reply from: [Gabe](https://wordpress.org/support/users/gabrielwhite/)
 * Last activity: [13 years, 3 months ago](https://wordpress.org/support/topic/sql-dump-not-working/#post-3512210)
 * Status: resolved