{"id":805,"date":"2017-11-07T11:26:06","date_gmt":"2017-11-07T20:26:06","guid":{"rendered":"\/blog\/?p=805"},"modified":"2023-09-21T09:37:42","modified_gmt":"2023-09-21T00:37:42","slug":"curl%ec%9d%84-%ec%9d%b4%ec%9a%a9%ed%95%9c-phpmyadmin-%ec%9b%90%ea%b2%a9-%eb%b0%b1%ec%97%85-%ec%8a%a4%ed%81%ac%eb%a6%bd%ed%8a%b8","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=805","title":{"rendered":"curl\uc744 \uc774\uc6a9\ud55c phpMyAdmin \uc6d0\uaca9 \ubc31\uc5c5 \uc2a4\ud06c\ub9bd\ud2b8"},"content":{"rendered":"\n
#! \/bin\/bash<\/span>\n\n#set -x<\/span>\n\n# This program is free software published under the terms of the GNU GPL.<\/span>\n#<\/span>\n# Forked: http:\/\/picoforge.int-evry.fr\/websvn\/filedetails.php?repname=curlmyback&path=%2Ftrunk%2Fcurl-backup-phpmyadmin.sh&rev=0&sc=1<\/span>\n# (C) Institut TELECOM + Olivier Berger <olivier.berger@it-sudparis.eu> 2007-2009<\/span>\n# $Id: curl-backup-phpmyadmin.sh 12 2011-12-12 16:02:44Z berger_o $<\/span>\n\n# Clean up and add parameter handling by Artem Grebenkin<\/span>\n# <speechkey@gmail.com> http:\/\/www.irepository.net<\/span>\n#<\/span>\n# This saves dumps of your Database using CURL and connecting to<\/span>\n# phpMyAdmin (via HTTPS), keeping the 10 latest backups by default<\/span>\n#<\/span>\n# Tested on phpMyAdmin 3.4.5<\/span>\n#<\/span>\n# For those interested in debugging\/adapting this script, the firefox<\/span>\n# add-on LiveHttpHeaders is a very interesting extension to debug HTTP<\/span>\n# transactions and guess what's needed to develop such a CURL-based<\/span>\n# script.<\/span>\n#<\/span>\n# Arguments: mysql-export.sh [-h|--help] [--stdout] [--tables=<table_name>,<table_name>] [--add-drop] [--apache-user=<apache_http_user>] [--apache-password=<apache_http_password>] [--phpmyadmin-user=<phpmyadmin_user>] [--phpmyadmin-password=<phpmyadmin_password>] [--database=<database>] [--host=<phpmyadmin_host>] [--use-keychain]<\/span>\n# -h, --help: Print help<\/span>\n#   --stdout: Write SQL (gzipped) in stdout<\/span>\n# --tables: Export only particular tables<\/span>\n# --add-drop: add DROP TABLE IF EXISTS to every exporting table<\/span>\n# --apache-user=<apache_http_user>: Apache HTTP autorization user<\/span>\n# --apache-password=<apache_http_password>: Apache HTTP autorization password or keychain entry name if --use-keychain<\/span>\n# --phpmyadmin-user=<phpmyadmin_user>: PhpMyAdmin user<\/span>\n# --phpmyadmin-password=<phpmyadmin_password>: PhpMyAdmin password or keychain entry name if --use-keychain<\/span>\n# --database=<database>: Database to be exported<\/span>\n# --host=<phpmyadmin_host>: PhpMyAdmin host<\/span>\n# --use-keychain: Use Mac OS X keychain to get passwords from. In that case --apache-password and --phpmyadmin-password will be used as account name for search in Mac Os X keychain.<\/span>\n#<\/span>\n# Common uses: mysql-export.sh --tables=hotel_content_provider --add-drop --database=hs --stdout --use-keychain --apache-user=betatester --phpmyadmin-user=hs --apache-password=www.example.com\\ \\(me\\) --phpmyadmin-password=phpmyadmin.example.com --host=https:\/\/www.example.com\/phpmyadmin | gunzip | mysql -u root -p testtable<\/span>\n#        exports and imports on the fly in local db<\/span>\n\n# Please adapt these values :<\/span>\n\nAPACHE_USER=0\nAPACHE_PASSWD=0\n\nPHPMYADMIN_USER=0\nPHPMYADMIN_PASSWD=0\n\nREMOTE_HOST=0\nDATABASE=0\nCOMPRESSION=on\nADD_DROP=1\nTMP_FOLDER=\"\/tmp\"<\/span>\nUSE_KEYCHAIN=0\n\n# End of customisations<\/span>\n\nstdin=0\nexport_tables=0\nadd_drop=0\n\nfor<\/span> arg<\/span> in<\/span> $@<\/span>\ndo<\/span>\n  if<\/span> [ $arg<\/span> == '-h'<\/span> ] |<\/span>|<\/span> [ $arg<\/span> == '--help'<\/span> ]\n  then<\/span>\n    cat <<\/span><<\/span> EOF\nArguments: mysql-export.sh [-h|<\/span>--help] [--stdout] [--tables=<<\/span>table_name><\/span>,<<\/span>table_name><\/span>] [--add-drop] [--apache-user=<<\/span>apache_http_user><\/span>] [--apache-password=<<\/span>apache_http_password><\/span>] [--phpmyadmin-user=<<\/span>phpmyadmin_user><\/span>] [--phpmyadmin-password=<<\/span>phpmyadmin_password><\/span>] [--database=<<\/span>database><\/span>] [--host=<<\/span>phpmyadmin_host><\/span>] [--use-keychain]\n       -h, --help: Print help<\/span>\n       --stdout: Write SQL (gzipped) in<\/span> stdout\n       --tables: Export only particular tables\n       --add-drop: add DROP TABLE IF EXISTS to every exporting table\n       --apache-user=<<\/span>apache_http_user><\/span>: Apache HTTP autorization user\n       --apache-password=<<\/span>apache_http_password><\/span>: Apache HTTP autorization password or keychain entry name if<\/span> --use-keychain\n       --phpmyadmin-user=<<\/span>phpmyadmin_user><\/span>: PhpMyAdmin user\n       --phpmyadmin-password=<<\/span>phpmyadmin_password><\/span>: PhpMyAdmin password or keychain entry name if<\/span> --use-keychain\n       --database=<<\/span>database><\/span>: Database to be exported\n       --host=<<\/span>phpmyadmin_host><\/span>: PhpMyAdmin host\n       --use-keychain: Use Mac OS X keychain to get passwords from. In that case<\/span> --apache-password and --phpmyadmin-password will be used as account name for<\/span> search<\/span> in<\/span> Mac Os X keychain.\n\n Common uses: mysql-export.sh --tables=hotel_content_provider --add-drop --database=hs --stdout --use-keychain --apache-user=betatester --phpmyadmin-user=hs --apache-password=www.example.com\\ <\/span>\\(<\/span>me\\)<\/span> --phpmyadmin-password=phpmyadmin.example.com --host=https:\/\/www.example.com\/phpmyadmin |<\/span> gunzip |<\/span> mysql -u root -p testtable\n  exports and imports on the fly in<\/span> local<\/span> db\nEOF\nexit<\/span> 0\n\n  elif<\/span> [ $arg<\/span> == '--stdout'<\/span> ]\n  then<\/span>\n    stdin=1\n  elif<\/span> [[ $arg<\/span> =~<\/span> --tables ]]\n  then<\/span>\n    export_tables=1\n    db_tables=$arg<\/span>\n  elif<\/span> [ $arg<\/span> == '--compression=off'<\/span> ]\n  then<\/span>\n    COMPRESSION=off\n  elif<\/span> [ $arg<\/span> == '--add-drop'<\/span> ]\n  then<\/span>\n    add_drop=1\n  elif<\/span> [[ $arg<\/span> =~<\/span> --apache-user ]] &&<\/span> [ $APACHE_USER<\/span> -eq 0 ]\n  then<\/span>\n    APACHE_USER=${arg:<\/span>14}<\/span>\n  elif<\/span> [[ $arg<\/span> =~<\/span> --apache-password ]] &&<\/span> [ $APACHE_PASSWD<\/span> -eq 0 ]\n  then<\/span>\n    APACHE_PASSWD=${arg:<\/span>18}<\/span>\n  elif<\/span> [[ $arg<\/span> =~<\/span> --phpmyadmin-user ]] &&<\/span> [ $PHPMYADMIN_USER<\/span> -eq 0 ]\n  then<\/span>\n    PHPMYADMIN_USER=${arg:<\/span>18}<\/span>\n  elif<\/span> [[ $arg<\/span> =~<\/span> --phpmyadmin-password ]] &&<\/span> [ $PHPMYADMIN_PASSWD<\/span> -eq 0 ]\n  then<\/span>\n    PHPMYADMIN_PASSWD=${arg:<\/span>22}<\/span>\n  elif<\/span> [[ $arg<\/span> =~<\/span> --database ]] &&<\/span> [ $DATABASE<\/span> -eq 0 ]\n  then<\/span>\n    DATABASE=${arg:<\/span>11}<\/span>\n  elif<\/span> [[ $arg<\/span> =~<\/span> --host ]] &&<\/span> [ $REMOTE_HOST<\/span> -eq 0 ]\n  then<\/span>\n    REMOTE_HOST=${arg:<\/span>7}<\/span>\n  elif<\/span> [[ $arg<\/span> ==<\/span> '--use-keychain'<\/span> ]]\n  then<\/span>\n    USE_KEYCHAIN=1\n  fi<\/span>\ndone<\/span>\n\nif<\/span> [ $USE_KEYCHAIN<\/span> -eq 1 ]\nthen<\/span>\n  APACHE_PASSWD=`security 2>&1<\/span> ><\/span>\/dev\/null find-internet-password -gs $APACHE_PASSWD<\/span> |<\/span> sed -e 's\/password: \"\\(.*\\)\"\/\\1\/g'`<\/span>\n  PHPMYADMIN_PASSWD=`security 2>&1<\/span> ><\/span>\/dev\/null find-internet-password -g -l $PHPMYADMIN_PASSWD<\/span> |<\/span> sed -e 's\/password: \"\\(.*\\)\"\/\\1\/g'`<\/span>\nfi<\/span>\n\n###############################################################<\/span>\n#<\/span>\n# First login and fetch the cookie which will be used later<\/span>\n#<\/span>\n###############################################################<\/span>\n\nMKTEMP=\/bin\/tempfile\nif<\/span> [ !<\/span> -x $MKTEMP<\/span> ];<\/span> then<\/span>\n    MKTEMP=`which mktemp`<\/span>\n    result=$($MKTEMP<\/span> \"$TMP_FOLDER<\/span>\/phpmyadmin_export.XXXXXX.tmp\")<\/span>\nelse<\/span>\n    result=$($MKTEMP<\/span> \"$TMP_FOLDER<\/span>\/phpmyadmin_export.$RANDOM<\/span>.tmp\")<\/span>\nfi<\/span>\n\napache_auth_params=\"--anyauth -u$APACHE_USER<\/span>:$APACHE_PASSWD<\/span>\"<\/span>\n\ncurl -s -k -D $TMP_FOLDER<\/span>\/curl.headers -L -c $TMP_FOLDER<\/span>\/cookies.txt $apache_auth_params<\/span> $REMOTE_HOST<\/span>\/index.php ><\/span> $result<\/span>\n    token=$(grep \"navigation.php\" $result<\/span> |<\/span> grep token |<\/span> sed \"s\/^.*token=\/\/\" |<\/span> sed \"s\/\\\"<\/span>$\/\/\")<\/span>\n\n    cookie=$(cat $TMP_FOLDER<\/span>\/cookies.txt |<\/span> cut  -f 6-7 |<\/span> grep phpMyAdmin |<\/span> cut -f 2)<\/span>\n\n    entry_params=\"-d \\\"<\/span>phpMyAdmin=$cookie<\/span>&phpMyAdmin=$cookie<\/span>&pma_username=$PHPMYADMIN_USER<\/span>&pma_password=$PHPMYADMIN_PASSWD<\/span>&server=1&phpMyAdmin=$cookie<\/span>&lang=en-utf-8&convcharset=utf-8&collation_connection=utf8_general_ci&token=$token<\/span>&input_go=Go\\\"<\/span>\"<\/span>\n\ncurl -s -S -k -L  -D $TMP_FOLDER<\/span>\/curl.headers -b $TMP_FOLDER<\/span>\/cookies.txt -c $TMP_FOLDER<\/span>\/cookies.txt $apache_auth_params<\/span> $entry_params<\/span> $REMOTE_HOST<\/span>\/index.php ><\/span> $result<\/span>\n\nif<\/span> [ $?<\/span> -ne 0 ]\nthen<\/span>\n     echo<\/span> \"Curl Error on : curl $entry_params<\/span> -s -k -D $TMP_FOLDER<\/span>\/curl.headers -L -c $TMP_FOLDER<\/span>\/cookies.txt $REMOTE_HOST<\/span>\/index.php. Check contents of $result<\/span>\"<\/span> >&2<\/span>\n     exit<\/span> 1\nfi<\/span>\ngrep -q \"HTTP\/1.1 200 OK\"<\/span> $TMP_FOLDER<\/span>\/curl.headers\nif<\/span> [ $?<\/span> -ne 0 ]\nthen<\/span>\n         echo<\/span> -n \"Error : couldn't login to phpMyadmin on $REMOTE_HOST<\/span>\/index.php\"<\/span> >&2<\/span>\n         grep \"HTTP\/1.1 \"<\/span> $TMP_FOLDER<\/span>\/curl.headers >&2<\/span>\n         exit<\/span> 1\nfi<\/span>\n\nmd5cookie=$token<\/span>\n\npost_params=\"token=$md5cookie<\/span>\"<\/span>\npost_params=\"$post_params<\/span>&export_type=server\"<\/span>\npost_params=\"$post_params<\/span>&export_method=quick\"<\/span>\npost_params=\"$post_params<\/span>&quick_or_custom=custom\"<\/span>\npost_params=\"$post_params<\/span>&db_select[]=$DATABASE<\/span>\"<\/span>\npost_params=\"$post_params<\/span>&output_format=sendit\"<\/span>\n\npost_params=\"$post_params<\/span>&what=sql\"<\/span>\npost_params=\"$post_params<\/span>&codegen_structure_or_data=data\"<\/span>\n# post_params=\"$post_params&codegen_format=0\"<\/span>\n# post_params=\"$post_params&csv_separator=%3B\"<\/span>\n# post_params=\"$post_params&csv_enclosed=%22\"<\/span>\n# post_params=\"$post_params&csv_escaped=%5C\"<\/span>\n# post_params=\"$post_params&csv_terminated=AUTO\"<\/span>\n# post_params=\"$post_params&csv_null=NULL\"<\/span>\npost_params=\"$post_params<\/span>&csv_structure_or_data=data\"<\/span>\n# post_params=\"$post_params&excel_null=NULL\"<\/span>\n# post_params=\"$post_params&excel_edition=win\"<\/span>\npost_params=\"$post_params<\/span>&excel_structure_or_data=data\"<\/span>\n# post_params=\"$post_params&htmlword_structure=something\"<\/span>\npost_params=\"$post_params<\/span>&htmlword_structure_or_data=structure_and_data\"<\/span>\n# post_params=\"$post_params&htmlword_null=NULL\"<\/span>\n# post_params=\"$post_params&latex_caption=something\"<\/span>\n# post_params=\"$post_params&latex_structure=something\"<\/span>\n# post_params=\"$post_params&latex_structure_caption=Structure+of+table+__TABLE__\"<\/span>\n# post_params=\"$post_params&latex_structure_continued_caption=Structure+of+table+__TABLE__+%28continued%29\"<\/span>\n# post_params=\"$post_params&latex_structure_label=tab%3A__TABLE__-structure\"<\/span>\n# post_params=\"$post_params&latex_comments=something\"<\/span>\npost_params=\"$post_params<\/span>&latex_data=something\"<\/span>\n# post_params=\"$post_params&latex_columns=something\"<\/span>\n# post_params=\"$post_params&latex_data_caption=Content+of+table+__TABLE__\"<\/span>\n# post_params=\"$post_params&latex_data_continued_caption=Content+of+table+__TABLE__+%28continued%29\"<\/span>\n# post_params=\"$post_params&latex_data_label=tab%3A__TABLE__-data\"<\/span>\n# post_params=\"$post_params&latex_null=%5Ctextit%7BNULL%7D\"<\/span>\npost_params=\"$post_params<\/span>&mediawiki_structure_or_data=data\"<\/span>\n# post_params=\"$post_params&ods_null=NULL\"<\/span>\npost_params=\"$post_params<\/span>&ods_structure_or_data=data\"<\/span>\n# post_params=\"$post_params&odt_structure=something\"<\/span>\n# post_params=\"$post_params&odt_comments=something\"<\/span>\npost_params=\"$post_params<\/span>&odt_data=something\"<\/span>\n# post_params=\"$post_params&odt_columns=something\"<\/span>\n# post_params=\"$post_params&odt_null=NULL\"<\/span>\n# post_params=\"$post_params&pdf_report_title=\"<\/span>\npost_params=\"$post_params<\/span>&pdf_data=1\"<\/span>\npost_params=\"$post_params<\/span>&php_array_structure_or_data=data\"<\/span>\npost_params=\"$post_params<\/span>&sql_header_comment=\"<\/span>\npost_params=\"$post_params<\/span>&sql_include_comments=something\"<\/span>\npost_params=\"$post_params<\/span>&sql_compatibility=NONE\"<\/span>\npost_params=\"$post_params<\/span>&sql_structure_or_data=structure_and_data\"<\/span>\npost_params=\"$post_params<\/span>&sql_if_not_exists=something\"<\/span>\npost_params=\"$post_params<\/span>&sql_auto_increment=something\"<\/span>\npost_params=\"$post_params<\/span>&sql_backquotes=something\"<\/span>\npost_params=\"$post_params<\/span>&sql_data=something\"<\/span>\npost_params=\"$post_params<\/span>&sql_columns=something\"<\/span>\npost_params=\"$post_params<\/span>&sql_extended=something\"<\/span>\npost_params=\"$post_params<\/span>&sql_max_query_size=50000\"<\/span>\npost_params=\"$post_params<\/span>&sql_hex_for_blob=something\"<\/span>\npost_params=\"$post_params<\/span>&sql_type=INSERT\"<\/span>\n# post_params=\"$post_params&texytext_structure=something\"<\/span>\npost_params=\"$post_params<\/span>&texytext_data=something\"<\/span>\n# post_params=\"$post_params&texytext_null=NULL\"<\/span>\n# post_params=\"$post_params&xls_null=NULL\"<\/span>\npost_params=\"$post_params<\/span>&xls_structure_or_data=data\"<\/span>\n# post_params=\"$post_params&xlsx_null=NULL\"<\/span>\npost_params=\"$post_params<\/span>&xlsx_structure_or_data=data\"<\/span>\npost_params=\"$post_params<\/span>&yaml_structure_or_data=data\"<\/span>\npost_params=\"$post_params<\/span>&asfile=sendit\"<\/span>\npost_params=\"$post_params<\/span>&filename_template=__SERVER__\"<\/span>\npost_params=\"$post_params<\/span>&remember_template=on\"<\/span>\npost_params=\"$post_params<\/span>&charset_of_file=utf-8\"<\/span>\n\nif<\/span> [ $add_drop<\/span> -eq 1 ]\nthen<\/span>\n  post_params=\"$post_params<\/span>&sql_drop_table=something\"<\/span>\n  post_params=\"$post_params<\/span>&sql_structure=data\"<\/span>\nfi<\/span>\n\nif<\/span> [ \"$COMPRESSION<\/span>\"<\/span> = \"on\"<\/span> ]\nthen<\/span>\n    post_params=\"$post_params<\/span>&compression=gzip\"<\/span>\nelse<\/span>\n    post_params=\"$post_params<\/span>&compression=none\"<\/span>\nfi<\/span>\n#&sql_hex_for_binary=something<\/span>\n\n#2.7.0-pl2<\/span>\n#post_params=\"$post_params&sql_structure=structure\"<\/span>\n#post_params=\"$post_params&sql_auto_increment=1\"<\/span>\n#post_params=\"$post_params&sql_compat=NONE\"<\/span>\n#post_params=\"$post_params&use_backquotes=1\"<\/span>\n#post_params=\"$post_params&sql_data=data\"<\/span>\n#post_params=\"$post_params&hexforbinary=yes\"<\/span>\n#post_params=\"$post_params&sql_type=insert\"<\/span>\n#post_params=\"$post_params&lang=fr-utf-8&server=1&collation_connection=utf8_general_ci&buttonGo=Ex\u00e9cuter\"<\/span>\n\nif<\/span> [ $export_tables<\/span> -eq 1 ]\nthen<\/span>\n  db_tables=${db_tables\/<\/span>=\/<\/span>table_select[]=}<\/span>\n  db_tables=${db_tables\/<\/span>\/<\/span>,\/<\/span>&table_select[]=}<\/span>\n  db_tables=${db_tables:<\/span>8}<\/span>\n\n  post_params=\"$post_params<\/span>&db=$DATABASE<\/span>&export_type=database&$db_tables<\/span>&filename_template=__DB__\"<\/span>\n\nfi<\/span>\n\nif<\/span> [ $stdin<\/span> -eq 1 ]\nthen<\/span>\n  curl -g -s -S -k -D $TMP_FOLDER<\/span>\/curl.headers -L -b $TMP_FOLDER<\/span>\/cookies.txt $apache_auth_params<\/span> -d \"$post_params<\/span>\"<\/span> $REMOTE_HOST<\/span>\/export.php\nelse<\/span>\n  curl -g -s -S -O -k -D $TMP_FOLDER<\/span>\/curl.headers -L -b $TMP_FOLDER<\/span>\/cookies.txt $apache_auth_params<\/span> -d \"$post_params<\/span>\"<\/span> $REMOTE_HOST<\/span>\/export.php\n\n  grep -q \"Content-Disposition: attachment\"<\/span> $TMP_FOLDER<\/span>\/curl.headers\n  if<\/span> [ $?<\/span> -eq 0 ]\n  then<\/span>\n    filename=\"$(echo<\/span> $REMOTE_HOST<\/span> |<\/span> sed 's\/\\.\/-\/g; s|^http[s]:\/\/||g; s|\/|-|g;')_${DATABASE}<\/span>_$(date  +%Y%m%d%H%M).sql\"<\/span>\n\n    if<\/span> [ \"$COMPRESSION<\/span>\"<\/span> = \"on\"<\/span> ]\n        then<\/span>\n            filename=\"$filename<\/span>.gz\"<\/span>\n            mv export<\/span>.php backup_mysql_$filename<\/span>\n            echo<\/span> \"Saved: backup_mysql_$filename<\/span>\"<\/span>\n    else<\/span>\n            mv export<\/span>.php backup_mysql_$filename<\/span>\n            gzip backup_mysql_$filename<\/span>\n            echo<\/span> \"Saved: backup_mysql_$filename<\/span>.gz\"<\/span>\n    fi<\/span>\n  fi<\/span>\nfi<\/span>\n\n# remove the old backups and keep the 10 younger ones.<\/span>\n#ls -1 backup_mysql_*${DATABASE}_*.gz | sort -u | head -n-10 | xargs -r rm -v<\/span>\n\nrm -f $result<\/span>\nrm -f $TMP_FOLDER<\/span>\/curl.headers\nrm -f $TMP_FOLDER<\/span>\/cookies.txt<\/pre>\n\n\n
mysql-export.sh<\/a>\ub2e4\uc6b4\ub85c\ub4dc<\/a><\/div>\n\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[10],"tags":[],"class_list":["post-805","post","type-post","status-publish","format-standard","hentry","category-computing_database"],"_links":{"self":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/805","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=805"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/805\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=805"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=805"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=805"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}