champics/mysql2psql.yml at master · champagne-dev/champics · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
mysql:
 hostname: localhost
 port: 5432
 socket: /tmp/mysql.sock
 username: root
 password:
 database: champics

destination:
 # if file is given, output goes to file, else postgres
 file: champic_pg.sql
 postgres:
  hostname: ec2-54-204-5-56.compute-1.amazonaws.com
  port: 5432
  username: svnkdndkyustio
  password: DH2tnapsXH_lfIoP5OKcwNa-Lx
  database: drlskmr5frosk

# if tables is given, only the listed tables will be converted.  leave empty to convert all tables.
#tables:
#- table1
#- table2
# if exclude_tables is given, exclude the listed tables from the conversion.
#exclude_tables:
#- table3
#- table4


# if supress_data is true, only the schema definition will be exported/migrated, and not the data
supress_data: false

# if supress_ddl is true, only the data will be exported/imported, and not the schema
supress_ddl: false

# if force_truncate is true, forces a table truncate before table loading
force_truncate: false