Create and import MySQL / MariaDB dump

Create a MySQL / MariaDB dump on command line

mysqldump -u [uname] -p db_name > db_backup.sql

1	mysqldump -u [uname] -p db_name > db_backup.sql

Import a dump into MySQL / MariaDB

mysql -u username -p db_name < db_backup.sql

1	mysql -u username -p db_name < db_backup.sql

Continue reading →

20 ways to make Platinum in Warframe

The general rule to make Platinum in Warframe is to sell items other tenno do not want to farm. Here are the 20 ways in detail: Continue reading →

When racism and harrasement are tolerated in a video game community

For the first time in 25 years of gaming I am ashamed to be a gamer. When you are called a social justice warrior for pointing out racism, harassment and hate speech in the in-game chat of your favorite video game something is very wrong. Continue reading →

cpanm – the easier way to install Perl modules

Perl is shipped with the cpan console to install new modules. This console is quite dated and sometimes asks too many questions when you just want to install a module. CPANM is a less talkative version of the old cpan.  Continue reading →

Warframe trading guide part 3 – how to use warframe.market, the almost auction house

This is the part 3 of my Warframe trading guide. It is followed by the transcript. Continue reading →

Emergency credit caches in your inventory and mods in Warframe

When you are low on credits you can sell of some items from your inventory and any duplicate mods. Continue reading →

Recursively delete directory with JSch on SFTP with Java

For a recent project I needed a way to recursively delete a directory and all its content from a remote SFTP connection. This code snippet works like charm but be very careful when using it: Continue reading →

Get parent directory path in Java

public static String getParentDirectoryPath(String inputPath) { String resultString = ""; String regEx = "(.*\\/)\\S+\\/$"; Pattern regexPattern = Pattern.compile(regEx); Matcher match = regexPattern.matcher(inputPath); if(match.find()) { resultString = match.group(1); } return resultString; }

1 2 3 4 5 6 7 8 9 10 11 12 13

public static String getParentDirectoryPath(String inputPath) { String resultString = ""; String regEx = "(.*\\/)\\S+\\/$"; Pattern regexPattern = Pattern.compile(regEx); Matcher match = regexPattern.matcher(inputPath); if(match.find()) { resultString = match.group(1); } return resultString; }

Warframe trading guide part 2 – trade chat, chat filter, wftrading and nexus-stats.com

This is the part 2 of my Warframe trading guide. It is followed by the transcript. Continue reading →

Warframe trading guide part 1 – trade process, tradable items, lingo and trade tax

This is the part 1 of my Warframe trading guide. It is followed by the transcript.
Continue reading →