Support » Installing WordPress » Restore DB backup outside of phpMyAdmin

  • Resolved ClintN


    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

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


    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.



    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



    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.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Restore DB backup outside of phpMyAdmin’ is closed to new replies.