1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Extract every single DB from a large (full) phpmyadmin DB backup

Discussion in 'Other Languages' started by GeezNotThatGuy, Nov 12, 2013.

  1. GeezNotThatGuy

    GeezNotThatGuy Newbie

    Joined:
    Feb 7, 2013
    Messages:
    24
    Likes Received:
    5
     
  2. fistor

    fistor Regular Member

    Joined:
    Feb 29, 2012
    Messages:
    256
    Likes Received:
    315
    Location:
    A mind needs books as a sword needs a whetstone, i
    Why didn't you just use the f operator?
    Or did it stop anyway?
     
  3. MafiaBoss

    MafiaBoss Elite Member

    Joined:
    May 5, 2012
    Messages:
    1,519
    Likes Received:
    1,032
    Gender:
    Male
    Occupation:
    Currently Un-Occupied
    Location:
    In granny's Basement
    Home Page:
    oh the code, the code, make me dizzy.
     
  4. GeezNotThatGuy

    GeezNotThatGuy Newbie

    Joined:
    Feb 7, 2013
    Messages:
    24
    Likes Received:
    5
    For my defense: My focus is on creating content, not handling server issues. I have just very basic knowledge and my serveradmin was asleep when the problems arose.
    So could you please elaborate? What is the f operator? And by the way, i tried to change stuff in the config tab in phpmyadmin, but for whatever reason i allways just got a blanc site.
    I know that there would have been an option to ignore errors.
     
  5. GeezNotThatGuy

    GeezNotThatGuy Newbie

    Joined:
    Feb 7, 2013
    Messages:
    24
    Likes Received:
    5
     
  6. Izzma

    Izzma Regular Member

    Joined:
    Jan 29, 2012
    Messages:
    293
    Likes Received:
    197
    Location:
    Canada
    If you are using cPanel why don't you use "Backup Wizard"? You can easily download your .SQL data and public_html directories with the click of a button.

    I have literally millions of entries I either export or restore on a monthly basis and never have a problem. For the people who don't use cPanel, try MySQL Dumper. It works just as well.
     
  7. GeezNotThatGuy

    GeezNotThatGuy Newbie

    Joined:
    Feb 7, 2013
    Messages:
    24
    Likes Received:
    5
     
  8. fistor

    fistor Regular Member

    Joined:
    Feb 29, 2012
    Messages:
    256
    Likes Received:
    315
    Location:
    A mind needs books as a sword needs a whetstone, i
    Gotcha!
    Just to make it clear, you don't have to defend yourself, as I was just asking. The f (force) would have been the first thing I would have tried.

    Basically PhpMyAdmin is just an interface for your Database. You could navigate to your MySQL folder directly via shell (such as putty) or directly via remote (cmd etc).
    Then you tell MySQL to import your Database Dump, without the "help" of PHPMyAdmin.

    You do that with a command such as mysql -uuser -ppassword < dumpfilenamehere.sql (IIRC! Been a long time since I messed with MySQL)
    If that should throw errors (unlikely), you can force MySQL to ignore the errors by adding -f or --force to the command above.

    That should have imported all your databases anyway.

    Again, long time since I played with MySQL. If anyone experienced finds this to be wrong, feel free to correct me. But imo, this should work.
     
  9. tompots

    tompots Elite Member Premium Member

    Joined:
    Dec 11, 2011
    Messages:
    4,371
    Likes Received:
    3,967
    Gender:
    Male
    Occupation:
    Full Time Bot Developer
    Location:
    Automation Alternatives
    Home Page:
  10. GeezNotThatGuy

    GeezNotThatGuy Newbie

    Joined:
    Feb 7, 2013
    Messages:
    24
    Likes Received:
    5