Hey there and thanks for watching WPBeginner.
Today we'll cover
WordPress database management with phpmyadmin.
If you are managing your WordPress database, you might want to know some basics
about how WordPress works.
It uses php programming language to
store and read data from a database.
That information includes your posts, pages,
comments, categories, custom fields
users and other things for your site.
Here I've logged into phpmyadmin through the
cpanel from my hosting provider to show you
the WordPress breakdown.
This is my database specifically
for my site and here are the 11 tables that
make up the data for WordPress.
From the phpmyadmin panel, I can create a
backup of my database by clicking on the database
and hitting the export key.
If we choose custom, we can pick which tables
to include and create a zipped compression
backup of our database.
In the admin panel, you can also optimize
your tables. This is like the old computer
days when you would defragment your computer,
mysql database becomes fragmented over time as well.
So just choose all tables and click optimize
table to defragment them and make them run smoother.
I hope you liked this video and found it helpful.
If you did, click on the like button below and leave us a comment.
And if you want to receive more helpful videos don't forget to subscribe to our channel
and check out WPBeginner for more useful information on WordPress.
