Main page Up Main page Part I: MySQL administration via NodeWorx 

Preface

Databases are the fundamental data storage mechanism for web applications today on the internet. The InterWorx hosting control panel supports the web’s most ubiquitous database server, MySQL. It’s an open source SQL relational database server currently maintained by Oracle Corporation. Due to it’s wide deployment and integration, most users feel comfortable using the MySQL database system. In addition, the online documentation for the software is very robust, making it easier than ever to become an expert in the database system.
In order to get the most out of this guide, we recommend that a server administrator have some experience with the following:
  • Linux command-line
  • Starting/Stopping daemons using /etc/init.d/servicename or the “service” command
  • Basic SQL queries (SELECT, INSERT, UPDATE, DELETE)
  • phpMyAdmin
  • MySQL server administration knowledge (/etc/my.cnf, /var/lib/mysql/*, mysql CLI client, mysqldump, mysqlcheck)
If you don’t have experience with one of the above items, you can still probably get use out of this guide, albeit with perhaps occasionally relying on Google to look up unknown terms or proper use of a piece of software. We try to leave most of the explaining of how MySQL works to the MySQL documentation and instead try to provide documentation here that is useful to an InterWorx server administrator.
 Main page Up Main page Part I: MySQL administration via NodeWorx 

(C) 2017 by InterWorx LLC