TestingDocs.com
Software Testing website
  • Automation
    • Selenium
    • JBehave Framework
  • Tutorials
    • MySQL Tutorials
    • Testlink
    • Maven
    • Git
  • IDEs
    • IntelliJ IDEA
    • Eclipse
  • Flowcharts
    • Flowgorithm
    • Raptor
  • About

TestLink Tutorial

TestLink Database Schema

Introduction

On this page, we will discuss the TestLink database schema. TestLink database schema is complex and contains a lot of tables in it. As of Testlink 1.9.x version, it contains 58 tables as shown in the picture.

 

TestLink Database Tables

Steps to connect:

Connect to TestLink MySQL instance.

/> mysql -u <username> -p

Enter password for your MySQL instance.

Use the TestLink database.

/> use <database_name> ;

Show tables.

/> show tables ;

To know about a specific table structure to know about the columns and the type and constraints, you can describe the table with the below command.

/> desc <tablename> ;

For example:

/> desc users;

 

Table structure

Rows in a Table

To know the number of rows in a table, you can use the below SQL query

/> select count(*) from users;

mysql> select count(*) from users;
+———-+
| count(*) |
+———-+
| 1 |
+———-+
1 row in set (0.06 sec)

 

Back-end testing and integrity checks of the TestLink database instance will be useful in case you have migrated or upgraded the TestLink.

MySQL Workbench

MySQL Workbench is GUI ( Graphical User Interface ) tool for MySQL database. It allows you to browse, create and design databases. Using this tool you can run SQL queries and work with database objects.

For example, to view the plugins

SELECT * FROM <testlink_schema>.plugins

Workbench tool automatically prompts for the query code. The tool prompts to select the list of databases. After selecting the database, the tool prompts the list of tables.

 

MySQL Workbench TestLink

Workbench migration wizard will also allow you in migrating database. You can use this tool to copy a database from one instance to another. To get a better picture of the entire database schema, we can use MySQL Workbench tool to generate the ER diagram.

 

TestLink Database Schema

DB Configuration during install

https://www.testingdocs.com/mysql-testlink-database-configuration/

DB Schema Backup

https://www.testingdocs.com/questions/how-to-setup-cron-for-testlink-db-backup/

Links

TestLink Tutorial on this website can be found at:
https://www.testingdocs.com/testlink-tutorials/

More information on TestLink Open source Test management tool can be found on the official website at: http://testlink.org

Related Posts

TestLink Bitnami Cloud Image

TestLink Tutorial /

TestLink Bitnami Cloud Image

Apache Server Configuration

TestLink Tutorial /

TestLink REST API Apache Server Configuration

TestLink Install on Domain

TestLink Tutorial /

Install TestLink Software via CPanel Platform

Test Suite Import Export TestLink

TestLink Tutorial /

Import/Export TestSuite in TestLink

TestLink Tutorial /

Commercial Alternatives to TestLink Tool

‹ Create Test Suite in TestLink› Different Types of Software Requirements

Recent Posts

  • MS Access Data Types
  • Install RAPTOR Avalonia on CentOS
  • Download RAPTOR Avalonia Edition on Windows
  • npm doctor command
  • Build & Run CLion Project
  • Create New CLion C Project on Windows
  • Configure CLion Toolchains on Windows
  • Launch CLion IDE on Windows
  • Activate CLion IDE
  • CLion IDE for C/C++ Development

Back to Top

Links

  • Contact
  • Privacy Policy
  • Cookie Policy

www.TestingDocs.com

Go to mobile version