Jump to content
AC Tool Forums
Sign in to follow this  

Step 2b: Setup & Import ACE into MariaDB


Setup & Import ACE into MariaDB

1: Open HeidiSQL (MariaDB uses HeidiSQL) and click on “New” to create a session.

mariadb-13.png

2: Name the session name ACE.

mariadb-14.png

3: Type in a password for the root account and click “Save” then click “Open”.

mariadb-15.png

4: Now HeidiSQL should open and present you with this.

mariadb-16.png

5: Right mouse click in an open area of the left pane and hover over Create New then click on “Database”.

mariadb-17.png

6: Type in ace_auth and click “OK”.

mariadb-18.png

7: Right mouse click in an open area of the left pane and hover over Create New then click on “Database”. Type in ace_shard and click “OK”.

mariadb-19.png

8: Right mouse click in an open area of the left pane and hover over Create New then click on “Database”. Type in ace_world and click “OK”.

mariadb-20.png

9: For importing you should use the MySQL Client (MariaDB) command line as it will be faster and not get stuck.

mariadb-21.png

10: Type in the password you set for the root account.

mariadb-22.png

11: Extract the latest ACE-Master https://github.com/ACEmulator/ACE

download-ace-2.png

and the latest World Database https://github.com/ACEmulator/ACE-World-16PY-Patches/releases/latest place them on the root of C:\ for ease of use.

download-world-db.png

12: Type in use ace_auth and then type in “source c:\ACE-master\Database\Base\AuthenticationBase.sql” without the quotes and press Enter.

mariadb-23.png

13: Type in “use ace_shard” without the quotes and press Enter.

14: Type in “source c:\ACE-master\Database\Base\ShardBase.sql” without the quotes and press Enter.

mariadb-24.png

15: Type in “use ace_world” without the quotes and press Enter.

16: Type in “source c:\ACE-master\Database\Base\WorldBase.sql” without the quotes and press Enter.

mariadb-25.png

17: Be sure to follow the same steps above for importing any updates that reside in the

18: Type in "use ace_auth" without quotes and press Enter and import anything found in c:\ACE-master\Database\Updates\Authentication

19: Type in "use ace_shard" without quotes and press Enter and import anything found in c:\ACE-master\Database\Updates\Shard

20: Type in "use ace_world" without quotes and press Enter and import anything found in c:\ACE-master\Database\Updates\World

21: Type in "source c:\ACE-World-Database-vx.x.xxx.sql" without quotes and press Enter. NOTE – This one will take a bit to finish.

 

Install Visual Studio

Tutorial Videos

Optionally you can add videos from Youtube or Vimeo to your tutorial



Recommended Comments

There are no comments to display.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Add a Comment

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use and to our Privacy Policy.