Updating database with phpmyadmin
Over time, plugins will add to this number with their own tables, however, the core tables for every fresh Word Press install are these: As you can see, they contain all the raw data of your website, minus styling, media files, and everything else that makes your website presentable to browsers and users. In your infinite quest for knowledge, you might have wondered what that “My SQL” in “My SQL database” means.
In short, it is the name of an open-source database management system that can be operated via typing in queries, “SQL” actually stands for “Structured Query Language.” (Funny enough, the “My” is actually the name of one of its inventors.) Now that we have that out of the way, what does php My Admin have to do with it?
Notice the user2 in 'user2_wrdp9' does not match the username1 in 'username1'@'localhost'.
Someone must edit the import file and change the old user2 to your new username1.
You will know this is the case when php My Admin times out.
Thank God, cause who wants to learn yet another coding language, right? So now let’s look at how to use php My Admin to perform common database maintenance tasks.
Pick ‘utf8_unicode_ci’ if your particular language is not available. Next up you will have to create a user who has all access privileges to your newly created database. The one that I find most convenient is to click on your newly created database.
When you are done with this, click the ‘Create’ button. From there pick ‘Privileges.’ Clicking on ‘add user’ will lead you to the screen where you can create a dedicated user for that database.
All the hard content — pages, posts, comments, and so on — is stored there.
At every install, a number of standard tables will be created in your Word Press database — 11 to be exact.