#1877 Restoring users and messages from backup - needs slight impr

[Meliza Amity]

My users DB table was corrupted.
I used the PGV backup and the "User Information Migration tool" import to restore it.

1. I copied only the authenticate.php to my index directory. This caused the data of the news, messages, favorites and blocks to be deleted.
I think that if the files are not in the index directory and there is data in the DB tables, then the data should remain in the tables.

2. I then copied from the backup also the ...dat files to the index directory and imported again the data.
My new messages are normally shown in PGV with the newest first.
The restored messages are shown with the oldest first.

[Meliza Amity]

Logged In: YES
user_id=959928
Originator: YES

It turns out that the restored users were created with "Visible to other users when online" No. Originally all, or at least most, were defined with the value Yes.
This means that users do no longer see who is online.

The few users I have looked at have also " Allow this user to edit his account information" No.

I am not at home for a couple of days.
Could someone tell me what else was lost and if the backup file contains the original values.

Thanks,
Meliza

[Meliza Amity]

Logged In: YES
user_id=959928
Originator: YES

The authenticate.php in the backup has the following values:
$user["visibleonline"] = '1';
$user["editaccount"] = '1';

The user DB table has
u_visibleonline = 'Y'
u_editaccount = 'Y'.

The backup or the import does not work as expected.

I have not yet tried to export the data.

Meliza

[Meliza Amity]

Logged In: YES
user_id=959928
Originator: YES

The tool export creates also the following values
$user["visibleonline"] = '1';
$user["editaccount"] = '1';

[Greg Roach]

Logged In: YES
user_id=1466942
Originator: NO

Just seen this bug. I fixed the "1"<=>"Y" issue a few days ago as part of my user-table access tables. This fixes your "visible online problem".

The issue of only restoring particular tables is still outstanding.