Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
4 Trả lời
27931 Lượt xem

Hello,

Anyone knows how to take back of database by terminal. I need to take database backup of my server, by terminal.Is there is any  commands that is used for take backup from server. I searched lot, and i tried those what i got , but its not succeed.Could you please help me to do this?


thanking you,

Logicious

Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

Hello,

You can also have an eye on this question it may helps



Ảnh đại diện
Huỷ bỏ
Tác giả

@ahmed : i already seen this sh script , i don't want use script because i doesn't have experience with scripting .

You don't need to use the all script. E.g you can use: pg_dump -E UTF-8 -p 5433 -F p -b -f $filename $db to execute the dumping ... $filename is where you will put the dump and $db is your database name ...

Tác giả

@ahmed :- Thank you i will try...

Câu trả lời hay nhất

Hi

pg_dump dbname | gzip > filename.gz

Reload with

createdb dbname

gunzip -c filename.gz | psql dbname

or you can refer link: http://www.postgresql.org/docs/8.1/static/backup.html

Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

https://linuxize.com/post/how-to-setup-automatic-odoo-backup/

Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

Hi,

A. To backup your database

    1. switch to postgres user

    sudo su - postgres

    2. backup with the ff command;

    pg_dump db_name > db_backup.sql

     [note db_name is the name of the database you want to backup; db_backup.sqlis the name you want to give your backup. Whatever name you want to give to your backup, end it with the .sql extension]

    3. To get the location of your backup, run this command from the terminal

    find / -name db_backup.sql


B.

    1. If your database is on a remote computer, connect to it using WinSCP;  supply your username and password

    2. browse to the directory where your backup is saved as gotten in step 3 of A above

     3. you can then copy the sql file to your desired location or download to a location on your local computer in case it is on         a remote computer.

I hope this helps a lot.


Ảnh đại diện
Huỷ bỏ
Bài viết liên quan Trả lời Lượt xem Hoạt động
4
thg 7 18
13090
1
thg 5 16
8182
1
thg 8 15
5014
1
thg 11 23
4063
2
thg 4 22
2720