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

Problems restoring wp_posts mysql

Discussion in 'Blogging' started by MisterTwister, May 30, 2011.

  1. MisterTwister

    MisterTwister Regular Member

    Joined:
    Feb 12, 2009
    Messages:
    458
    Likes Received:
    160
    I am pulling my hair out trying to restore my wp_posts in my msql database.

    I backed up wp_posts then emptied the database. I now want to restore but I kept getting a 101 error as the db is so large.

    I have installed mysqldumper and it seems to upload the db but it is not appearing.

    I am no expert and I am probably doing something wrong that is simple.

    +REP to anyone that can help me with this.
     
  2. devoted

    devoted Registered Member

    Joined:
    Aug 31, 2010
    Messages:
    57
    Likes Received:
    7
    if your database file is too large, you cannot import it using phpmyadmin. the best option is to split your database using SQL Dump Splitter (google plz). and then first import databasename_DataStructure.sql first because it contains the Tables structure. After that, you can execute the other .sql files as they contain the data of the now existing tables.

    keep the value of maximum database file below 18MB
     
    • Thanks Thanks x 1
  3. MisterTwister

    MisterTwister Regular Member

    Joined:
    Feb 12, 2009
    Messages:
    458
    Likes Received:
    160
    Devoted fixed my problem - Don't know how you did it but THANKYOU!

    +REP