Support » Installing WordPress » Restore DB backup outside of phpMyAdmin

  • Resolved ClintN

    (@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

    (@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.

    ClintN

    (@clintn)

    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

    2ninerniner2

    (@2ninerniner2)

    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.