test installation of upgrade

[teknews]

Hi There

is there a way to quickly create a test environment of cms (on the same server)
and test an upgrade?

eg
# copy directory
cp -R ./cms/ ./cmsdev1
# copy databasse
mysqldump --opt cms --password=enteronehere > /var/www/cms_1.1.sql
# use phpmyadmin to create dev1 database
mysql --user=root --password=enteronehere dev1 < cms_all1.1.2.sql
# grant user access
GRANT SELECT , INSERT , UPDATE , DELETE ON dev1 . * TO 'cms_user'@'localhost' IDENTIFIED BY 'anythingyouwish';
#delete all files from tmp/cache
chmod 777 tmp/cache
chmod 777 tmp/templates_c
#edit config.php
# - change db name
# - chmod 666 config.php
# - change path to NEW directory

this works to a certain extent but, i think there are references in the MYSQL tables that I need to change
any ideas which tables?

Cheers

Tek

[Pierre M.]

Hello Tek,

...but, i think there are references in the MYSQL tables that I need to change

What makes you think this ?

Have you tried to dump and restore only db objects with the choosen cms_ prefix ?

Pierre M.

[calguy1000]

1) there should be no references (except maybe absolute links in the content) to paths in the database

2) config.php can be 444 after install

3) you need to convert the tmp directory to allow write access to the httpd serer

4) in order to allow modules to install and de-install you need to have CREATE TABLE, and DROP TABLE permission


Sitepusher does exactly what your talking about but via ftp.