{"id":70703,"date":"2024-07-25T05:05:51","date_gmt":"2024-07-25T01:35:51","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/%d9%be%d8%b4%d8%aa%db%8c%d8%a8%d8%a7%d9%86-%d8%a7%d9%86%d8%ac%d9%85%d9%86-dev\/"},"modified":"2024-07-25T05:05:51","modified_gmt":"2024-07-25T01:35:51","slug":"%d9%be%d8%b4%d8%aa%db%8c%d8%a8%d8%a7%d9%86-%d8%a7%d9%86%d8%ac%d9%85%d9%86-dev","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/%d9%be%d8%b4%d8%aa%db%8c%d8%a8%d8%a7%d9%86-%d8%a7%d9%86%d8%ac%d9%85%d9%86-dev\/","title":{"rendered":"\u067e\u0634\u062a\u06cc\u0628\u0627\u0646 – \u0627\u0646\u062c\u0645\u0646 DEV"},"content":{"rendered":"

<\/p>\n

\n
\n
Huawei Cloud \u00fczerinde GaussDB veritaban\u0131n\u0131 yedeklemek ve geri y\u00fcklemek i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izleyebilirsiniz:\n\n### 1. Yedekleme \u0130\u015flemi\n\n#### Ad\u0131m 1: GaussDB Konsoluna Giri\u015f\n1. **Huawei Cloud Management Console**'a giri\u015f yap\u0131n.\n2. **GaussDB** hizmetini aray\u0131n ve **GaussDB for MySQL** veya **GaussDB(for PostgreSQL)** se\u00e7in, kulland\u0131\u011f\u0131n\u0131z s\u00fcr\u00fcme ba\u011fl\u0131 olarak.\n3. Yedeklemek istedi\u011finiz veritaban\u0131 \u00f6rne\u011fini se\u00e7in.\n\n#### Ad\u0131m 2: Yedekleme Ba\u015flatma\n1. **Backup Management** veya **Yedekleme Y\u00f6netimi** sekmesine gidin.\n2. **Manual Backup** veya **Manuel Yedekleme** butonuna t\u0131klay\u0131n.\n3. Yedekleme i\u00e7in bir ad belirtin ve gerekli di\u011fer bilgileri doldurun.\n4. **OK** veya **Tamam** butonuna t\u0131klayarak yedekleme i\u015flemini ba\u015flat\u0131n.\n\n#### Ad\u0131m 3: Yedekleme Durumunu Kontrol Etme\n1. **Backup Management** sekmesinde, yedeklemenin durumunu kontrol edebilirsiniz.\n2. Yedekleme i\u015flemi tamamland\u0131\u011f\u0131nda, yedekleme dosyas\u0131n\u0131n bulundu\u011fu konumu not edin.\n\n### 2. Geri Y\u00fckleme \u0130\u015flemi\n\n#### Ad\u0131m 1: GaussDB Konsoluna Giri\u015f\n1. **Huawei Cloud Management Console**'a giri\u015f yap\u0131n.\n2. **GaussDB** hizmetini aray\u0131n ve **GaussDB for MySQL** veya **GaussDB(for PostgreSQL)** se\u00e7in, kulland\u0131\u011f\u0131n\u0131z s\u00fcr\u00fcme ba\u011fl\u0131 olarak.\n3. Yedekten geri y\u00fcklemek istedi\u011finiz veritaban\u0131 \u00f6rne\u011fini se\u00e7in.\n\n#### Ad\u0131m 2: Geri Y\u00fckleme Ba\u015flatma\n1. **Backup Management** veya **Yedekleme Y\u00f6netimi** sekmesine gidin.\n2. Geri y\u00fcklemek istedi\u011finiz yedekleme dosyas\u0131n\u0131 se\u00e7in.\n3. **Restore** veya **Geri Y\u00fckle** butonuna t\u0131klay\u0131n.\n4. Geri y\u00fcklemek istedi\u011finiz hedef veritaban\u0131n\u0131 se\u00e7in veya yeni bir veritaban\u0131 olu\u015fturun.\n5. **OK** veya **Tamam** butonuna t\u0131klayarak geri y\u00fckleme i\u015flemini ba\u015flat\u0131n.\n\n#### Ad\u0131m 3: Geri Y\u00fckleme Durumunu Kontrol Etme\n1. **Backup Management** sekmesinde, geri y\u00fckleme i\u015fleminin durumunu kontrol edebilirsiniz.\n2. Geri y\u00fckleme i\u015flemi tamamland\u0131\u011f\u0131nda, veritaban\u0131n\u0131z kullan\u0131ma haz\u0131r olacakt\u0131r.\n\n### Yedekleme ve Geri Y\u00fckleme Komutlar\u0131\n\nE\u011fer yedekleme ve geri y\u00fckleme i\u015flemlerini komut sat\u0131r\u0131ndan yapmak isterseniz, a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izleyebilirsiniz.\n\n#### Yedekleme \u0130\u00e7in:\n<\/code><\/pre>\n
\n
\n    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n
    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n
\u0636\u0631\u0628\u0647 \u0634\u062f\u06cc\u062f<\/p>\n
pg_dump -h 192.168.0.183 -p 8000 -U hccdp -F c -b -v -f \/path\/to\/backup\/hccdp_db.backup hccdp_db<\/p>\n
\n
\n#### Geri Y\u00fckleme \u0130\u00e7in:\n<\/code><\/pre>\n
\n
\n    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n
    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n
\u0636\u0631\u0628\u0647 \u0634\u062f\u06cc\u062f<\/p>\n
.\/gsql -h 192.168.0.183 -U root -d postgres -p 8000 -W yourpassword -r
\u0627\u06cc\u062c\u0627\u062f \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 hccdp_db_new \u0628\u0627 \u0627\u0644\u06af\u0648\u06cc \u0642\u0627\u0644\u06280 \u06a9\u062f\u06af\u0630\u0627\u0631\u06cc 'UTF8';
ALTER DATABASE hccdp_db_new OWNER TO hccdp;
\\ q<\/p>\n
pg_restore -h 192.168.0.183 -p 8000 -U hccdp -d hccdp_db_new -v \/path\/to\/backup\/hccdp_db.backup<\/p>\n
\n
\nBu ad\u0131mlar\u0131 takip ederek Huawei Cloud \u00fczerinde GaussDB veritaban\u0131n\u0131z\u0131 yedekleyebilir ve gerekti\u011finde geri y\u00fckleyebilirsiniz. Yedekleme ve geri y\u00fckleme i\u015flemleri s\u0131ras\u0131nda herhangi bir hata al\u0131rsan\u0131z, detaylar\u0131 payla\u015f\u0131rsan\u0131z daha fazla yard\u0131mc\u0131 olabilirim.\n<\/code><\/pre>\n
\n
\n    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n
    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n
\n
.\/gsql -h 192.168.0.183 -U root -d postgres -p 8000 -W yourpassword -r\n\n\npg_dump -h 192.168.0.183 -p 8000 -U hccdp -F c -b -v -f \/path\/to\/backup\/hccdp_db.backup hccdp_db\n\n\nls -lh \/path\/to\/backup\/hccdp_db.backup\n\n\n.\/gsql -h 192.168.0.183 -U root -d postgres -p 8000 -W yourpassword -r\nCREATE DATABASE hccdp_db_new WITH TEMPLATE template0 ENCODING 'UTF8';\nALTER DATABASE hccdp_db_new OWNER TO hccdp;\n\\q\n\n\npg_restore -h 192.168.0.183 -p 8000 -U hccdp -d hccdp_db_new -v \/path\/to\/backup\/hccdp_db.backup\n\n\n# ECS \u00fczerinde terminale ba\u011flan\u0131n\nssh username@ecs-ip-address\n\n# GaussDB istemci ara\u00e7lar\u0131n\u0131 \u00e7al\u0131\u015ft\u0131r\u0131n\ncd \/path\/to\/GaussDB_opengauss_client_tools\/EulerOS_X86_64\nsource gsql_env.sh\n\n# Veritaban\u0131na ba\u011flan\u0131n ve yedekleme komutunu \u00e7al\u0131\u015ft\u0131r\u0131n\npg_dump -h 192.168.0.183 -p 8000 -U hccdp -F c -b -v -f \/path\/to\/backup\/hccdp_db.backup hccdp_db\n\n# ECS \u00fczerinde terminale ba\u011flan\u0131n\nssh username@ecs-ip-address\n\n# GaussDB istemci ara\u00e7lar\u0131n\u0131 \u00e7al\u0131\u015ft\u0131r\u0131n\ncd \/path\/to\/GaussDB_opengauss_client_tools\/EulerOS_X86_64\nsource gsql_env.sh\n\n# Yeni veritaban\u0131n\u0131 olu\u015fturun\n.\/gsql -h 192.168.0.183 -U root -d postgres -p 8000 -W yourpassword -r\nCREATE DATABASE hccdp_db_new WITH TEMPLATE template0 ENCODING 'UTF8';\nALTER DATABASE hccdp_db_new OWNER TO hccdp;\n\\q\n\n# Yede\u011fi yeni veritaban\u0131na geri y\u00fckleyin\npg_restore -h 192.168.0.183 -p 8000 -U hccdp -d hccdp_db_new -v \/path\/to\/backup\/hccdp_db.backup\n\n<\/code><\/pre>\n
\n
\n    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n
    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"
Huawei Cloud \u00fczerinde GaussDB veritaban\u0131n\u0131 yedeklemek ve geri y\u00fcklemek i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izleyebilirsiniz: ### 1. Yedekleme \u0130\u015flemi #### Ad\u0131m 1: GaussDB Konsoluna Giri\u015f 1. **Huawei Cloud Management Console**’a giri\u015f yap\u0131n. 2. **GaussDB** hizmetini aray\u0131n ve **GaussDB for MySQL** veya **GaussDB(for PostgreSQL)** se\u00e7in, kulland\u0131\u011f\u0131n\u0131z s\u00fcr\u00fcme ba\u011fl\u0131 olarak. 3. Yedeklemek istedi\u011finiz veritaban\u0131 \u00f6rne\u011fini se\u00e7in. #### Ad\u0131m 2: …<\/p>\n","protected":false},"author":2,"featured_media":70704,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/media.dev.to\/cdn-cgi\/image\/width=1000,height=500,fit=cover,gravity=auto,format=auto\/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F93w1ed8hc670qgpfzbfr.png","fifu_image_alt":"","footnotes":""},"categories":[339],"tags":[],"class_list":["post-70703","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dev"],"_links":{"self":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/70703","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/comments?post=70703"}],"version-history":[{"count":0,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/70703\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media\/70704"}],"wp:attachment":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media?parent=70703"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/categories?post=70703"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/tags?post=70703"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}