Hi, this is David with TinyFrog. I’m here to talk about WordPress database structure. This is a slightly more advanced topic. For people who maintain a database on a website already, which we would be moving over, it’s important to think about how WordPress organizes the data in a website and on a server. When you think of a database, a lot of people think about a spreadsheet with columns and rows that store the data.
On WordPress and a lot of website systems, it’s actually a little bit different. We have a lot of different spreadsheets that all reference each other. Let’s say we’re storing blog posts in WordPress. There’s a database and it tells you the ID number of the blog and maybe a couple other tiny bits of information. Then there’s another database that stores all the metadata on that blog post. It’s not like a spreadsheet and when you try to view it in any database viewing system, it’s a little bit tricky.
The good thing is that we’re here to help you with that migration and we’re experts at moving information over. Whether it’s from a SQL server or some other database system, we pull it all to the WordPress system and organize it in a way that you can use it in the front end as well as the back end. We can even set up reports for you to run any certain database query, pull that data out and put it into a nice format that you can easily view and edit. This is very common for people who have store fronts or tons and tons of clients that they need to manage.
Talk to your TinyFrog developer about your database migration as soon as possible. Let us look at your old database structure and start making a plan for moving that data over. The sooner you get on that during the website project, the better. This is David signing off with database migration and how data is stored in WordPress.
