2.2. Restaurar la base de datos

Recree la base de datos MySQL (de ser necesario, elimínela primero):

$ mysql -u root -p
Enter password: 

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 103
Server version: 5.1.38 MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> DROP DATABASE ojs;
Query OK, 0 rows affected (0.23 sec)

mysql> CREATE DATABASE ojs DEFAULT CHARACTER SET utf8;
Query OK, 1 row affected (0.00 sec)

mysql> GRANT ALL ON ojs.* TO pkpuser@localhost IDENTIFIED BY 'password';
Query OK, 0 rows affected (0.01 sec)

mysql> 

Cargue el volcado de memoria de la base de datos en la base de datos que acaba de crear:

$ zcat /root/ojs-database.sql.gz | mysql -u pkpuser -p ojs23