Export MYSQL To Text File

[6Foot2]

Our ICT Department is giving courses on MYSQL. They have reached a point where they would like the students to be able to export the entire database so that they can work on it at home.

 

Is there a statement that can be run against the database that will export everything associated with the said database [tables, queries, forms anything in the database] to a text file?

 

Many thanks.

[powdarrmonkey]

The mysqldump program, or phpmyadmin.

[webman]

Or HeidiSQL which is a free Windows app.

[plexer]

+1 for Heidi I used her all the time for my MySQL needs.

 

Ben

[danbuntu]

or mysql workbench