Copying Database Problem

Squiz Matrix Installation
1

I'm having trouble with restoring a database from a dev server. I have installed version 3.2 as a default without problem, created a new alias in apache and having run the backup.sh script and moved the tarball to the new server and unzipped it without problem to the new directory (as pointed to in the alias block), I have edited the /data/private/conf/main.inc file, run the system_move_update.php script and restarted apache.


The new alias and the original root on the server now both point at the same (default… as created by php steps 1-3) database and not, as expected, to the default for root and imported / restored for the new alias.



I hope that that make some sense, and any advice would be appreciated!

2

I think it might just be that it's early in the morning and my brain isn't working, but what do you mean by

[quote]The new alias and the original root on the server now both point at the same (default… as created by php steps 1-3) database and not, as expected, to the default for root and imported / restored for the new alias.[/quote]



Are you saying that both your old and newly restored versions of matrix are pointing at the same database? Have you edited the SQ_CONF_DB_DSN* options in the new main.inc to point at the correct database?

3

Sorry … not the most succinct description ever offered!
When I login to either of the versions of matrix (http://www.???.??.??/_admin and the /dev/_admin) I get a perfect working copy of the blank, default database… and not, as I had expected the default one on the /_admin URL and the restored database on the /dev/_admin URL. If I change the admin password in the database… the new password is required to log in from the other URL… so they are pointing at the same database. Finally, yes, I have changed the pertinent details in the main.inc (although I have done this only for the main.inc which pertains to the /dev version of matrix)

4

So you have two systems then.

  1. clean one located at http://www.domain.com/
  2. restored one located at http://www.domain.com/



    correct ?



    Which way around are your aliases in the apache conf?



    You will need to have the ‘dev’ aliases above the ones on the system root because Apache just matches the first alias not the best one.
5

Brilliant!
Thank you so much Blair… I have a working system.

I, and all those who want to use the system… can go away and have a very Happy Christmas.

May I wish you all at Squiz a very Merry Christmas and Prosperous New Year too.

Thanks again.