Database Backup & Restore
I plan do move my gallery to a new hosting provider soon.
I cannot use the backup option in the Admin area since it generates a lot of MySQL errors.
I'd rather do it through Export/Import features of phpMyAdmin from my host's Control Panel. The database is quite large, and I guess I'd use the option "zipped" to save the file to my local hard drive to be later imported into PhotoPost.
I've never done this before. Has anybody backed up the database and successfully restored it when moving to a new hosting provider ?