install manual database dump

  • Resolved Jules Colle

    (@jules-colle)


    6 years, 4 months ago

    I’m sure you heard this 2000 times before, but thank you so much for this amazing plugin!

    I have a small problem on a couple of sites with large databases. The problem is that the database-only dump always results in a timeout.

    I am, however, able to create the dump with phpmyadmin. Is there a way to use duplicator installer.php script with a manually created database dump? And if so, how would I do this?

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

  • Hey Jules,

    You have a few options:

    1. You can filter out any large tables on step 1 of the build process.
    2. You can try to work with your hosting provider to see if they will increase the time that a PHP and MySQL process is allowed to run.
    3. The mysqldump option tends to be faster on some servers but slower on others, so try both PHP and mysqldump modes (see Settings > Packages)

    Hope that helps~

    Thread Starter Jules Colle

    (@jules-colle)

    Thanks for the response! I think I’m going to fiddle with the installer.php script a bit so it skips the size checks instead. Looks like the most automation-friendly option to me. I know this is hackish and you will probably not approve of this, let alone give any support, but do you think it will work? I guess I could just copy all my wordpress files to the root, and rename the database dump to database.sql and then just tick “Manual extract package”, right?

    Hey Jules,

    Yeah, a similar process is documented here:

    ? ? – Two-Part Install
    ? ? – https://snapcreek.com/duplicator/docs/quick-start#quick-060-q

    The code is open-source so if you know your way around feel free to try and make it work however you can.

    Cheers~

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘install manual database dump’ is closed to new replies.