WordPress stores all data of your posts, pages, products, revisions and images in a MySQL database.
Depending on your configuration, this starts with a so-called prefix. By default, WordPress puts the prefix “wp_” in front of the tables.
For technical reasons, the data is distributed into several tables. The most important tables include wp_posts, wp_posts_meta and wp_options.
| Name | Description |
| wp_posts | Contributions, pages, products, revisions and attachments are stored here. The standard fields such as title, content and excerpts are stored here. Dates can also be found here. |
| wp_posts_meta | Additional information is stored here. This includes e.g. additional fields, time stamps, options for posts and individual post types. |
| wp_options | General options are usually stored in the wp_options. Here you can find the standard fields of WordPress like email address, title of the page and URL mostly also theme options. |
You can usually access the database via your hosting provider. To do this, log in to your provider and look for a link to the “database”. Most providers allow you to access your database via the PhpMyAdmin web application.
You can find the name of your database in the configuration file of WordPress. Connect to your server via FTP and open the file wp-config.php.
There you will find an entry DB_NAME, behind which the name of the database is stored.
define('DB_NAME','database_name_here');Furthermore, you will find the entries DB_USER and DB_PASSWORD.
define('DB_USER','database_username');
define('DB_PASSWORD','database_password');With this information, you can log in to PhpMyAdmin.
Comments