http://code.activestate.com/recipes/tags/simpledb/popular/2008-10-31T11:55:16-07:00ActiveState Code Recipes2008-10-31T11:55:16-07:00Chris McAvoyhttp://code.activestate.com/recipes/users/4167739/http://code.activestate.com/recipes/576548-converting-mysql-database-to-an-amazon-simple-db-d/

<p style="color: grey"> Python recipe 576548 by <a href="/recipes/users/4167739/">Chris McAvoy</a> (<a href="/recipes/tags/amazon/">amazon</a>, <a href="/recipes/tags/database/">database</a>, <a href="/recipes/tags/mysql/">mysql</a>, <a href="/recipes/tags/simpledb/">simpledb</a>). </p> <p>This script will take all the tables from a given MySQL database and upload them to Amazon SimpleDB as Domains. The 'name' of each uploaded record is the value of the first primary key found in the table.</p> <p>This was written to scratch a particular itch, I've tested it against a 500mb database of my own, but didn't try overly hard to make it an all purpose general tool.</p>