Wp Database Table

Mar 06, 2008 · This is a fairly common issue in older WordPress installs because the MySQL database default is commonly Latin-1, and older versions of WordPress did not specify the character set when creating the database tables (so they would default to Latin-1) and the default encoding in the WordPress settings is UTF-8. The New Database Tables which appear in WordPress Multisite. wpDataTables is a best-selling WordPress plugin which makes your work with tables, charts and data management easy. And you can make the table mobile responsive. The wp_options table is one of the most important WordPress database table and stores all the settings of a WordPress site like the URL, the title, installed plugins, etc. Nov 18, 2015 · WordPress adds special class to all post or page and you can use it to style table on specific page. May 16, 2013 · You can do a find and replace for text or html code on a post or page across a whole WordPress site by using the mysql database that the site stores all its data in. The problem came up was number of tables doesn’t have any primary key and they were not ready to create any type of Keys on the table. #1 Tables & Charts Creator WordPress Plugin. The database structure and the diagram below were last updated in version 4. It’s easier if you don’t have another system that’s relying on. Although the table is standard in the Information Schema, all but TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE, ENGINE and VERSION are MySQL and MariaDB extensions. As a result, your WordPress site would have broken and we need to quickly make the change in the configuration file! Changing wp-config. In order to store additional WordPress user data, the wp_usermeta table is used. A table is an arrangement of columns and rows that organizes and positions data. On the left, select the database that contains the table that you want to export. WordPress is one of the most commonly used blogging engines and can be quite cumbersome to resolve issues when trying to set it up on Azure Websites. php file and insert the same values as in the wp_options table. Useful when you want to bulk upload data from your CSV file (e. May 16, 2018 · Export database tables; Export an entire database; Export database tables. Sep 27, 2018 · To know what to fill there, you have to open your database. Tables have never been something that WordPress is particularly good at. Aug 26, 2015 · Either change your WordPress setup (in wp-config. Mar 12, 2019 · “Table” Responsive from Pablo García Fernández is a stunning execution of what the modern CSS3 standard (and also HTML5) is able to bring to the table. WP/14/118 Deposit Insurance Database Asli Demirgüç-Kunt, Edward Kane, and Luc Laeven Table 2 reports these coverage limits both in reported (typically. Then: Modify the wp_users Table. On the Tools page click on the Diagnostic tab. If that does not resolve the issue and the visitors table is the only table listed, you may want to check your MySQL version. In the left pane, click the name of the database that you want to work on. redirects) Jan 31, 2019: This is the final release of Wikistats-1 dump-based reports. php file which holds the database information. To help you get started, we're going to cover some of the best WordPress Database Plugins - designed to make your life easier and your website faster. Displaying MySQL data on Wordpress page, in a table I have a table on a wordpress page that acts both as a form for accepting inputs, and displays information from the database that the inputs are being stored in. WordPress Multisite database tables explained. php where the individual methods are documented. Jan 20, 2016 · Working with Databases in WordPress. It's easier if you don't have another system that's relying on. is_active Defines if the feed is active or not. In the list of tables, click the table name ending in options. Click here to see the back-end configuration, here to see the documentation for responsive tables, and here for documentation on editable tables. If you want to display a chart rather than a table, then WP Table Manager can help. Conclusion. The WordPress database class and the other various APIs available make it pretty easy to interact with the WordPress database but often times you need to go a step further and create a custom API specific to your plugin's database tables. Comparison of information is also rightly done using tables. To display a list of posts, you have to use the WordPress loop. Despite the rising incidence of childhood obesity, international data from Eurostat show that the prevalence of obesity among those aged 15–19 years remains under 5%, which offers an important. The following is an example of a typical WordPress loop structure. For example, the following image shows the example_wordpress database selected: In the right pane, select the check boxes for the tables in the database that you want to repair. Each time someone logs into your website, their credentials are checked against a specific database entry. * Database connection test script for WordPress * * Parses the wp-config. Jul 25, 2015 · The s2Member plugin uses the WordPress database to store all data; there are no s2Member-specific database tables. Oct 17, 2019 · If you are not interested in using plugins, insert HTML tables in your pages. At the moment the items appear in the order they are defined in the code since the WP_List_Table class does not contain any code for sorting. And no, I haven't forgotten about the. Use MySQL queries. So, there's no way to use custom tables with WP with zero coding. Their relationships are almost the same. Jul 11, 2011 · Open the WordPress database file (*. com WordPress. You imported the SQL file in the proper database, but table prefixes are wrong. This tutorial explains how to access the MySQL Shell, how to create and delete a new database, how to create and delete a new table, and how to add, delete, and up. Aug 31, 2014 · Duplicate a MySQL table – Copy Table / Duplicate Database / PHP Script August 31, 2014 15 Comments database , php , programming languages , sql , tricks , web programming Suppose if you want to copy a Table to another, this can be done in MySQL with two steps. Character set and Collation defines how the data is stored in the database and how it is read. На базе этого класса выводится все виды таблиц в админ-панели WordPress. wp_term_taxonomy: Contains the taxonomy definitions for the data stored in the wp_terms table. The ID field from the users table and the user_id field from this table are used to link the record of the same user. Note: Table names in your WordPress database may have a different table prefix than the one we are showing in our screenshot. • The insertion of new information into the database. Jan 28, 2019 · The new wp_blogmeta table is a global table in WordPress and developers should be cautious not to overuse it. php script to the root directory on your server or access your database using hosting cpanel PhpMyAdmin tool. Posts, pages, comments, shortcodes, plugin settings… absolutely everything. On installation, wordpress creates some database tables. Use options when the data concerns only the site itself. It's located in the Database info section. We use a wpdb class to interact with a database in WordPress. I called mine "wordpress". Use MySQL queries. 3% of the top 10-million websites on the Web and has more than 60-million websites in total. The plugin will look for other tables in the same database. replace – This function is used to replace a row in the database table. Simple_Query is very similar to how Pippin handles custom database tables in his plugins Easy Digital Downloads, and Affiliate WP. Name the file as connect. Once inside the phpMyadmin look to the left hand sidebar and click on your specific wordpress database. product details) to the WordPress database (MySQL) in one go. Dec 03, 2019 · By default, WordPress database table prefix is wp_. With a single click, you can transfer any table to Ninja Tables. Useful if you need to make corrections, perform actions in bulk, or want to create a plugin. You can think of a table as a storage container for one type of data, so your data is kept organized by keeping different types of data in different tables. SSH to your Database server as root and login to MySQL as Root :. Once you have WordPress up and running the first step is creating the new table in our WordPress database. WordPress database error: [CREATE command denied to user 'danielkaim_7'@'10. 7 and up (tested to 5. * Errors will be reported. Take a fresh backup of your website. MySQL is free and open source like WordPress and also best work with other open source software like PHP, Apache web server etc. Jan 17, 2018 · Databases are compilations of ‘tables’ that contain large sets of information. All other objects on each Numbers sheet were placed on separate worksheets. Mar 13, 2019 · Click the table named wp_options. So, there's no way to use custom tables with WP with zero coding. Login to you hosting account and locate “phpMyAdmin” tool which is used to maintain your WordPress database. Conclusion. Caggiano CFRI- 1701 March 2017. Here’s how Gravity Forms is structured within your database: Note: This structure applies to Gravity Forms version 2. On the Tools page click on the Diagnostic tab. The rules say that this is a game for 6+, and I think this is fair. This is a problem when you migrate the site to another domain name, or add an SSL certificate because clicking on links redirect back to the old site, or non-secure version. • The deletion of information from the database. WordPress defines a class called wpdb, which contains a set of functions used to interact with a database. Mar 06, 2018 · WordPress uses a MySQL database to store all of your website’s content. This means that the moment your database, or any table in the database, is corrupted (in laymen terms, it means your. Click on Yes to drop (delete) the table. All the options that you set in Settings in your Dashboard are stored in this table. Oct 02, 2019 · The following database tables have been deprecated as of Gravity Forms 2. Oct 14, 2012 · SQL Query to Find All Table Names on a Database With MySQL and SQL Server Examples How do you find names of all tables in a database is a recent SQL interview questions asked to one of my friend. Before getting to the point I have to explain briefly some properties of the MySQL database parts that contain the information we need. For example, wp transient delete --all lets you delete one or all transients: $ wp transient delete --all Success: 34 transients deleted from the database. [Note: The table that crashed probably won’t let you export it, and will give you this ugly message: Table ‘wp_posts’ is marked as crashed and should be repaired]. Reviews for WP-Chatbot by MobileMonkey. MySQL is free and open source like WordPress and also best work with other open source software like PHP, Apache web server etc. You have two options for optimizing your database: Call our support number and one of our experts can do it for you for a fee. You’ll see how the columns within a record relate to the content you see in the WordPress back-end. Your database will be loaded and you will now see a list of your database tables. You need to carefully modify the database to reflect the new location of your site. WP CSV to Database plugin allows you to insert CSV file content into WordPress database. You can find the settings page in the WP Admin Panel » Optimize Database -or- via the WP Admin Panel » Optimize Database icon (depends on settings) Excluding specific posts/pages from deleting revisions. Aug 18, 2014 · How To Change WordPress Home And Site URL Via MySQL Database Servers With Google’s announcement that sites that implement HTTPS or SSL will get a small ranking boost, most webmasters are jumping onto the news and switching their blogs and websites to serve https traffic. php' script included in the default installation of this plugin, and retrieve the full contents of the user table in the WordPress installation. When you're running queries you should always use this class to execute them. Select the check box for the tables whose links you want to change, and then click OK. The WordPress backend is fantastic, and does allow you to manage and edit everything with ease, but only up to a certain point. Dec 24, 2016 · The WP DB Optimization Tool works for either MyISAM or InnoDB. When you install WooCommerce on the WordPress. Find, Search, Replace, and Delete in the WordPress Database The following was originally published on WordCast and authored by Lorelle VanFossen. Publishing has never been easier. To list/show the tables in a MySQL database: Log into your database using the mysql command line client; Issue the use command to connect to your desired database (such as, use mydatabase) Use the MySQL show tables command. Every character set has at least one collation. If you want to display content such as custom post types, custom fields or taxonomies, you will need to set them up beforehand and then display them using Posts Table Pro. Checking for Capabilities. php file for DB connection information and tests * a mysql connection to the DB server and selection of the database. Changing your WordPress table prefix is risky to implement and it does absolutely nothing to enhance your site security. wp db optimize: Optimizes the database. Select the check box for the tables whose links you want to change, and then click OK. The Data Projects tool helps you to create your own data driven WordPress apps that run in the WordPress dashboard or on your web pages. As a WordPress user, you probably realize that your website is essentially made up of three components: The WordPress core files; Your theme files. First let’s create a database and table with 3 rows. Ninja Tables is the Best Selling WordPress table builder plugin with a user-friendly layout, easy to use settings, and enticing front-end. These are the basic steps. It is also recommended that you try and keep the number of rows on your wp_options table to a minimum. During WordPress installation, it asks you if you want to change your database table prefix "wp_" to something. May 02, 2016 · The following tables are store WooCommerce products database : wp_posts-. May 16, 2018 · Export database tables; Export an entire database; Export database tables. Базовый класс для создания таблиц со списком чего угодно в WordPress. Here is a chart that compares feature of all popular WordPress database optimization & cleanup plugins: Do let me know which WordPress database optimization plugin you are using. Now your WordPress database has all the structure needed to migrate the custom tables. ACF Custom Database Tables ACF Custom Database Tables is an ACF extension plugin that makes it possible to store ACF data in organised, structured database tables instead of WordPress' core meta tables. Below is a syntax to covert character set ofwp_posts and wp_postmetatables. When you're running queries you should always use this class to execute them. org Plugin Page Custom DataBase Tables. In WordPress (WP), the meaning of Metadata is a bit fuzzier. WP CSV to Database plugin allows you to insert CSV file content into WordPress database. SQL WordPress Plugins: Accessing the Database from within WordPress In some sites more than others, I will find myself spending more time in the database or SQL side of the site as this makes for an incredibly efficient method to updating, restoring, or fixing data as opposed to using the WordPress admin interface. First step is, Connect to your database using PHP. It will help you to instantly start charging your users for access to your content. Note: When defining a WordPress SQL table prefix, make sure it's less than 20 characters. The Data Projects tool helps you to create your own data driven WordPress apps that run in the WordPress dashboard or on your web pages. MemberPress is an easy to use WordPress Membership Plugin. Here’s a couple queries you can use to achieve such results. Jan 14, 2015 · 1. Jan 13, 2009 · PHP Tutorial: Print All MySQL Database Tables & Fields Comments 17 Standard You are commenting using your WordPress. TablePress is a free and open source plugin for the WordPress publishing platform. Front Range Round Table 2016 Interagency Fuel Treatment Database Technical Report Prepared by the Colorado Forest Restoration Institute at Colorado State University on behalf of the Front Range Round Table Michael D. com pricing is simple -- We bundle hosting, domains, privacy, and security into one low price with plans for anyone. I currently have an old wordpress blog that I need to import post from this old blog into a new wordpress database. How to Find Your WordPress Database Name. Click on Yes to drop (delete) the table. This will display your WordPress database tables where you need to browse next to wp_users table. If you have to deal with a lot of customers or clients, it can pay off to keep track of their basic data in one convenient place. Super Impressed and Super Easy 2 setup ⭐⭐⭐⭐⭐ This is simply the best plugin for quick chat directly connected to your Facebook page chat. The importer can get images and data into plugin/theme fields or anywhere else you need it. (What's New on 3. However, there are better solutions available for creating tables in WordPress. In the menu to your left, click wp_options to open the options table. Optimizing WordPress is always been my goal. 14 Best Free Responsive WordPress Table Plugin (2019) in United States A comprehensive list of 14 Best Free Responsive WordPress Table Plugin (2019) according to 2282 users. SNAP adds two tables to the WordPress Database. 3% of the top 10-million websites on the Web and has more than 60-million websites in total. How to Optimize WordPress Database? Is there any complete guide? Well, try following this tutorial and I bet, you will see better site loading performance after that. By creating an action on a report that calls itself you can pass values to hidden parameters and then use those parameters in stored procedures that are called from a dataset to…. Custom DataBase Tables. Database tables have the wp_ prefix by default. Dec 28, 2016 · There is an idea that was popularized a few years ago that if you change WordPress table prefix in your database, it helps protect your WordPress website from attackers. Think of it as a file cabinet where you store data in different sections called tables. WordPress is no doubt the best content management system (CMS) for various reasons. It allows you to create both small and very large databases, and to create, read, and edit data in these databases quickly and effectively. Build beautiful forms fast with our drag & drop WordPress form builder! Toggle navigation. This includes your posts, pages, but also the smaller elements, such as the title of your site, the layout of your widgets, the color settings, and etc. Categories and tags for posts. wp_icl_languages. If that does not resolve the issue and the visitors table is the only table listed, you may want to check your MySQL version. * * Place this file in the same directory as wp-config. This is the minimal version of a WP_List_Table possible: Download minimal WP_List_Table example (gist) Sorting. Jan 18, 2012 · You must first create a "Database Link", which is a schema object that allows you to access objects in one database, from another. To display a list of posts, you have to use the WordPress loop. Click on the name of your database to expand the list of the tables and select wp_users table: 5. Jul 26, 2012 · If you’ve ever had the need to find the name of your WordPress database, then there’s an easy way to do that – simply look for it in your wp-config. If you have auto_increment field set for MySQL table then it is very easy to get details of last row in that table. Aspire Public Schools Careers - Art Teacher, Elementary. Below is a syntax to covert character set ofwp_posts and wp_postmetatables. After submitting “ Add” button it will send you to “Table Rows” tab. Mar 06, 2018 · WordPress uses a MySQL database to store all of your website’s content. The WordPress database class and the other various APIs available make it pretty easy to interact with the WordPress database but often times you need to go a step further and create a custom API specific to your plugin's database tables. In short, all your content (such as options, posts, comments, and so on) is stored in a MySQL database in […]. In that folder there is a file called wp-config. From something basic and clean to more advanced variations, there is a free table for everyone. In the admin menu click WP Cerber-> Tools. We usually skip this thing, so WordPress automatically creates a database with its default table prefix “wp_”. Cleaning Up Left Over Plugin Database Tables Unlike traditional website platforms which run purely on HTML, WordPress includes both files and database tables. WordPress adds some prefixes to your database tables. Feb 20, 2015 · wp_postmeta. Apr 15, 2018 · Therefore you need to make sure to copy only the relevant tables which contain the WooCommerce products data. There are two main steps to this process: Load the items from the database using the WP_Query function. Discover WP Rocket. League Table (Premium) League Table is yet another powerful WordPress table plugin with extensive customization options and ultra-responsive design. The standard installation of WordPress creates the underlying database and tables. Just another WordPress. The wp_users table in the WordPress user database is designed to store only the basic information of users. DemoTable ( id int, col1 varchar(4000)) GO -- Insert 3 rows = 2 pages INSERT INTO dbo. 30,000+ companies and individuals already trust this WordPress tables plugin to work with financial, scientific, statistical, commercial and other data. Products are located mainly in 2 tables: wp_posts table with a post_type product or product_variation, wp_postmeta table with the corresponding post_id by product (the product ID). Some of the plugins provide separate options to replace the site URL and to change the URL in all the database tables. May 02, 2014 · Learn how to optimize WordPress’ wp_options table for faster database results. In this article, we’ll see how to generate some native admin tables the right way. Do whatever you want – create, edit, maintain and customize. Updated on August 28, 2019. But with a proper guide, you can't go wrong. WordPress development tool for non-devs. Generate list tables based on the WP_List_Table class to support standard WordPress list table layout and user. Now You can transfer Data Tables Generator by Supsystic from Ninja Tables -> Import a Table -> Import From Other WP Table Plugin and select “Data Tables Generator by Supsystic” that will show all the Supsystic Tables. Jan 29, 2019 · Tables have never been something that WordPress is particularly good at. Perhaps you’ve simply read metadata from the database, or maybe you’ve both written to and read from the database table, as well. You can use wp_cache_set() and wp_cache_get() with your persistent caching tool of choice. I show the most important ones and give some small examples. To create a database and set up tables for the same use the following sql commands:. Note that the posts tables is used by Custom Post Types, and WooCommerce uses those for products, coupons. I've had a Wordpress site for a time but neglected it, and am just now learning Wordpress. First, launch the phpMyAdmin and select your WordPress database. id Contains the unique feed ID. The following is an example of a typical WordPress loop structure. If you have been using WordPress for a while, then you should think absolutely about a clean up. Facebook page link: https. Jun 23, 2017 · Tables are important for any website to showcase information in a user-friendly way. Create Database Tables. Exporting the WordPress database is a daunting task for many people. Basically, if you want to showcase data tables in WordPress, you'll most likely end up crafting the whole presentation by hand - using raw HTML and CSS to make everything look good. The usermeta table is updated. Jan 27, 2015 · When you export the database, make sure you check the "Add DROP TABLE / VIEW / PROCEDURE / FUNCTION" setting. 3 compatible). Login to you hosting account and locate "phpMyAdmin" tool which is used to maintain your WordPress database. You can also verify that this is the correct database by ensuring that it contains your WordPress site's URL. Thereafter, we decided to factorize it into an. MySQL Cluster CGE. T-SQL – Search a Database for all Table Columns with a Text Value 2013-01-03 Justin Cooney There are times when it comes in handy to be able to query all columns of all of the tables in a database for a particular text match. UI to add existing tables that are unclaimed by other modules to Data's table management. A huge collection of 3400+ free website templates, WP themes and more at the biggest community-driven free web design site. designed to work with database tables in all types of applications. If you are also a user of the Advanced WordPress Database Cleaner plugin, let me know your experience. wp_postmeta. By default, the prefix is "wp_", but you'll need to check on the actual value and use it to define your database table name. We always recommend running the most up-to-date version, but we also support older installations: WooCommerce – 3. Truth be told, regular WordPress users don't really ever have to dig into the database unless they want to. php to reflect the new database username and password details; or import an existing dataset into your WordPress database. Then, follow the steps below to create a new database and user for your applications:. First, launch the phpMyAdmin and select your WordPress database. myRepono is an online site reinforcement benefit which empowers you to safely reinforcement your WordPress site documents and mySQL database tables utilizing an on the web and electronic administration framework. MemberPress will help you confidently create, manage and track membership subscriptions and sell digital download products. We’ve published a tutorial on how to do this. NET WP - Delete Database Data - In this chapter, we will be covering how to delete an existing database record. wpDataTables gets my vote of confidence as it is the best possible plugin available online. It is an extensive WordPress database cleanup and optimization tool. All the tables created can be managed among others. All data used by your site is stored in tables in the database. It lets you create dynamic tables with the drag and drop interface. sql) using a text editor. Since very early days I. Take a look at our summary of the best WordPress database plugins to help you manage your WordPress database like a pro!. As a WordPress user, you probably realize that your website is essentially made up of three components: The WordPress core files; Your theme files. com Account Recovery I need help logging into WordPress. Change your database table prefix in wp-config. Facebook page link: https. As you probably know, the WordPress database plays a critical role in the smooth functioning of your site. Create a table from a database query - either the WordPress database or an external MySQL database; I'll create a table manually for this review, but it's by no means the only way. DemoTable SELECT 1, REPLICATE('a',4000) UNION ALL SELECT 2. You’ll see how the columns within a record relate to the content you see in the WordPress back-end. The WordPress Database Demystified. php file or not. The WordPress database class and the other various APIs available make it pretty easy to interact with the WordPress database but often times you need to go a step further and create a custom API specific to your plugin's database tables. Once you have WordPress up and running the first step is creating the new table in our WordPress database. If you are doing something where you need the name of your database, then I'm. I show the most important ones and give some small examples. These plugins let you update old URLs in the database. Download Advanced WordPress Database Cleaner. When we do so, the existing transients are not removed from the database. A database is a. Do it carefully, we mentioned below about this entire process. Here’s a couple queries you can use to achieve such results. Tables wp_gf_addon_feed. This information works for the advantage of hackers. Mar 15, 2019 · How to Easily Move a WordPress Site. Each table was converted to an Excel worksheet. unless => '/usr/bin/wp core is-installed --network' and trying to use wp core multisite-convert but that command does seem to create the tables for me even though that's in the docs. WordPress software is a personal publishing system that uses a PHP/MySQL platform, which provides everything you need to create your own website and publish your own content dynamically without knowing how to code those pages. wp_links; Other tables in a WordPress database are created by other plugins and are not necessarily needed to run successfully the website. 24' for table 'wp_amz_assets'] CREATE TABLE IF NOT EXISTS `wp_amz_assets` ( `id` BIGINT(15) UNSIGNED NOT NULL AUTO_INCREMENT, `post_id` BIGINT(20) NOT NULL, `asset` VARCHAR(225) NULL DEFAULT NULL, `thumb` VARCHAR(225) NULL DEFAULT NULL, `download_status` VARCHAR(20) NULL DEFAULT 'new' COMMENT 'new, success. " Please advise how to do this, and. TablePress is a free and open source plugin for the WordPress publishing platform. Instructions for Command Line Larger databases may require you to export/import directly from the command line. And now a short overview of each of them. The WP Security Audit Log uses two tables in the database to store the WordPress activity log: wp_wsal_metadata. Search Replace DB is a powerful tool for developers, allowing them to run a search replace against their database where CLI tools or WP plugins can’t work. And no, I haven't forgotten about the. League Table (Premium) League Table is yet another powerful WordPress table plugin with extensive customization options and ultra-responsive design. 6+ blog/website with PHP 7 and MySQL 5. Jun 06, 2013 · Wordpress Multisite Blogs Help Tips | How to optimize WordPress multisite network with SQL queries how to delete transients and reduce size of db tables for comment meta, post revisions, simplepress members and more. NET is a free, open source, full-featured e-commerce solution for companies of any size. Find, Search, Replace, and Delete in the WordPress Database The following was originally published on WordCast and authored by Lorelle VanFossen. myRepono WordPress Backup. The database captures all the sales transactions that occurs between the company i. They are: wp_wpforms_entries: The info inside the fields (values) of your entries are stored in this database table; wp_wpforms_entry_meta: This table has meta info about your entries like associated IDs and dates. Windows Azure supports WordPress out of the box. Seems I never renamed the database during testing. Here is a screenshot of my WordPress blog database which needs optimization:. Recently, I wanted to write a product comparison post, but I failed to create any tables using the inbuilt HTML editor (i. " which configuration script file I have to modify to find this value. phpMyAdmin comes with a wide range of documentation and users are welcome to update our wiki pages to share ideas and howtos for various operations. Changing the Database Collation in PhpMyAdmin. Transfer wordpress posts from one database to the other Sometimes you need to access your WordPress database in order to modify things quickly and "dirtily" you could use a plugin but when you enjoy dealing with source code without worrying about installing any third part applications, why not just doing it !. Database tables provide a way to manage, organize, and save data for your plugin, and creating them is fairly simple. Accessing the File Manager. When adding a custom role or custom capability, the information is saved to the database (in table wp_options, field wp_user_roles), so it might be better to run this on theme/plugin activation. So far so good. wp db import: Imports a database from a file or from STDIN. During WordPress installation, it asks you if you want to change your database table prefix "wp_" to something. WordPress with its wide variety of functions and functionality has very few and specialized tasks left when one has to perform a query or operation on the database.