Re: export data from mysql into a text file or CSV file

[Balaji Devarajan]

how about this?

mysqldump -u$dbUser -p$dbPass --database ${DBNAME} --table ${tablename} --no-data -h ${DBHOST} > ${DBDIR}/${DBNAME}_${TYPE}/${tablename}.structure

mysql -e "select * from ${tablename};" -u$dbUser -p$dbPass -A ${DBNAME} -h ${DBHOST} -N --quick > ${DBDIR}/${DBNAME}_${TYPE}/${tablename}.data

this way the file is stored in the client not in the server and you can load them into any server you want

you can recreate table in other server like this way...
mysql -u....< ${DBDIR}/${DBNAME}_${TYPE}/${tablename}.data

and load the data

load data ....'${DBDIR}/${DBNAME}_${TYPE}/${tablename}.data' into....


_ balaji