Joyent

Translations of this page:

Manage SQLite databases

Creating a SQLite database

To create a new database through Virtualmin, do the following:

Database names can only contain alphanumeric characters and underscores. Other characters, like periods, will cause an error.

  1. Sign in to Virtualmin (see Account logins and important URLs).
  2. Select a domain from the drop-down in the left-hand navigation (your main domain should be already selected when you first login to Virtualmin). This is the domain that you'll add a new database to.
  3. Click Edit Virtual Server
  4. Click Enabled features and then select Allow SQLite databases?
  5. Click Save Virtual Server. SQLite databases have now been enabled for this domain.
  6. Click Edit Databases in the left-hand navigation. You should now see a list of your current databases on the Edit Databases page.
  7. Click Create a new database.
  8. In the Database name field enter a name for your database
    • Database names will automatically be prefixed with your main user name. On secondary domains, the first part of the domain name is inserted as a second prefix after the user name (e.g., username_domainname_dbname ).
  9. For Database server type, select SQLite.
  10. Leave Character set for MySQL database as the default value.
  11. Click Create Your database has now been created.
  12. Click Return to database list to see your list of databases

You should now see your newly created database listed under Database name.

Deleting a SQLite database

To delete a database through Virtualmin, do the following:

  1. Sign in to Virtualmin (see Account logins and important URLs).
  2. Select a domain from the drop-down in the left-hand navigation (your main domain should be already selected when you first login to Virtualmin). This is the domain that you'll add a new database to.
  3. Click Edit Databases. You should now see a list of your current databases on the Edit Databases page.
  4. Select the database you want to delete from the left-hand column and click Delete Selected. You will now see a confirmation screen verifying that you want to delete this database.
  5. Click Delete Now Your MySQL database should now be deleted. Click Return to database list if you wish to return to your list of databases for this domain.
 
shared/kb/manage-sqlite.txt · Last modified: 2007/08/05 18:31 by christopher
 
Recent changes RSS feed Creative Commons License Driven by DokuWiki