Moving Serendipity from one server to another

[voelspriet]

Hi all,

I would love to move Serendipity from a slow host (godaddy.com) to my own server (Hetzner.de). But I like to have an exact copy of my site, called searchbistro.com. So no clumsy backup with manual repairs afterwards

Is there someone who can give me step by step instructions how to do transfer Serendipity from one server to the other server? Both are Debian.

[garvinhicking]

Hi!

Yes, please have a look at the FAQ on www.s9y.org.

Regards,
Garvin

[chartwell]

I am doing the same thing as voelspriet.

I have followed these instructions, and I am getting error messages about folder permissions, but the paths reporting errors are absolute, local paths to directories on my old server.

Cannot write to directory /home/u3/nolaspearfishing/html/cblog/templates_c. Please check the permissions.

Where can I change the the server paths in the Serendipity config files? The admin control panel is not working yet, and this path appears to be from my old server.

[chartwell]

Ok, I found this in case anyone else needs to know. The server path is stored in the database serendipity_config table:

INSERT INTO `serendipity_config` VALUES ('serendipityPath', '/home/*****/nolaspearfishing.com/html/cblog/', 0);

I was able to edit it in php my admin, and my site is now back up and running.

[tchirou]

Hi,

My provider moved my blog to another server last night.
When I try to access it, it says :

Code: Select all

Warning: file_exists() [function.file-exists]: Unable to access /mnt/136/free.fr/e/c/akeow/serendipity/plugins/serendipity_event_autosave/serendipity_event_autosave.php in /mnt/157/sdb/e/c/akeow/serendipity/include/plugin_api.inc.php on line 445

Warning: file_exists() [function.file-exists]: Unable to access /mnt/136/free.fr/e/c/akeow/serendipity/plugins/serendipity_event_assigncategories/serendipity_event_assigncategories.php in /mnt/157/sdb/e/c/akeow/serendipity/include/plugin_api.inc.php on line 445

Warning: file_exists() [function.file-exists]: Unable to access /mnt/136/free.fr/e/c/akeow/serendipity/plugins/serendipity_event_s9ymarkup/serendipity_event_s9ymarkup.php in /mnt/157/sdb/e/c/akeow/serendipity/include/plugin_api.inc.php on line 445

Warning: file_exists() [function.file-exists]: Unable to access /mnt/136/free.fr/e/c/akeow/serendipity/plugins/serendipity_event_emoticate/serendipity_event_emoticate.php in /mnt/157/sdb/e/c/akeow/serendipity/include/plugin_api.inc.php on line 445

Warning: file_exists() [function.file-exists]: Unable to access /mnt/136/free.fr/e/c/akeow/serendipity/plugins/serendipity_event_browsercompatibility/serendipity_event_browsercompatibility.php in /mnt/157/sdb/e/c/akeow/serendipity/include/plugin_api.inc.php on line 445

Warning: file_exists() [function.file-exists]: Unable to access /mnt/136/free.fr/e/c/akeow/serendipity/plugins/serendipity_event_nl2br/serendipity_event_nl2br.php in /mnt/157/sdb/e/c/akeow/serendipity/include/plugin_api.inc.php on line 445

Warning: file_exists() [function.file-exists]: Unable to access /mnt/136/free.fr/e/c/akeow/serendipity/plugins/serendipity_event_spamblock/serendipity_event_spamblock.php in /mnt/157/sdb/e/c/akeow/serendipity/include/plugin_api.inc.php on line 445

Warning: file_exists() [function.file-exists]: Unable to access /mnt/136/free.fr/e/c/akeow/serendipity/plugins/serendipity_event_mailer/serendipity_event_mailer.php in /mnt/157/sdb/e/c/akeow/serendipity/include/plugin_api.inc.php on line 445

Warning: file_exists() [function.file-exists]: Unable to access /mnt/136/free.fr/e/c/akeow/serendipity/plugins/serendipity_event_statistics/serendipity_event_statistics.php in /mnt/157/sdb/e/c/akeow/serendipity/include/plugin_api.inc.php on line 445

Warning: file_exists() [function.file-exists]: Unable to access /mnt/136/free.fr/e/c/akeow/serendipity/plugins/serendipity_event_emoticonchooser/serendipity_event_emoticonchooser.php in /mnt/157/sdb/e/c/akeow/serendipity/include/plugin_api.inc.php on line 445

Warning: file_exists() [function.file-exists]: Unable to access /mnt/136/free.fr/e/c/akeow/serendipity/plugins/serendipity_event_typesetbuttons/serendipity_event_typesetbuttons.php in /mnt/157/sdb/e/c/akeow/serendipity/include/plugin_api.inc.php on line 445

Warning: file_exists() [function.file-exists]: Unable to access /mnt/136/free.fr/e/c/akeow/serendipity/plugins/serendipity_event_backup/serendipity_event_backup.php in /mnt/157/sdb/e/c/akeow/serendipity/include/plugin_api.inc.php on line 445

Warning: file_exists() [function.file-exists]: Unable to access /mnt/136/free.fr/e/c/akeow/serendipity/plugins/serendipity_event_xhtmlcleanup/serendipity_event_xhtmlcleanup.php in /mnt/157/sdb/e/c/akeow/serendipity/include/plugin_api.inc.php on line 445

Warning: file_exists() [function.file-exists]: Unable to access /mnt/136/free.fr/e/c/akeow/serendipity/plugins/serendipity_event_userprofiles/serendipity_event_userprofiles.php in /mnt/157/sdb/e/c/akeow/serendipity/include/plugin_api.inc.php on line 445

Warning: file_exists() [function.file-exists]: Unable to access /mnt/136/free.fr/e/c/akeow/serendipity/plugins/serendipity_event_imageselectorplus/serendipity_event_imageselectorplus.php in /mnt/157/sdb/e/c/akeow/serendipity/include/plugin_api.inc.php on line 445

Warning: file_exists() [function.file-exists]: Unable to access /mnt/136/free.fr/e/c/akeow/serendipity/plugins/serendipity_event_podcast/serendipity_event_podcast.php in /mnt/157/sdb/e/c/akeow/serendipity/include/plugin_api.inc.php on line 445

Warning: file_exists() [function.file-exists]: Unable to access /mnt/136/free.fr/e/c/akeow/serendipity/plugins/serendipity_event_layout_printerfriendly/serendipity_event_layout_printerfriendly.php in /mnt/157/sdb/e/c/akeow/serendipity/include/plugin_api.inc.php on line 445

Warning: file_exists() [function.file-exists]: Unable to access /mnt/136/free.fr/e/c/akeow/serendipity/plugins/serendipity_event_versioning/serendipity_event_versioning.php in /mnt/157/sdb/e/c/akeow/serendipity/include/plugin_api.inc.php on line 445

Warning: file_exists() [function.file-exists]: Unable to access /mnt/136/free.fr/e/c/akeow/serendipity/plugins/serendipity_event_httpauth/serendipity_event_httpauth.php in /mnt/157/sdb/e/c/akeow/serendipity/include/plugin_api.inc.php on line 445

Warning: file_exists() [function.file-exists]: Unable to access /mnt/136/free.fr/e/c/akeow/serendipity/plugins/serendipity_event_mailcc/serendipity_event_mailcc.php in /mnt/157/sdb/e/c/akeow/serendipity/include/plugin_api.inc.php on line 445

Warning: file_exists() [function.file-exists]: Unable to access /mnt/136/free.fr/e/c/akeow/serendipity/plugins/serendipity_event_lightbox/serendipity_event_lightbox.php in /mnt/157/sdb/e/c/akeow/serendipity/include/plugin_api.inc.php on line 445

Warning: file_exists() [function.file-exists]: Unable to access /mnt/136/free.fr/e/c/akeow/serendipity/plugins/serendipity_event_externalauth/serendipity_event_externalauth.php in /mnt/157/sdb/e/c/akeow/serendipity/include/plugin_api.inc.php on line 445

Warning: file_exists() [function.file-exists]: Unable to access /mnt/136/free.fr/e/c/akeow/serendipity/plugins/serendipity_event_google_analytics/serendipity_event_google_analytics.php in /mnt/157/sdb/e/c/akeow/serendipity/include/plugin_api.inc.php on line 445

Warning: file_exists() [function.file-exists]: Unable to access /mnt/136/free.fr/e/c/akeow/serendipity/templates/carl_contest/template.inc.php in /mnt/157/sdb/e/c/akeow/serendipity/include/functions_smarty.inc.php on line 693

Warning: is_dir() [function.is-dir]: Unable to access /mnt/136/free.fr/e/c/akeow/serendipity/templates_c in /mnt/157/sdb/e/c/akeow/serendipity/include/functions_smarty.inc.php on line 716
Je ne peux pas écrire dans le répertoire /mnt/136/free.fr/e/c/akeow/serendipity/templates_c. Il faudrait que vous me donniez les droits d'accès nécessaires manuellement.

I have obviously to change the path from mnt/136/free.fr/ to mnt/157sdb. I don't know how to edtit tables in phpmyadmin to do this.

Anyone has more specific advices for me please ?

Thnak you,

Cyril

[garvinhicking]

Hi!

You must do this via phpMyAdmin. Maybe you need to go to the phpMyAdmin forums to ask for help there on how to do it. Or you could ask your provider to do it for you, since he moved the paths.

You can create a database dump, use a texteditor to replace the paths, and then re-upload the Database dump.

You need to change the paths in the DB tables 'serendipity_plugins' and 'serendipity_config' only.

Best regards,
Garvin

[tchirou]

Thank you Garv.

I just did what you said. I tried to figure how to dump the table serendipity-config in a word document. I changed the path twice. I deleted the old table. But when I try to upload tne new one, it says :

Code: Select all

ERROR: C1 C2 LEN: 1 2 893
STR: 

CVS: $Id: sqlparser.lib.php,v 2.34.2.1 2005/06/30 16:58:11 lem9 Exp $
MySQL: 5.0.37
USR OS, AGENT, VER: Win MOZILLA 5.0
PMA: 2.6.3-pl1
PHP VER,OS: 4.4.7 Linux
LANG: fr-utf-8
SQL: ��ࡱ�����������������>���	����������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������#`	������������������e���bjbj���������������������2���������]�����������������������������������������������������������������������������@������@��@������@������@������@������@�������������d���w��\m�����\m�����\m�����\m�\����m�
��X}��������������w������w������w������w������w������x������x������x�����������������������������������

I an about to commit suicide... What did I do wrong ?

Snif

[garvinhicking]

Hi!

Oooh... A word document? Word is not suited to edit those files, it might have damaged the file.

Do you still have the original file?

Regards,
Garvin

[tchirou]

Noooooooooooooooooooooooooooooo

But it offered word itself to export, with SQL, excel, xml.

The word is readable. I have an xml version too. But I think I don't know how to and where to upload. Could you tell me on which page and on which button I have to click to do it please ?

Thank you so much

[garvinhicking]

Hi!

Really? I never used the Word-Export! Maybe you can ask the phpMyAdmin support forums.

Best regards,
Garvin

[tchirou]

Pfiou.

I think i am gonna rebuild a .sql file from wy word file manually. But some information miss in my word file for the serendipity_config table.

I have exported the serendipity_plugins table in .sql and in .doc to compare them.

There are not the following info in the .doc file :

Code: Select all

CREATE TABLE `serendipity_plugins` (
  `name` varchar(128) collate latin1_general_ci NOT NULL,
  `placement` varchar(6) collate latin1_general_ci NOT NULL default 'right',
  `sort_order` int(4) NOT NULL default '0',
  `authorid` int(11) default '0',
  `path` varchar(255) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`name`),
  KEY `pluginauthorid_idx` (`authorid`),
  KEY `pluginplace_idx` (`placement`),
  KEY `pluginretr_idx` (`placement`,`sort_order`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

Could someone give me these info for the serendipity_config table please ?

I hope it's gonna work

Thnak you

Cyril

[tchirou]

Okay.

With the xml dump and another serendipity_config table from another server, I have recreated a new .sql manually. 504 lines to type. Tiring.

Now, it remains one tiny problem. Categories appears this way: Cat�gories.

Because it is written in french, the "é" is corrupted.

Could you tell me where is the php file where I can rewritten it?

Thanks for everything.

Cyril

[garvinhicking]

Hi!

The language constants are in the files /lang/serendipity_lang_fr.inc.php for ISO-format and /lang/UTF-8/serendipity_lang_fr.inc.php for UTF-8 blogs.

HTH,
Garvin

[tchirou]

Thank You Garv.

Actually, the problem was about the title of the category sidebar plugin. So I rewrote "Catégories" in the plugin configurator and everything is fine now.

Back in Business now