I'm trying to get migrate data from a postgre db into mysql (mariaDB) and was wondering if it is possible to restore a db in mysql from a pgsql dump?
I have regular backups of my mysql server.For convenience I set it up as a single Mysql nightly dump. Now I need to restore one of the databases from the dump.
How do I restore a single database from the whole Mysql dump? It is a pretty big file as well. It is about 800mb.
I am on Debian Wheezy 32bit
can we convert postgreSql dump file into mysql dump through commadline
i tried but **i get syntax error.**
if there is any way to resolve my problem please suggest me.
thanks in advance...
cd "C:\Program Files\MySQL\bin"
mysql -u root -proot
i run this batch file
after i put this