en:server:services:mariadb

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
en:server:services:mariadb [2022/10/24 08:24] – external edit 127.0.0.1en:server:services:mariadb [2023/02/14 21:42] (current) – [Check/update database] switched to mariadb-* instead of mysql* dan
Line 101: Line 101:
 ===== Backup database ===== ===== Backup database =====
  
-You can dump all databases with the following command ''mysqldump %%--%%single-transaction %%--%%flush-logs %%--%%master-data=2 %%--%%all-databases -u root -p | gzip > all_databases.sql.gz +You can dump all databases with the following command ''mysqldump -u root -p %%--%%all-databases | gzip > all_databases.sql.gz'' or just one single database ''mysqldump -u root -p --databases database_name | gzip > database_name.sql.gz''.
-''.+
  
 Or use the following script, which contains: Or use the following script, which contains:
Line 188: Line 187:
   - upgrade the package(s)   - upgrade the package(s)
   - restart the daemon   - restart the daemon
-  - run mysql_upgrade+  - run mariadb-upgrade
  
 <code> <code>
Line 195: Line 194:
  
 <code> <code>
-mysql_upgrade -u root -p+mariadb-upgrade -u root -p
 </code> </code>
  
 To check all tables in all databases:   To check all tables in all databases:  
 <code> <code>
-mysqlcheck --all-databases -u root -p -c+mariadb-check --all-databases -u root -p -c
 </code>   </code>  
  
 To analyze all tables in all databases:   To analyze all tables in all databases:  
 <code> <code>
-mysqlcheck --all-databases -u root -p -a+mariadb-check --all-databases -u root -p -a
 </code>   </code>  
  
 To repair all tables in all databases:   To repair all tables in all databases:  
 <code> <code>
-mysqlcheck --all-databases -u root -p -r+mariadb-check --all-databases -u root -p -r
 </code>  </code> 
    
 To optimize all tables in all databases:   To optimize all tables in all databases:  
 <code> <code>
-mysqlcheck --all-databases -u root -p -o+mariadb-check --all-databases -u root -p -o
 </code> </code>
  
Line 221: Line 220:
 <code> <code>
 systemctl restart mariadb.service systemctl restart mariadb.service
-mysql_upgrade -u root -p +mariadb-upgrade -u root -p 
-mysqlcheck --all-databases -u root -p -c +mariadb-check --all-databases -u root -p -c 
-mysqlcheck --all-databases -u root -p -a +mariadb-check --all-databases -u root -p -a 
-mysqlcheck --all-databases -u root -p -r +mariadb-check --all-databases -u root -p -r 
-mysqlcheck --all-databases -u root -p -o+mariadb-check --all-databases -u root -p -o
 </code> </code>
  • en/server/services/mariadb.txt
  • Last modified: 2023/02/14 21:42
  • by dan