Hi, I have multiserver setup. 5 servers (one web, one mail, one db, and two dns) with Apache2, postfix and mysql. When I set an automatic backup in "SITE TAB", It backup ONLY website and not mysql DB. When a client go to backup tab, It can only restore website. Please help me. Thnaks.
This behavior is by design. The "Backup" feature is intended to backup the filesystem only. It is beyond the scope of ISPConfig to implement some type of atomic backup/restore process that handles both the filesystem and one or more databases. What if you were using a different database, such as postgreSQL? ISPConfig cannot possibly account for all of the variables involved. I recommend that you create a cron job that calls the "mysqldump" executable and exports the contents of the user's database(s) to the "private" directory within his website-home directory on a scheduled basis. The credentials that are passed in the arguments to "mysqldump" will ensure that only the database(s) to which the web-user in question has access are included in the dump file. With this approach, the SQL dump files will be included in the ISPConfig Backup, in which case your client will be able to restore them to the filesystem as needed. Once the dump files are restored to the filesystem, your client will be able to import the dump files by whatever means is available to him. If he has access to a tool such as phpMyAdmin, he can download the dump file to his local computer and then re-upload it using PMA. Better yet, if he has some type of shell access, he can use the "mysql" executable directly to import the backup dump files.
There is no need for a cron-job calling mysqldump. ISPConfig backups the websites on the web-server and the databases on the db-server during cron_daily.
Really? To what location on disk does ISPConfig write the database backups? Also, to be clear, does ISPConfig backup the database(s) for a given website only when a backup interval is specified for the website? Further, does ISPConfig backup the database(s) regardless of their type (e.g., MySQL vs. postgreSQL)? And, finally, does ISPConfig restore the database(s) automatically when the backup is restored?
If you enable backups for the website, ispconfig also backups the databaseses linked to the site. You can restore the website and / or the database.
Yes, you are right. I found db backup on DB SERVER. But in this way my client are unable to restore because they don't have access to /var/backup on db server
I have a problem with backup. All my Wordpress sites had their databases saved. So did the phpBB forum sites. However, sites that had BOTH a WP & phpBB database only had the phpBB database saved. Is backup limited to one database per website?
Yes they are. Their names are of the form of: c1_name_forumx c1_name_wpx Where name is a munged version of the domain name (without the .com). They share the same DB user c1_name In ever other respect they are identical to databases on other domains which back up correctly. I was wondering if the similarity in name on one account means the script may miss the second database or they see only one user and assume one database? It is forum3 (alphabetically higher = the first) that gets backed up in preference. Changing the name/user format would break other scripts
Thank you for your swift response. What do you mean by values? Both databases are connected with the same domain in the ISPConfig database listing.
I didn´t have such problems. Can you verify the db-settings in phpmyadmin? run SELECT * FROM web_database WHERE backup_interval != 'none' AND backup_interval != ''" This query displays all databases which will be backuped.
Yes they are both listed there for weekly backup. Identical records except for the database id and the database name suffix of course. The backuped database is listed ahead of the other. I have also checked the /var/backup directory on both servers. Apart from a minutes difference in the backup time the _wpx database is missing on both. Both backup ok on my own mysqldump script to another place.
How do I enable it ? I am using version 3.1.5.4p5 and want to upgrade it to a new server with version 3.1.5
upgrade to 3.1, make sure, that the database is connected to the website and enable backups in the backup-tab for the website
