How to create migration_version table in Mysql?










1














I use MySql and i dropped migration_versions table. Now command doctrine:migrations:migrate start to execute all migrations from the first one
How can i create and add all migrations to migration_versions?










share|improve this question





















  • I just manually added all migration numbers to migration_versions, but i'm curious is there command for such situations?
    – Dorian
    Nov 11 '18 at 19:32















1














I use MySql and i dropped migration_versions table. Now command doctrine:migrations:migrate start to execute all migrations from the first one
How can i create and add all migrations to migration_versions?










share|improve this question





















  • I just manually added all migration numbers to migration_versions, but i'm curious is there command for such situations?
    – Dorian
    Nov 11 '18 at 19:32













1












1








1







I use MySql and i dropped migration_versions table. Now command doctrine:migrations:migrate start to execute all migrations from the first one
How can i create and add all migrations to migration_versions?










share|improve this question













I use MySql and i dropped migration_versions table. Now command doctrine:migrations:migrate start to execute all migrations from the first one
How can i create and add all migrations to migration_versions?







mysql symfony






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Nov 11 '18 at 19:19









Dorian

87113




87113











  • I just manually added all migration numbers to migration_versions, but i'm curious is there command for such situations?
    – Dorian
    Nov 11 '18 at 19:32
















  • I just manually added all migration numbers to migration_versions, but i'm curious is there command for such situations?
    – Dorian
    Nov 11 '18 at 19:32















I just manually added all migration numbers to migration_versions, but i'm curious is there command for such situations?
– Dorian
Nov 11 '18 at 19:32




I just manually added all migration numbers to migration_versions, but i'm curious is there command for such situations?
– Dorian
Nov 11 '18 at 19:32












2 Answers
2






active

oldest

votes


















3














Yes it can be done with this command according to the symfony docs:



 php bin/console doctrine:migrations:version --add --all


Source: https://symfony.com/doc/master/bundles/DoctrineMigrationsBundle/index.html#generating-migrations-automatically






share|improve this answer




























    1














    It's easy enough to add them manually (in the mysql console, or PHPMyAdmin), or there is also a console command, that will let you add/delete them all, or a range:



    bin/console doctrine:migrations:version --help



    Description: Manually add and delete migration versions from the
    version table.



    ...



    Help: The doctrine:migrations:version command allows you to manually
    add, delete or synchronize migration versions from the version table:



     bin/console doctrine:migrations:version YYYYMMDDHHMMSS --add


    If you want to delete a version you can use the --delete option:



     bin/console doctrine:migrations:version YYYYMMDDHHMMSS --delete


    If you want to synchronize by adding or deleting all migration
    versions available in the version table you can use the --all option:



     bin/console doctrine:migrations:version --add --all
    bin/console doctrine:migrations:version --delete --all


    If you want to synchronize by adding or deleting some range of
    migration versions available in the version table you can use the
    --range-from/--range-to option:



     bin/console doctrine:migrations:version --add --range-from=YYYYMMDDHHMMSS --range-to=YYYYMMDDHHMMSS
    bin/console doctrine:migrations:version --delete --range-from=YYYYMMDDHHMMSS --range-to=YYYYMMDDHHMMSS


    You can also execute this command without a warning message which
    you need to interact with:



     bin/console doctrine:migrations:version --no-interaction






    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',
      autoActivateHeartbeat: false,
      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%2f53252298%2fhow-to-create-migration-version-table-in-mysql%23new-answer', 'question_page');

      );

      Post as a guest















      Required, but never shown

























      2 Answers
      2






      active

      oldest

      votes








      2 Answers
      2






      active

      oldest

      votes









      active

      oldest

      votes






      active

      oldest

      votes









      3














      Yes it can be done with this command according to the symfony docs:



       php bin/console doctrine:migrations:version --add --all


      Source: https://symfony.com/doc/master/bundles/DoctrineMigrationsBundle/index.html#generating-migrations-automatically






      share|improve this answer

























        3














        Yes it can be done with this command according to the symfony docs:



         php bin/console doctrine:migrations:version --add --all


        Source: https://symfony.com/doc/master/bundles/DoctrineMigrationsBundle/index.html#generating-migrations-automatically






        share|improve this answer























          3












          3








          3






          Yes it can be done with this command according to the symfony docs:



           php bin/console doctrine:migrations:version --add --all


          Source: https://symfony.com/doc/master/bundles/DoctrineMigrationsBundle/index.html#generating-migrations-automatically






          share|improve this answer












          Yes it can be done with this command according to the symfony docs:



           php bin/console doctrine:migrations:version --add --all


          Source: https://symfony.com/doc/master/bundles/DoctrineMigrationsBundle/index.html#generating-migrations-automatically







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Nov 11 '18 at 19:45









          benvdh

          8016




          8016























              1














              It's easy enough to add them manually (in the mysql console, or PHPMyAdmin), or there is also a console command, that will let you add/delete them all, or a range:



              bin/console doctrine:migrations:version --help



              Description: Manually add and delete migration versions from the
              version table.



              ...



              Help: The doctrine:migrations:version command allows you to manually
              add, delete or synchronize migration versions from the version table:



               bin/console doctrine:migrations:version YYYYMMDDHHMMSS --add


              If you want to delete a version you can use the --delete option:



               bin/console doctrine:migrations:version YYYYMMDDHHMMSS --delete


              If you want to synchronize by adding or deleting all migration
              versions available in the version table you can use the --all option:



               bin/console doctrine:migrations:version --add --all
              bin/console doctrine:migrations:version --delete --all


              If you want to synchronize by adding or deleting some range of
              migration versions available in the version table you can use the
              --range-from/--range-to option:



               bin/console doctrine:migrations:version --add --range-from=YYYYMMDDHHMMSS --range-to=YYYYMMDDHHMMSS
              bin/console doctrine:migrations:version --delete --range-from=YYYYMMDDHHMMSS --range-to=YYYYMMDDHHMMSS


              You can also execute this command without a warning message which
              you need to interact with:



               bin/console doctrine:migrations:version --no-interaction






              share|improve this answer

























                1














                It's easy enough to add them manually (in the mysql console, or PHPMyAdmin), or there is also a console command, that will let you add/delete them all, or a range:



                bin/console doctrine:migrations:version --help



                Description: Manually add and delete migration versions from the
                version table.



                ...



                Help: The doctrine:migrations:version command allows you to manually
                add, delete or synchronize migration versions from the version table:



                 bin/console doctrine:migrations:version YYYYMMDDHHMMSS --add


                If you want to delete a version you can use the --delete option:



                 bin/console doctrine:migrations:version YYYYMMDDHHMMSS --delete


                If you want to synchronize by adding or deleting all migration
                versions available in the version table you can use the --all option:



                 bin/console doctrine:migrations:version --add --all
                bin/console doctrine:migrations:version --delete --all


                If you want to synchronize by adding or deleting some range of
                migration versions available in the version table you can use the
                --range-from/--range-to option:



                 bin/console doctrine:migrations:version --add --range-from=YYYYMMDDHHMMSS --range-to=YYYYMMDDHHMMSS
                bin/console doctrine:migrations:version --delete --range-from=YYYYMMDDHHMMSS --range-to=YYYYMMDDHHMMSS


                You can also execute this command without a warning message which
                you need to interact with:



                 bin/console doctrine:migrations:version --no-interaction






                share|improve this answer























                  1












                  1








                  1






                  It's easy enough to add them manually (in the mysql console, or PHPMyAdmin), or there is also a console command, that will let you add/delete them all, or a range:



                  bin/console doctrine:migrations:version --help



                  Description: Manually add and delete migration versions from the
                  version table.



                  ...



                  Help: The doctrine:migrations:version command allows you to manually
                  add, delete or synchronize migration versions from the version table:



                   bin/console doctrine:migrations:version YYYYMMDDHHMMSS --add


                  If you want to delete a version you can use the --delete option:



                   bin/console doctrine:migrations:version YYYYMMDDHHMMSS --delete


                  If you want to synchronize by adding or deleting all migration
                  versions available in the version table you can use the --all option:



                   bin/console doctrine:migrations:version --add --all
                  bin/console doctrine:migrations:version --delete --all


                  If you want to synchronize by adding or deleting some range of
                  migration versions available in the version table you can use the
                  --range-from/--range-to option:



                   bin/console doctrine:migrations:version --add --range-from=YYYYMMDDHHMMSS --range-to=YYYYMMDDHHMMSS
                  bin/console doctrine:migrations:version --delete --range-from=YYYYMMDDHHMMSS --range-to=YYYYMMDDHHMMSS


                  You can also execute this command without a warning message which
                  you need to interact with:



                   bin/console doctrine:migrations:version --no-interaction






                  share|improve this answer












                  It's easy enough to add them manually (in the mysql console, or PHPMyAdmin), or there is also a console command, that will let you add/delete them all, or a range:



                  bin/console doctrine:migrations:version --help



                  Description: Manually add and delete migration versions from the
                  version table.



                  ...



                  Help: The doctrine:migrations:version command allows you to manually
                  add, delete or synchronize migration versions from the version table:



                   bin/console doctrine:migrations:version YYYYMMDDHHMMSS --add


                  If you want to delete a version you can use the --delete option:



                   bin/console doctrine:migrations:version YYYYMMDDHHMMSS --delete


                  If you want to synchronize by adding or deleting all migration
                  versions available in the version table you can use the --all option:



                   bin/console doctrine:migrations:version --add --all
                  bin/console doctrine:migrations:version --delete --all


                  If you want to synchronize by adding or deleting some range of
                  migration versions available in the version table you can use the
                  --range-from/--range-to option:



                   bin/console doctrine:migrations:version --add --range-from=YYYYMMDDHHMMSS --range-to=YYYYMMDDHHMMSS
                  bin/console doctrine:migrations:version --delete --range-from=YYYYMMDDHHMMSS --range-to=YYYYMMDDHHMMSS


                  You can also execute this command without a warning message which
                  you need to interact with:



                   bin/console doctrine:migrations:version --no-interaction







                  share|improve this answer












                  share|improve this answer



                  share|improve this answer










                  answered Nov 11 '18 at 19:43









                  Alister Bulman

                  25.4k55599




                  25.4k55599



























                      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%2f53252298%2fhow-to-create-migration-version-table-in-mysql%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

                      Use pre created SQLite database for Android project in kotlin

                      Darth Vader #20

                      Ondo