All columns of all views defined as “1” in phpmyadmin export

Putting a vertical line in each Histogram using GraphicsGrid

How can I prevent an oracle who can see into the past from knowing everything that has happened?

How unreachable are Jupiter's moons from Mars with the technology developed for going to Mars?

How can I handle players killing my NPC outside of combat?

Is the UK legally prevented from having another referendum on Brexit?

How can I put a period right after the algorithm's number in the algorithm's title?

How to deal with an underperforming subordinate?

Is it really OK to use "because of"?

How do I narratively explain how in-game circumstances do not mechanically allow a PC to instantly kill an NPC?

Taking an academic pseudonym?

Boss asked me to sign a resignation paper without a date on it along with my new contract

How to draw a node with two options using TikZ graphs in LaTeX

Do the speed limit reductions due to pollution also apply to electric cars in France?

Lubuntu 18.10 File Manager: How to view directory tree structure?

Was there a pre-determined arrangement for the division of Germany in case it surrendered before any Soviet forces entered its territory?

Why does a single AND gate need 60 transistors?

What's the reason that we have different quantities of days each month?

Is "accuse people to be racist" grammatical?

How do I add a strong "onion flavor" to the biryani (in restaurant style)?

Sing Baby Shark

Isn't a semicolon (';') needed after a function declaration in C++?

Do we still track damage on indestructible creatures?

Protagonist constantly has to have long words explained to her. Will this get tedious?

What can I do to encourage my players to use their consumables?



All columns of all views defined as “1” in phpmyadmin export














0















MySQL 5.7.24, phpmyadmin 4.8.3



phpMyAdmin appears to export corrupted definition on all views of one of my MySQL database. Eg:
show create view v_contacts returns



CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_contacts` AS select `d`.`rowseq` AS `rowseq`,`d`.`airline_rowseq` AS `airline_rowseq`,`a`.`name` AS `airline_name`,`c`.`name` AS `country_name`,`d`.`i_type` AS `i_type`,`ab`.`hint` AS `contact_type`,`d`.`i_index` AS `i_index`,`d`.`i_value` AS `i_value`,`d`.`updated` AS `updated` from (((`atdb6`.`directory` `d` join `atdb6`.`airline` `a`) join `atdb6`.`country` `c`) join `atdb6`.`abbreviations` `ab`) where ((`d`.`airline_rowseq` = `a`.`rowseq`) and (`a`.`country` = `c`.`rowseq`) and (`ab`.`type` = 'D') and (`d`.`i_type` = `ab`.`code`) and (`d`.`i_type` <> 'LG'))  utf8    utf8_general_ci


Exporting with phpMyAdmin generates a file which contains:



DROP TABLE IF EXISTS `v_contacts`;
/*!50001 DROP VIEW IF EXISTS `v_contacts`*/;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `v_contacts` AS SELECT
1 AS `rowseq`,
1 AS `airline_rowseq`,
1 AS `airline_name`,
1 AS `country_name`,
1 AS `i_type`,
1 AS `contact_type`,
1 AS `i_index`,
1 AS `i_value`,
1 AS `updated`*/;
SET character_set_client = @saved_cs_client;


and later in the export file, the correct definition:



/*!50001 DROP VIEW IF EXISTS `v_contacts`*/;
/*!50001 SET @saved_cs_client = @@character_set_client */;
/*!50001 SET @saved_cs_results = @@character_set_results */;
/*!50001 SET @saved_col_connection = @@collation_connection */;
/*!50001 SET character_set_client = utf8 */;
/*!50001 SET character_set_results = utf8 */;
/*!50001 SET collation_connection = utf8_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_contacts` AS select `d`.`rowseq` AS `rowseq`,`d`.`airline_rowseq` AS `airline_rowseq`,`a`.`name` AS `airline_name`,`c`.`name` AS `country_name`,`d`.`i_type` AS `i_type`,`ab`.`hint` AS `contact_type`,`d`.`i_index` AS `i_index`,`d`.`i_value` AS `i_value`,`d`.`updated` AS `updated` from (((`atdb6`.`directory` `d` join `atdb6`.`airline` `a`) join `atdb6`.`country` `c`) join `atdb6`.`abbreviations` `ab`) where ((`d`.`airline_rowseq` = `a`.`rowseq`) and (`a`.`country` = `c`.`rowseq`) and (`ab`.`type` = 'D') and (`d`.`i_type` = `ab`.`code`) and (`d`.`i_type` <> 'LG')) */;
/*!50001 SET character_set_client = @saved_cs_client */;
/*!50001 SET character_set_results = @saved_cs_results */;
/*!50001 SET collation_connection = @saved_col_connection */;


However only the first part is used when importing on another computer with phpMyAdmin 4.0.10.14, so all columns are set to 1.



Same for all views in the same database. Is this a bug, and no export file generated by phpMyAdmin 5.7 should be reused for import by phpMyAdmin 4.8 ?









share







New contributor




Alexandre Avrane is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

























    0















    MySQL 5.7.24, phpmyadmin 4.8.3



    phpMyAdmin appears to export corrupted definition on all views of one of my MySQL database. Eg:
    show create view v_contacts returns



    CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_contacts` AS select `d`.`rowseq` AS `rowseq`,`d`.`airline_rowseq` AS `airline_rowseq`,`a`.`name` AS `airline_name`,`c`.`name` AS `country_name`,`d`.`i_type` AS `i_type`,`ab`.`hint` AS `contact_type`,`d`.`i_index` AS `i_index`,`d`.`i_value` AS `i_value`,`d`.`updated` AS `updated` from (((`atdb6`.`directory` `d` join `atdb6`.`airline` `a`) join `atdb6`.`country` `c`) join `atdb6`.`abbreviations` `ab`) where ((`d`.`airline_rowseq` = `a`.`rowseq`) and (`a`.`country` = `c`.`rowseq`) and (`ab`.`type` = 'D') and (`d`.`i_type` = `ab`.`code`) and (`d`.`i_type` <> 'LG'))  utf8    utf8_general_ci


    Exporting with phpMyAdmin generates a file which contains:



    DROP TABLE IF EXISTS `v_contacts`;
    /*!50001 DROP VIEW IF EXISTS `v_contacts`*/;
    SET @saved_cs_client = @@character_set_client;
    SET character_set_client = utf8;
    /*!50001 CREATE VIEW `v_contacts` AS SELECT
    1 AS `rowseq`,
    1 AS `airline_rowseq`,
    1 AS `airline_name`,
    1 AS `country_name`,
    1 AS `i_type`,
    1 AS `contact_type`,
    1 AS `i_index`,
    1 AS `i_value`,
    1 AS `updated`*/;
    SET character_set_client = @saved_cs_client;


    and later in the export file, the correct definition:



    /*!50001 DROP VIEW IF EXISTS `v_contacts`*/;
    /*!50001 SET @saved_cs_client = @@character_set_client */;
    /*!50001 SET @saved_cs_results = @@character_set_results */;
    /*!50001 SET @saved_col_connection = @@collation_connection */;
    /*!50001 SET character_set_client = utf8 */;
    /*!50001 SET character_set_results = utf8 */;
    /*!50001 SET collation_connection = utf8_general_ci */;
    /*!50001 CREATE ALGORITHM=UNDEFINED */
    /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
    /*!50001 VIEW `v_contacts` AS select `d`.`rowseq` AS `rowseq`,`d`.`airline_rowseq` AS `airline_rowseq`,`a`.`name` AS `airline_name`,`c`.`name` AS `country_name`,`d`.`i_type` AS `i_type`,`ab`.`hint` AS `contact_type`,`d`.`i_index` AS `i_index`,`d`.`i_value` AS `i_value`,`d`.`updated` AS `updated` from (((`atdb6`.`directory` `d` join `atdb6`.`airline` `a`) join `atdb6`.`country` `c`) join `atdb6`.`abbreviations` `ab`) where ((`d`.`airline_rowseq` = `a`.`rowseq`) and (`a`.`country` = `c`.`rowseq`) and (`ab`.`type` = 'D') and (`d`.`i_type` = `ab`.`code`) and (`d`.`i_type` <> 'LG')) */;
    /*!50001 SET character_set_client = @saved_cs_client */;
    /*!50001 SET character_set_results = @saved_cs_results */;
    /*!50001 SET collation_connection = @saved_col_connection */;


    However only the first part is used when importing on another computer with phpMyAdmin 4.0.10.14, so all columns are set to 1.



    Same for all views in the same database. Is this a bug, and no export file generated by phpMyAdmin 5.7 should be reused for import by phpMyAdmin 4.8 ?









    share







    New contributor




    Alexandre Avrane is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.























      0












      0








      0








      MySQL 5.7.24, phpmyadmin 4.8.3



      phpMyAdmin appears to export corrupted definition on all views of one of my MySQL database. Eg:
      show create view v_contacts returns



      CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_contacts` AS select `d`.`rowseq` AS `rowseq`,`d`.`airline_rowseq` AS `airline_rowseq`,`a`.`name` AS `airline_name`,`c`.`name` AS `country_name`,`d`.`i_type` AS `i_type`,`ab`.`hint` AS `contact_type`,`d`.`i_index` AS `i_index`,`d`.`i_value` AS `i_value`,`d`.`updated` AS `updated` from (((`atdb6`.`directory` `d` join `atdb6`.`airline` `a`) join `atdb6`.`country` `c`) join `atdb6`.`abbreviations` `ab`) where ((`d`.`airline_rowseq` = `a`.`rowseq`) and (`a`.`country` = `c`.`rowseq`) and (`ab`.`type` = 'D') and (`d`.`i_type` = `ab`.`code`) and (`d`.`i_type` <> 'LG'))  utf8    utf8_general_ci


      Exporting with phpMyAdmin generates a file which contains:



      DROP TABLE IF EXISTS `v_contacts`;
      /*!50001 DROP VIEW IF EXISTS `v_contacts`*/;
      SET @saved_cs_client = @@character_set_client;
      SET character_set_client = utf8;
      /*!50001 CREATE VIEW `v_contacts` AS SELECT
      1 AS `rowseq`,
      1 AS `airline_rowseq`,
      1 AS `airline_name`,
      1 AS `country_name`,
      1 AS `i_type`,
      1 AS `contact_type`,
      1 AS `i_index`,
      1 AS `i_value`,
      1 AS `updated`*/;
      SET character_set_client = @saved_cs_client;


      and later in the export file, the correct definition:



      /*!50001 DROP VIEW IF EXISTS `v_contacts`*/;
      /*!50001 SET @saved_cs_client = @@character_set_client */;
      /*!50001 SET @saved_cs_results = @@character_set_results */;
      /*!50001 SET @saved_col_connection = @@collation_connection */;
      /*!50001 SET character_set_client = utf8 */;
      /*!50001 SET character_set_results = utf8 */;
      /*!50001 SET collation_connection = utf8_general_ci */;
      /*!50001 CREATE ALGORITHM=UNDEFINED */
      /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
      /*!50001 VIEW `v_contacts` AS select `d`.`rowseq` AS `rowseq`,`d`.`airline_rowseq` AS `airline_rowseq`,`a`.`name` AS `airline_name`,`c`.`name` AS `country_name`,`d`.`i_type` AS `i_type`,`ab`.`hint` AS `contact_type`,`d`.`i_index` AS `i_index`,`d`.`i_value` AS `i_value`,`d`.`updated` AS `updated` from (((`atdb6`.`directory` `d` join `atdb6`.`airline` `a`) join `atdb6`.`country` `c`) join `atdb6`.`abbreviations` `ab`) where ((`d`.`airline_rowseq` = `a`.`rowseq`) and (`a`.`country` = `c`.`rowseq`) and (`ab`.`type` = 'D') and (`d`.`i_type` = `ab`.`code`) and (`d`.`i_type` <> 'LG')) */;
      /*!50001 SET character_set_client = @saved_cs_client */;
      /*!50001 SET character_set_results = @saved_cs_results */;
      /*!50001 SET collation_connection = @saved_col_connection */;


      However only the first part is used when importing on another computer with phpMyAdmin 4.0.10.14, so all columns are set to 1.



      Same for all views in the same database. Is this a bug, and no export file generated by phpMyAdmin 5.7 should be reused for import by phpMyAdmin 4.8 ?









      share







      New contributor




      Alexandre Avrane is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.












      MySQL 5.7.24, phpmyadmin 4.8.3



      phpMyAdmin appears to export corrupted definition on all views of one of my MySQL database. Eg:
      show create view v_contacts returns



      CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_contacts` AS select `d`.`rowseq` AS `rowseq`,`d`.`airline_rowseq` AS `airline_rowseq`,`a`.`name` AS `airline_name`,`c`.`name` AS `country_name`,`d`.`i_type` AS `i_type`,`ab`.`hint` AS `contact_type`,`d`.`i_index` AS `i_index`,`d`.`i_value` AS `i_value`,`d`.`updated` AS `updated` from (((`atdb6`.`directory` `d` join `atdb6`.`airline` `a`) join `atdb6`.`country` `c`) join `atdb6`.`abbreviations` `ab`) where ((`d`.`airline_rowseq` = `a`.`rowseq`) and (`a`.`country` = `c`.`rowseq`) and (`ab`.`type` = 'D') and (`d`.`i_type` = `ab`.`code`) and (`d`.`i_type` <> 'LG'))  utf8    utf8_general_ci


      Exporting with phpMyAdmin generates a file which contains:



      DROP TABLE IF EXISTS `v_contacts`;
      /*!50001 DROP VIEW IF EXISTS `v_contacts`*/;
      SET @saved_cs_client = @@character_set_client;
      SET character_set_client = utf8;
      /*!50001 CREATE VIEW `v_contacts` AS SELECT
      1 AS `rowseq`,
      1 AS `airline_rowseq`,
      1 AS `airline_name`,
      1 AS `country_name`,
      1 AS `i_type`,
      1 AS `contact_type`,
      1 AS `i_index`,
      1 AS `i_value`,
      1 AS `updated`*/;
      SET character_set_client = @saved_cs_client;


      and later in the export file, the correct definition:



      /*!50001 DROP VIEW IF EXISTS `v_contacts`*/;
      /*!50001 SET @saved_cs_client = @@character_set_client */;
      /*!50001 SET @saved_cs_results = @@character_set_results */;
      /*!50001 SET @saved_col_connection = @@collation_connection */;
      /*!50001 SET character_set_client = utf8 */;
      /*!50001 SET character_set_results = utf8 */;
      /*!50001 SET collation_connection = utf8_general_ci */;
      /*!50001 CREATE ALGORITHM=UNDEFINED */
      /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
      /*!50001 VIEW `v_contacts` AS select `d`.`rowseq` AS `rowseq`,`d`.`airline_rowseq` AS `airline_rowseq`,`a`.`name` AS `airline_name`,`c`.`name` AS `country_name`,`d`.`i_type` AS `i_type`,`ab`.`hint` AS `contact_type`,`d`.`i_index` AS `i_index`,`d`.`i_value` AS `i_value`,`d`.`updated` AS `updated` from (((`atdb6`.`directory` `d` join `atdb6`.`airline` `a`) join `atdb6`.`country` `c`) join `atdb6`.`abbreviations` `ab`) where ((`d`.`airline_rowseq` = `a`.`rowseq`) and (`a`.`country` = `c`.`rowseq`) and (`ab`.`type` = 'D') and (`d`.`i_type` = `ab`.`code`) and (`d`.`i_type` <> 'LG')) */;
      /*!50001 SET character_set_client = @saved_cs_client */;
      /*!50001 SET character_set_results = @saved_cs_results */;
      /*!50001 SET collation_connection = @saved_col_connection */;


      However only the first part is used when importing on another computer with phpMyAdmin 4.0.10.14, so all columns are set to 1.



      Same for all views in the same database. Is this a bug, and no export file generated by phpMyAdmin 5.7 should be reused for import by phpMyAdmin 4.8 ?







      phpmyadmin export catalog-views





      share







      New contributor




      Alexandre Avrane is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.










      share







      New contributor




      Alexandre Avrane is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.








      share



      share






      New contributor




      Alexandre Avrane is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      asked 1 min ago









      Alexandre AvraneAlexandre Avrane

      1




      1




      New contributor




      Alexandre Avrane is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





      New contributor





      Alexandre Avrane is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






      Alexandre Avrane is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






















          0






          active

          oldest

          votes











          Your Answer








          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "182"
          };
          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',
          autoActivateHeartbeat: false,
          convertImagesToLinks: false,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          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
          });


          }
          });






          Alexandre Avrane is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230600%2fall-columns-of-all-views-defined-as-1-in-phpmyadmin-export%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes








          Alexandre Avrane is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          Alexandre Avrane is a new contributor. Be nice, and check out our Code of Conduct.













          Alexandre Avrane is a new contributor. Be nice, and check out our Code of Conduct.












          Alexandre Avrane is a new contributor. Be nice, and check out our Code of Conduct.
















          Thanks for contributing an answer to Database Administrators Stack Exchange!


          • 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%2fdba.stackexchange.com%2fquestions%2f230600%2fall-columns-of-all-views-defined-as-1-in-phpmyadmin-export%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

          Szabolcs (Ungheria) Altri progetti | Menu di navigazione48°10′14.56″N 21°29′33.14″E /...

          Discografia di Klaus Schulze Indice Album in studio | Album dal vivo | Singoli | Antologie | Colonne...

          How to make inet_server_addr() return localhost in spite of ::1/128RETURN NEXT in Postgres FunctionConnect to...