Skip to content

Latest commit

 

History

History
43 lines (25 loc) · 746 Bytes

migration.md

File metadata and controls

43 lines (25 loc) · 746 Bytes

AWS Free Tier MySQL user/pass:

User: root Pass: root

Dump sqlite3 db to a file

Example:

sqlite3 ./db_file .dump > output.dump

Use the conversion script

Ref: https://www.redmine.org/boards/2/topics/12793?r=24983

Example usage:

mysql -u user -p -e "create database redmine character set utf8;" 
sqlite3 production.db .dump | sqlite3-to-mysql.py | mysql -u user -p redmine

Import dump to MySQL

Remember to create the database first: mysql -u root -p -e "create database main character set utf8;"

Example: mysql -u root -p < nitm.sql

Poor man MySQL backup

(AWS RDS has auto-backup, however it is easy to manually dump a backup as well)

Ref: http://webcheatsheet.com/sql/mysql_backup_restore.php#mysqldump