Topic: Backup2 Restore - Database not being restored

[AndyCocker]

Hi,

I'm trying Backup2 on a SME7rc1 VM Ware test server with all updates.

Backup2 RPM's installed are

Code: [Select]

smeserver-backup2-0.0.1-b1dmay.noarch.rpm
rar-3.5.1-7dmay.i386.rpm

Used phpmyadmin to create database and user in order to install Joomla CMS to Ibay called cms. Joomla working perfectly.

Setup a 911 backup job (adding /etc/dansguardian), and did manual backup to network share. 911 RAR created fine.

Loaded up a VM Ware SME7rc1 clean install, reinstalled all contribs as previous installation, and set up 911 backup exactly as before. Did restore, then reconfigure.

Everything seems to have gone back in place, except my Joomla database! The Ibay has the Joomla CMS within it, but, using phpmyadmin, the Joomla database has not been restored.

I opened mysql.dump from the backup RAR, and searched for the Joomla database, and it all seems to be there - at least there are many references to Joomla and 'jos_'.

My question is: Surely I shouldn't have to do anything else to inject the mysql.dump back into mysql, or should I? I've done plenty of searching on this, but not found anything that helped me.

Anyone any ideas, or should this go in the bugtracker?

[CharlieBrady]

I'm trying Backup2 on a SME7rc1 VM Ware test server with all updates.
...
Anyone any ideas, or should this go in the bugtracker?

Problems with contribs should be reported via the Bug Tracker (Contribs section).

[pfloor]

Are you sure it restored everything back into MySQL or did it just build a new database from scratch?  A new install will build a complete database containing everything EXCEPT any added databases.

Another clue would be if it restored the Joomla "user" or not.  You will find the user in the user table and not as part of the Joomla table(s).

I think you should submit a bug for this against that particular contrib.  Be prepared to submit log files from the time of the restore.

[AndyCocker]

Problems with contribs should be reported via the Bug Tracker (Contribs section).

Done. Bug No. 1311

Andy

[AndyCocker]

Are you sure it restored everything back into MySQL or did it just build a new database from scratch?  A new install will build a complete database containing everything EXCEPT any added databases.

I'm not familiar with everything that resides in the MySQL databases on SME, but after my restore, the only tables listed were those present after a clean reinstall. However, extra users and mail had been restored OK, as well as changes made to the Fetchmail contrib (but I'm not sure where these are stored and whether it's relevant to this MySQL problem)

Another clue would be if it restored the Joomla "user" or not.  You will find the user in the user table and not as part of the Joomla table(s).

No, it didn't.

I think you should submit a bug for this against that particular contrib.  Be prepared to submit log files from the time of the restore.

I have done so (Bug no 1311), and have just performed the entire restore process all over again, copying the var/log directory before and after, so hopefully I'll have any info required.
Incidentally, this time after the restore, phpmyadmin could not connect to MySQL at all (see bug for error text).

All the best,
Andy Cocker

[dmay]

Please see:

http://bugs.contribs.org/show_bug.cgi?id=1311

All correspondence to the Bug Tracker please.

Darrell