Database Transfer
I've seen several threads on this, but I want to make sure I get the answer for what I've got. I'm moving to a new hosting server and need to move a rather large database. My old server has cPanel, my new one does not. I want to see if my plan is OK, and how to do the latter portion.1] Make a backup (gzipped) of the database and save to my computer.
2] Upload the backup to the new server
3] Decompress the database (Via SSH, I have that access on the new server, but not the old)
Is this a viable option, and if so, how would I use SSH to complete this task?
Thanks in advance.