EXPORTSQL export files created from the Data Explorer main page contain a create table statement for every exported table and an insert into statement for every exported row.To export multiple tables at ones, select the desired tables, select Export Table from the...
Data Explorer
Posts under the "Data Explorer" category
Navigation
Show Data Explorer getting started page Show What's new? page (red if news is available, blue after reading) Starts the Data Designer Allows to (de)select listed columns Allows to upload SQL files (uploads ZIP files containing multiple SQL files if ZipArchive is...
Getting started
The Data Explorer allows plugin users to perform data and database related tasks directly from the WordPress dashboard. Tables, columns, indexes and foreign keys can be viewed inline. Common DDL actions, SQL and CSV imports, as well as table and row exports in several...
Settings
WP Data Access > Data Explorer > Manage > SettingsThis is a very powerful feature which allows plugin users to add a layer around a table or view. Settings defined for a table or view are available to all plugin tools (Data Explorer, Data Tables, Data...
Transfer to other WP DB
Attended as well as scheduled unattended exports to SQL allow plugin users to exchange tables between WordPress databases that use different table prefixes. The WordPress table prefix of the WordPress source database is replaced during export by environment variable...
Data Backup
Backup Navigate to WP Data Access > Data Explorer > Data Backup Select the tables you want to backup Define a unique backup id Select your backup location (backup to local or dropbox folder) Define a backup interval or select Run once Define the number of backup...
Import CSV & SQL files
Import CSV file Import SQL or ZIP file from Data Explorer main page Import SQL from Data Explorer table page Import CSV file Upload CSV file Perform column mapping Import CSV file Use reload to import an updated CSV file and prevent the need to remap table...
Manage tables & views
Click on the Manage link of a table or view on the Data Explorer main page to get access to table and view structures. Tables and views have different tabs and action buttons. Example of Table LayoutExample of View LayoutTabs Actions Available for tables and views....
Explore tables & views
The Data Explorer allows you to administer any table in your WordPress database. The following features are available: View, insert, update and (bulk) delete rows (List tables) (Data entry forms) Import (SQL and CSV) and export (SQL, XML, JSON, Excel and CSV) rows...
Recent Comments