15
In my opinion you are ok, I will only do some recommendations based in my experience:
- Backpup your files to you computer and also, if your host provides any kind of cpanel, "move" your old site to other folder instead of deleting it, so if your new installation gets impossible and you finally get frustrated you can get back you old site on-line by moving deleting new installation, moving back your old files and recovering your old db), so you can give "tomorrow" an other chance.
It is easiest to move folder than wait to ftp upload again your old files. Of course you need enough hard disk space for two site at the host.
- Backup your db twice, you never know what could happen.
As you said use phpmyadmin por db, but also try HeidiSQL for win. If have used this software for 3 years and it is very useful. You only need external (internet) db access to mysql databases.
- When installing new 2.5.6. make sure it works every thing before deleting the db and importing the local one.
Check if XOOPS_VAR_PATH if properly configured, try installing some common modules like news, create some stories.
- Test your theme with your 2.5.6. theme before importing your local db. If there are some errors, it is better to find them with less places to look in.
- After all previous check ok, back up your "fresh 2.5.6 db" before delete it and importing your local 2.5.6. db. If it doesn't work, you can easily go back.
- If complete local 2.5.6. db import doesn't work in the webhost to do it step by step:
- Install and check new fresh 2.5.6. (out of the box).
- Do basic configuration / customization.
- Do a db backup
- Install one module, test it, create dummy content and test.
- Import db tables only for the installed module. (Edit the sql file and copy and paste only the required tables to a new file).
- Test the module, and if every thing is ok, import an other module, and repeat previous "sub-steps".
- If you finally get success importing step by step make a db backup.
- Only one more recommendation, when everything online gets working import your 2.5.6. on-line db in your local computer and test it, if it doesn't work locally your webhost and localhost machine configurations are "critically" different, so you must find the differences and try to set config for both the same, so you can make "experiments / install new modules" in your local machine and then upload them to you webhost and meke them run easily.