> For the complete documentation index, see [llms.txt](https://lees-plugins.gitbook.io/onestopshop-2/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://lees-plugins.gitbook.io/onestopshop-2/mysql-guide.md).

# MySQL Guide

## Overview

When MySQL is enabled it'll copy the parent server's plugin data, this incudes menu items, interface items, shop items, stock and restock time. Dynamic shop mode is also supported with MySQL. Any changes need to be done on the parent server, any changes made on the parent server will reflect on all connected servers.

## How to setup MySQL

1. Open the `config.yml`.
2. Under the `mysql` key change `enabled` to `true` and input your MySQL database details.
3. If this is the parent server also make sure the key `parent-server` is set to `true`. For all other servers connected to this database, change it to `false`.
4. Restart server, do not reload.
5. If you didn't get any errors on startup you successfully setup MySQL for this plugin.

## How To Update Child Servers To Parent Server

1. When you've made a change to the parent server, like adding or removing items, you'll want to run the command `/shop updatedatabase` to push those updates to the MySQL database. You can also simply restart the server.
2. When this is completed you can now run `/shop reload` on the child servers to apply the update. You can also simply restart the server.
3. You should now see the updates from the parent server on your child server.