Monday 20 February 2012

Sql Import

All Loads / Any Source

If you have more than 1GB of data to load, or if your data is coming from somewhere other than a MySQL database, we recommend creating flat files and loading them with mysqlimport. mysqlimport is another command line utility bundled with the MySQL client software whose purpose is to load flat files into MySQL.

We also recommend creating DB Snapshots of the target Amazon RDS DB Instance before and after the data load. Amazon RDS DB Snapshots are complete backups of your DB Instance that can be used to restore your DB Instance to a known state. When you initiate a DB Snapshot, I/O operations to your database instance are temporarily suspended for a few minutes while your database is backed up.


Creating a DB Snapshot immediately before the load allows you restore the database to its state prior to the load, should the need arise. A DB Snapshot taken immediately after the load protects you from having to load the data again in case of a mishap and can also be used to seed new database instances.


be "sales.csv" or "sales.txt", but not "sales_01.csv".  


http://aws.amazon.com/articles/2933

No comments:

Post a Comment