I am in the process of switching hosting companies and I was wondering how to go about transferring two MySQL databases, each of which are about 1.3mb in size. I am somewhat familiar with PHPmyAdmin and Ive tried exporting the database; however, when I try to import on the other server its giving an error because its trying to create a brand new database. Similiarly, another problem involves the naming of those databases. My current host has this named like this: name_blog And my new host has them named like this: name1_blog I want to make sure that that change, while minor, will not affect database or table structure/content. Any advice you all could give would be much appreciated, Ive tried doing Google searches but havent had success thus far.