Skip Navigation

[Resolved] I can not find the database in phpmyadmin

This thread is resolved. Here is a description of the problem and solution.

Problem:

I tried to follow the following tutorial: "How to migrate from a custom database into WordPress".

but inside this database don't have the table that I looking for.

Solution:

The custom fields are stored in your database table "wp_postmeta"

Relevant Documentation:

https://codex.wordpress.org/Database_Description#Table:_wp_postmeta

This support ticket is created 6 years, 2 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun Mon Tue Wed Thu Fri Sat
- 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 -
- 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 -

Supporter timezone: Asia/Hong_Kong (GMT+08:00)

This topic contains 8 replies, has 2 voices.

Last updated by tohL 6 years, 2 months ago.

Assisted by: Luo Yang.

Author
Posts
#1132820

I can not find the database in phpmyadmin.

I have created the custom fields but it does not show in the database.

I tried to follow the following tutorial,

"How to migrate from a custom database into WordPress"

Please guide me for this, Thank you.

#1133191

Hello,

You can find the your website database definition in your website root folder, file wp-config.php, for example:

define( 'DB_NAME', 'wordpress' );
#1133225

I can find the database location but inside this database don't have the table that I looking for.

#1133226

The custom fields are stored in your database table "wp_postmeta", see wordpress document:
https://codex.wordpress.org/Database_Description#Table:_wp_postmeta

#1133294

I still can not find the database. I need to export the database and import again to the database.

#1133310

In different wordpress installation, the table prefix "wp_" will be different, for example, it could be "my_postmeta", or something else.

#1133340

Finally, I found the data. But I have a question here.

How do I assign the meta_id and post_id?

#1133344

"meta_id" is a auto_increment column, you don't need setup it's value, the "post_id" value is the post's ID, you can get it when you edit a single post/page, see this article:
hidden link

#1133957

My issue is resolved now. Thank you!