初心者のためのphpMyAdminによるWordPressデータベース管理ガイド

108件のコメント返信を残す

1. Jiří Vaněk

   Wow, this is a great article, I have saved it to my favorites. I actually knew some of the tricks in phpmyadmin, but definitely not all of them, and here it’s all beautifully described, including pictures. This article is a goldmine for working with databases and WordPress.

   返信

   • WPBeginner Support

     Glad you liked our article

     返信

     管理者

2. Nadine

   Hi!

   Thanks you so much for this tutorial!!! it was really help full!

   返信

   • WPBeginner Support

     Glad our guide was helpful

     返信

     管理者

3. Abdul

   Article is well explanatory and concise. Thank you.

   返信

   • WPBeginner Support

     You’re welcome

     返信

     管理者

4. Kelvin

   Am having problem with the login pageusername how it connect with database

   返信

   • WPBeginner Support

     For any issues with your database, you would want to reach out to your hosting provider and they should be able to assist.

     返信

     管理者

5. Kevin

   A good introduction thank you.

   I have several WP sites and several databases.
   How can I tell which database belongs to which site?

   返信

   • WPBeginner Support

     The wp-config file for each site and that would specify which database they are using. You can see our guide on the wp-config file below:

     https://www.wpbeginner.com/glossary/wp-config-php/

     返信

     管理者

6. Salman

   Perfect… I want to learn

   返信

   • WPBeginner Support

     Glad our article can be a good starting point

     返信

     管理者

7. Pam Sheets

   Awesome! Very well explained quick and to the point.

   Thank you,

   返信

   • WPBeginner Support

     You’re welcome, glad you liked our article

     返信

     管理者

8. Dubravka

   Very clear and really good article.

   返信

   • WPBeginner Support

     Thank you

     返信

     管理者

9. Aviral

   Very nice article

   返信

   • WPBeginner Support

     Thank you

     返信

     管理者

10. Vimal Rathod

    You write well I learned a lot from this blog. My question was answered but I also got the information I needed

    返信

    • WPBeginner Support

      Glad our content has been helpful

      返信

      管理者

11. ajay

    I have two totally separate WP websites setup. Different domains, different databases. I manage both of them and they are both hosted on a dedicated server. I am trying to include some basic content that requires just a tad more than an RSS feed. I need to pull data from SITE-1 and display it on SITE-2

    返信

    • WPBeginner Support

      If it is a post or page you can go under Tools>Export on the site with the content to select the specific content you want to be transferred and then use Tools>Import on the site to bring in the content

      返信

      管理者

12. Dr Eddy

    I need more help how to create, a website via word press and how to Host it
    Any help..

    返信

    • WPBeginner Support

      We have a guide you can follow here: https://www.wpbeginner.com/guides/

      返信

      管理者

13. Wadhi

    do i need to learn back end development if i use WordPress. I mean aren’t there some plugins which can help me create a website with front-end and back end system. I want a food delivery website

    返信

    • WPBeginner Support

      You do not need to learn development to run a WordPress site. Some plugins will give you that kind of editing power but not all of those plugins are needed.

      返信

      管理者

14. George

    when i clink on new post, this is what i see; Sorry, that didn’t work.
    Please try again or come back later.
    504 Error. Gateway Timeout.
    please help

    返信

    • WPBeginner Support

      For the 504 error, you would want to take a look at our article here: https://www.wpbeginner.com/wp-tutorials/how-to-fix-the-504-gateway-timeout-error-in-wordpress/

      返信

      管理者

15. Steve Hanzek

    I’m looking to create a website that would allow bands and venues to maintain their schedules, and a visitor to select a date and see all the bands playing on that date, and all the venues with bands playing on that date.
    I’m proficient with the SQL (mySQL) needed to do the querying, just want to find out if WordPress will let me create custom pages based on the results of a query?
    Thanks

    返信

    • WPBeginner Support

      WordPress will allow that, for an example plugin that already allows you to search you can take a look at our article here: https://www.wpbeginner.com/plugins/how-to-let-users-filter-posts-and-pages-in-wordpress/

      返信

      管理者

16. Kelsei

    I am new at a job and just taking over the website. However, I am reaching the Error Establishing Database Connection on the website itself and the login page. The email they used to originally sign up for the website has been deactivated due to her no longer working here. I have searched the files and cannot find the WP files I am seeing being mentioned above. I am unsure what my next steps should be. Any ideas?

    返信

    • WPBeginner Support

      For the error establishing database connection, you would want to take a look at our article here: https://www.wpbeginner.com/wp-tutorials/how-to-fix-the-error-establishing-a-database-connection-in-wordpress/
      If you reach out to your hosting provider they should be able to assist with swapping the email address to your new email

      返信

      管理者

17. Sharwari

    Hi my database is automatically created! Can I Rename the database?

    返信

    • WPBeginner Support

      Yes, you can, you would want to follow our guide on how to do this here: https://www.wpbeginner.com/wp-tutorials/how-to-change-the-wordpress-database-prefix-to-improve-security/

      返信

      管理者

18. Yinka

    Hi,

    I recently moved by hosting and it affected the frontend of my website which displays “Error Establishing a Database Connection”. So I created a database.

    The website contents are in the public_html folder in my cPanel File Manager.

    How and where do I move these contents to the database in order to display my actual website?

    Thanks.

    返信

    • WPBeginner Support

      Rather than moving your content, you would want to take a look at solving the error using our article here: https://www.wpbeginner.com/wp-tutorials/how-to-fix-the-error-establishing-a-database-connection-in-wordpress/

      返信

      管理者

19. Kerrie Taylor

    Hi, I cannot get WordPress to reset my password. How would I go about doing it using this way?
    Thanks

    返信

    • WPBeginner Support

      You would log in to your hosting provider to find your phpMyAdmin, depending on the host there are a few places it could be located.

      返信

      管理者

20. Miza

    Hi, I need help on this.

    I’m planning to utilize database to create a system that can be accessed only by our company staff in wordpress.

    May I know from where i should started ?

    返信

    • WPBeginner Support

      If you’re wanting to create an intranet you could take a look at: https://www.wpbeginner.com/wp-tutorials/how-to-create-a-wordpress-intranet-for-your-organization/

      返信

      管理者

      • Miza

        How about for existing wordpress? just want to implement system that can be used by our staff only. i mean i want to create a page (basically a service report in our company website – wordpress) that can only be accessed by our staff

        返信

        • WPBeginner Support

          If it is only one page you could use the method in: https://www.wpbeginner.com/plugins/how-to-share-private-posts-with-user-groups-in-wordpress/

21. Mich

    Hi,

    I recently created a few Wordpress sites and I did it through one click Wordpress installation in cPanel. What I wanted to know is, “Should I change my Wordpress database name and database user name?” Is it something easily hackable if I’m already using a free security plugin like Wordfence?

    Thanks!

    返信

    • WPBeginner Support

      Most hosting providers’ one-click installations change the database prefix for you to help with that. It is not something that by default is easily hackable and security plugins help even more

      返信

      管理者

22. Joachim

    This is great. But what if i create a custom site on wordpress and input a form validation input. Is the data going to be automatically stored in the wp_database?

    返信

    • WPBeginner Support

      You would need to set up in your form to store the information, it would not be automatic.

      返信

      管理者

23. John Certalic

    Is it possible to get this information in an email rather than a tweet? It would be more easily accessible for me in an email for future reference. I appreciate all you do for newbies like me. Thank you.

    返信

    • WPBeginner Support

      While we don’t have the entire article in our newsletter emails, we’ll be sure to take a look into possibilities.

      返信

      管理者

24. polo

    Hello Sir, I have hosted my website with someone which has not given me inbuild features of myphp admin.So how to download it on my desktop plz guide .is there othere software required with myphp to download it.

    返信

    • WPBeginner Support

      Hi Polo,

      You can access phpMyAdmin from your web hosting account. If you have access to your web hosting account, then you can login there and under the databases section you’ll find phpMyAdmin icon.

      返信

      管理者

25. Rajat Pandey

    Very Informative Thank You

    返信

26. Ayush singh

    i have a result table in database and i want to fetch the result of the student by registration number.
    i m not getting solution to where to code in the wordpress site….and how to see result of the student by registration number.

    返信

    • Prakash

      Use wp_user table

      返信

27. Zziwa Daniel

    Thank you so much for the tutorial, its powerful
    however I have a question;

    I have a database that I have created with workbench and I have imported it to phpmyadmin. however I want to connect with wordpress so that when I submit data through wordpress I can be able to view it in phpmyadmin and I can view it again in wordpress interface that I have created

    返信

28. Ibrahim

    Your tutorials has been helpful.

    based on a previous tutorial on installing wordpress on PC, I followed the tutorial and it was successful. i developed a website for diabetes association of Nigeria which iam a member too. But my challenge now is how to add registration form for new members to register online and how to get donation online in the website. i need your help please.

    返信

    • WPBeginner Support

      Hi Ibrahim,

      Please see our tutorial on how to create a custom user registration form in WordPress. As for donations, we are not sure which payment providers you will be using to collect donations. Here is our tutorial on how to accept online donations in WordPress

      返信

      管理者

29. Hemant

    Is it possible to migrate Wordpress database to newly developed web applications?

    返信

    • Jiří Vaněk

      If you mean exporting certain tables, then it is possible. In phpmyadmin, the entire database does not have to be exported, but individual tables can be exported as well. E.g. tables with posts that you can then export to another database. Specifically with the contribution, it is also necessary to remember that images and audiovisual content are not stored in the database and are stored on FTP.

      返信

30. Ian de Guzman

    Where can i upload the website I made and that can be accessed offline. Thank you in advance.

    返信

    • WPBeginner Support

      hi Ian,

      If it is a WordPress website, then see our guide on how to move a local site to a live server. You will need a WordPress hosting account for that.

      返信

      管理者

    • FirdausShukor

      To make your wordpress website can be accessed offline you can use xampp as a local server and you can install wordpress inside htdocs folder in xampp installation folder.

      返信

31. Siva

    Thanks a lot.it gave me some clear vision.

    返信

32. Andreas

    What if i want to import wordpress menus? Where in the database are the menus stored?

    返信

33. Pooja Raval

    thanks…it helps a lot to understand it a bit better..

    返信

34. Laura Panait

    Very helpful tutorial, thank you, it actually worked.

    返信

35. Divo

    Please where does wordpress store page information. How can I change a page title from the database?

    返信

36. Prerna Rathod

    I use contact form 7 for feedback purposes and i store that data in database but now i want that particular data by URL like (abc.com/feedback/5) so it will show the data of id no 5 how i do this in wordpress?

    返信

37. Mirjana

    Hello,

    I`m planing to make some wp website with registration for specific users ( I have a non profit organisation that has more than 2000 members.) Now, I have the list of them (members) in my Access db with all informations needed. My question is, is it possible to connect this access db with wp db? If yes, how to do that?
    Also, every member has a unique ID in my db, which is also a number for the membership card they have. If before mentioned is possible, could I make a field in registration form, beside Username&Pass, that would request that ID number which would be checked from db and if correct, make a registration, if false, deny it?
    Hope you understand me cause my englesh is not so grate…
    Thanks in advance

    返信

    • Ayomide

      I’m having the same problem, please did you figure out a solution?? If you did please, get back to me.

      返信

38. Matthew

    Hello, I am preparing to launch my first wordpress blog site under my first website. Testing and learning the blog setup I am wondering how the email stuff is working. I created a comment in response to a post and ticked the email me a notification when posts are done option. And when I made another post I received an email notification. Looking in the tables using phpmyadmin I can see the email address I entered with the comment stored in wp1_comments but cannot see where/how the fact is stored that an email should be sent to that address when a new post is made.

    Thank you

    返信

39. Saud Khan

    Hi,

    Can you please help me that how can I view my blog database because they are not visible anywhere.

    snaps attached

    返信

40. Murali

    Hi,
    I run Certification Services like food certificate, ISI Certificate and etc.,.
    I have simple wordpress website (self hosted),

    Now, I plan to create Page for my clients to get current status about their Application.

    Once they enter (1) Application No. (2) Date of Birth / Mobile number, if match details it will display application status else show error message (like not match given details).

    Kindly suggest me which plugin / method suite for my requirement.

    Thanks

    返信

41. Tom

    Hello
    I need some help, because I don’t understand something:
    I register a WP website… and install WooCommerce in it. (I use XAMPP localhost on C partition)
    So I have a clear WP+WooCommerce site which I’d like to use to create other WP sites too.
    So I copy all the WP files from C… to another partition, let’s say D partition
    and I also export its database by phpMyAdmin. Now I have a copy of the WP site and its database on D partition.
    But what if I’d like to use the copied WP+WooCommerce site (pattern) I’ve created?
    It is still contains the same e-mail address and password I used when I registrated on the official site of WP right? So how can I modify that?
    I’d like to create a new website (with different admin e-mail and password) but using the same WP+WooCommerce site (pattern) I’ve created before.

    返信

42. Penelope

    When I did a database backup and followed the custom options. (following these steps: )

    When I hit GO, a file goes to my downloads folder and does nothing. the file is empty. What could I be doing wrong?

    返信

43. Richard

    Thank you for the great explanation of how WordPress interfaces to MySQL. Question: We have some blogs our site that are displaying a blank page. The blogs with blank pages have the same information as those that are working properly. I’ve used phpMyadmin to examine the tables and all looks well. Which table does WordPress use to begin the page generation?

    返信

    • WPBeginner Support

      It seems like a plugin or theme issue. To find out what’s causing the issue, deactivate all plugins on your site and then switch to a default theme like Twenty Sixteen.

      返信

      管理者

44. roj

    The video was a little superfluous to the more descriptive written explanation of this article AND, as with many of your videos the narrator speaks too quickly and is thus difficult to understand if you don’t speak American. – even to me as a native English speaker!

    返信

45. Anik

    how should i connect the in-build search form with my database to see the search results…

    返信

46. WPBeginner Staff

    In wp_comments table you will find comment_author_email and comment_author_IP fields. Note that the wp_ prefix in the comments table may differ in your database.

    You can also find comment author email and IP information inside WordPress admin area.

    返信

47. IdolHanz

    Which part of the database management system in phpMyAdmin shows a commenter’s IP address and email address?

    返信

48. WPBeginner Staff

    phpMyAdmin is not a database management system. It is a utility that allows you to manage your database in a web based graphical user interface.

    Your actual database resides on your MySQL database server. Any utility that wants to manage, backup, or make changes to your database will need your database username and password to do so.

    BackupBuddy works as a WordPress plugin and your database username and password are already stored in your WordPress configuration file. So it can automatically connect to your database without explicitly asking for your username and password.

    返信

49. Nazim

    Is it necessary for any plugin/ tool to access to myphpadmin to backup database.. If not then how backupbuddy creates database backups…

    Is backupbuddy require username and password of myphpadmin to access to database…

    I am newbie and confused. If you know then please let me know…

    返信

50. Bernhardt Le Mechant

    I just wanted to say…thanks…good article! (i was wondering how all this worked).

    返信