Dochazka3000 pod wine + mysql

Dochazka 3000 pod wine

1. kopie beziciho stromu (c:\apache) do .wine/drive_c/
2. editace https.conf:
ServerRoot "c:/apache"
Listen 8000
Port 8000
DocumentRoot "c:/apache/htdocs"
 
#Action application/x-httpd-php /php/php.exe
# ScriptAlias /cgi-bin/ "c:/apache/cgi-bin/"
# ScriptAlias /php/ "php/"
LoadModule php5_module "c:/apache/php/php5apache.dll"
AddModule mod_php5.c
#Action application/x-httpd-php /php/php.exe

3. edit apache/php/php.ini
extension_dir = "c:/apache/php/ext/"
 

4. link /apache/php/php.ini -> c:/windows/php.ini
(php.ini je hledano tam)

5. link dll knihoven
/apache/php/*dll ->/windows/
(nechtelo to najit libmysql.dll)

6. Konfigurace databazoveho systemu:
CREATE DATABASE `db003444` DEFAULT CHARACTER SET latin1 COLLATE latin1_bin;
grant all on * to 'rrrt'@'localhost' ;
grant usage on * to 'rrrt'@'localhost' ;
 

import zalohy databaze.

time mysql -u rrrt db003444 < data-20140531.sql

zmenit v access.php  user root na rrrt

2022-06-28 je nutne napred udelat usera:

CREATE USER 'rrrt'@'localhost' ;
GRANT ALL ON `db003444`.* TO 'rrrt'@'localhost' ;
(?je to nutne?)GRANT USAGE ON `db003444`.* TO 'rrrt'@'localhost' ;

---------------------------------------------------

export dat z databaze

select indexza,jmeno,prijmeni,karta,prijmeno from doch_za1 where 1 into outfile '/uzivs.csv';

recode latin2.. <uzivs.csv