{"id":51235,"date":"2024-09-05T18:56:18","date_gmt":"2024-09-05T08:56:18","guid":{"rendered":"https:\/\/riscy.biz\/?p=51235"},"modified":"2024-09-08T17:11:14","modified_gmt":"2024-09-08T07:11:14","slug":"mariadb","status":"publish","type":"post","link":"https:\/\/riscy.biz\/index.php\/2024\/09\/05\/mariadb\/","title":{"rendered":"MariaDB"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Useful commands<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<pre class=\"wp-block-code\"><code><code>docker exec -it mariadb bash<\/code><\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code><code>create database DATABASE_NAME;<\/code><\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code><code>grant all privileges on DATABASE_NAME.* TO 'USER_NAME' identified by 'PASSWORD';<\/code><\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code><code>flush privileges;<\/code><\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><code>CREATE OR REPLACE TABLE table_name (a int);<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>docker exec mariadb mariadb-dump -uroot -ppassword --all-databases > \/mnt\/backup\/database\/mariadb-$(date +%Y-%m-%d).sql<\/code><br><br><\/p>\n<\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Useful commands CREATE OR REPLACE TABLE table_name (a int); docker exec mariadb mariadb-dump -uroot -ppassword &#8211;all-databases > \/mnt\/backup\/database\/mariadb-$(date +%Y-%m-%d).sql<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-51235","post","type-post","status-publish","format-standard","hentry","category-computers"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/riscy.biz\/index.php\/wp-json\/wp\/v2\/posts\/51235","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/riscy.biz\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/riscy.biz\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/riscy.biz\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/riscy.biz\/index.php\/wp-json\/wp\/v2\/comments?post=51235"}],"version-history":[{"count":0,"href":"https:\/\/riscy.biz\/index.php\/wp-json\/wp\/v2\/posts\/51235\/revisions"}],"wp:attachment":[{"href":"https:\/\/riscy.biz\/index.php\/wp-json\/wp\/v2\/media?parent=51235"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/riscy.biz\/index.php\/wp-json\/wp\/v2\/categories?post=51235"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/riscy.biz\/index.php\/wp-json\/wp\/v2\/tags?post=51235"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}