Feb 09, 2007 - 09:09 PM
So if you run it with notepad you can see the text.
If you need to run the sql statements in Access, there probably is some kind of sql editor in access where you can copy paste the statements and execute them.
Beware though that it might not be possible to execute mysql statements on the access database without problems, since there could be some differences in the syntax. If you have problems, you can post the statements here and I can see if I can help you.
Feb 09, 2007 - 09:19 PM
Feb 09, 2007 - 09:21 PM
Feb 09, 2007 - 09:32 PM
Feb 09, 2007 - 09:33 PM
Feb 09, 2007 - 09:36 PM
in there is a "Import" function that allows you to upload an .sql file.
Feb 10, 2007 - 12:25 AM
If you cannot see the data with a text viewer, then it's either using a different character encoding, it's corrupt or maybe it's zip-compressed.
phpmyadmin does have import and export functions that compresses the sql files with zip, so wordpress might have done the same. I recommend to install phpmyadmin and try to import it.
Feb 10, 2007 - 09:29 AM
Feb 19, 2007 - 01:44 PM
What I guess is, that wordpress is using a .sql suffix for the backup file but it actually isn't a text based .sql file. If you do a backup using MySql administrator, you will get a text based sql file which you can open in Notepad. I assume that this wordpress sql file is a wordpress specific format and can only be used in wordpress. Sorry. I do not have any experience in wordpress. But I have some experience in MySQL.
I recommend to use MySql administrator (download here: http://www.mysql.org/downloads/gui-to...), create a backup of the table. This will result in a text based sql file. Then you can create a blank database in MS Access, open a query, set the view to SQL and cut and paste the sql text from the backup file into this query. You can try and run it but be prepared that there are some differences between the SQL syntax of MySql and MS Access.
Let us know how you get on!