Comments (3)
Try to replace localhost with an actual ip (127.0.0.1).
Please, let me know if it helped.
from frommysqltopostgresql.
Hi Pathikrit!
I think there is a problem with one of "connection strings".
Could you send me the config file you used?
from frommysqltopostgresql.
This is the config file:
{
"source_description" : [
"Connection string to your MySql database",
"Please ensure, that you have defined your connection string properly.",
"Ensure, that details like 'charset=UTF8' are included in your connection string (if necessary)."
],
"source" : "mysql:host=localhost;port=3306;charset=UTF8;dbname=main,dev,dev",
"target_description" : [
"Connection string to your PostgreSql database",
"Please ensure, that you have defined your connection string properly.",
"Ensure, that details like options='[double dash]client_encoding=UTF8' are included in your connection string (if necessary)."
],
"target" : "pgsql:host=localhost;port=5432;dbname=main;options=--client_encoding=UTF8,dev,dev",
"encoding_description" : [
"PHP encoding type.",
"If not supplied, then UTF-8 will be used as a default."
],
"encoding" : "UTF-8",
"schema_description" : [
"schema - a name of the schema, that will contain all migrated tables.",
"If not supplied, then a new schema will be created automatically."
],
"schema" : "",
"data_chunk_size_description" : [
"During migration each table's data will be split into chunks of data_chunk_size (in MB).",
"If not supplied, then 10 MB will be used as a default."
],
"data_chunk_size" : 10
}
Yes, the username and password for both mysql and postgres I have is dev
and dev
locally..
from frommysqltopostgresql.
Related Issues (20)
- extra data after last expected column HOT 6
- trouble with cyrrilic HOT 1
- SQLSTATE[42830]: Invalid foreign key: 7 ERROR: foreign key referenced-columns list must not contain duplicates HOT 3
- JSON column type HOT 3
- Foreign Keys and Table order HOT 4
- longblob type does not convert HOT 5
- Does it support migration from MySQL 4.1 HOT 4
- FromMySQLToPostgreSQL or NMIG? HOT 3
- Script is terminated HOT 4
- Script terminates without any error HOT 1
- boolean to bit variyng HOT 4
- Getting errors with json type HOT 2
- Clarification needed HOT 4
- 'not a sequence' issue HOT 1
- ERROR: operator does not exist: smallint = boolean HOT 1
- How to install PD_MYSQL, PDO_PGSQL, etc... ? HOT 2
- migration of views
- unusual setup HOT 5
- Indexes and Triggers not imported HOT 2
- Full text index is not supported
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from frommysqltopostgresql.