TEXT   17

Backups

Guest on 3rd August 2022 01:42:58 AM

  1. Backups
  2. *******
  3.  
  4.  
  5. Database
  6. ========
  7.  
  8. Here are some sample commands you could use to backup your database,
  9. depending on what database system you're using. You may have to modify
  10. these commands for your particular setup. Replace the $VARIABLEs with
  11. appropriate values for your setup.
  12.  
  13.  
  14. MySQL
  15. -----
  16.  
  17. **mysqldump --max-allowed-packet=32M -u $USERNAME -p $DATABASENAME >
  18. backup.sql**
  19.  
  20. The value for **max-allowed-packet** should be the value you've set in
  21. your MySQL configuration file, and should be larger than the largest
  22. attachment in your database. See the mysqldump documentation for more
  23. information on "mysqldump".
  24.  
  25.  
  26. PostgreSQL
  27. ----------
  28.  
  29. **pg_dump --no-privileges --no-owner -h localhost -U $USERNAME >
  30. bugs.sql**
  31.  
  32.  
  33. Bugzilla
  34. ========
  35.  
  36. The Bugzilla directory contains some data files and configuration
  37. files which you would want to retain. A simple recursive copy will do
  38. the job here.
  39.  
  40. **cp -rp $BUGZILLA_HOME /var/backups/bugzilla**
  41.  
  42. ======================================================================
  43.  
  44. This documentation undoubtedly has bugs; if you find some, please file
  45. them here.

Raw Paste


Login or Register to edit or fork this paste. It's free.