Stuck setting up a dedicated box

[Pathfinder]

Hi everyone

 

I have been stuck trying to setup a epoch server. I have installed a MYSQL server but I am confused when it says the following.

 

• Create a new mysql database called "dayz_epoch" and import the epoch.sql file found in the SQL folder.

 

I believe I have created the database but how do I import the epoch.sql  file found in the sql folder. I know were the folder is at and I see the file but it does not populate the tables or anything. When I select the database in HeidiSQL program is says SQL error (1049) unkown database.

[axeman]

I believe epoch.sql is a mySQL dump file. You want to restore it:

 

You can do this at command prompt with 

mysql.exe --user=root --pass=yourpassword dayz_epoch < C:\Arma2\sql\epoch.sql

Assuming dayz_epoch is the database name you are using and the path is correct to your epoch.sql, adjust as necessary. Might need quotes around the path if it has any spaces in.

 

If you use a custom port on your mysql server add (after password)

--port=customportnumber

Am pretty sure mySQL workbench will do this in the GUI. Have found it has some other issues though which is why I still use mySQL Administrator..