Empty file is returned when i am trying to export the PostgreSQL from phppgadmin











up vote
0
down vote

favorite












I am trying to deploy my application in Alibaba Cloud ECS instance. For that, I am trying to export my database structure and data from the phppgadmin pannel in my dev environment. I tried a couple of times it always gives me an empty file (0 bytes). So I decided to use Postgres dump to export the database but it gives me only DB structure. What I am missing? This is my first application with respect to PostgreSQL.



The Command I used to get the PostgreSQL dump is




pg_dump -U username dbname > dbexport.sql




Note: The above is the syntax i used to export the PostgreSQL after getting empty file via the control pannel.






sql postgresql alibaba-cloud alibaba-cloud-ecs







share|improve this question


























    up vote
    0
    down vote

    favorite












    I am trying to deploy my application in Alibaba Cloud ECS instance. For that, I am trying to export my database structure and data from the phppgadmin pannel in my dev environment. I tried a couple of times it always gives me an empty file (0 bytes). So I decided to use Postgres dump to export the database but it gives me only DB structure. What I am missing? This is my first application with respect to PostgreSQL.



    The Command I used to get the PostgreSQL dump is




    pg_dump -U username dbname > dbexport.sql




    Note: The above is the syntax i used to export the PostgreSQL after getting empty file via the control pannel.






    sql postgresql alibaba-cloud alibaba-cloud-ecs







    share|improve this question
























      up vote
      0
      down vote

      favorite









      up vote
      0
      down vote

      favorite











      I am trying to deploy my application in Alibaba Cloud ECS instance. For that, I am trying to export my database structure and data from the phppgadmin pannel in my dev environment. I tried a couple of times it always gives me an empty file (0 bytes). So I decided to use Postgres dump to export the database but it gives me only DB structure. What I am missing? This is my first application with respect to PostgreSQL.



      The Command I used to get the PostgreSQL dump is




      pg_dump -U username dbname > dbexport.sql




      Note: The above is the syntax i used to export the PostgreSQL after getting empty file via the control pannel.






      sql postgresql alibaba-cloud alibaba-cloud-ecs







      share|improve this question













      I am trying to deploy my application in Alibaba Cloud ECS instance. For that, I am trying to export my database structure and data from the phppgadmin pannel in my dev environment. I tried a couple of times it always gives me an empty file (0 bytes). So I decided to use Postgres dump to export the database but it gives me only DB structure. What I am missing? This is my first application with respect to PostgreSQL.



      The Command I used to get the PostgreSQL dump is




      pg_dump -U username dbname > dbexport.sql




      Note: The above is the syntax i used to export the PostgreSQL after getting empty file via the control pannel.






      sql postgresql alibaba-cloud alibaba-cloud-ecs




      sql postgresql alibaba-cloud alibaba-cloud-ecs






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 22 at 3:10









      Ranjith Udayakumar

      13811




      13811
























          1 Answer
          1






          active

          oldest

          votes

















          up vote
          0
          down vote



          accepted










          You can try below mentioned command line to export PostgreSQL Dump:



          ./pg_dump -U username -c -f /htdocs/dbexport.sql databasename





          share|improve this answer





















            Your Answer






            StackExchange.ifUsing("editor", function () {
            StackExchange.using("externalEditor", function () {
            StackExchange.using("snippets", function () {
            StackExchange.snippets.init();
            });
            });
            }, "code-snippets");

            StackExchange.ready(function() {
            var channelOptions = {
            tags: "".split(" "),
            id: "1"
            };
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function() {
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled) {
            StackExchange.using("snippets", function() {
            createEditor();
            });
            }
            else {
            createEditor();
            }
            });

            function createEditor() {
            StackExchange.prepareEditor({
            heartbeatType: 'answer',
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader: {
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            },
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            });


            }
            });














            draft saved

            draft discarded


















            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53423329%2fempty-file-is-returned-when-i-am-trying-to-export-the-postgresql-from-phppgadmin%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown

























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes








            up vote
            0
            down vote



            accepted










            You can try below mentioned command line to export PostgreSQL Dump:



            ./pg_dump -U username -c -f /htdocs/dbexport.sql databasename





            share|improve this answer

























              up vote
              0
              down vote



              accepted










              You can try below mentioned command line to export PostgreSQL Dump:



              ./pg_dump -U username -c -f /htdocs/dbexport.sql databasename





              share|improve this answer























                up vote
                0
                down vote



                accepted







                up vote
                0
                down vote



                accepted






                You can try below mentioned command line to export PostgreSQL Dump:



                ./pg_dump -U username -c -f /htdocs/dbexport.sql databasename





                share|improve this answer












                You can try below mentioned command line to export PostgreSQL Dump:



                ./pg_dump -U username -c -f /htdocs/dbexport.sql databasename






                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered 2 days ago









                Ashly Taylor

                3027




                3027






























                    draft saved

                    draft discarded




















































                    Thanks for contributing an answer to Stack Overflow!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid …



                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.


                    To learn more, see our tips on writing great answers.





                    Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


                    Please pay close attention to the following guidance:


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid …



                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.


                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function () {
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53423329%2fempty-file-is-returned-when-i-am-trying-to-export-the-postgresql-from-phppgadmin%23new-answer', 'question_page');
                    }
                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    -

                    Popular posts from this blog

                    Catalogne

                    Image
                    Pour les articles homonymes, voir Catalogne (homonymie). Ne doit pas être confondu avec Pays catalans. Cet article concerne un événement récent ou en cours. Ces informations peuvent manquer de recul, ne pas prendre en compte des développements récents ou changer à mesure que l’événement progresse. Le titre lui-même peut être provisoire. N’hésitez pas à l’améliorer en veillant à citer vos sources . La dernière modification de cette page a été faite le 30 décembre 2018 à 18:00. Catalogne Catalunya (ca) Catalonha (oc) Cataluña (es) .mw-parser-output .entete.map{background-image:url("//upload.wikimedia.org/wikipedia/commons/7/7a/Picto_infobox_map.png")} Armoiries Drapeau Administration Pays   Espagne Capitale Barcelone 41° 23′ N, 2° 11′ E Statut d'autonomie 9 septembre 1932 19 septembre 1979, modifié le 19 juin 2006 Sièges au Parlement 47 députés 24 (16 élus et 8 désignés) sénateurs Présiden...
                    Read more

                    Violoncelliste

                    Image
                    Cet article est une ébauche concernant un musicien. Vous pouvez partager vos connaissances en l’améliorant ( comment ? ) selon les recommandations des projets correspondants. Un violoncelliste jouant un air de tango dans une rue de Buenos Aires. En musique, un violoncelliste est un musicien instrumentiste jouant du violoncelle. Voir aussi | Catégorie:Violoncelliste Catégorie:Violoncelliste classique Portail de la musique Portail de la musique classique This page is only for reference, If you need detailed information, please check here
                    Read more

                    Héron pourpré

                    Image
                    .mw-parser-output h1 #sous_titre_h1{display:block;font-size:0.7em;line-height:1.3em;margin:0.2em 0 0.1em 0.5em} Ardea purpurea Ardea purpurea Ardea purpurea - Tarn Classification (COI) Règne Animalia Embranchement Chordata Sous-embr. Vertebrata Classe Aves Ordre Pelecaniformes Famille Ardeidae Genre Ardea Nom binominal Ardea purpurea Linnaeus, 1766 Répartition géographique     ////   zone de nidification     ////   résident permanent     ////   non nicheur Statut de conservation UICN LC  : Préoccupation mineure Le Héron pourpré ( Ardea purpurea Linnaeus, 1766) est une espèce d'oiseaux de la famille des Ardeidae. C'est un oiseau migrateur présent et nicheur en Europe et Afrique du Nord, hivernant occasionnellement en Europe de l'Ouest et du sud, protégé. Chants et appels Enregistrement 1 : Enregistrement 2 : Écouter le Héron pourpré sur xeno-canto Sommaire 1 Description...
                    Read more