1. Home
  2. Docs
  3. Index
  4. Data Explorer
  5. Database administration

Database administration

Please note that there are two different types of Data Explorer pages:

  1. The Data Explorer main page to manage your WordPress database
  2. The Data Explorer tables pages to manage your table data

This section explains how to work with the Data Explorer main page to perform database administration tasks.

 

Data Explorer Main Page

The following features are available from the Data Explorer main page:

  • Explore tables and views
    See Data Administration.
  • View tables and view structures
    Use the Manage link.
  • Export table(s)
    Use the Manage link to export an individual table. Select the Actions tab and click on the Export button. Individual tables can be exported to SQL, XML, JSON, Excel and CSV.
    To export multiple tables select the tables to be exported, select Export Table(s) from the bulk actions menu and click on the Apply button. Selections of multiple tables can be exported to SQL only.
  • Import table(s)
    Click on the Import button at the top of the screen and follow the instructions.
  • Rename tables and views
    Use the Manage link to rename a table or view click. Select the Actions tab and rename the table of view.
  • Copy tables
    Use the Manage link to copy a table. Select the Actions tab and copy the table either with or without data.
  • Truncate table
    To truncate a table click on the icon, select the Actions tab and truncate the table.
  • Drop table or view
    To drop a table or view click on the icon, select the Actions tab and drop the table of view.
  • Optimize table
    To optimize a table click on the icon, select the Actions tab and optimize the table.
  • Alter tables
    Use the Manage link to alter a table click. Select the Actions tab and alter the table. This action will load the table structure into the Data Designer.
  • View table indexes
    Use the Manage link to view indexes. Select the Indexes tab.
  • View or copy SQL create table and view statements
    Use the Manage link to view or copy table and view definitions. Select the SQL tab.
  • Mark tables and views as favourites for quick access
    Click on the star icon for the table you want to add to your favourites. Click again to remove. Choose from the listbox on the top of the screen if you want to see all tables, favourites only or only non favourites.

NOTES

  • WordPress tables are protected by default. For obvious reasons it’s not possible to drop, truncate or rename WordPress tables. Individual records of WordPress tables can be updated and deleted (see next section). Access to individual tables and views can be limited under plugin settings as well.
  • For obvious reasons not all actions on the Actions tab are available for views (cannot truncate a view for example).

Was this article helpful to you? Yes 1 No

2 Replies to “Database administration”

  1. Installed WP Data Access to siteground site.
    Entered basic table info (event_vendors)
    Click on Create table and I get a dialog with:
    Create database table “?
    Does not create indexes!

    I have entered event_vendors for the table name and added
    and id column, company column, and name column.
    Trying to see if this plugin will allow me to create a couple of tables that will
    track vendors that are registering to have a booth a given conference.
    But, I can’t get past this error.
    I have gone as far as supplied around 20 columns, specifying the column type, key, mandatory, max length, default value for the column and it is ever does create a table…Only the 1st column is ever registered. I’ve tried this at least 15 times without success. Only once did a table get created – when I prefixed it with “wp_”…but it only had the id column.

  2. Hi Jeff,

    This is just a message to inform you that the plugin will create the table, but it won’t create any indexes. In your case this does not make any difference since you have no indexes. You only have a primary key (on your id) which will be created when you create the table. Just keep in mind that you will need to create indexes separately.

    How to continue:
    Click button CREATE TABLE and click OK. The table will be created. You can check the result in the Data Explorer. After that you can use your table in a Data Project of Data Publication.

    Hope this helps! Let me know if you need more assistance.

    Best regards,
    Peter

Leave a Reply

Your email address will not be published. Required fields are marked *