Title: Backup database
Last modified: August 21, 2016

---

# Backup database

 *  Resolved [mycky](https://wordpress.org/support/users/mycky/)
 * (@mycky)
 * [12 years, 1 month ago](https://wordpress.org/support/topic/backup-database-1/)
 * Hi,
    I would like to know what would be your strategy to backup a website with
   the sqlite plugin ? I thought that simply backup the website files would be enough
   with sqlite plugin installed, but since the database folder rights are set to
   0707, the database folder can’t be duplicated. I don’t have root access and owner
   of database folder is “www-data nogroup”.
 * Do you have a solution ?
 * Thank you !
 * [https://wordpress.org/plugins/sqlite-integration/](https://wordpress.org/plugins/sqlite-integration/)

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

 *  Plugin Author [kjmtsh](https://wordpress.org/support/users/kjmtsh/)
 * (@kjmtsh)
 * [12 years, 1 month ago](https://wordpress.org/support/topic/backup-database-1/#post-4892116)
 * Hi, mycky
 * >  I thought that simply backup the website files would be enough with sqlite
   > plugin installed
 * Yes, I think so, too. Do you mean you have a problem in creating a backup file
   with the dashboard utility? Any error messages? You can access the utility page
   after activating the plugin.
 * Thank you.
 *  Thread Starter [mycky](https://wordpress.org/support/users/mycky/)
 * (@mycky)
 * [12 years, 1 month ago](https://wordpress.org/support/topic/backup-database-1/#post-4892130)
 * Hi kjmtsh,
    I wanted to do it by ssh. But I only get “Permission denied” messages
   when I want to list (ls), copy (cp) or chmod the database folder. I can’t access
   it and I don’t have root access on my server to change this.
 * Here is an ls on the wp-content folder concerning the database folder:
    drwx—
   rwx 2 www-data nogroup 4 May 9 09:48 database
 * Do you think I had a problem during the sqlite plugin installation ?
 * I also tried by the dashboard (tools > backup), but ended with an error I was
   expected:
    mysqldump: Got error: 2002: Can’t connect to local MySQL server through
   socket ‘/var/run/mysqld/mysqld.sock’ (2) when trying to connect mysql_connect():
   Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’(
   2), /home/mcb/mlecle25/public_html/wordpress/wp-content/plugins/backupwordpress/
   hm-backup/hm-backup.php, 724
 * Thanks for the help
 *  Plugin Author [kjmtsh](https://wordpress.org/support/users/kjmtsh/)
 * (@kjmtsh)
 * [12 years, 1 month ago](https://wordpress.org/support/topic/backup-database-1/#post-4892160)
 * Hi,
 * I’ve got the point. You can’t use the backup wordpress plugin. It is for MySQL
   database server.
 * In admin dashboard, try like below:
    1. Plugins > activate SQLite Integration
    2. Settings > SQLite Integration
    3. Click the link to Miscellaneous
 * You can see “Create or Delete backup file(s)” section. Just click backup button.
   You can download the file if you like.
 * I hope this helps you.
 *  Thread Starter [mycky](https://wordpress.org/support/users/mycky/)
 * (@mycky)
 * [12 years, 1 month ago](https://wordpress.org/support/topic/backup-database-1/#post-4892168)
 * Hi,
    great, that’s working ! Thank you !

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

The topic ‘Backup database’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/sqlite-integration.svg)
 * [SQLite Integration](https://wordpress.org/plugins/sqlite-integration/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/sqlite-integration/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/sqlite-integration/)
 * [Active Topics](https://wordpress.org/support/plugin/sqlite-integration/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/sqlite-integration/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/sqlite-integration/reviews/)

 * 4 replies
 * 2 participants
 * Last reply from: [mycky](https://wordpress.org/support/users/mycky/)
 * Last activity: [12 years, 1 month ago](https://wordpress.org/support/topic/backup-database-1/#post-4892168)
 * Status: resolved