29,402
edits
Changes
FAQ Migrate my Mysql database to PostgreSQL (view source)
Revision as of 02:24, 19 February 2012
, 13 years ago→Import dump file
Line 30:
Line 30:
sed -e 's/\\/\\\\/g' tmpfile.sql > mysqldump_readyforpgsql.sql
sed -e 's/\\/\\\\/g' tmpfile.sql > mysqldump_readyforpgsql.sql
</source>
</source>
−* Après avoir convertit le fichier, importer le sur votre base postgresql vierge:
+* After conversion of file, import it into your empty postgresql database:
<source lang="bash">
<source lang="bash">
−psql -h name_or_ip_of_postgresql_server -d name_database_postgresql -U login_database_mysql -f mysqldump_readyforpgsql.sql
+psql -h name_or_ip_of_postgresql_server -d name_database_postgresql -U login_database_mysql -f mysqldump_readyforpgsql.sql > /tmp/resimport.log
+</source>
+* Once import is finished, you must update all sequences to match imported data.
+<source lang="bash">
+psql -h name_or_ip_of_postgresql_server -d name_database_postgresql -U login_database_mysql
+# select rebuilt_sequences();
+CTRL+D
</source>
</source>