Versions Compared

Old Version 23

changes.mady.by.user Mike Conlon

Saved on

compared with

New Version 24

changes.mady.by.user Mike Conlon

Saved on

Key

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

...

  1. Record the name of the database you used to install VIVO.  In the installation instructions, this is referred to as vitrodb, but you may have named it something else.  After you have finished with the sample data, you will follow steps to reset VIVO to use this database.

  2. Create a new database in MySQL

    Code Block
    titleCreate sample database
    $ mysql -u root -p
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.9 MySQL Community Server (GPL)
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> CREATE DATABASE sampledb CHARACTER SET utf8;
mysql> GRANT ALL ON sampledb.* TO 'vitrodbUsername'@'localhost' IDENTIFIED BY 'vitrodbPassword';


  3. edit Edit the runtime.properties file to tell VIVO the name of the database it should use.  In this case sampledb.
  4. Restart Tomcat

On completing these steps, your VIVO will be using an "empty" database.  VIVO automatically loads data from files distributed with VIVO. These data pertain to countries of the world.  Your home page should look like:

...