title: How to export all tables data into csv or excel format in MySQL using a script or some other way ?
body: <p>I have the following problem. I have a production table on a server its like <code>12GB</code> and what i wanted is to just pull off the data form production and import it into my local database for ease operation. </p>
  
  <p>AT the end i want to submit the data in <code>CSV</code> or <code>Excel</code> format to the client. But , i need to have automated script which can import each tables data into a csv file , as naming it by the table name or something ? can you really help on this , i appreciated it? </p>