By davedg629 on

I need serious help moving my drupal site from my local server (apache) to my newly acquired web server (anhosting.com). I have been looking around for hours trying to find guides/howtos/help on how to accomplish this but everything I read does not help.

I have uploaded all of the drupal files using ftp but they went to www.example.com/ftpadmin (ftpadmin is the ftp user name I created in Cpanel). How do I get this files to the right place so my homepage is www.example.com?

I do not use phpmyadmin to administer my database on the local server. I just use the mysql administer gui. How can I export my database and then import it onto the web server using phpmyadmin (phpmyadmin is an included app with anhosting.com)?

These are my main problems right now. It seems like there must be a full tutorial that explains most of this stuff but I cant seem to find anything. Thanks so much for any help!

Dave

⋅ Categories: Drupal 5.x

Comments

mb450’s picture

mb450 commented

You can backup your mysql database using mysqldump

mysqldump -u username -ppassword databasename > db_dump.sql

You can restore it with the command line or phpmyadmin
mysql -u username -ppassword -h hostname databasename < db_dump.sql

the dump file can be imported using the import option

on cpanel you will have an @www or a public_html directory put your data in there.

davedg629’s picture

davedg629 commented

I have already backed up my database using MySQL Administrator. When I try to import the back up file using phpmyadmin onto the web server I get an error saying that my mysql user (on the web server) "does not have access to the database 'drupal'" (my database name is 'drupal'). Why can't I import this backup file? Thanks for the help btw

mb450’s picture

mb450 commented

This is because you haven't granted to the correct option to the drupal database.

Have a look at the grant documentation at: http://dev.mysql.com/doc/refman/5.1/en/grant.html

either that or a database called drupal already exists and yours is conflicting with it (although that would probably only happen in a shared hosted environemnt and even then normally the databases are prefixed with user names to avoid such collisions)