How to access database of Sitebuilder

Created:

2016-11-16 12:55:25 UTC

Modified:

2017-08-16 17:08:10 UTC

0

Was this article helpful?


Have more questions?

Submit a request

How to access database of Sitebuilder

Applicable to:

  • Plesk Sitebuilder for Linux
  • Plesk Sitebuilder for Windows

Question

How to access database of Sitebuilder?

Answer

To access mysql database of Sitebuilder 4.5 for Linux

  1. Login details for Sitebuilder database are stored in the configuration file /usr/local/sitebuilder/config ( /opt/sitebuilder/config for Debian/Ubuntu):

    [database]
    adapter = PDO_MYSQL
    dbname = sitebuilder3
    emulate_prepares = 0
    host = localhost
    password = ********************
    port = 3306
    username = sitebuilder_db
  2. Login to the database using host , username , password , port and dbname :

    # mysql -hlocalhost -usitebuilder_db -p3306 -p******************** sitebuilder3
    

To access SQL Express 2005 database of Sitebuilder 4.5 for Windows

  1. Database properties are shown in the registry key:

    HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SWsoft SiteBuilder for Windows
    

    Remember values:

    DBNAME
    SQLSERVER
    WSB_SQLUSER
    WSB_SQLPWD
  2. Download SQL Server Management Studio Express and install it on the server.

  3. Start the tool, put values received from the registry into Connect to Server fields:

    Server name: <SQLSERVER>
    Authntification: SQL Server Authentification
    Login: <WSB_SQLUSER>
    Password: <WSB_SQLPWD>
  4. Go to Databases > <DBNAME> > Tables to access the database of Sitebuilder.

    Use New Query and Execute to manage the database.

Have more questions? Submit a request
Please sign in to leave a comment.