1. Use same db type, if innodb use innodb. you can always buy additional space.
2. use mysqldump to dump database in sql file, copy file to vps and run mysql < db.sql.
3. there is no matter for mysql if you are using hdd or ssd.
4. Change your marketing strategy.