Wiki

User Tools

Site Tools

Trace: • install_mame • configure_ui • hello_world
computer_setup:mysql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision		Previous revision
computer_setup:mysql [2021/07/03 10:47] – created petercomputer_setup:mysql [2021/07/03 11:54] (current) – peter
Line 29: Line 29:
  
 select  ENGINE, TABLE_NAME,Round( DATA_LENGTH/1024/1024) as data_length , round(INDEX_LENGTH/1024/1024) as index_length, round(DATA_FREE/ 1024/1024) as data_free from information_schema.tables  where  DATA_FREE > 0; select  ENGINE, TABLE_NAME,Round( DATA_LENGTH/1024/1024) as data_length , round(INDEX_LENGTH/1024/1024) as index_length, round(DATA_FREE/ 1024/1024) as data_free from information_schema.tables  where  DATA_FREE > 0;
 +
 +./hist_to_mysql.sh 
 +
 +mysqldump -uroot -p --opt --routines --add-drop-database --default-character-set=utf8 --create-options --all-databases | bzip2 > db-20160611.bz2
 </code> </code>
computer_setup/mysql.1625309249.txt.gz · Last modified: 2021/07/03 10:47 by peter
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki