After sql import

  • Resolved bubbles00

    (@bubbles00)


    15 years, 3 months ago

    Hi everyone.

    My old blog was some how messed up so bad I could no longer login so I made a new wordpress blog. Luckily I had an sql backup saved of the old blog. I was very scared not to mess the new blog so I actually installed one more wordpress just to test (!)

    On my testing blog I followed the sql restore tutorial (https://codex.www.ads-software.com/Restoring_Your_Database_From_Backup) and gathered the courage to import sql. After a while I got the success message saying that my import was sucessful.

    However, I don’t see any of my old posts/categories etc on the blog or dashboard.

    I checked the sql again I saw that there are duplicate tables of everything, one with the prefix mywp and other with wp. I must have named the table prefix mywp on my old blog…now how do I change this… I mean is there a way to get my old posts on my new testing blog?? ??

    Please help me!

    P.S: I am an absolute N00b and I dunno anything about sql stuff so forgive me if I make no sense…

Viewing 1 replies (of 1 total)
  • Thread Starter bubbles00

    (@bubbles00)

    meh, I am sorry to say this but no one ever replies to my posts on this forum when I need help…I found the fix myself.

    Anyone having the same problem should follow this at their own risk:

    The problem I had was that my old blog (the backup sql of which I had) had the table prefix mywp. My new blog had the table prefix wp. So After following the aforementioned tutorial of importing sql through phpadmin, my posts/pages/categories/comments were not updated even though the sql data was added to the new one because of different table prefixes.

    What I did was: First of all, I did all this to a new TESTING blog, so that even if anything went wrong, I wont mess up my site/new blog.

    The fix:

    1.) Save an original backup file copy….always!

    2.) Open the backup sql file in text editor like word pad (I used Notepad++).

    3.) Search for the old table prefix (mine was mywp).

    4.) Replace the old prefix name text with the new table prefix on your current testing blog (its usually wp if not changed in config.php file).

    5.) Replace the mywp with wp in the whole file.

    6.) Save the sql file.

    7.) Follow the sql restore tutorial and backup the sql using the new saved file.

    8.) Cross fingers and hopefully you will receive a success message after a while.

    9.) Go to your new testing blog and you will see it working.

    10.) If you see a blank page try changing your theme to default one/classic.

    IMPORTANT!: I am not an expert and I found this cure myself and it worked for me. Please follow this at your own risk and always store backups of backups and everything else. I tested this in a test blog first, you can do the same to be safe.
    Good luck.

Viewing 1 replies (of 1 total)
  • The topic ‘After sql import’ is closed to new replies.