Configure MySQL Databases
Either run Core database or Demo database but do not do both of the items. It is highly recommended that you use Demo unless you know how to stand up core.
Core database
| cd /opt/atavism_server/sql/New_Install_Core sudo mysql -u gameadmin –p admin < /opt/atavism_server/sql/New_Install_Core/admin.sql sudo mysql -u gameadmin –p atavism < /opt/atavism_server/sql/New_Install_Core/atavism.sql sudo mysql -u gameadmin –p master < /opt/atavism_server/sql/New_Install_Core/master.sql sudo mysql -u gameadmin –p world_content < /opt/atavism_server/sql/New_Install_Core/world_content.sql |
Demo database
| cd /opt/atavism_server/sql/New_Install_with_Demo_Data sudo mysql -u gameadmin –p admin < /opt/atavism_server/sql/New_Install_with_Demo_Data/admin.sql sudo mysql -u gameadmin –p atavism < /opt/atavism_server/sql/New_Install_with_Demo_Data/atavism.sql sudo mysql -u gameadmin –p master < /opt/atavism_server/sql/New_Install_with_Demo_Data/master.sql sudo mysql -u gameadmin –p world_content < /opt/atavism_server/sql/New_Install_with_Demo_Data/world_content.sql |
- Log in to your Ubuntu server using your SSH client or directly from the terminal.
- Navigate to the folder where the database files are stored using the cd command. In this case, the databases are located in “/opt/atavism_server/sql/New_Install_with_Demo_Data/” folder.
cd /opt/atavism_server/sql/New_Install_with_Demo_Data/
- Next, run the following command to log in to the MySQL database server using the root user and password:
mysql -u root -p
- Enter your MySQL root password when prompted.
- Once you are logged in to MySQL, create a new database for each of the four database files using the following commands:
CREATE DATABASE admin;
CREATE DATABASE atavism;
CREATE DATABASE master;
CREATE DATABASE world_content;
- Exit from MySQL command prompt by typing “exit” and pressing Enter.
- Now, import the database files into the corresponding databases using the following commands:
mysql -u root -p admin < admin.sql
mysql -u root -p atavism < atavism.sql
mysql -u root -p master < master.sql
mysql -u root -p world_content < world_content.sql
- After importing the databases, log back in to the MySQL command prompt using the following command:
mysql -u root -p
- Switch to the database that contains the imported data using the following command:
USE atavism;
- Verify that the data has been imported successfully by listing the tables in the database using the following command:
SHOW TABLES;
You should now be able to see a list of all the tables in the “atavism” database. Repeat the same steps for the other databases.
That’s it! You have successfully imported the databases into MySQL on your Ubuntu server.