title: Is it possible to generate a sql/csv export without running a mysql server locally?
body: <p>Essentially I'm hoping to run a python script in jupyter notebook that generates an sql export or a CSV export.</p>
  <p>The script currently builds a DB and stores it in a mysql server locally.</p>
  <p>Unfortunatly, the machine that generates the data we are building the DB from doesn't have, nor can it have a local mysql server running on it.</p>
  <p>Is it possible to 'build the DB' and just hold it in memory and then dump it straight to an export rather than commiting it to a mysql server?</p>
  <p>Thanks</p>
  <p>Edit:</p>
  <p>A little more information for clarity</p>
  <p>The script basically takes 5 unrelated excel sheets and produces a relational database from them. I simply use csv to import the data, manipulate it then use mysql.connector to build the structure I want directly into a locally running mysql server.</p>
  <p>What I want to do is be able to get a sql export that would allow me skip the step of running a mysql server locally.</p>
  <p>The work flow I'm hoping to end up with is:</p>
  <p>Load and run script in Jupyter -&gt; SQL export is generated -&gt; move to machine with mysql server and import.</p>