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?.....
Extract data from MySQL the easy way...How? (3 posts)
-
Madsen
Posted 4 years 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
Posted 4 years 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
Topic Closed
This topic has been closed to new replies.
