Page 1 of 1

change of server

Posted: Tue Feb 01, 2005 7:43 pm
by bluelayer
hie

i have one instalation in one Mysql 4.1.9 server and PHP5 but i need to move to another server, and that server have the mysql 4 and php 4... can anyone help me ?

thanks

PS: Sory for the bad english :oops:

Re: change of server

Posted: Tue Feb 01, 2005 8:43 pm
by garvinhicking
Hi bluelayer!

No problem, the versions don't matter. Everything will rune fine with Serendipity without a change in the code.

Just upload all files, upload a whole DB SQL Dump with your data, apply permissions as on the old host, edit serendipity_config_local.inc.php and the DB table serendipity_config to contain all the new path settings.

Then you're done :)

Regards,
Garvin

Re: change of server

Posted: Tue Feb 01, 2005 9:09 pm
by bluelayer
garvinhicking wrote:Hi bluelayer!

No problem, the versions don't matter. Everything will rune fine with Serendipity without a change in the code.

Just upload all files, upload a whole DB SQL Dump with your data, apply permissions as on the old host, edit serendipity_config_local.inc.php and the DB table serendipity_config to contain all the new path settings.

Then you're done :)

Regards,
Garvin
mysqli extencion from php5 will not cause problems ??

thanks

Re: change of server

Posted: Wed Feb 02, 2005 9:45 am
by garvinhicking
You can compile mysqli for PHP4 without problems, yes.

Regards,
Garvin

Re: change of server

Posted: Wed Feb 02, 2005 9:54 am
by tomsommer
garvinhicking wrote:You can compile mysqli for PHP4 without problems, yes.
Really? Are you sure about that?

Re: change of server

Posted: Wed Feb 02, 2005 9:57 am
by garvinhicking
Tom: I haven't tried it myself, but I heard from a guy who said it would work...

Otherwise, you can still use the plain mysql extension to connect to Serendipity on your server...the DB layout is the same.

Regards
,Garvin

Posted: Wed Feb 02, 2005 9:59 am
by tomsommer
You can't succesfully use the mysql extension with MySQL 4.1 -- as far as I know -- since MySQL 4.1 uses diffirent auth mechs than 4.0

I'm not entirely sure about this though, I've never really played with mysqli or MySQL 4.1

Posted: Wed Feb 02, 2005 10:15 am
by garvinhicking
You can. phpMyAdmin uses that, and on my machine I am using PHP4.3.10+MySQL 4.1+mysql extension for playing with Serendipity. :)

Regards,
Garvin

Posted: Wed Feb 02, 2005 2:05 pm
by bluelayer
garvinhicking wrote:You can. phpMyAdmin uses that, and on my machine I am using PHP4.3.10+MySQL 4.1+mysql extension for playing with Serendipity. :)

Regards,
Garvin
garvinhicking wrote:You can. phpMyAdmin uses that, and on my machine I am using PHP4.3.10+MySQL 4.1+mysql extension for playing with Serendipity. :)

Regards,
Garvin
try to update the mysql server to the last version 4.1.9 and your mysql extencion will not work! if you have upgraded from mysql 4, yes it is possible to use 4.1.9 version on php 4(use old password format comand ...). form 4.1.7 mysql version is not possible to use mysql extencion of php 4.
And the mysql dump form my mysql 4.1.9 is NOT compatible whith the new server (mysql 4.0.20), i'm getting errors, i will ned a new instalation of blog...

:twisted:

Posted: Wed Feb 02, 2005 3:44 pm
by garvinhicking
bluelayer,

create a SQL dump with phpMyAdmin. That one is backwards compatible.

Regards,
Garvin

Posted: Wed Feb 02, 2005 4:13 pm
by Guest
garvinhicking wrote:bluelayer,

create a SQL dump with phpMyAdmin. That one is backwards compatible.

Regards,
Garvin
i do that, don't work...
i don't remember de error but it told me about "utf8 settings" and some comands unrecognized...

thanks

Posted: Wed Feb 02, 2005 4:28 pm
by garvinhicking
Bluelayer, with latest phpMyAdmin you can check to not export Collation sets. Then everything will be okay.

Regards,
Garvin