Great intro. Would be great to expand this to cover woocommerce tables and its data in core tables and in general how relationships (orders to users, attachments to posts) are established and maintained.
Great video as always. I would like to see how you clean a 5 years old WP DB. A site that has thousands of posts and has changed 3-4 themes (and myriads of plugins).... how do you clean such a mess with an army of zombies transients/tons of revisions etc. How do you optimize such a database without breaking it. What are the best WP DB plugins that can show you at a glance the health of WP DB.
I just saw I just saw the title of this video and I immediately got excited watching this but I like this video before watching and move the video to watch later at least
Thank you WPCasts for the presentation. I was wondering if you could you please go more deeply into the table wp_terms, wp_term_taxonomy and wp_term_relationship.
Can you delete tables and transfer tables to a second WP install? How would you go about doing that? I won't go into the details of how I messed my site up, but I had an existing site that I created in 2009. I installed WP in a folder I called Blog (1st mistake I think. But I had no idea how to use the theme to redesign my HTML pages that were one level up in public_html. So I think I need to install a 2nd instance of WP in public_html and somehow connect the two installs - one for my pages and the one with all my posts and uploads.
Great video as usual! Do you have any tools or methods you would recommend for stress testing WordPress websites to see if a solution is viable for enterprise use?
I see you are using a Local App to run your WP instances, could you explain how to connect to the WP instance DB from Sequel Pro? Since the local DB is running inside the docker container, I have issues to connect to it, thanks
There’s actually a button in the Local app, you click it and it’ll open up the database client, connected to that site’s database. Super-simple, super-easy.
@@MichaelAlderete yeah I know that, it opens up the phpmyadmin in a browser, but I was asking about different thing, how to connect to the database with Sequel Pro or Workbench, to that database.
@@ranostaj-dev When I run Local.app and have a site running, there are four tabs in the main/details area for that site: Overview, Database, Utilities, and Tools. When I click the Database tab, there's a number of items in the details area, starting with a Connect line. That line has two options/buttons available to me: Open Adminer, and Open Sequel Pro. And when I click Open Sequel Pro, it does exactly that, connecting to the site's MySQL database. (Well, it used to; my Mac is currently having serious problems after I sent it out to have the battery replaced...) Is that not what you're trying to do? This is on Mac, using the latest version of Local.app.
Ever thought about sharing your vids on dev[dot]to ? I think you'll get like a ton of subscribes from that place. It's heavy on JS stuff but I feel iike there's a void for hybrid JS WP stuff. You could share your videos there, it's a pretty open place.
@@WPCasts It's a pretty active community, everyone can write, everyone is a member and there are some quality folks in there doing tutorials with gifs n stuff, but like really pro content, well made. There's ofc a lot of "Hi I'm new here" posts, but I think you could fill the WP void they're currently having.
This is great, because almost every course or tutorial on WordPress development never talks about the database.
you can look at mysql tutorials seperately =P
I’d definitely be interested in seeing a deep dive video on this. Love your videos, so very helpful. Thank you!
This channel is helping me keep my job!
I lol'd :D
I can't wait to get my thank you card in the mail!
Great intro. Would be great to expand this to cover woocommerce tables and its data in core tables and in general how relationships (orders to users, attachments to posts) are established and maintained.
Hey bro. Take Love From Bangladesh. I love the way how you summarizes useful information in a nutshell. God bless you.
Great video as always. I would like to see how you clean a 5 years old WP DB. A site that has thousands of posts and has changed 3-4 themes (and myriads of plugins).... how do you clean such a mess with an army of zombies transients/tons of revisions etc. How do you optimize such a database without breaking it. What are the best WP DB plugins that can show you at a glance the health of WP DB.
I love how this guy can explain things. awesome
oh wow, this channel is so good
Thank you for the couse. A deep dive would definitely be helpful. Would you think about doing the same for WooCommerce? Thanks!
I just saw I just saw the title of this video and I immediately got excited watching this but I like this video before watching and move the video to watch later at least
Thank you WPCasts for the presentation. I was wondering if you could you please go more deeply into the table wp_terms, wp_term_taxonomy and wp_term_relationship.
Thank you for putting out highly unique and super useful content. You are awesome.
My pleasure!
Can you delete tables and transfer tables to a second WP install? How would you go about doing that? I won't go into the details of how I messed my site up, but I had an existing site that I created in 2009. I installed WP in a folder I called Blog (1st mistake I think. But I had no idea how to use the theme to redesign my HTML pages that were one level up in public_html. So I think I need to install a 2nd instance of WP in public_html and somehow connect the two installs - one for my pages and the one with all my posts and uploads.
Great video as usual!
Do you have any tools or methods you would recommend for stress testing WordPress websites to see if a solution is viable for enterprise use?
nice explanation
Long form video would be great!
I see you are using a Local App to run your WP instances, could you explain how to connect to the WP instance DB from Sequel Pro? Since the local DB is running inside the docker container, I have issues to connect to it, thanks
There’s actually a button in the Local app, you click it and it’ll open up the database client, connected to that site’s database. Super-simple, super-easy.
@@MichaelAlderete yeah I know that, it opens up the phpmyadmin in a browser, but I was asking about different thing, how to connect to the database with Sequel Pro or Workbench, to that database.
@@ranostaj-dev When I run Local.app and have a site running, there are four tabs in the main/details area for that site: Overview, Database, Utilities, and Tools. When I click the Database tab, there's a number of items in the details area, starting with a Connect line. That line has two options/buttons available to me: Open Adminer, and Open Sequel Pro.
And when I click Open Sequel Pro, it does exactly that, connecting to the site's MySQL database. (Well, it used to; my Mac is currently having serious problems after I sent it out to have the battery replaced...)
Is that not what you're trying to do?
This is on Mac, using the latest version of Local.app.
@@MichaelAlderete yeah, but not able to connect for some reason
Thanks for tour!.....which tool are you using to explore the DB?
You're welcome! It's called Sequel Pro: www.sequelpro.com/
@@WPCasts Thanks!
it would be nice to see how to use scripts and common examples of scripts you run on your db
Thank you for this - excellent :-)
Say for example I add a custom field on woocommerce product, could I grab that field from the database and output it into the woocommerce order email?
Absolutely! WooCommerce data is stored in the wp_postmeta table. You can search by the product's ID and get all the info you need!
@@WPCasts Awesome, I'll give it a try
Ok but how to set everything up and enter that panel...?
some tip and tricks with SQL would be great, always daunting to mess with the database
Ever thought about sharing your vids on dev[dot]to ? I think you'll get like a ton of subscribes from that place. It's heavy on JS stuff but I feel iike there's a void for hybrid JS WP stuff. You could share your videos there, it's a pretty open place.
Thanks for the suggestion. I'll look into it!
@@WPCasts It's a pretty active community, everyone can write, everyone is a member and there are some quality folks in there doing tutorials with gifs n stuff, but like really pro content, well made. There's ofc a lot of "Hi I'm new here" posts, but I think you could fill the WP void they're currently having.
Longer video please!