Pro posgres.
stolknulsa s tem chto mne nado bylo sdelat backup bazy dannyx i soxranit ego.
ideja mne krajne ne ponravilas, t.k. utilitku dla backupa predlagalos pisat na php
otkryl manual po posgreSql
v papke kuda ustanovlen postgres (obychno /usr/local/pgsql ) v podpapke bin est mnozjestvo krasivyx utilitok
naprimer:
-- vse primery ispolnajutsa iz papki /usr/local/pgsql/bin i rabotajut s bazoj, nazyvajuschejsa dbname
./createdb dbname
sozdaet bazu
./dropdb dbname
udalaet
./pg_dump dbname > /home/postgres/mybackup
sozdaet dump bazy (dannye o tablicax i ix soderzjimom v vide SQL kommand)
i zapisyvaet ego v fail /home/postgres/mybackup
./psql dbname < /home/postgres/mybackup
vosstanavlivaet bazu iz fajla
Wednesday, July 4, 2007
Subscribe to:
Post Comments (Atom)

0 comments:
Post a Comment