Scripts to migrate Wordpress uploads to S3 for WP Offload S3 Lite

README.md

Improvements are welcome!

dump.sql

-- replace YOURREGION and YOURBUCKET accordingly
-- this will dump a number of php lines for you to run.  paste all these rows into a file and run it.  Use the output in the next file
select CONCAT(
"<?php print(\"(",
ID,
", 'amazonS3_info', '\".str_replace('O:8:\"stdClass\"', 'a', serialize(json_decode(\"",'{ \\"region\\": \\"YOURREGION\\", \\"bucket\\": \\"YOURBUCKET\\", \\"key\\": \\"', SUBSTRING(guid, 31), '\\"}"\))) ."\'),") ?>') from db224570_1clk_wordpress_qq175dggRSHpFIs1.wp_posts where post_type = 'attachment';

import.sql

-- paste the output from dump.sql (after running it through PHP) onto line 3:
insert into wp_postmeta (post_id, meta_key, meta_value) values