Recently my clan United Gamers Coalition *pimp*
http://planetugc.com *pimp* have decided to move to a new host. The new host is a major upgrade, and will change our second url (unitedgamerscoalition.com to ugcworld.com).
I have done an entire site backup for both URL's, done an entire MySQL Export for all DB's.
Our forums are done with YaBB and it uses an SQL DB. Ive backed up the entire SQL DB, and tried to dump that into another DB we have on other host, but it seems to upload forever and i give up.
I know the forum is huge and shld take time, but maybe im wrong and it wont.
Therefore what i need is anyone with experience with this type of stuff can accurately give me a good layout on how to move an entire site and MySQL Database to another host without losing info would be greatly appreciated.
Im sure ive figured out all the proper steps (except for the MySQL part) but would like some good advice from experienced people to ensure no info is lost. I only have 4 days in which to prepare so a speedy reply is appreciated.
Anyone who helps will have UGC's gratitude and a mention on our frontapge news and a link to this wonderful forum from our site. So your doing me and HLP a favor as we have

of traffic come through their. I know its a bribe but u guys are the only place i wld ask and know i can find an answer.
Thanks ahead of time.