Extract data from MySQL the easy way…How?

  • madsen

    (@madsen)


    18 years, 8 months ago

    Long story…my blog got hacked and the whole database got erased. I’ve got a backup of the db (a 64 mb .sql-file), and I would now like to extract data (blog entries…articles) from this database.
    I’ve tried to open it using various editor, but that just returns gibberish…Is there a way I can extract data without having to: upload it to a MySQL enabled server/installing MySQL and php locally on my mac?…..

Viewing 2 replies - 1 through 2 (of 2 total)
  • moshu

    (@moshu)

    18 years, 8 months ago

    What do you mean by “extracting data”? The .sql file can be used to be imported into a database – and the DB can be either on a host server or your own machine, but in both cases you need MySQL installed wher the data goes.

    Cypher

    (@cypher)

    18 years, 8 months ago

    If you exported your database to a .SQL file, it should just be a regular text file. Try opening it in Wordpad and if you can see relevant SQL commands like, “DROP IF EXISTS”, “CREATE TABLE”, “INSERT INTO TABLE” and so on, you’ve got a valid file that you can use phpMyAdmin to re-create your database.

    So before we can figure out why you are seeing gibberish in the file, how exactly did you create your backup?

    Regards

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Extract data from MySQL the easy way…How?’ is closed to new replies.

Tags