A
A
Andrey2018-01-30 14:12:08
MySQL
Andrey, 2018-01-30 14:12:08

How to convert mysql database dump to postgresql?

There is a file dump.sql
It is intended for MySQL

MySQL dump 10.13  Distrib 5.7.20, for Win64 (x86_64)

DB encoded cp1251
Error during normal recovery psql databasename < /path/to/dump/dump.sqlis
ERROR:  invalid byte sequence for encoding "UTF8": 0xd3 0xc0

Need to convert it in such a way that it can be restored in postgresql?
Are there any plugins? or ways?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
R
Roman Frank, 2018-01-30
@Akellacom

https://habrahabr.ru/post/198366/
https://sysadmins.ws/viewtopic.php?f=31&t=699

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question