[TYPO3] seriuos problem migrating 4.2.1 installtion to another server

[G.Unger]

... shame on me :(

after making a dump of dir/DB myself the install on Mac was as easy aas usual!

soooooooooory to bother :S

thx and rgds
GUIDO


On 2008-08-26 19:51:32 +0200, G.Unger <skyfreak1 at gmx.net> said:

> hi list
> 
> everything on hold
> here is sth rally going wrong, it looks like the dumps the customer 
> made and provided me with are corrupt!
> 
> I insested to get shell access and pack everything again, dump 
> everything on my own and test it again.
> 
> rgds
> GUIDO
> 
> 
> 
> 
> 
> On 2008-08-26 19:12:48 +0200, G.Unger <skyfreak1 at gmx.net> said:
> 
>> hi dimitry
>> 
>> thx for popping in on this one!
>> 
>> although I do not consider myself expert/advanced TYPO3 user, the way 
>> of moving (dumping files and DB + modifying localconf.php) is the way 
>> that always forked for me.
>> 
>> strange enough, that a new install of T3 4.2.1 workz even with umlaute 
>> in TS. I can move it online as I always do, make changes (more umlaute 
>> in TS) and dump it back to my local machine.
>> 
>> coming back to the problem:
>> 
>> how do I set
>> 
>>> SET NAMES utf8
>>> SET character_set_server utf8
>> 
>> in install tool? there is only one input field and no more textarea 
>> showing up in install tool of 4.2.1 no textarea to insert 2 seperate 
>> lines.
>> 
>> I tried inserting them comma seperated and even with a semicolon, 
>> nothing worked.
>> than I tried to insert it manually in the localconf.php like
>> 
>> $TYPO3_CONF_VARS['SYS']['setDBinit'] = 'SET NAMES utf8'.chr(10).'SET 
>> character_set_server utf8';
>> 
>> no success either, apart that in install tool the field ['setDBinit'] 
>> vanished completely.
>> 
>> I am really helpless on this one, sorry.
>> tried an export from T3 backend as well, apart of a couple of files 
>> beeing too big from user_upload folder (zips with more than 1MB) the 
>> export and import worked. Yet the error persists :(
>> 
>> 
>> rgds,
>> GUIDO
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> On 2008-08-26 17:21:00 +0200, "Dmitry Dulepov [typo3]" <dmitry at typo3.org> said:
>> 
>>> Hi!
>>> 
>>> G.Unger wrote:
>>>> - client made a complete download of all files and folders by ftp from 
>>>> the online development server
>>>> - database was exported/dumped by phpMyAdmin extension. looking in the 
>>>> sql file I see that charset is utf-8 and collation as well
>>> 
>>> Next time use import/export inside TYPO3. File copying and SQl import 
>>> is better for advanced TYPO3 users.
>>> 
>>>> where do I go wrong?
>>> 
>>> It seems that you did not set db init commands in Install tool. Set them to:
>>> 
>>> SET NAMES utf8
>>> SET character_set_server utf8
>>> 
>>> You will need to clear page cache after that.