SM_PAGE_TITLE

PBXware 2.x
Administration Manual
End User Guide
Install Guide
FAQs
How To Guides
  General
  Backup & Restore
  Codecs
  Conferencing
  Conf Files
  Destinations
  DID
  Extensions
  IVR
  Licencing
  Monitor
  Music On Hold
  MySQL
  System Daemon
  OSC (Online Self Care)
  Protocols
  Providers
  Queue
  Networking
  Reports
  Servers
  Setup Wizard
  Sounds
  System
  SSH
  TFTP
  Trunks
  UAD
  Voicemail
  Zaptel
  Agents
  Enhanced Services
  Fax
  Cabling
  Presentation
  SM Settings
Troubleshooting
Sqlite

To run PBXware sqlite do:

 

1. Login to PBXware using SSH protocol

 

2. Navigate to 'pbxware' directory 'cd /home/servers/pbxware/'

 

3. Execute 'sh/sqlite'

 

4. Manually edit sqlite database

 

5. To quit execute '.quit;'

 

 

 

Options available once editing sqlite database:

 

.databases                List names and files of attached databases

.dump ?TABLE? ...        Dump the database in a text format

.echo ON|OFF                Turn command echo on or off

.exit                        Exit this program

.explain ON|OFF        Turn output mode suitable for EXPLAIN on or off.

.header(s) ON|OFF        Turn display of headers on or off

.help                        Show this message

.indices TABLE                Show names of all indices on TABLE

.mode MODE                Set mode to one of "line(s)", "column(s)", "insert", "list", or "html"

.mode insert TABLE        Generate SQL insert statements for TABLE

.nullvalue STRING        Print STRING instead of nothing for NULL data

.output FILENAME        Send output to FILENAME

.output stdout                Send output to the screen

.prompt MAIN CONTINUE Replace the standard prompts

.quit                        Exit this program

.read FILENAME                Execute SQL in FILENAME

.schema ?TABLE?        Show the CREATE statements

.separator STRING        Change separator string for "list" mode

.show                        Show the current values for various settings

.tables ?PATTERN?        List names of tables matching a pattern

.timeout MS                Try opening locked tables for MS milliseconds

.width NUM NUM ...        Set column widths for "column" mode


 
End User Pricing
Unlimited stock
Please register

Store
PBXware
gloCOM
Bicom Systems
Software
Press Releases
TELCOware
Telephony Billing
Solutions
Appliances
SERVERware
Support Categories
  Search
  PBXware 3.x
  PBXware 2.x
  SERVERware
  outCALL
  Sound Converter Wizard
  PWmobile
  Appliances
  TELCOware
  Site manager
  gloCOM
  Call Centre Applications
  Customer Help Desk
  Presence Panel
  sipMON
  Troubleshooting
  Need Help With Support
  NEW!!! Bicom Systems documentation on Wiki
Hardware
SIP Security
SIP Monitoring
Softphones
Work Preview
Financing Options
Content
Working at Bicom Systems
Invoicing
Trade Shows
Click here - SALES Click here - SUPPORT
Privacy Policy Copyright Bicom Systems 2003 - 2025


Bicom Systems at Twitter       Bicom Systems at Facebook   Bicom Systems at Flickr   Bicom Systems at Voip-Info   Bicom Systems at FierceVoIP