Ok this is too much for me to handle. The database is a 175 MBish and I cant figure out how to move it. Its going from one dedicated server to another. Please let me know if you can do this and for how much.
Do you have root access on the destination server? You can dump the database with phpMyAdmin from the source server and then import it (from the command line) on the destination server. mysql -u database_username -p databasename < dumpfile.sql
On the source server: mysqldump -u database_username -p databasename > dumpfile.sql Then copy the dumpfile.sql to the destination server and: mysql -u database_username -p databasename < dumpfile.sql
I did and they transferred all my site except that one. Basically I went from the slowest dedicated server to the fastest at hostgator and they transferred everything for me but that site. Guess they had problems too.
Thing is I dont know what directory to go to, or even much how to use SSH. Ive read how to do it, but I just cant.
Aaron, it's not too hard to use SSH, however if you've never used it before, maybe you should get somebody here to do it for you for a small price? I could do it but I'm sure there are other people that you know here who are just as capable. And a word of advice, you SHOULD know how to backup your 178MB database because what would you do if it became corrupt? From what I understand you don't know how to back it up either, since that's the first half of moving it.. But really, you should be backing that up daily. You don't want to even think about the headaches of losing all your database data...