Transferring site to a new host: how to handle database?

  • I created a wordpress site for a nonprofit, in a subdirectory of my own domain. Now that it is done and accepted, I need to transfer it to its own domain and host. I downloaded all the files from my server and uploaded them to the new server – but that does not transfer the database.

    My host is ICDSoft, which uses cpanel. I tried exporting the database from the development site and importing it to the new site, and got
    #1044 – Access denied for user ‘occupycehkc’@’%’ to database ‘anitra_oceh’

Viewing 4 replies - 1 through 4 (of 4 total)

  • Has your database user got full access privileges?

    Thread Starter Anitra Freeman

    (@anitraweb)

    Yes. The database user has full privileges on both sites.

    The first thing you’ll need to do is dump the database from your host. You can do this from the terminal if you have SSH access with:

    $ mysqldump -u’username’ -p’password’ databasename > somefilename.sql

    If you don’t have SSH access, you’ll need to dump the database through cPanel or the like.

    Once you have the database you can either clean it by doing a search and replace anywhere that your domain appears, or you can use the utility described:
    https://www.twincitieswebdeveloper.com/2012/04/wordpress-migration/

    If you want to use the utility described above, simply import your database on the new host and then follow the instructions.

    To import the database through SSH, you’ll have to create the empty database, then:
    mysql -u’username’ -p’password’ database < thedumpfilename.sql

    Make sure that the username, password, and database name are the same on both servers.

    I’m sure I’m making unreasonable assumptions here so let me know if you have problems.

    The database user has full privileges on both sites.

    Are you sure? Access denied for user 'occupycehkc'@'%' to database 'anitra_oceh' suggests otherwise.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Transferring site to a new host: how to handle database?’ is closed to new replies.