LSP Installation

1. Obtain a tarball of the SQL database
2. Clone the LSP source code
3. Extract the LSP source code to the future location, i.e. DOCUMENT_ROOT/public/lsp/
4. Create an LSP database

mysql
#     or
mysql -u root -p
#     ^--- (Depends on OS) 
create database somedatabase;
exit;

1. Extract the SQL dump to a temporary location.
2. Import the SQL dump

mysql [-u root -p] somedatabase < lsp_dump.sql

1. Create a mysql user for LSP

create user 'someuser'@'localhost' identified by 'P@SSW0RD';

1. Grant someuser permissions on somedatabase

grant all privileges on somedatabase.* to 'someuser'@'localhost'

1. Edit lsp/dbo.php

$DB_TYPE = 'mysql';
$DB_HOST = "localhost";
$DB_USER = "someuser";
$DB_PASS = "P@SSW0RD";
$DB_DATABASE = "somedatabase";
$PAGE_SIZE = 10;
$TMP_DIR = '../../../';	// "tmp" is added automatically
$DATA_DIR = '../../../';
$LSP_URL = 'http://lmms.io/lsp/index.php';

Under construction