• From: Australia, Victoria, Geelong
  • Registered: 2009-11-04
  • Posts: 19

Topic: Backup / Restore Plugin

This is just a suggestion, if Wolf is installed with an SQLITE DB, then why bother converting it to XML. Why not just zip up the actual SQLITE File that way if any other plugins have created custom tables within the db these will then also be backed up.

For MySQL you could just take a normal dump I guess.

And as an added option you could also consider zipping up the Public folder that way you have any CSS, Javascript, Images, etc.

Also another idea is to create an XML List of installed plugins. And then when you do the restore Wolf would go and download and install the plugins for you if they weren't already installed.
To do this properly though we would need some sort of centralised plugin repo I guess.

Speaking of which are there any sort of plans for a plugin repository??

Like I said these are just ideas and I would be happy to help out with the coding.
Just wanted to get peoples feedback.

bradleyenator's Website

Thumbs up

  • From: Leiden, The Netherlands
  • Registered: 2009-07-15
  • Posts: 2,442
  • User Karma: 31

Re: Backup / Restore Plugin

bradleyenator wrote:

This is just a suggestion, if Wolf is installed with an SQLITE DB, then why bother converting it to XML. Why not just zip up the actual SQLITE File that way if any other plugins have created custom tables within the db these will then also be backed up.

For MySQL you could just take a normal dump I guess.

Simple: because XML is DB independent.

It also means you could, for example, use it to restore just a single page/user/whatever. Plugin support will be added in the future.

Also: "normal dump"s are hardly normal. They tend to be DB version specific which leads to entirely different headaches.

bradleyenator wrote:

And as an added option you could also consider zipping up the Public folder that way you have any CSS, Javascript, Images, etc.

Could do. smile Why don't you make it a feature request?

bradleyenator wrote:

Also another idea is to create an XML List of installed plugins. And then when you do the restore Wolf would go and download and install the plugins for you if they weren't already installed.
To do this properly though we would need some sort of centralised plugin repo I guess.

Speaking of which are there any sort of plans for a plugin repository??

Yes... but I can't discuss it any more than that for now. ')

bradleyenator wrote:

Like I said these are just ideas and I would be happy to help out with the coding.
Just wanted to get peoples feedback.

And I love people who offer help. smile Please see the "Helping out" section on this page.

Wolf CMS founder and lead developer
Please always check the Support forums and Wiki before asking. (My Ohloh account.)
Like Wolf CMS? Consider making a financial contribution.

mvdkleijn's Website

Thumbs up

  • From: Australia, Victoria, Geelong
  • Registered: 2009-11-04
  • Posts: 19

Re: Backup / Restore Plugin

What you have said all makes sense.
I look forward to hearing about the plans for the Plugin Repository.
I believe this will certainly be a major improvement.

bradleyenator's Website

Thumbs up

  • From: St. Petersburg, Russia
  • Registered: 2009-08-03
  • Posts: 8

Re: Backup / Restore Plugin

Hi! All of you working plugin Backup Restore? I have a 0.7RC1 and when I click on the button "Create a backup" gives a white page. This is something I once broke? smile or plugin needed to be improved?

P.S. Yeah, just the table name has changed from user_permission to user_role smile

Last edited by kostromind (2010-12-22 13:05)

Thumbs up

  • From: St. Petersburg, Russia
  • Registered: 2009-08-03
  • Posts: 8

Re: Backup / Restore Plugin

In general, it would be good is not hard to ask the names of tables for backup, and will scan the entire database, to offer the user in the admin panel the entire list of tables in the database for backup, with marked defaults to copying the main table and the opportunity to note (selected or all) of the other tables.

Thumbs up

  • From: Veenendaal, the Netherlands
  • Registered: 2010-01-18
  • Posts: 969
  • User Karma: 18

Re: Backup / Restore Plugin

kostromind wrote:

In general, it would be good is not hard to ask the names of tables for backup, and will scan the entire database, to offer the user in the admin panel the entire list of tables in the database for backup, with marked defaults to copying the main table and the opportunity to note (selected or all) of the other tables.

Sounds like a good idea to me.
I have some custom tables in my Wolf CMS database and
currently I need to back those up separately.

Fortron's Website

Thumbs up

  • From: Leiden, The Netherlands
  • Registered: 2009-07-15
  • Posts: 2,442
  • User Karma: 31

Re: Backup / Restore Plugin

I'll update the backup_restore plugin this weekend. There was probably a reason why I hardcoded the table names in there, I'll check.

Wolf CMS founder and lead developer
Please always check the Support forums and Wiki before asking. (My Ohloh account.)
Like Wolf CMS? Consider making a financial contribution.

mvdkleijn's Website

Thumbs up

  • From: Spain
  • Registered: 2010-07-08
  • Posts: 305
  • User Karma: 35

Re: Backup / Restore Plugin

I'll post the Spanish translation file for this plugin here, but for the other core plugins, do I submit an issue or post them in their own topic?

es-message.php.

Thumbs up

  • From: Leiden, The Netherlands
  • Registered: 2009-07-15
  • Posts: 2,442
  • User Karma: 31

Re: Backup / Restore Plugin

Submitting an issue is fine, then they won't get lost. smile

By the way, for those keeping track... I updated the backup_restore plugin as part of 0.7.0 final to retrieve table names. I immediately remembered why. Its not an easy thing to do in a DB independent manner. Anyway, it should work now. I tested it locally with a MySQL, SQLite and PostgreSQL DB.

I'm very much up for improvements to the SQL though.

Wolf CMS founder and lead developer
Please always check the Support forums and Wiki before asking. (My Ohloh account.)
Like Wolf CMS? Consider making a financial contribution.

mvdkleijn's Website

Thumbs up

10 Reply by gabor

  • gabor
  • Community member
  • Offline
  • Registered: 2010-09-01
  • Posts: 24

Re: Backup / Restore Plugin

Hi,
Just another idea regarding backup/restore plugin.
Would this be possible to make backups online and be able to restore immediately? I would happily wast some hosting space.
regards
Gabor

Thumbs up

11 Reply by graeme

  • graeme
  • Community member
  • Offline
  • Registered: 2009-09-28
  • Posts: 67

Re: Backup / Restore Plugin

If you want to back up the SQLite database as is, you can just copy the file.

I use rysnc to backup everything: SQLite database and the entire installation. It only backs up what has changed, so, and it compresses data transferred, so its very fast. It can tunnel over SSH so it works with most shared hosting these days.

I use a nice GUI for rsync called GRsync.

I love rsync. Its incredibly useful for backups (even local ones), uploads (much faster than FTP), and one way syncing.

Thumbs up

  • From: Leiden, The Netherlands
  • Registered: 2009-07-15
  • Posts: 2,442
  • User Karma: 31

Re: Backup / Restore Plugin

@gabor - Its a good idea for a next version of the plugin.

@graeme - gabor didn't specify what DB was used. Could be MySQL. smile But you're very right about SQLite and rsync. (very useful tool, rsync)

Wolf CMS founder and lead developer
Please always check the Support forums and Wiki before asking. (My Ohloh account.)
Like Wolf CMS? Consider making a financial contribution.

mvdkleijn's Website

Thumbs up

13 Reply by graeme

  • graeme
  • Community member
  • Offline
  • Registered: 2009-09-28
  • Posts: 67

Re: Backup / Restore Plugin

I worded that a bit ambiguously: I was actually replying to bradleyenator's original post.

Thumbs up

  • From: Leiden, The Netherlands
  • Registered: 2009-07-15
  • Posts: 2,442
  • User Karma: 31

Re: Backup / Restore Plugin

graeme wrote:

I worded that a bit ambiguously: I was actually replying to bradleyenator's original post.

Ah! Right. smile

Wolf CMS founder and lead developer
Please always check the Support forums and Wiki before asking. (My Ohloh account.)
Like Wolf CMS? Consider making a financial contribution.

mvdkleijn's Website

Thumbs up

  • Registered: 2009-07-31
  • Posts: 186

Re: Backup / Restore Plugin

I'm using version 0.6.0 of this plugin on numerous websites and have just found that when restoring from a backup (which I've only just done for the first time to be honest), the login permissions are preventing any users from logging in.

The MySQL database user table data seems correct. Has anybody else come across this problem?

Last edited by BlueWolf (2011-04-28 13:01)

Thumbs up

  • Registered: 2009-07-31
  • Posts: 186

Re: Backup / Restore Plugin

BlueWolf wrote:

I'm using version 0.6.0 of this plugin on numerous websites and have just found that when restoring from a backup (which I've only just done for the first time to be honest), the login permissions are preventing any users from logging in.

The MySQL database user table data seems correct. Has anybody else come across this problem?

Sorry. I was still logged into one of the admins ... the user table has not faithfully been restored. Password strings are incorrect and salt NULL values are missing. I'm manually going to rectify this to hopefully fix this on this occasion, but would appreciate a permanent fix.

Last edited by BlueWolf (2011-04-28 13:01)

Thumbs up

  • From: Leiden, The Netherlands
  • Registered: 2009-07-15
  • Posts: 2,442
  • User Karma: 31

Re: Backup / Restore Plugin

BlueWolf wrote:

Password strings are incorrect and salt NULL values are missing.

Please clarify what you mean by this... passwords get reset to pswpsw123 (if I remember correctly) by the backup-restore plugin if you do not backup passwords.

Wolf CMS founder and lead developer
Please always check the Support forums and Wiki before asking. (My Ohloh account.)
Like Wolf CMS? Consider making a financial contribution.

mvdkleijn's Website

Thumbs up

  • Registered: 2009-07-31
  • Posts: 186

Re: Backup / Restore Plugin

mvdkleijn wrote:
BlueWolf wrote:

Password strings are incorrect and salt NULL values are missing.

Please clarify what you mean by this... passwords get reset to pswpsw123 (if I remember correctly) by the backup-restore plugin if you do not backup passwords.

I was meaning that the user passwords are changed. Thus, if a user backs up a website and then restores it using a backup, their login password (all passwords) is not restored and thus nobody can log in.

Am I right in assuming that you intend for user passwords to be changed? It doesn't seem logical for a backup to change contents of the backup, or am I missing something? as you seem to suggest that it does this if the passwords are not backed up, but I don't recall their even being an option to opt!?

Thumbs up

  • From: Leiden, The Netherlands
  • Registered: 2009-07-15
  • Posts: 2,442
  • User Karma: 31

Re: Backup / Restore Plugin

The settings screen for the backup restore plugin has an option called "Include passwords". The help text next to it says:

Help text wrote:

Do you want to include passwords in the backup file?
If you select no, all passwords will be reset upon restoring the backup.

Am I to understand this feature is not working for you? (just trying to get a clear picture as to what is or isn't working)

Wolf CMS founder and lead developer
Please always check the Support forums and Wiki before asking. (My Ohloh account.)
Like Wolf CMS? Consider making a financial contribution.

mvdkleijn's Website

Thumbs up

  • Registered: 2009-07-31
  • Posts: 186

Re: Backup / Restore Plugin

Sorry, it was the following restore statement that was confusing me: "If no password is provided in the backup file, reset all password fields to this default." As I did have passwords, I wasn't expecting the passwords to be reset, period. In fact, I think I have been mistakenly assuming that this password was an optional password to protect the backup file itself (I think because I opted to use the zip compression, which I assumed allowed password protection - a key benefit over using a plain xml file).

Last edited by BlueWolf (2011-04-30 01:06)

Thumbs up

21 Reply by RBNZ

  • RBNZ
  • New community member
  • Offline
  • Registered: 2011-06-08
  • Posts: 1

Re: Backup / Restore Plugin

Hi,

I am having an issue after restoring a backup.

I created a backup for SiteA and imported it into to SiteB (different domain name + fresh install) and now there's content missing from the home page. Also after saving a page it seems to delete it (ie 404 error when viewing page).

Anyone else had this problem?

I have installed all the plugins used in SiteA.

Still investigating the problem at the mo...

Any ideas on what could delete a page after editing? (Still appears in admin/editor with the same content so data is still in DB...)

cheers,

RB

[EDIT]
Just discovered that when I edit any page, in the CMS, (after backup restore) the MySQL database values that are empty or have a value of "0" are replaced with "NULL".

CMS works fine until I run Backup Restore
[/EDIT]

[EDIT 2]
* ! Not an issue with Backup/Restore -- It's a script somewhere within one of my pages... whoops.
[/EDIT2]

Last edited by RBNZ (2011-06-08 16:31)

Thumbs up

22 Reply by gabor

  • gabor
  • Community member
  • Offline
  • Registered: 2010-09-01
  • Posts: 24

Re: Backup / Restore Plugin

Hi,

I have just tried to backup a site on 0.7.3 and installed 0.7.5 from scratch (mysql db and prefix are different)
But when I restore the backup on 0.7.5 - got successful message - but pages are not restored.

(I have another site with 0.6 but i don't want to start upgrade in this case)

Any idea?
Thanks
Gabor

update: i have installed over the old db and now i have pages in admin but got 404 error when tried to preview them sad

Last edited by gabor (2011-11-15 18:07)

Thumbs up

  • From: Leiden, The Netherlands
  • Registered: 2009-07-15
  • Posts: 2,442
  • User Karma: 31

Re: Backup / Restore Plugin

gabor wrote:

update: i have installed over the old db and now i have pages in admin but got 404 error when tried to preview them sad

There is a bug with the preview feature that results in a 404 for Archive pages.

Wolf CMS founder and lead developer
Please always check the Support forums and Wiki before asking. (My Ohloh account.)
Like Wolf CMS? Consider making a financial contribution.

mvdkleijn's Website

Thumbs up

24 Reply by gabor

  • gabor
  • Community member
  • Offline
  • Registered: 2010-09-01
  • Posts: 24

Re: Backup / Restore Plugin

Sorry I mean all pages show 404 error - i don't know what do you mean preview feature.

mvdkleijn wrote:
gabor wrote:

update: i have installed over the old db and now i have pages in admin but got 404 error when tried to preview them sad

There is a bug with the preview feature that results in a 404 for Archive pages.

Thumbs up

  • From: Leiden, The Netherlands
  • Registered: 2009-07-15
  • Posts: 2,442
  • User Karma: 31

Re: Backup / Restore Plugin

Have you checked in the DB itself to see if the pages are in there?

Wolf CMS founder and lead developer
Please always check the Support forums and Wiki before asking. (My Ohloh account.)
Like Wolf CMS? Consider making a financial contribution.

mvdkleijn's Website

Thumbs up