Xserver access patterns (SSH + FTP + MySQL tunnel)

Xserver shared hosting access

COCON Inc. has 19 domains on Xserver shared hosting (sv8140.xserver.jp). Used as legacy hosting + sources for ongoing VPS migration.

SSH

Host xserver-cocorobo sv8140
  HostName  sv8140.xserver.jp
  User      cocorobo
  IdentityFile /root/.ssh/id_ed25519_xserver
  Port      10022

SSH key registered on Xserver SSH設定 panel 2026-04-30.

Sub-FTP

• Account: corone@cocon-inc.co.jp
• Host: sv8140.xserver.jp
• Covers all 19 sub-domains under cocon-inc.co.jp parent

Tool: lftp (handles directory mirroring + parallel transfer).

lftp -u corone@cocon-inc.co.jp,'<password>' sv8140.xserver.jp <<EOF
mirror -P 4 --verbose --delete /remote/path /local/path
EOF

MySQL access (via SSH tunnel — REQUIRED)

Xserver blocks external MySQL TCP. Solution: tunnel through cocorobo SSH.

ssh -N -L 13306:127.0.0.1:3306 xserver-cocorobo &
mysql -h 127.0.0.1 -P 13306 -u <db_user> -p <db_name>

DB hostname is INTERNAL Xserver MySQL host (mysql<NN>.xserver.jp style) — must be looked up from Xserver control panel. Tunnel the local port → remote 3306 forwarding.

Migration completed

Project	Date	Size	Method
Kokorozashi	2026-04-30	23 GB	lftp mirror → /var/www/kokorozashi-app.cocon-lab.com/ + assets to /var/www/assets.cocon-lab.com/

Migration TODO (others)

19 sub-domains total — only Kokorozashi migrated so far. Full migration deferred until per-project plan.

DB import (post-tunnel)

mysqldump -h 127.0.0.1 -P 13306 -u <user> -p <db> > backup.sql
mysql -u root local_db < backup.sql

See also

• kokorozashi — first migration target
• github-account-routing — SSH alias listing