Postgres Phppgadmin problem – empty SQL dump after export
In this post we will give you information about Postgres Phppgadmin problem – empty SQL dump after export. Hear we will give you detail about Postgres Phppgadmin problem – empty SQL dump after exportAnd how to use it also give you demo for it if it is necessary.
In this post, You will get the solution of empty SQL dump after the export database from phppgadmin.
I had also faced this issue while I was working with PostgreSQL and that time I was confused that for what reason it’s dumping out the empty SQL file even database was not empty.
With the help of Google, I find the solution that I am going to share.
Working with Postgres 9.5, the ‘-i’ option that means ignoring the version differences is causing an error, since it has been removed.
This option was deprecated from the Postgres 8.4 but it is removed from the version 9.5
To resolve this issue, i will have to modify our dbexport.php that you can see in /usr/share/phppgadmin directory on ubuntu and in window you will find in htdocs/phpPgAdmin folder.
Change the line from :
$cmd = $exe . " -i";
To
$cmd = $exe;
And then change –
passthru($cmd);
To
echo passthru($cmd);
Now save this file and export the database from Phppgadmin.
Hope this code and post will helped you for implement Postgres Phppgadmin problem – empty SQL dump after export. if you need any help or any feedback give it in comment section or you have good idea about this post you can give it comment section. Your comment will help us for help you more and improve us. we will give you this type of more interesting post in featured also so, For more interesting post and code Keep reading our blogs