I've been building these websites and have avoided a lot of things. This is one of them...which is encapsulated inside of other things I'm learning. Thanks for the guidance.
Thanks Joel. Clear, concise, to-the-point instruction. I like you addressing more than one way to get the job done. Eager to work my way through your other videos. A new subscriber!
Thanks Susan, I have a huge list of videos I’m getting ready to record. I’ll probably update this video as well to include WordPress Multisite. Let me know if there’s anything in particular you’re interested in watching.
Thanks, I'm gearing up a more advanced series on WordPress Development, especially with the new Gutenberg Editor and how that will change theme and plugin development. I might also create a more advanced database video as well. Thanks for watching and let me know if there's any video you think I should create.
Thank you for this video. It answered a lot of questions and explained concepts which I never properly understood before. A lot of info is packed into a short amount of time. I had to stop the video several times and think a bit to absorb what was just covered; that's no problem, because so much good info was in there. I learned a lot.
i guess im randomly asking but does anyone know of a method to log back into an instagram account..? I was dumb forgot my password. I would love any tricks you can give me!
@Enoch Royal thanks for your reply. I found the site through google and Im in the hacking process atm. Looks like it's gonna take quite some time so I will reply here later with my results.
Great video. I actually didn't mind the speed that you went at, despite me not knowing everything about database stuff. It's easy enough to speed up the video, if needed, so maybe going a little slower would be more beneficial to other viewers. Slowing videos down just makes tutors sound...slow. Subscribed!
Yeah, I’m always trying to figure out the right pace. Especially with longer videos. With complex topics, I should definitely slow down a bit. Thanks for watching.
nice basic tutorial about how wordpress use the database but what i really want is making forms and add data to the database from the outside interface
WOW YOU ARE THE BEST RUclipsR WOW..WE LOVE YOU BROTHER...YOU LET US KNOW HOW THE WOLF DANCE ...THANKS A LOT OF .....GOD BLESS YOU AND YOUR FAMILLY......
@@PixemWeb you are welcome! Thanks for the great content. I want to become a python sql developer! Do you have beginner tutorials for wordpress? Am i starting in the right place? I want to learn the fundamentals of databases in Wordpress.
I'm a newbie doing my own site. I did delete and reinstall wordpress and after that it crash. Thanks for these tutorial. Hope i can set the database on my own. Its so confusing when its being setup by the hosting company
Mario Constantin: I think the video is quite good but it still does not answers the question: how do I insert the form7 data into Mysql automatically from the form-how do I link the form to MySql from the website? regards, Mario
I try to figure out how to find my old website that I created in WordPress. Site is not active anymore but it was created in WordPress so all the information is sometwhere there in the database. Where do I find that? If I type my site address with /wp-admin I get the message that there is an error because the domain is not active anymore, but I just want to enter the database with all the page I created. How can I do that? Thank you
Thanks Joel. You just got a new subscriber! I have 1 question please, if i have a form like wp contact form 7. if a person add his details. How and what is the safest way to add it into the database?
Hi Mergulho, You could go to the users table in phpMyAdmin and check what users are created. you can see what level of access they have. If there's an account that seems to have greater access than it's supposed to you can either change the access level or you can further investigate via WordPress Admin Dashboard. In the dashboard you can go to your users and see who has admin level access. It should just be you. You can get greater control over your users with plugins like Members which I believe I have a video on and also the User Role Editor Plugin which is really good as well. Thanks for watching.
Hi thanks for this great tutorial. I am happy to find this. By the way, I also want to ask which file should go if I want to customised the look and feel of the WP admin dashboard, say I want to change color, font style, the Text (example instead of the word Product in woocommerce I will replace it by Services. Same goes to check out page and shop page. Thanks bro
Thanks for the video. I have a question. I would like to build a form where the drop down content is created from a query of a database. Here is an example. A user selects a U.S. State, (California), the results from a query filter only populates the Cities with those that are in the database. So, if California and I only have Los Angeles and San Francisco, only Los Angeles and San Francisco are listed in the new dropdown. Then after selecting Los Angeles, the output only lists facilities located in Los Angeles. Can you point me in the direction of a youtube video or link that might help me code this?
You will want to make sure that your web hosting account is secure with unique credentials, 2 factor authentication and make sure your database credentials are also strong and unique. Since the database works with WordPress or any other CMS like Drupal or Joomla, just make sure to only use trusted plugins and themes since they can insert information into the database.
Hi Joel. Thanks for the great video. I backed up my site, restored it and found all subscribers were set to role none. How can I use the database to set them all to subscriber again? I have over 37K subscribers. Doing it manually is a nightmare :(
Joel, quick question, can I Optimize all tables directly on phpMyadmin? For example, I use WP-Optimize it clean several things, but I got the tables postmeta, post, and option tables which were around 8-12 MB each. And I reduce to 1MB each just by selecting those 3 tables and clicking "Optimize tables" on phpMyAdmin... So I was wondering if I can safely optimize like that All tables? Thanks !!
I actually do prefer to optimize all the tables via phpmyadmin. I frequently check the tables, repair them and optimize them from phpmyadmin since it gives you greater control. Just make sure to take a full backup.
Still on my to do list. Should get it done soon. Hopefully in the next 30 days. I have a bunch of videos on Developing a WordPress Website via themes and plugins. Stay tuned.
It was found to have a massive security issue and was subsequently removed from the repository. I actually no longer use phpmyadmin anymore either. Straight up command line, but mainly because the performance issues caused by so many GUI’s. Thanks for watching.
Thanks for your informative video, it explains exactly what the title says in a comprehensive way. I just looked for the adminer plugin but did not find it any more from within wordpress, so I looked externally and then found "This plugin has been closed as of April 5, 2019 and is not available for download. Reason: Security Issue. " Apparently, there is another plugin called adminer that is currently available in version 4.7.8. Have you tried this one and is it secure in your view?
THANKS AGAIN TEACHER...HOW CAN WE PLEASE HOST OUR LOCALHOST FROM HOME TO TEST THIS WITH PHPMYADMIN I MEAN OVER WAN BROTHER...?THANKS AGAIN AND I AM HAPPY TO FIND YOUR TUTTOR HERE...GOD BLESS YOU
I have some videos on WordPress Security but I’m gearing up for a whole new series of WordPress focused videos for 2019 full of new tips and tricks. I’ll show how to secure your website from nearly all attacks (except for zero day vulnerabilities since those are unknown). I’m also creating an advanced scanning and tracking plugin and will show how to code it. 2019 is going to be an epic year. Thanks for watching.
PixemWeb also discusses the backup issues like a backup of website and database, intervals like 1 month or daily, restoring the same, backup on local hardware. etc. Generally, people don't know that at what intervals backup is needed...
I have a few videos on backups from manual approach to the plugin route. Checkout the Duplicator Plugin Video. In that one I show how to clone a website and restore from backup.
Hey, thanks for watching. I hear ya, sometimes I talk to slow and other times, too fast. I must have had a lot of coffee that day lol. If the video is too fast, then you can slow down the playback to something like 75%. Let me know if you have any questions. Again, thanks for watching.
Slow down. Remember, you are showing people who do NOT know what you know how something works. What is the hurry??? You zoom through it as though it were painful. Also, try NOT to wiggle the mouse around to emphasize something. That is very poor tutorial method. ...
Gotcha, thanks for the feedback. Still learning how to do these video tutorials. Playing around with a few different ideas on how to best upload. It's either very long and slow tutorials, fast tutorials where I cram in a lot of info, or what I'm probably going to settle on is splitting the videos into shorter segments.
Keep this in mind: people are watching this who DO NOT KNOW what you know. Use Camtasia #9 - really the best tutorial maker of them all. Then use zoom in/out, draw boxes and arrows and use those things (there are more) instead of nervous mouse wiggling around attempting to point at something using mouse wiggles (does not work) . Focus on ONE message and do not mention options and other ways unless you really think the mention is worth the diversion. Diversions are deadly for tutorials as they do not add to your message but divert from it. I recently watched a bunch of SSL installation methods and they all made it far more difficult than it actually is. So, keep it simple. People who know something which has options find it difficult not to show off their knowledge of the options. The discipline is to keep focused and if all the options matter than do another tutorial for options. Otherwise, show ONE set of an option and make a passing comment that it is "one option" and you have other tutorials for other options if you want to. ...
Thanks again for the feedback. I'm using Camtasia 9. It's awesome. Still learning all the features it provides. I appreciate your constructive criticism. It'll help me create better videos that people will benefit from.
I've been building these websites and have avoided a lot of things. This is one of them...which is encapsulated inside of other things I'm learning. Thanks for the guidance.
God bless you for that!!!
i was searching a good tutorial for this topic and you nailed it!
Love the fast pace of the video. fast and still learnt properly
New WP user here. Thank you for the excellent tutorial.
Thanks Joel. Clear, concise, to-the-point instruction. I like you addressing more than one way to get the job done. Eager to work my way through your other videos. A new subscriber!
Thanks Susan, I have a huge list of videos I’m getting ready to record. I’ll probably update this video as well to include WordPress Multisite. Let me know if there’s anything in particular you’re interested in watching.
Superb Sir, Really appreciated your way of teaching.
Thanks, I'm gearing up a more advanced series on WordPress Development, especially with the new Gutenberg Editor and how that will change theme and plugin development. I might also create a more advanced database video as well. Thanks for watching and let me know if there's any video you think I should create.
OUTSTANDING!!! The best on WP admin I've seen (and I've seen a lot!!). Thank you, sir!!!
Thank you for this video. It answered a lot of questions and explained concepts which I never properly understood before. A lot of info is packed into a short amount of time. I had to stop the video several times and think a bit to absorb what was just covered; that's no problem, because so much good info was in there. I learned a lot.
Thanks, I'm working on a massive update to DevWP which is my development training theme. Uploading a video on it next week. Stay tuned.
i guess im randomly asking but does anyone know of a method to log back into an instagram account..?
I was dumb forgot my password. I would love any tricks you can give me!
@Armando Ameer Instablaster =)
@Enoch Royal thanks for your reply. I found the site through google and Im in the hacking process atm.
Looks like it's gonna take quite some time so I will reply here later with my results.
@Enoch Royal it did the trick and I finally got access to my account again. I am so happy:D
Thanks so much, you saved my ass!
Awesome man, need database deep leavel operations that is not handled so many people
simply awesome , i m in notification squad
Great video. I actually didn't mind the speed that you went at, despite me not knowing everything about database stuff. It's easy enough to speed up the video, if needed, so maybe going a little slower would be more beneficial to other viewers. Slowing videos down just makes tutors sound...slow.
Subscribed!
Yeah, I’m always trying to figure out the right pace. Especially with longer videos. With complex topics, I should definitely slow down a bit. Thanks for watching.
Hi Sir, I cannot find the mentioned plugin. Plz help me out
It's no longer available
Did anyone find a similar replacement?
@@CrudChronicles I found WP-DBManager plugin but I did not use it yet
nice basic tutorial about how wordpress use the database
but what i really want is making forms and add data to the database from the outside interface
WOW YOU ARE THE BEST RUclipsR WOW..WE LOVE YOU BROTHER...YOU LET US KNOW HOW THE WOLF DANCE ...THANKS A LOT OF .....GOD BLESS YOU AND YOUR FAMILLY......
Thanks for the nice video. But... What happened to Adminer? It is not availlable anymore??? Can I maybe download this plugin from someone, plz?
Thank you for making this very very useful Video.
No problem, glad you found it useful. I'm working on a few more videos on working with the WordPress Database, basically on optimization and security.
Im the 1000th like!
That’s awesome. Thanks for the support.
@@PixemWeb you are welcome! Thanks for the great content. I want to become a python sql developer! Do you have beginner tutorials for wordpress? Am i starting in the right place? I want to learn the fundamentals of databases in Wordpress.
Great work sir
I'm a newbie doing my own site. I did delete and reinstall wordpress and after that it crash. Thanks for these tutorial. Hope i can set the database on my own. Its so confusing when its being setup by the hosting company
Database is located @> Go To Your Hosting Companies CPanel >Databases> And Then Click phpMyAdmin.
Life saver man, thank you so much!
No problem, glad it helped.
Mario Constantin: I think the video is quite good but it still does not answers the question: how do I insert the form7 data into Mysql automatically from the form-how do I link the form to MySql from the website? regards, Mario
I believe the ARI Adminer plugin is not available anymore. Is there a similar alternative?
I try to figure out how to find my old website that I created in WordPress. Site is not active anymore but it was created in WordPress so all the information is sometwhere there in the database. Where do I find that? If I type my site address with /wp-admin I get the message that there is an error because the domain is not active anymore, but I just want to enter the database with all the page I created. How can I do that? Thank you
Awesome tutorial
Thanks. I might create an updated video to reflect WordPress multisite. What do you think?
@@PixemWeb its sounds good
this tutorial is helpful
Excellent!
i got a Wix ad lol!
Lol, that’s funny. Thanks for watching.
Apparently they removed the plugin
But how to change localhost to costum domain in php my admin ??????
Thanks Joel. You just got a new subscriber!
I have 1 question please, if i have a form like wp contact form 7. if a person add his details. How and what is the safest way to add it into the database?
Very good, thank you!
But I still have one doubt, how may I discover if someone created another administrator account in hidden mode?
Hi Mergulho, You could go to the users table in phpMyAdmin and check what users are created. you can see what level of access they have. If there's an account that seems to have greater access than it's supposed to you can either change the access level or you can further investigate via WordPress Admin Dashboard. In the dashboard you can go to your users and see who has admin level access. It should just be you. You can get greater control over your users with plugins like Members which I believe I have a video on and also the User Role Editor Plugin which is really good as well. Thanks for watching.
Put like only for the music.
great tutorial
Hi thanks for this great tutorial. I am happy to find this.
By the way, I also want to ask which file should go if I want to customised the look and feel of the WP admin dashboard, say I want to change color, font style, the Text (example instead of the word Product in woocommerce I will replace it by Services.
Same goes to check out page and shop page. Thanks bro
Thanks for the video. I have a question. I would like to build a form where the drop down content is created from a query of a database. Here is an example. A user selects a U.S. State, (California), the results from a query filter only populates the Cities with those that are in the database. So, if California and I only have Los Angeles and San Francisco, only Los Angeles and San Francisco are listed in the new dropdown. Then after selecting Los Angeles, the output only lists facilities located in Los Angeles.
Can you point me in the direction of a youtube video or link that might help me code this?
Hi. can't find the adminer plugin, after search using the keyword adminer, maybe it maybe renamed, idk. Please help thanks!
It’s been removed from the WordPress repository. It’s best just to use phpmyadmin
Adminer is not there? maybe this tut needs updated now
Yeah, it’s about time for an update
@@PixemWeb To be fair, i managed to follow along just fine. really helpful tutorial, Thanks
Great Video again! So How to protect properly the database?
You will want to make sure that your web hosting account is secure with unique credentials, 2 factor authentication and make sure your database credentials are also strong and unique. Since the database works with WordPress or any other CMS like Drupal or Joomla, just make sure to only use trusted plugins and themes since they can insert information into the database.
@@PixemWeb Is it recommended/good practice to also rename the default tables to make it more difficult for script attacks to do their work?
Could you recommend further resources on wordpress database repair, optimisation and hack solutions?
sir I want to know can WordPress webpage host to MySQL database & is it ok?
I do type adminer in search box nothing is there???!!!
I got same problem. :(
Hi Joel. Thanks for the great video. I backed up my site, restored it and found all subscribers were set to role none. How can I use the database to set them all to subscriber again? I have over 37K subscribers. Doing it manually is a nightmare :(
Joel, quick question, can I Optimize all tables directly on phpMyadmin? For example, I use WP-Optimize it clean several things, but I got the tables postmeta, post, and option tables which were around 8-12 MB each. And I reduce to 1MB each just by selecting those 3 tables and clicking "Optimize tables" on phpMyAdmin... So I was wondering if I can safely optimize like that All tables? Thanks !!
I actually do prefer to optimize all the tables via phpmyadmin. I frequently check the tables, repair them and optimize them from phpmyadmin since it gives you greater control. Just make sure to take a full backup.
hi thank you for the nice lesson, what is the link of your video about the multi site database? thank you
Still on my to do list. Should get it done soon. Hopefully in the next 30 days. I have a bunch of videos on Developing a WordPress Website via themes and plugins. Stay tuned.
Thanks for your video, Can I recover pages's content from the database phpmyadmin ? Merci
that was good tutorial on wp tables. i would like to see also how acf affects the tables, but i think i will try it on my own. thanks
Thanks :)
No problem. Glad you found it helpful.
Awsome
Glad it helped
It seems that this plugin is no longer available in the search
It was found to have a massive security issue and was subsequently removed from the repository. I actually no longer use phpmyadmin anymore either. Straight up command line, but mainly because the performance issues caused by so many GUI’s. Thanks for watching.
Thanks for your informative video, it explains exactly what the title says in a comprehensive way.
I just looked for the adminer plugin but did not find it any more from within wordpress, so I looked externally and then found "This plugin has been closed as of April 5, 2019 and is not available for download. Reason: Security Issue.
"
Apparently, there is another plugin called adminer that is currently available in version 4.7.8. Have you tried this one and is it secure in your view?
can you tell me what name is it
?
THANKS AGAIN TEACHER...HOW CAN WE PLEASE HOST OUR LOCALHOST FROM HOME TO TEST THIS WITH PHPMYADMIN I MEAN OVER WAN BROTHER...?THANKS AGAIN AND I AM HAPPY TO FIND YOUR TUTTOR HERE...GOD BLESS YOU
I use MAMP for a local server. You can also try WAMP or Xampp. They are all great tools and they're free.
IM seeking for some help of using database. how can i contact you?
cant search today 2019
16:30 wp_posts
hey, nice video... haven't watched full... asking in between how to save the database from hackers???
I have some videos on WordPress Security but I’m gearing up for a whole new series of WordPress focused videos for 2019 full of new tips and tricks. I’ll show how to secure your website from nearly all attacks (except for zero day vulnerabilities since those are unknown). I’m also creating an advanced scanning and tracking plugin and will show how to code it. 2019 is going to be an epic year. Thanks for watching.
PixemWeb also discusses the backup issues like a backup of website and database, intervals like 1 month or daily, restoring the same, backup on local hardware. etc. Generally, people don't know that at what intervals backup is needed...
I have a few videos on backups from manual approach to the plugin route. Checkout the Duplicator Plugin Video. In that one I show how to clone a website and restore from backup.
@@PixemWeb sure...!!👍
Slow down.Your explanation is too fast.Anyone who is beginner is not able to understand what you explain.
Hey, thanks for watching. I hear ya, sometimes I talk to slow and other times, too fast. I must have had a lot of coffee that day lol. If the video is too fast, then you can slow down the playback to something like 75%. Let me know if you have any questions. Again, thanks for watching.
J
Not for begginers
It is an in depth walk through but it's good to learn how the database works for WordPress.
Slow down. Remember, you are showing people who do NOT know what you know how something works. What is the hurry??? You zoom through it as though it were painful.
Also, try NOT to wiggle the mouse around to emphasize something. That is very poor tutorial method.
...
Gotcha, thanks for the feedback. Still learning how to do these video tutorials. Playing around with a few different ideas on how to best upload. It's either very long and slow tutorials, fast tutorials where I cram in a lot of info, or what I'm probably going to settle on is splitting the videos into shorter segments.
Keep this in mind: people are watching this who DO NOT KNOW what you know. Use Camtasia #9 - really the best tutorial maker of them all. Then use zoom in/out, draw boxes and arrows and use those things (there are more) instead of nervous mouse wiggling around attempting to point at something using mouse wiggles (does not work) .
Focus on ONE message and do not mention options and other ways unless you really think the mention is worth the diversion.
Diversions are deadly for tutorials as they do not add to your message but divert from it. I recently watched a bunch of SSL installation methods and they all made it far more difficult than it actually is. So, keep it simple. People who know something which has options find it difficult not to show off their knowledge of the options. The discipline is to keep focused and if all the options matter than do another tutorial for options. Otherwise, show ONE set of an option and make a passing comment that it is "one option" and you have other tutorials for other options if you want to.
...
Thanks again for the feedback. I'm using Camtasia 9. It's awesome. Still learning all the features it provides. I appreciate your constructive criticism. It'll help me create better videos that people will benefit from.
You do have the speed controls bottom right of the video.
i'm totally fine with the speed. this material is sooooo boring that the speed actually makes it tolerable. i'm fine w the mouse movements as well.
Love the fast pace of the video. fast and still learnt properly