lanyrd/mysql-postgresql-converter
lanyrd/mysql-postgresql-converter has 1,313 GitHub stars and 462 forks. GitHot measured 0 stars in 24 hours, -1 in 7 days, and -1 in 15 days. Last checked 2026-11-21 22:37 UTC. Last push 2022-09-16.
Gemessener Sternzuwachs
- in 24h
- 0
- in 7 days
- -1
- in 15 days
- -1
- in 1 month
- Verlauf wird gesammelt
Nettoänderungen in überlappenden Zeiträumen, keine Tagessummen. Fehlende Messwerte bleiben leer. Sterne zeigen Interesse, nicht Qualität.
Über uns
Lanyrd's MySQL to PostgreSQL conversion script
DatenREADME.md
OriginalMySQL to PostgreSQL Converter
Lanyrd's MySQL to PostgreSQL conversion script. Use with care.
This script was designed for our specific database and column requirements - notably, it doubles the lengths of VARCHARs due to a unicode size problem we had, places indexes on all foreign keys, and presumes you're using Django for column typing purposes.
How to use
First, dump your MySQL database in PostgreSQL-compatible format
mysqldump --compatible=postgresql --default-character-set=utf8 \
-r databasename.mysql -u root databasename
Then, convert it using the dbconverter.py script
python db_converter.py databasename.mysql databasename.psql
It'll print progress to the terminal.
Finally, load your new dump into a fresh PostgreSQL database using:
psql -f databasename.psql
More information
You can learn more about the move which this powered at http://lanyrd.com/blog/2012/lanyrds-big-move/ and some technical details of it at http://www.aeracode.org/2012/11/13/one-change-not-enough/.
Ähnliche Projekte entdecken
Wird geladen…