Database – back up, modify, then restore

  • eswrite-wp

    (@eswrite-wp)


    12 years, 2 months ago

    In the process of recovering from a base64 hack, I’ve been scanning through my database tonight. I did a backup/download to my PC, made a copy of the downloaded database, and I am about to go through and remove/replace suspicious stuff (if I find it). For good measure, I did a global search/replace (with Universal SQL Editor) for stale URLs in my older posts that needed to be updated (very cool).

    Now I’m wondering…

    1. If I do a restore using the modified SQL file, will records/tables in my online database be replaced? Or will I have duplicates?
    2. I am also noticing that MySQL/phpMyAdmin has a 10MB limit on Imports, but my database is 15-16MB. Am I out of luck?

    I’ve been following instructions in the following links:

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter eswrite-wp

    (@eswrite-wp)

    12 years, 2 months ago

    Maybe I don’t need to do a full import for what I want to do. I just found this tidbit about doing a search/replace in phpMyAdmin:

    http://www.marketingtechblog.com/mysql-search-replace/

    update wp_posts set post_content = replace(post_content, ‘replace_that’, ‘with_this’);

    However, this still leaves the question unanswered as to how to do a full database restore from a backup. Anyone know? My ISP tech support is telling me to use FTP, but that seems… wrong based on everything I’ve read about dealing with WordPress databases.

    Thread Starter eswrite-wp

    (@eswrite-wp)

    12 years, 2 months ago

    Also found this plug-in for search/replace. Sounds like the least painful way to do it…

    Thread Starter eswrite-wp

    (@eswrite-wp)

    12 years, 2 months ago

    Well, for the 10MB limit, I just got word from my ISP that I need to upload the SQL file via FTP (not thru phpMyAdmin’s ‘Import’), and that they will then add it for me. Wondering if this will work, but will definitely try it to test how to do a database restore.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Database – back up, modify, then restore’ is closed to new replies.