Activity

1. zhj-hx

   added

   enhancement

   on Aug 2, 2021
2. tianzhou commented on Aug 2, 2021

   

   tianzhou

   on Aug 2, 2021

   Member

   More actions

   Do you mean to (1) only backup the schema or (2) the data as well as the schema (like mysqldump) ?
3. zhj-hx commented on Aug 3, 2021

   

   zhj-hx

   on Aug 3, 2021

   Author

   More actions

   Do you mean to (1) only backup the schema or (2) the data as well as the schema (like mysqldump) ?

   I have added an instance, but I do not see the database information on the instance.If I add a database, I will be prompted that the database already exists.
4. tianzhou commented on Aug 3, 2021

   

   tianzhou

   on Aug 3, 2021

   Member

   More actions

   Do you mean to (1) only backup the schema or (2) the data as well as the schema (like mysqldump) ?

   I have added an instance, but I do not see the database information on the instance.If I add a database, I will be prompted that the database already exists.

   Sorry, I am a bit lost here as I couldn't see how it's related to the original "backup of sql change" question. Could you please elaborate a bit more?
5. zhj-hx commented on Aug 3, 2021

   

   zhj-hx

   on Aug 3, 2021

   Author

   More actions

   sorry,I confused the two issues. This issue wants to know how to facilitate rollback after database changes
6. tianzhou commented on Aug 3, 2021

   

   tianzhou

   on Aug 3, 2021

   Member

   More actions

   sorry,I confused the two issues. This issue wants to know how to facilitate rollback after database changes

   Do you mean to rollback the schema change like specifying a down "script" as opposed to "up" statement similar to ruby migration? https://edgeguides.rubyonrails.org/active_record_migrations.html ?

   If that's the case, we are planning to add this in couple weeks. Stay tuned.
7. tianzhou

   changed the title [-]backup of sql change[/-] [+]Support rollback of SQL schema change[/+] on Aug 9, 2021
8. tianzhou commented on Sep 3, 2021

   

   tianzhou

   on Sep 3, 2021

   Member

   More actions

   b124888

   Released in 0.4.1 https://github.com/bytebase/bytebase/releases/tag/0.4.1
9. tianzhou

   closed this as completedon Sep 3, 2021
10. vsai12

    added 4 commits that reference this issue on May 9, 2026

    refactor(advisor/tidb): extract index-family spine + fix TEXT regress…

    ...

    d12d74c

    refactor(advisor/tidb): apply dual-arm ATAddConstraint+ATAddIndex sib…

    ...

    bb7b011

    refactor(advisor/tidb): migrate index key-number + total-number pair …

    ...

    70b74f7

    refactor(advisor/tidb): migrate index_no_duplicate_column to omni AST…

    ...

    9a19edd