WordPress.org

Forums

[resolved] Restore DB backup outside of phpMyAdmin (4 posts)

  1. ClintN
    Member
    Posted 9 months ago #

    After spending two days with phpMyAdmin timing out rather when trying to import SQL files from SimpleBackup plugin, I need to investigate a way to achieve this outside of phpMyAdmin.

    I thought other plugins may help with importing SQL files, but have had no luck getting my data back into WP

  2. RossMitchell
    Member
    Posted 9 months ago #

    It is unusual for phpMyAdmin to timeout.
    Are you able to use phpMyAdmin in ways other than import ?
    How big is the file you are trying to import ?
    Are you able to successfully import even the smallest file ?
    Have you checked with your hosting providor ? Do they have some particular problem ?

    If it really is that your file is just too big, then it is possible to cut it up into smaller more easily digested fragments, and import your data in stages.

  3. ClintN
    Member
    Posted 9 months ago #

    Ahhhh yes the SQL is 185 mb which may be too big!

    I will investigate how to cut up a SQL file into smaller chunks, I did a test run with the original file doing it manually, which I believed worked even though there was an SQL error message in phpMyAdmin.

    I an not sure if the there is any special naming conventions or file headers required to do it manually, but I would prefer a tool to cut up a 185mb file

    Thanks heaps

  4. 2ninerniner2
    Member
    Posted 9 months ago #

    Perhaps give it a try using a gzipped export file.

    In phpMyAdmin Export, select Custom in the Export Method, then in Output, select gzipped from the compression drop down.

    You may also want to investigate a tool such as Navicat for MySQL.

Reply

You must log in to post.

About this Topic