My home server will be offline for quite some time. As a result, I’ve decided to migrate my Nextcloud to a shared hosting server.
Everything is straight-forward except for the database migration. Specifically, dumping the current db is not an issue but restoring it to the new server seems to be problematic:
- my hosting provider forces me to prepend my existing Nextcloud user name and database name with my hosting account user name. These are not the same as those in my current configuration. Furthermore, my existing Nextcloud server name is “localhost”; I cannot use this on the new server. Due to these naming conflicts, it seems that I will be prevented from importing (restoring) my database into the new server.
I’m at a loss as to how I should proceed. Is there some MySQL (MariaDB) “magic” available to help me overcome what I perceive to be a road block in my need to migrate?