Create an account

Very important

  • To access the important data of the forums, you must be active in each forum and especially in the leaks and database leaks section, send data and after sending the data and activity, data and important content will be opened and visible for you.
  • You will only see chat messages from people who are at or below your level.
  • More than 500,000 database leaks and millions of account leaks are waiting for you, so access and view with more activity.
  • Many important data are inactive and inaccessible for you, so open them with activity. (This will be done automatically)

0Day Forums Coding Database PostgreSQL Migrate database from Postgres to MySQL

Thread Rating:
  • 784 Vote(s) - 3.46 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Options
Migrate database from Postgres to MySQL

Offline dum193811


Valued member
***
Valued member
Posts: 1
Threads: 1
Joined: May 2023
Reputation: 0
Level: 1 [Level]
Total Points: 0
Rank 0 / 1
99% to upload Level
Rank
Activity 0 / 1
99% to upload your Rank
Activity
Experience 1
99% to upload Experience
Experience

Points: 50
#1
07-30-2023, 02:01 PM
I have changed database from [tag:PostgreSQL] to [tag:MySQL], but I don't know how to transfer data from one to other.

Does anyone know any command by which I can copy/migrate my database from [tag:PostgreSQL] to [tag:MySQL]?
Reply

Offline farrahfarrand898


Member
*
Member
Posts: 0
Threads: 0
Joined: Sep 2018
Reputation: 0
Level: inf [Level]
Total Points: inf
Rank nan / 1
100% to upload Level
Rank
Activity inf / 1
99% to upload your Rank
Activity
Experience nan
100% to upload Experience
Experience

Points: 50
#2
07-30-2023, 02:04 PM
You can use the [MySQL Workbench](

[To see links please register here]

) which can import from a variety of database types, including Postgres.
Reply

Offline reversfc


Valued member
***
Valued member
Posts: 0
Threads: 0
Joined: Jul 2017
Reputation: 0
Level: inf [Level]
Total Points: inf
Rank nan / 1
100% to upload Level
Rank
Activity inf / 1
99% to upload your Rank
Activity
Experience nan
100% to upload Experience
Experience

Points: 50
#3
07-30-2023, 02:19 PM
Faced the problem a few years ago, and used **[pg2mysql][1]**

**EDIT 21 july 2019** : **[this fork][2]** seems a better option (patches, light maintenance)

[1]:

[To see links please register here]

[2]:

[To see links please register here]

Reply

Offline orsoladtktrikyqs


Member
*
Member
Posts: 0
Threads: 0
Joined: Dec 2018
Reputation: 0
Level: inf [Level]
Total Points: inf
Rank nan / 1
100% to upload Level
Rank
Activity inf / 1
99% to upload your Rank
Activity
Experience nan
100% to upload Experience
Experience

Points: 50
#4
07-30-2023, 02:25 PM
[Dbeaver][1] is the perfect solution for painless migration, column to column mapping, character encoding and also open source.


[1]:

[To see links please register here]

Reply

« Next Oldest
Next Newest »


Forum Jump:


Users browsing this thread:
1 Guest(s)

©0Day  2016 - 2023 | All Rights Reserved.  Made with    for the community. Connected through