gump-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Gump Wiki] Update of "VmgumpConfig" by StefanBodewig
Date Sat, 29 Oct 2016 11:30:20 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Gump Wiki" for change notification.

The "VmgumpConfig" page has been changed by StefanBodewig:
https://wiki.apache.org/gump/VmgumpConfig?action=diff&rev1=81&rev2=82

  /srv/gump$ sudo svn co https://svn.apache.org/repos/private/pmc/gump/packages
  }}}
  
+ == Set up database ==
+ 
+ 
+ === Set a mysql password for root ===
+ 
+ {{{
+ mysqladmin -u root -p password "NEW-PASSWORD"
+ }}}
+ 
+ the initial password after installation is empty.
+ 
+ 
+ === Create a gump database and user ===
+ 
+ {{{
+ ~$ mysql -u root -p
+ mysql> CREATE DATABASE gump_public;
+ mysql> GRANT ALL PRIVILEGES ON gump_public.* TO 'gump'@'localhost' IDENTIFIED BY 'othernewpwd';
+ mysql> FLUSH PRIVILEGES;
+ mysql> EXIT;
+ ~$ mysql -u gump -p gump_public
+ }}}
+ 
+ {{{
+ ~$ sudo vi /root/.mysqlpass
+ }}}
+ 
+ === dump old database on vmgump ===
+ 
+ Since we are migrating an installation, the database is created by restoring a database
dump from the "old" vmgump.
+ 
+ {{{
+ ~$ mkdir dump
+ ~$ export currdate=`date +%Y%m%d`
+ ~$ cd dump/
+ ~/dump$ mysqldump -u root -p gump_public --add-drop-table --create-options > $currdate-gump_public.mysqldump
+ }}}
+ 
+ === restore database on new vmgump2 ===
+ 
+ copy over the dump
+ 
+ {{{
+ ~$ mysql --user=root -p gump_public < $currdate-gump_public.mysqldump 
+ }}}
+ 
+ 
+ ------
  
  === everything below is obsolete but kept so the Puppet setup may explain itself better
===
  

Mime
View raw message