Help with migrating site using Duplicator

  • Resolved pinecone427

    (@pinecone427)


    1 year, 4 months ago

    Hello everyone,

    I’m trying to migrate a wordpress site to a host, namely OVHcloud and I wish to understand how to install the database as the documentation for Duplicator isn’t very clear.

    So I’ve been able to create the installer and archive files using duplicator, and I’ve managed to access it from the domain and access the installer. Now, my problem is that I can’t seem to get past the database installation step. First of all, what “Action” should I choose to ensure that the data from my previous database is transfered? I’ve written a lot of additional CSS and to my understanding the CSS is stored in the database. Secondly, if I’m doing a “Classic Install” (no previous wordpress installation on the new host) do I need to create a new database with a new user or use the old one on the previous host?

    Thank you in advance for any help!

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

  • In the duplicator files, there will be a database dump file included. When you are configuring things over on your new location, you’ll have to create a new database there, so the restore part of Duplicator can store your database on OVH. It will include everything as in your original database. In the last step you can then do the URLs which if the URL is different, it does a find/replace in your database too as the last step.

    Thread Starter pinecone427

    (@pinecone427)

    @jeroenrotty that makes sense to me. I’ve created a database on OVH but when I enter the credentials I get the “access denied” error from Duplicator. Just to be clear, the password and user fields should be filled with the database credentials or the user that has access to the database? Is it possible to create this user using phpMyAdmin? Thanks for the response

    No, it’s the credentials you are configuring on your host when you create the database. You can’t enter phpMyAdmin without credentials (unless the host has an a 1-click login for it) – so the moment you created the DB on your host, you should have set credentials for it (user/pass). Sometimes user is the same as the DB name, but preferably not.

    Thread Starter pinecone427

    (@pinecone427)

    @jeroenrotty I see. I am using the set credentials for the user/pass but I still get a connection error in the database setup step in Duplicator. The exact error is the following:

    Unable to connect the user [ USERNAME ] to the host [ HOSTNAME ].

    The server error response was: Access denied for user ‘USERNAME’@’ip_adress’

    And this is using the hostname [databasename].mysql.db

    The user and password are using the database credentials in phpMyAdmin.

    I don’t think your hostname ([databasename].mysql.db) is correct. If it is not localhost for the database server, make sure to check in your host what the hostname of the database should be. Few hosts run their database not on the web server itself. Do check with OVH.

    Thread Starter pinecone427

    (@pinecone427)

    @jeroenrotty thank you for the responses, I was able to resolve my problem !

    Happy to read that, you’re welcome!
    If you have a second, please mark the topic as resolved :-).

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Help with migrating site using Duplicator’ is closed to new replies.

Tags