Answer Question
Opening file with .sql extension
I've backed up my wordpress mysql database to a file with extension .sql . I'd like to access the data in that file, perhaps to repurpose the postings. I'm hoping there's some way to open it., preferably in MS Access.
I've tried opening it directly in Access 2002, but it doesn't support the format, nor is it one of the file options to link to. I know I can link to other databases from Access using ODBC. I've set up odbc connections before, but I haven't the foggiest how to set up an odbc connection to this file. I have some inkling I'm supposed to install mysql in order to read the file and then access it, but the msql site didn't yield much in the way of guidance for me.
If someone could point me in the right direction, that'd be great.
TEXT
Uploading file and scanning for virus...
Please Wait