Eventually I managed to import the database into a new slice. Earlier failure was due to extremely large mysqldump mostly due to logs, file size reduced from 16 to 4.5Mb.
I then hit another problem, I locked myself out. It was like slam closed my main door without the key in hand, all windows were also shut to keep the rain out, how nice!
How am I going to get in if I purposely made the
sshd_configand firewall to stop anyone getting in. There is in fact a safety backdoor available at slicehost however editor nano isn't very useful there according to this thread. My only 'key' to get back in is using Vi, a 30+ years old editor available to almost any UNIX/Linux distro, to edit
I have been very comfortable with
nanobecause that reminds me of WordStar which I learnt to master when the original IBM PC came into market. I was a kid then.
Googled a bit about Vi looking for howto, tutorial and cheatsheet and the like I found this interesting read and this tips. I'm sure there are still a lot of 'died hard' fans to this 'old editor'. Younger generation is just too lazy to climb an apparently steep learning curve. It was said that badly designed systems aren't bad as long as you can get used to it, e.g. QWERTY keyboard isn't a good logical design (I can type fast by the way). During the 500 years of piano history there were also so called genius logical design of multiple keyboards (as in organ, so that you don't need to stretch your hands) and curved keyboard but none of these lasted very long.
PS: now I'm in my house again using editor Vi. I have yet to setup firewall at the new slice before I decide to switch to LEMP from LAMP. I also found that the apparent speed issue of loading this site is due to the jQuery scripts that I'm using rather than performance of Apache.