moving live

Hi all, as i said before I am new to spip but am totally loving it, I already
spent a week in hell trying to install campsite, spip is great!

However I now have to move it from my testing server onto a live server, is this
easy to do? I couldnt find any articles about it on the site, will I have to
install it again on live or can I just upload everything including the
database??? Where can I change the settings I gave it on install

Cheers IA

Craig

On 17/01/2008, at 3:11 PM, Craig wrote:

Hi all, as i said before I am new to spip but am totally loving it, I already
spent a week in hell trying to install campsite, spip is great!

However I now have to move it from my testing server onto a live server, is this
easy to do? I couldnt find any articles about it on the site, will I have to
install it again on live or can I just upload everything including the
database??? Where can I change the settings I gave it on install

I’ve done this once or twice by installing SPIP on the new host as normal and installing any plug-ins required. Then I upload the IMG directory and the templates and associated files along with mes_options.php and mes_fonctions.php, if required.

Then I take a back up of the testing server database (Configuration → Site Maintenance) and transfer the dump file (in tmp/dump/) from the testing server to the production server. This can now be restored using the same Configuration->Site Maintenance screen from the back end.

Do be aware though that some things seem not to transfer cleanly in this process. If you’re using the forms plug-in, for example, you’ll probably need to activate the plug-ins after restoring the database (perhaps a backup does not include plug-in tables). If so you might have better luck transferring the whole lot via FTP and phpMyAdmin then updating SPIP’s database settings in config/connect.php.

Regards,

Thomas Sutton
Web Developer
bouncingorange
graphic + web design

On Thu, 2008-01-17 at 19:11, Craig wrote:

Hi all, as i said before I am new to spip but am totally loving it, I already
spent a week in hell trying to install campsite, spip is great!

However I now have to move it from my testing server onto a live server, is this
easy to do? I couldnt find any articles about it on the site, will I have to
install it again on live or can I just upload everything including the
database??? Where can I change the settings I gave it on install

If you're on a UNIX machine then `rsync' and `mysqldump' are your
friends, e.g.:

[test_server] % rsync -avz --delete /path/to/spip/
production_server:/path/to/spip

and

[test_server] % mysqldump --password=***** --quick spip | gzip -9 >
/path/to/spip.sql.gz

and

[production_server] % mysql -u username -p spip < spip.sql

Best,

Richard

--
Richard MAHONEY | internet: http://indica-et-buddhica.org/
Littledene | telephone/telefax (man.): +64 3 312 1699
Bay Road | cellular: +64 27 482 9986
OXFORD, NZ | email: r.mahoney@indica-et-buddhica.org
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Indica et Buddhica: Materials for Indology and Buddhology
Scholia: http://scholia.indica-et-buddhica.org/
Lexica: http://lexica.indica-et-buddhica.org/dict/lexica

A last thing you have to do :
change the url of your website in the private area (in
ecrire/?exec=configuration)
It is used for redirections in the private area, so it can be usefull :wink:

On Jan 17, 2008 7:34 AM, Thomas Sutton <thomas@bouncingorange.com> wrote:

On 17/01/2008, at 3:11 PM, Craig wrote:

Hi all, as i said before I am new to spip but am totally loving it, I
already
spent a week in hell trying to install campsite, spip is great!

However I now have to move it from my testing server onto a live server, is
this
easy to do? I couldnt find any articles about it on the site, will I have to
install it again on live or can I just upload everything including the
database??? Where can I change the settings I gave it on install

I've done this once or twice by installing SPIP on the new host as normal
and installing any plug-ins required. Then I upload the IMG directory and
the templates and associated files along with mes_options.php and
mes_fonctions.php, if required.

Then I take a back up of the testing server database (Configuration -> Site
Maintenance) and transfer the dump file (in tmp/dump/) from the testing
server to the production server. This can now be restored using the same
Configuration->Site Maintenance screen from the back end.

Do be aware though that some things seem not to transfer cleanly in this
process. If you're using the forms plug-in, for example, you'll probably
need to activate the plug-ins *after* restoring the database (perhaps a
backup does not include plug-in tables). If so you might have better luck
transferring the whole lot via FTP and phpMyAdmin then updating SPIP's
database settings in config/connect.php.

Regards,

Thomas Sutton
Web Developer
bouncingorange
graphic + web design
_______________________________________________
spip-en@rezo.net - http://listes.rezo.net/mailman/listinfo/spip-en