Restore MySQL database from postgresql dump file.

I have postgresql database and prefer to use MySQL to work on the same data.
Can I just dump postgresql data using pg_dump and restore in to MySQL?
Since I'm very new to MySQL, and I think, it shouldn't have been that hard, is it?
Any advice would be very appriciated, thank you very much in advance.
busakornAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

UmeshMySQL Principle Technical Support EngineerCommented:
0
busakornAuthor Commented:
Thanks ushastry.
When I used "database workbench" to connect to my server, it said XXX.XXX.XXX.XXX (my machine) is not allowed to connect to this MySQL server.
And that was why I couldn't do anything else, such as convert postgresql dump to mysql file.
Any more idea?
0
UmeshMySQL Principle Technical Support EngineerCommented:
hI,

[TAKEN FROM net]

The MySQL privilege system ensures that all users may perform only the operations allowed to them. As a user, when you connect to a MySQL server, your identity is determined by the host from which you connect and the username you specify. The system grants privileges according to your identity and what you want to do.

Can you tell me few things here.. like OS, are you running mysql server on local host or some other server? have you created any user accounts in the mysql server etc..
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

busakornAuthor Commented:
Thanks,
I'm running MySQL on Linux server and I'll try to connect to it on Windows XP client.
I've created one user on MySQL other than connecting to the dababase as root.
Well, when I granted user to the database, I can register the server, now.
Sorry, I connected as root at first, and now I can connect to it as user.
Well, when I tried to use schema migration, in the Select source schema,
there is no postgresql to select, so I just tried on selecting MySQL, then select server and database.
then I also select MySQL as target schema, (I just tried). The error occured, it said
"select command denied to user xxx@xxx.xxx.xxx.xxx for table 'func'"
Is it because I selected the same thing as source and target?
If so, what should I do? There is no postgresql for me to select.
0
busakornAuthor Commented:
BTW, is there any ways to list the tables name in MySQL?
0
UmeshMySQL Principle Technical Support EngineerCommented:
use this sql command..

SHOW TABLES;

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
busakornAuthor Commented:
Thanks, I have them shown now.
But what about converting file? Is there any ways to convert postgresql file to MySQL?
0
busakornAuthor Commented:
I've had it done now, by perl.
Thank you very much, ushastry, for your kind assistance.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.