managing my database offline

  • Resolved hsawires

    (@hsawires)


    5 years, 10 months ago

    Hi,
    I have bckuped my database and downloaded to my desktop pc.
    now I need to open and manage the database locally over my machine.
    how do I do that please?

    ps. I tried to open it using “DB Browser for SQLite” but it tell that the file is not a database.

    please help

Viewing 5 replies - 1 through 5 (of 5 total)

  • @hsawires

    You can extract db.gz file, rename the file with .sql extension.

    Go to phpMyAdmin or “DB Browser for SQLite” truncate/delete the existing tables, then import the .sql file.

    Note: take a backup of existing tables before deleting it.

    Thanks,
    Harshad

    Thread Starter hsawires

    (@hsawires)

    Thank you @bornforphp for your reply

    It didnt work, maybe I did so,thing wrong as I am not expert in handling databases.
    I got an error message using “DB Browser for SQLite”

    Error Importing data: Error in statement#1: unrecognized token: "#".
aborting execution and rolling back.
    • This reply was modified 5 years, 10 months ago by hsawires.
    Plugin Author David Anderson / Team Updraft

    (@davidanderson)

    The database backup is not an SQLite file, so you cannot do anything with it with a tool designed for SQLite. SQLite is something with not much to do with WordPress at all.

    What is it you mean by “manage” the database backup? The backup file is not itself a live database that you can use database tools on, it is a database backup that you can recreate a database from, e.g. by importing it into MySQL or MariaDB.

    Thread Starter hsawires

    (@hsawires)

    Thank you david for your reply

    I have lost my hosting and all my website for some reason. somebody hacke my website and deleted all my database and I couldn’t restore it. maybe I have no skills to do so.
    but Thanks God I did a backup with you plugin two days before the disaster.

    I need to rebuild a new website with some (not all) the database I have.
    so I need to see what in my database which to import.

    some posts have absolute links I need to replace with new location I need to do so the way (find and replace)

    if you could help me how to open and see what in my backuped database .. i will be so grateful.

    Plugin Author David Anderson / Team Updraft

    (@davidanderson)

    What tools are you using to manage your MySQL install? Normally it’ll have an “import” function. e.g. If you’re using phpMyAdmin, then the documentation on how to import is here: https://docs.phpmyadmin.net/en/latest/import_export.html

    Though, unless you’re a MySQL expert, poking around in the database itself usually isn’t the easiest way to proceed; it may be easier to restore the website, and then use native WP tools (e.g. the Import/Export plugins for different parts of WP) to get specific bits you want, if you’re wanting to rebuild a new site using only bits and not to fully restore.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘managing my database offline’ is closed to new replies.