Versions Compared

Old Version 45

changes.mady.by.user Jeremy McCormick

Saved on

compared with

New Version 46

changes.mady.by.user Jeremy McCormick

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
titleCreating a Backup
mysqldump -h hpsdb.jlab.org -ujeremymu$USER -pXXXXXXp$PASSWORD hps_conditions &> hps_conditions.sql

...

Code Block
titleLoading a Backup
mysql -h hpsdb.jlab.org -u jeremym$USER -pXXXXXXp$PASSWORD hps_conditions < hps_conditions.sql

...

Code Block
mysqldump -h hpsdb.jlab.org -uUSERu$USER -pPASSWORDp$PASSWORD --disable-lock-tables hps_conditions &> hps_conditions_for_slac.sql

...

Code Block
mysql -D rd_hps_cond -h mysql-node03.slac.stanford.edu -P 3306 -u USER$USER -p PASSWORD$PASSWORD < /nfs/slac/g/hps/someDir/hps_conditions_for_slac.sql

...