ok i am a complete newbie when it comes to this but i want to move web hosting because i made the mistake of choosing 1and1. I am running a wordpress website and just need to know how to transfer it to the new host. do i go to export database in php my admin? i tried this and tried exporting it as a sql file. then when i went to import that file on bluehost it said my username @ localhost was not allowed to access the database. Can anyone provide some insight i will be so grateful i have been pulling my hair out for hte last week trying to resolve this issue thanks in advance guys!
Ahhhh 1&1 noooooooo....... When you create a database with 1&1 they create a user for that database at the same time. This isn't the way it works with most other hosting companies. If you have something like cPanel you usually have to create a database user and then assign that user to a database. Also with most hosting companies your hostname will be localhost. With 1&1 you usually get a different hostname with each database. It takes a bit of getting used to after being with 1&1 for a while. I still have a lot of domains with 1&1 but have recently started switching domains over to HostNine. I'm afraid that 1&1's service has gone into a nosedive recently. I've had major problems with billing and customer service. They banned my IP from accessing my accounts for no explainable reason. Then they took over 48 hours to register a domain. They also lost me another domain which was quite valuable due to more delays. Anyone thinking about using them, think again
thanks for the assistance. Do i create the new user on the bluehost side? or on the 1and1 side before i do the export to a .sql file? Also i need to get my domains off of 1and1 quickly and quietly. actually there is only one i need to worry about. can you provide maybe a step by step that could help me bluehost uses a Cpanel with PHPmyadmin any suggestions would be great thank you
oh btw you can check out my other thread in the general chat section http://forums.digitalpoint.com/showthread.php?t=515822 i would really like to make people aware of how awful 1and1 truly is feel free to chime in
The "username @ localhost was not allowed to access the database" error has nothing to do with your old host or really anything to do with the import file. It's basically saying you dont have permission on the database server to run the commands in the import file. First things first, export all your databases from the old database, this will create a bunch of .sql files. These files are basically text files containing a bunch of sql commands. Usually the first creates a database, then a table, the inserts records. Once you have these .sql files, you can run them on the new database server to import them.. If you get permission errors, you need to make sure you have permission to create databases/tables. This is something you may have to talk to your host about if you're not familiar with changing the permissions on a Mysql server.