To create a tab-delimited MySQL dump, use the -T option in conjunction with the mysqldump command. After the -T, include the folder you would like to place the dump. /tmp is probably the best location, since mysql needs to have write permissions on that folder. The name of the file that will appear is tablename.txt:
[ryans ~]$ mysqldump -u username -p -h localhost tablename -T /tmp
Post new comment