Friday, June 03, 2016

transfer/copy database with SSH with only one command line

You can migrate a database using a single command line:

mysqldump –add-drop-table –extended-insert –force –log-error=error.log -uUSER -pPASS OLD_DB_NAME | ssh -C user@newhost "mysql -uUSER -pPASS NEW_DB_NAME"

man: can't set the locale; make sure $LC_* and $LANG are correct

I keep getting this error:
man: can't set the locale; make sure $LC_* and $LANG are correct

I tried locale-gen and many other things, without success.
The only thing that fixed it is: export LC_ALL=en_US.UTF-8 (which of course can be added in .profile to be permanent)

Friday, April 15, 2016

Search engine for html source code search

I needed to search for a little code which is available only in HTML source, not in the rendered page. So a simple search would show nothing. After reading on Quora and Stackoverflow, I've found some recommendations: MeanPath, Blekko, Datanyze, Nerdydata. Useless, except some limited results from Google, nothing really worked.

Add Russian charset in Linuxmint/Debian

I opened a console and tried to paste some Russian word but it looked very weird. Then I run: # locale-gen ru_RU.UTF-8 and all works well.

Friday, April 08, 2016

Aman surname

Some more research on my name...
Aman seems to be a popular surname in USA and also a popular first name in India. It means "peace" and rhymes with Atman and Batman.

Friday, April 01, 2016

Surname Aman

Today I have taken a better look on Locate My Name website and I have found some interesting facts. I had no idea my name is so popular in these countries: /fr/Aman /de/Aman /at/Aman.

Monday, March 28, 2016

Saturday, March 26, 2016

SSH port forwarding: bind: Cannot assign requested address

While trying to do a simple port forwarding to access a remote mysql server via a secured channel I was getting an annoying bind: Cannot assign requested address.

$ ssh -v user@host.biz -L5555:localhost:3306
debug1: Local forwarding listening on ::1 port 5555.
bind: Cannot assign requested address

So it must be the buggy IPv6, after adding -4, all worked like a charm.

$ ssh -4 -v user@host.biz -L5555:localhost:3306
debug1: Local forwarding listening on 127.0.0.1 port 5555.
debug1: channel 0: new [port listener]

Diacritics in a linux console for pico/nano/etc

I wanted to quickly edit a text file with pico and when I pasted a word, I noticed that all diacritics were replaced with some funny characters. A quick fix was to edit /etc/locale.gen and add my language like pl_PL.UTF-8 UTF-8 for Polish. Then run # locale-gen as root and all was working good. A list with all supported languages can be found in /usr/share/i18n/SUPPORTED

Monday, January 25, 2016

SCAM ALERT: Blue strawberries, climbing strawberries, blue roses




A few weeks ago I have ordered from Ebay some strawberry seeds. I wanted to get as many varieties as possible and while searching I noticed some guys offer blue or violet or even green strawberry seeds. I ordered a couple of those too, only to find out later that such things don't even exist and the pictures are made in Photoshop. Then I looked at reviews and I realised how many people got scammed the same way. Many gave positive reviews right away after receiving the seeds. Shame on all these sellers for what they are doing. You spend money plus time and resources to take care of something that has no chances to succeed. Shame on them and shame on me because I researched this only after the purchase. This works very well with ebay feedback because getting a fruit from seeds could take years, and you can no longer leave feedbacks after 60 days so these sellers keep 99%+ positives and appear very legit.

It's 100% SCAM. If you look on youtube there is no single video of real blue or climbing strawberries. Yeah, videos can be manipulated too, but not as easy as an image.