How to backup specific tables in a mysql database through shell?
Posted on 2010-11-23
I have a very large mysql database and would like to fetch specific fields within tables and download them as a .csv file. More specifically:
I'd like to backup 3 separate user fields within one table out of the database (ex. email, username, ipaddress). I looked up some shell commands, and know some rudimentary stuff, but haven't been able to piece together a command to accomplish this.
Anyone know how?
By the way, I would like to download all of the data from each field.
Thanks a bunch!