Revision [732]

This is an old revision of ConfigStratoServer made by WojciechLisiewicz on 2015-02-25 16:19:07.

 

Konfiguracja nowego serwera

hosting strato


1. Instalacja poszczególnych komponentów - w szczególno?ci "lampp"



2. Make a dump of old mysql-databases
mysqldump -u NUTZERNAME -p DATENBANKNAME > myfile.sql (nach Aufforderung das Nutzerpasswort eingeben)

2. Config virtual hosts and domains



apache - poszczególne serwisy




install and config php-my-admin

converting DB with polish codepage

following commands were successful:

DB dump
mysqldump -u root -p --default-character-set=latin1 --skip-set-charset internalwiki > /storage/db_dumps/internalwiki_latin1.sql

converting itself
iconv -f ISO-8859-2 -t UTF-8 internalwiki_latin1.sql | sed -e 's/latin2/utf8/g' >internalwiki_utf8.sql
(wasn't good enough - probably was old text in windows codepage! this one was better:)
iconv -f Windows-1250 -t UTF-8 internalwiki_latin1.sql | sed -e 's/latin2/utf8/g' >internalwiki_utf8.sql

put converted DB - into an empty DB
mysql -u root -p --default-character-set=utf8 wikiutf8 <internalwiki_utf8.sql


There are no comments on this page.
Valid XHTML :: Valid CSS: :: Powered by WikkaWiki