Getting data out of a mysql database into a text file is pretty straight forward using mysqldump
mysqldump5 -u USERNAME -p DATABASE_NAME TABLE_NAMES > /PATH/TO/FILENAME
TABLE_NAMES are optional and need to separated by a space if you are exporting a couple.
Filed under: development , database, export, mysql
