I need to access to history of each wiki page. I found http://dumps.wikimedia.org/fawiki/latest/fawiki-latest-pages-meta-history.xml.7z contains such data for Persian wiki in XML format. But I want prossess the data using MySQL. Is that file available in sql format too? Where can I find it?
No, there are no SQL versions of the XML dump files.
The page Data dumps/Tools for importing on meta.wikimedia.org describes how to work around that: You can either use
ImportDump.php to import the XML file directly (apparently suitable only for small wikis), or you can use a tool like mwdumper to convert the XML into SQL and then import that.
There is already an answer to this question, by @RSFalcon7.
You will find the whole explanation on this Wikipedia page about dumps available in XML or SQL format.
The data about revisions in SQL seems private though (no link provided for direct download), but I couldn't figure what this implies.
It does not seem available in Persian unfortunately either.
Another possibility is to parse your XML and add it to your database. You can then define your own Database schema. Python language can probably help you do that.