/docs/MyDocs

To get this branch, use:
bzr branch http://darksoft.org/webbzr/docs/MyDocs

« back to all changes in this revision

Viewing changes to Development/database/MySQL/recipes.txt

  • Committer: Suren A. Chilingaryan
  • Date: 2019-01-10 05:46:35 UTC
  • Revision ID: csa@suren.me-20190110054635-pk8r99f96cg0pzz7
Update on OpenShift/Gluster/MySQL, added OSInit

Show diffs side-by-side

added added

removed removed

Lines of Context:
Development/database/MySQL/recipes.txt
 
1
Queries
 
2
=======
1
3
 - Add \G (no space) to get table with huge amount of columns in horizontal format.
2
4
        SHOW SLAVE STATUS\G
3
5
        show global status\G
 
6
 
 
7
Encoding
 
8
========
 
9
 - recovering unicode double conversion in MySQL
 
10
    mysqldump --default-character-set=latin1 -u csa -p backup_hauptspektrometer
 
11
    cat dump.sql | mysql -u csa -p backup_hauptspektrometer
 
12
 
 
13