mysqlpostgresqlimportrestoredump
PostgreSQL: Database Import from MySQL dump - syntax error
I have a backup MySQL file, and I'm trying to import that to my PostgreSQL database.
/Users/bheng/Desktop/database_backups/2016-06-10-local.sql
I'm trying to do it via a command line:
psql -d db-local -U root -f ~/Desktop/database_backups/2016-06-10-local.sql
I kept getting
I even try to log in to Postgres and run this it import fine
\i /Users/bheng/Desktop/database_backups/2016-06-10-local.sql
but the same result happens.
Did I do something wrong ? How do I stop/prevent this ?
Solution
What worked for me was pgloader. It's very fast + open source under the PostgreSQL License.
The first detail at the top of the website actually mentions migrating from MySQL to PostgreSQL in one command. Good luck!
- How to return NULL when result is empty?
- Extract dirname from full path stored in database
- Using larger than or equal (>=) to in PreparedStatement in Java
- What is the difference between count(0), count(1).. and count(*) in mySQL/SQL?
- Convert a SELECT query containing two WHERE conditions to CodeIgniter's active record syntax
- How to find the minimum of a sum of values based on a distinct value?
- How to use 'and' with 'on' condition of joins in knex
- MYSQL Update query, replace part string containing URL
- CodeIgniter SELECT query to find rows with qualifying sets of column values in a JOINed table
- can we delete wp_woocommerce_sessions from database?
- NodeJS/mySQL - ER_ACCESS_DENIED_ERROR Access denied for user 'root'@'localhost' (using password: YES)
- Fast page retrieval in MySQL, index usage?
- MySQL Not Equal To Certain Length
- Problem connecting springboot to mysql with docker-compose
- Laravel Paginate with OrderByRaw return different order
- How to update a database using a loop?
- mysql2 Segmentation fault at 0x0000000000000000
- Retrieve query results as dict in SQLAlchemy
- How to do paging of pictures in PHP
- How to make a relation between two tables without foreign key
- How to pass password from file to mysql command?
- SQL - Columns merge and grouping by column name while summation of the other column
- A hackerrank sql challenge
- MySql Leap Years
- how to prevent mysql from createing mysql-bin.00000x files?
- Data truncation: Data too long for column 'logo' at row 1
- Count number of query results in a CodeIgniter application
- Convert raw MySQL containing a JOIN on identical column names and a WHERE and ORDER BY clause to CodeIgniter active record
- How to create MySQL function to update database if a value reaches 800?
- Delphi XE5 FireDAC Error: Cannot load vendor library [libmysql.dll or libmysqld.dll]