title: Exporting Large MySql Table
body: <p>I have a table in MySql that I manage using PhpMyAdmin.   Currently it's sitting at around 960,000 rows.   </p>
  
  <p>I have a boss who likes to look at the data in Excel, which means weekly, I have to export the data into Excel.</p>
  
  <p>I am looking for a more efficient way to do this.   Since I can't actually do the entire table at once, because it times out.   So I have been stuck with 'chunking' the table into smaller queries and exporting it like that.</p>
  
  <p>I have tried connecting Excel (and Access) directly to my database, but same problem; it times out.   Is there any way to extend the connection limit?</p>