28 December, 2015
Importing Postgresql dump
sudo -u postgres pg_restore --verbose --clean --no-acl --no-owner -h localhost -U postgres -d dbname ./dumpfilename
27 December, 2015
Connecting to Heroku Postgre from a remote host
It was kind of tricky to figure out, but it turned out that Heroku Postgre requires some SSL tricks to connect from outside. Here are my PHPStorm connection settings, Advanced tab:
12 December, 2015
MySQL replication
This is mostly a note for myself, so I don’t have to do research again. Bunch of usefull links:
Servers for hackers – replication
Exporting / Importing data in a UTF8 safe way
Replication was easy in my case, the real issue was with handling huge backup files. Here are the commands I used for export, transfer and import of data.
Also, remember to check master status (log position) and to lock the database before you start.
mysqldump -u root -p --routines --triggers --all-databases -r database.dump sudo rsync -vP --inplace utf8.dump user@server.com:/home/user/ mysql -uroot -p --default-character-set=utf8 mysql> SOURCE database.dump;
In case you’re getting binary logging errors (“Statement based binlogging does not work in isolation level READ UNCOMMITTED and READ COMMITTED since the necessary locks cannot be taken.” or so), make sure this line is present in your MySQL config:
binlog_format=row
I hate WordPress editor.
4 September, 2014
Distributed version control: setting up Plastic SCM replication
Here’s a link to a blog post I wrote on Unknown Worlds blog. If you’re working in a highly-distributed team or you’re in gamedev, this one might be for you!
27 August, 2014
An update!
So, I updated the website witb a nice theme and I’m updating the content right now. Looks like I’ll keep the blog alive too. I plan to publish new articles about programming every time I feel I do something new (not only for me!). My work at Unknown Worlds got a bit more challenging since few weeks ago – I started working on the interface of our upcoming game, Subnautica. Well, let’s get rolling!