Sinan'ın Yeri

I continue to work with mysql and php install on openbsd. I made some progress. After installing mysql and php one must install php5-mysql package too. Then making some soft links, mysql extension is made readable by php.Inside /var/www directory there must exist a /tmp directory writable by others for storing session info etc. Adding required directives to apache's,php's config files it began working. I have some minor problems to be solved.

I think it would be only possible to restore data correctly when restoring my mysql backup file, after converting it to ISO8859-1 from UTF-8 by the following command iconv -f UTF-8 -t ISO8859-1 backup.sql.

Mysql to mysql backup through secured mysql connection between two ends. The situation is this: I have two mysql servers behind two modems. Only port 22 is open on modems. Ports 3306 are open on both servers. First port forward on the server which is going to be backed up by ssh -L 23306:127.0.0.1:3306 user@remoteserver(backupserver) Then mysqldump -t -u localuser -p db | mysql -v --host=127.0.0.1 --port=23306 -u remoteuser -p -C db makes the magic. By mysqldump we dump the mysqlserver which is going to be backed up. And point it to the local (forwarded) port 23306 and everything is written to the remote host. Wow. BTW, to connect to backup server from local we need this mysql --host=127.0.0.1 --port=23306 thing.