Problems restoring wp_posts mysql

MisterTwister

Regular Member
Joined
Feb 12, 2009
Messages
459
Reaction score
145
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.
 
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
 
Devoted fixed my problem - Don't know how you did it but THANKYOU!

+REP
 
Back
Top