 Thank you. So good morning, everyone. I would like to start. Thank you all for coming. It's quite earlier today. But let's start talking about WP CLI. Does everyone here knows this tool already? No? OK. So it's basically a command line interface for WordPress. You can, possibly, all the things you do on your dashboard by using this command line tool. It's a powerful command line tool. This is from their site, you know? It's a powerful command line interface for WordPress, which allows you to handle almost everything that an administrator would be. It runs an MIT license. It's quite good. And I would like to start by listing some kind of things that I'm doing every day using this tool. It's kind of download, install, update, and manage WordPress. Install, activate, deactivate themes, plugins. Install, activate language. Manage Chrome events. Manage attachments. Database. Perform basic database operations. Publish posts. Sounds strange. Publish posts using the command line tool. But it's quite useful. User management. This is quite useful on a day that you need to add even update a password on command line tool. So you don't need to go inside a dashboard to create or update an user. So you can add, remove, update load users from a CSV file, which is useful when you need to migrate sites. The requirements to use WordPress SQL I, it's pretty much that all we have now on hosting. It's an Unix-like environment. They have support for Siegwind, but please do not install Windows and run PHP or anything else. It runs on PHP 5.3 or later and WordPress 3.5.2 or later. If you install this version, 3.5.1, it will not run. OK, so I'm going to show you some pages that you see, comments, just to make sure you all get this. So to install, it's pretty easy to install WordPress CLI. You just need to download a file, run this file using those two arguments, and then just turn it around, enable, move it to your path location, and voila. You have WordPress CLI running on all your Unix-like environments. First things first, to download, it's quite handy, these two, to download. You can go ahead, use your path to your site. This is based on an nginect stack, so the var slash www dash slash your site. You just need to run wp core download. It will go there and download your WordPress, the latest version always. Then you just need to configure. What does that mean? It will create your wp dash config dot PHP using those arguments. It means that you need to have your database already set up. You need to have your password. The next one here, car install, will install your system using the URL, title, user, email, and password. This is great because you don't need to use the first user as admin here. You can change it. You can use anything. So you don't need to go into your dashboard and then create a new user and then erase the admin user. To update your WordPress as well, this is how you can downgrade. To downgrade WordPress, site's not so easy with all these two. But using WordPress CLI, you just need to use wp core update, which using just this part, we will update to the latest version. It's needed for the freed, outdated. So to downgrade, you just need to put this argument version equals the version you would like to have it downgraded. And then put the force here. This will actually downgrade your WordPress version. It's not recommended, of course. But if you want to, you can. And then the last one, car update DB. Even if you include the core update, you might need to run the update DB. So customers don't need to go there and wait the process of database update. With WPCLI, you can manage the themes without going to a dashboard or even downloading a zip file to install on your system. Here are all the possible arguments. But I will show you the basic ones. To search themes, it's quite useful. So you can use these arguments and put here the slug. So you will have here some great informations about the theme. In this case, Glades, the slug, name, and rating on WordPress.org. Then to install a theme, it's pretty easy. Only need to change the search to install. But the slug, and it will download the theme. And then you will have this theme on your system. You can, of course, activate this theme here on your command line. So you're seeing that you don't need to go into your dashboard to do anything. You can also combine the dash, dash, activate here. And then it will download and automatically activate the theme. So to list the themes, you can use these arguments, wp theme list. It will list all your themes installed in your system. It will also show you if there is an update of iLabel, which is quite handy if you are going to make some maintenance on this site. You know, keeping themes outdated, it's a huge security risk for your site. So you can see here, and then you can activate, perform the status. Status is not so useful. It will only show you the author of theme. You can also update a theme. You can also use an update here. So just make sure you get it. The theme activate will change from the full theme to your brand new installed theme, just like this. It's quite easy. To remove a theme, you might need first off activate another theme. So before the letting, it will not allow you to let a theme already activated, still activated. So you need to activate another theme and then the let. It will deactivate the theme, and also will remove it completely from your system. If the theme has been properly coded, it will also remove all the things on your database as well. Just like the themes, you can run almost all the same things using the four plugins. It's very, very cool. You can search just like this using a keyword, and then you will see almost all the plugins. It's 1,000, more than 1,000 plugins with this keyword. And here is another great trick. You have this arguments dash dash fields, which you can use on almost all the things you can list to choose the fields you would like to have on your screen. The fields name are mostly the same name on your database, the database fields. And you also can set the per page results, because it's 1,000, more than 1,000. So showing a little bit less results is nice. And again, the list, this is the full version of list without using the fields arguments. It's also show you if there is an update, the version, and if it's active and inactive. So to install plugins, the same thing that on themes. You don't need to worry so much. You just need to run WPPlugin install and use this lug. Using this lug will download the plugin and it will install. Just like on themes, you can combine it with dash dash activated. And then it will activate your plugin automatically. And again, with that WordPress CEO now installed. And here is, I think, the most useful argument that's update plugins on WordPress CLI. So you know that the plugins normally breaks almost every site. Anyone here probably had the site messed up. And then you cannot even go inside your dashboard to update a plugin. You need to download the plugin and upload it via FTP and then extract. And then the site will be fixed. So using WordPress CLI, you can both update one plugin or you can run this dash dash all. And you will update all the plugins on your site using just one comment. Think about it on a huge server that has 10, 20 sites. It's pretty easy to update tons of plugins and a ton of sites just combining a bash script. You can run one line to update all your sites. And here is another great trick. It's the filtering options on WordPress CLI. You can use here a name of field here. It's update. You could be using version or status. But on plugins, of course, the update is great to use. So using WordPress CLI plugin list, the name of field dash dash update equals a variable. It will bring you only the plugins that has an update of a variable. You can also change here by status and use only for inactive or active plugins. And here again, just using two fields. So this applies to almost all the comments on WordPress CLI. It's pretty useful when you need to build some bash script to automate your job. Now, talking about language, you can list the language. Again, using the fields arguments, you can download, install, activate just like the same as themes and plugins. It's pretty easy. You can list your events. You can do anything regarding to your event. So you can list. You can schedule. You can delete. It's very nice. While you are going to manage your WordPress site, sometimes when migrate content from one site to another, you see some files that are available on your media gallery and other aren't. So this is quite useful to bring all those images that aren't present on your media gallery to your site back. Here is just one line script to bring all the contents on uploads directory. So you can see here that this file wasn't added. So you can see that there weren't the thumbnails generated. And so you can just run WP media regenerate. And it will regenerate the thumbnails and also bring all those images to your media gallery easily, very, very fast. Here's one of the my preferred things to do using WordPress CLI. While you are needing to perform some database interactions on your WordPress, using MySQL command line, you need to understand where exactly is the database. You need to know the password. But using WordPress CLI inside the directory, you just need to run WPDB CLI. And then it will automatically opens the MySQL CLI. And you just are on the place you need to be. You are on that database for that site and nothing else. So you will not mess it up in another database or another site. And you can just run all the queries you might need, just like on the regular MySQL CLI. This is another thing very nice is the optimize. This is the same of MySQL check. If I'm not wrong, it will run the optimize, just like the dash dash optimize on SQL. To export data, again, this is pretty useful. You can export data, import data, run queries, show the tables, reset your database, and run a search and replace. This is very nice when you are migrating sites. It's always a pain to run this search replace. Using WordPress CLI, it's very easy. You can also use the WordPress options to get some options on WP options table. And you can list them using get. You can set them. You can also set using the update. Users, you can list users, create, list using the same thing. You can flush your cache. You can also flush your transients. You can also delete all them. The rewrite is also another useful to change your slug, and then the flush just to make sure it's working. You can list posts. You can create a post. This is not so earlier notice. It's just because the WordPress, when it moves to the 4.4, the WordPress CLI has incompatibilities, but you don't need to worry with this right now. Okay, people, so anyone here has questions?