Exporting an Oracle schema and uploading to Amazon S3
Warning: mysql_get_server_info(): Access denied for user ''@'localhost' (using password: NO) in /home/blucel/public_html/wp-content/plugins/xml-google-maps/xmlgooglemaps_dbfunctions.php on line 10
Warning: mysql_get_server_info(): A link to the server could not be established in /home/blucel/public_html/wp-content/plugins/xml-google-maps/xmlgooglemaps_dbfunctions.php on line 10
Question: How do I upload an oracle database schema file to s3 from linux command prompt
Answer: Download s3cmd
run ./s3cmd –configure
enter your access key and secret key when prompted
run your expdp command as oracle user
i.e. expdp sys/password schemas=rivpacs directory=DATA_PUMP_DIR dumpfile=rivpacs100309.dmp logfile=rivpacs100309.log
upload to your s3 bucket
i.e.
./s3cmd put rivpacs100309.dmp s://mybucketname
Voila. comments please..