Skip to content

Instantly share code, notes, and snippets.

@jzzdog

jzzdog/MySql Tooltips.md

Last active October 19, 2021 07:05
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save jzzdog/2b1166455dee8556933d to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save jzzdog/2b1166455dee8556933d to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. jzzdog revised this gist Mar 5, 2015. 1 changed file with 0 additions and 1 deletion.
    1 change: 0 additions & 1 deletion MySql Tooltips.md
    View file
    Original file line number Diff line number Diff line change
    @@ -12,7 +12,6 @@ mysql> EXIT;
    #### Backup and restore
    ```cmd
    > mysqldump -u deploy -p[password] azcommunity_production > dump.sql
    > mysql -u deploy -p[password] azcommunity_production < community_dump.sql
    ```

  2. jzzdog revised this gist Mar 5, 2015. 1 changed file with 3 additions and 1 deletion.
    4 changes: 3 additions & 1 deletion MySql Tooltips.md
    View file
    Original file line number Diff line number Diff line change
    @@ -11,7 +11,9 @@ mysql> EXIT;

    #### Backup and restore
    ```cmd
    > mysqldump -u jzzdog -p azcommunity_production > dump.sql
    > mysqldump -u deploy -p[password] azcommunity_production > dump.sql
    > mysql -u deploy -p[password] azcommunity_production < community_dump.sql
    ```

    more info: http://habrahabr.ru/post/105954/
  3. jzzdog revised this gist Mar 5, 2015. 1 changed file with 3 additions and 1 deletion.
    4 changes: 3 additions & 1 deletion MySql Tooltips.md
    View file
    Original file line number Diff line number Diff line change
    @@ -12,4 +12,6 @@ mysql> EXIT;
    #### Backup and restore
    ```cmd
    > mysqldump -u jzzdog -p azcommunity_production > dump.sql
    ```
    ```

    more info: http://habrahabr.ru/post/105954/
  4. jzzdog revised this gist Mar 5, 2015. 1 changed file with 7 additions and 1 deletion.
    8 changes: 7 additions & 1 deletion MySql Tooltips.md
    View file
    Original file line number Diff line number Diff line change
    @@ -1,4 +1,4 @@
    ### Initial settings
    #### MySql Initial settings

    ```cmd
    $ mysql -u root -p
    @@ -7,3 +7,9 @@ mysql> GRANT ALL PRIVILEGES ON azcommunity_production.* TO 'deploy'@'localhost'
    IDENTIFIED BY 'deploy';
    mysql> EXIT;
    ```


    #### Backup and restore
    ```cmd
    > mysqldump -u jzzdog -p azcommunity_production > dump.sql
    ```
  5. jzzdog revised this gist Mar 4, 2015. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion MySql Tooltips.md
    View file
    Original file line number Diff line number Diff line change
    @@ -4,6 +4,6 @@
    $ mysql -u root -p
    mysql> CREATE DATABASE azcommunity_production DEFAULT CHARACTER SET utf8;
    mysql> GRANT ALL PRIVILEGES ON azcommunity_production.* TO 'deploy'@'localhost'
    IDENTIFIED BY 'deploy';
    IDENTIFIED BY 'deploy';
    mysql> EXIT;
    ```
  6. jzzdog revised this gist Mar 4, 2015. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion MySql Tooltips.md
    View file
    Original file line number Diff line number Diff line change
    @@ -4,6 +4,6 @@
    $ mysql -u root -p
    mysql> CREATE DATABASE azcommunity_production DEFAULT CHARACTER SET utf8;
    mysql> GRANT ALL PRIVILEGES ON azcommunity_production.* TO 'deploy'@'localhost'
    IDENTIFIED BY 'deploy';
    IDENTIFIED BY 'deploy';
    mysql> EXIT;
    ```
  7. jzzdog revised this gist Mar 4, 2015. 1 changed file with 2 additions and 1 deletion.
    3 changes: 2 additions & 1 deletion MySql Tooltips.md
    View file
    Original file line number Diff line number Diff line change
    @@ -3,6 +3,7 @@
    ```cmd
    $ mysql -u root -p
    mysql> CREATE DATABASE azcommunity_production DEFAULT CHARACTER SET utf8;
    mysql> GRANT ALL PRIVILEGES ON azcommunity_production.* TO 'deploy'@'localhost' IDENTIFIED BY 'deploy';
    mysql> GRANT ALL PRIVILEGES ON azcommunity_production.* TO 'deploy'@'localhost'
    IDENTIFIED BY 'deploy';
    mysql> EXIT;
    ```
  8. jzzdog revised this gist Mar 4, 2015. 1 changed file with 3 additions and 1 deletion.
    4 changes: 3 additions & 1 deletion MySql Tooltips.md
    View file
    Original file line number Diff line number Diff line change
    @@ -1,6 +1,8 @@
    ### Initial settings

    ```terminal
    ```cmd
    $ mysql -u root -p
    mysql> CREATE DATABASE azcommunity_production DEFAULT CHARACTER SET utf8;
    mysql> GRANT ALL PRIVILEGES ON azcommunity_production.* TO 'deploy'@'localhost' IDENTIFIED BY 'deploy';
    mysql> EXIT;
    ```
  9. jzzdog revised this gist Mar 4, 2015. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion MySql Tooltips.md
    View file
    Original file line number Diff line number Diff line change
    @@ -1,6 +1,6 @@
    ### Initial settings

    ```cmd
    ```terminal
    $ mysql -u root -p
    mysql> CREATE DATABASE azcommunity_production DEFAULT CHARACTER SET utf8;
    ```
  10. jzzdog revised this gist Mar 4, 2015. 1 changed file with 2 additions and 3 deletions.
    5 changes: 2 additions & 3 deletions MySql Tooltips.md
    View file
    Original file line number Diff line number Diff line change
    @@ -1,7 +1,6 @@
    ### Initial settings

    ```cmd
    $ mysql -u root
    }
    $ mysql -u root -p
    mysql> CREATE DATABASE azcommunity_production DEFAULT CHARACTER SET utf8;
    ```
  11. jzzdog revised this gist Mar 4, 2015. 1 changed file with 3 additions and 7 deletions.
    10 changes: 3 additions & 7 deletions MySql Tooltips.md
    View file
    Original file line number Diff line number Diff line change
    @@ -1,11 +1,7 @@
    I think you should use an
    `<addr>` element here instead.
    ### Initial settings

    ```cmd
    $ mysql -u root
    ```sql
    function fancyAlert(arg) {
    if(arg) {
    $.facebox({div:'#foo'})
    }
    }
    ```
  12. jzzdog revised this gist Mar 4, 2015. 1 changed file with 1 addition and 7 deletions.
    8 changes: 1 addition & 7 deletions MySql Tooltips.md
    View file
    Original file line number Diff line number Diff line change
    @@ -2,16 +2,10 @@ I think you should use an
    `<addr>` element here instead.


    ```
    ```sql
    function fancyAlert(arg) {
    if(arg) {
    $.facebox({div:'#foo'})
    }
    }
    ```

    function fancyAlert(arg) {
    if(arg) {
    $.facebox({div:'#foo'})
    }
    }
  13. jzzdog revised this gist Mar 4, 2015. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion MySql Tooltips.md
    View file
    Original file line number Diff line number Diff line change
    @@ -2,7 +2,7 @@ I think you should use an
    `<addr>` element here instead.


    ```javascript
    ```
    function fancyAlert(arg) {
    if(arg) {
    $.facebox({div:'#foo'})
  14. jzzdog renamed this gist Mar 4, 2015. 1 changed file with 7 additions and 1 deletion.
    8 changes: 7 additions & 1 deletion gistfile1.md → MySql Tooltips.md
    View file
    Original file line number Diff line number Diff line change
    @@ -8,4 +8,10 @@ function fancyAlert(arg) {
    $.facebox({div:'#foo'})
    }
    }
    ```
    ```

    function fancyAlert(arg) {
    if(arg) {
    $.facebox({div:'#foo'})
    }
    }
  15. jzzdog created this gist Mar 4, 2015.
    11 changes: 11 additions & 0 deletions gistfile1.md
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,11 @@
    I think you should use an
    `<addr>` element here instead.


    ```javascript
    function fancyAlert(arg) {
    if(arg) {
    $.facebox({div:'#foo'})
    }
    }
    ```