Installing a MySQL back up?

If you already have the backup exported, then it is relatively easy.

1. create a new database on the new host (i used the same usernames and then created the same user and added that to the database) but you can go with a fresh name and user. If you do you will just have to amend the details in the config file.

2. You should now have an empty database. Go into phpMyAdmin and in your empty database, use the import command. Browse for your file you previously saved on your computer, press go and wait. It will take a little while to exectue all the queries.

3. Edit your config file in the efic root directory to reflect the new database/user names. Even if you have the same database name and user you will have to alter your prefix to them.
for example if your host username was  abcd and your efic database was efic, then it woudl be abcd_efic. Your new host username will be different so you will need to change your config file to efgh_efic.

you are done

Oh my goodness that sounds so easy!

Thank you so much, Jacci. I really appreciate it.
The new db is already installed with a fresh efic. I just want to move
my data there. I'm going to give it a try right now and hope that I don't mess it up. 🙂

I'll be back to let you know how it went and to <.< beg for help if I ruined it. >.<

I'm happy to say that thanks to the wonderful, Jacci, the problem is solved.

Thanks again, Jacci!  😀

You are very welcome, glad you got it sorted  😀