Backup database

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.

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

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.

Hi,
great, that’s working !
Thank you !