download the dump file??

[hisham]

Am developing a web application using PHP/mySQL, how can I allow the users to download the dump file using a link”i.e. click here to download the dump file” because the users haven’t access to phpmyadmin area?
Thanks in advance.

 

[jimoblak]

You could create a query that produces the contents of all fields, separated by a comma or tab.

Select * from Table...

The output could be displayed as a simple text file that the user could save from their browser. The CSV file could be managed in MS Excel.

 

[hisham]

and how to download the file in .gz format?