Converter mysql schema and data to postgresql
Usage
- Create dump in xml format using command:
mysqldump --xml -u USER_NAME DB_NAME > DUMP_FILE_NAME - Run converter using command:
php convertor.php -i DUMP_FILE_NAME -o PSQL_FILE_NAME
Additional options
-b50- set batch count (used on insert data). By default batch count = 200-n- non export structure
Restriction
This converter does not support foreign keys, because mysql does not return foreign key in xml dump Also You must have installed locally php postgresql extension