Skip to content

SQL

Note

This area of the Gambio Admin is only available in self-hosted shops.

Under Toolbox > SQL you have the option of entering and executing database queries directly. By default, the MiniSQL view of phpMiniAdmin is used for this. Older shop versions sometimes still have a simplified view. Here, however, when outputting larger amounts of data, the view may become shifted so that the column headings can no longer be assigned correctly. Therefore, please preferably open the MiniSQL view via the MiniSQL tab, if it is displayed.

Note

In the following, we describe the MiniSQL view that is common in current versions.

Attention

Only enter commands and queries whose effects you know exactly. Resulting changes to the database cannot be undone!

Above the input window, there are several links under which predefined commands are stored, as well as a dropdown menu for selecting the database:

  • phpMiniAdmin [version number]: redirects to the phpMiniAdmin for MySQL page, the page is loaded in a new window/tab
  • Databases: executes the command ‚show databases‘
  • show tables: executes the command ‚show tables‘
  • status: executes the command ‚show table status‘
  • export: export the entire database
  • import: import a database
  • settings: opens the connection settings
  • phpinfo: opens the phpinfo

Enter the desired query into the text field, please note that multiple queries must each be separated from one another by a semicolon, and execute them by clicking on the Go button. Below the input window, the number of affected records and the execution time are output. Output appears below the second, dashed line. Clicking on Clear empties the input field.

Attention

Changes to the connection settings may, under certain circumstances, cause the shop database to no longer be reachable.

If you perform a database import, the existing shop database will be replaced. All data stored there will be irretrievably lost.