One-click WP site generation wih wp-cli on Windows

This is the script I use on Windows under XAMPP. It includes a MySQL command to create the database, and a tweak to improve security by nuking user 1 (and all its content) straight after install, resulting in a clean empty database.

@echo off
set dbName="wp_yourdbname"
set dbPass="your_random_db_password"
set siteUrl="sitename.localdev.yourdomain.com"
set siteName="Kluwell"
set siteDesc=""
set adminUser="Second User Name"
set adminPass="admin_password"
set adminEmail="[email protected]"
:: these get nuked straight after install
set adminUserDummy="admin"
set adminUserDummyEmail="[email protected]"

SET /P AREYOUSURE=This will nuke the current site %siteUrl% and the DB %dbName%. Are you sure (Y/[N])?
IF /I "%AREYOUSURE%" NEQ "Y" GOTO END

REM SQL setup
mysql -u root -p -e "DROP USER IF EXISTS %dbName%@localhost;DROP DATABASE IF EXISTS %dbName%;CREATE USER %dbName%@localhost IDENTIFIED BY '%dbPass%';CREATE DATABASE IF NOT EXISTS %dbName%; GRANT ALL PRIVILEGES ON %dbName% . * TO %dbName%@localhost;exit;"

REM setup core
call wp core download
call wp core config --dbname=%dbName% --dbuser=%dbName% --dbpass=%dbPass%
call wp core install --url=%siteUrl% --title=%siteName% --admin_user=%adminUserDummy% --admin_password=%adminPass% --admin_email=%adminUserDummyEmail%

REM remove first user
call wp user create %adminUser% %adminEmail% --role=administrator --user_pass=%adminPass%
call wp user delete 1 --yes

Works a treat, especially if you set up a wildcard DNS entry to point *.localdev.yourdomain.com to 127.0.0.1 and configure mod_vhost_alias under Apache so that you can serve all the localdev sites out of a single directory, one subdir per host, so creating a subdirectory of dave equates to a url of dave.localhost.yourdomain.com

Related Posts:

  1. WP CLI Shell not working on Windows
  2. WP Cli will not execute on Windows
  3. ‘wp’ is not recognized as an internal or external command, operable program or batch file
  4. Detect if WP is running under WP-CLI
  5. wp-cli Enabling Maintainance Mode
  6. WP-CLI Cannot Connect to Database due to Vagrant
  7. WP-CLI Process Killed
  8. wp-cli commands do nothing, return nothing
  9. How do I clone or duplicate a post with the WordPress Command Line Interface WP-CLI?
  10. wp-cli doesn’t find and wordpress installation
  11. WP-CLI :: Cannot installing plugin as www-data
  12. wp-cli import theme sample data
  13. Export list of users with first and lastname in WP-CLI
  14. What could cause WP-CLI search-replace to not replace all instances of a string?
  15. Using Travis CI to run unit tests and running phpunit locally [closed]
  16. wp-cli create post and media import
  17. Import Media To CPT with CLI & Filter Custom Taxonomy
  18. wp-cli with MAMP shows sh: mysql: command not found
  19. What is the difference between the Package Language and the Site Language?
  20. PHP warning are displaying when using WP CLI [closed]
  21. How do I update a nested option?
  22. Trying to install WordPress on WSL Windows 10, and running into issues with wp-cli and “wp db create”
  23. Is it possible to use WP-CLI via PHP-framework?
  24. WP-CLI with theme: Uncaught Error: Class ‘WP_CLI’ not found
  25. What tools respect `.distignore`?
  26. How to prevent WP-CLI shell from exiting when an exception occurs?
  27. WP-CLI Get Site ID from its url
  28. WP-CLI alias: connect with ssh proxy
  29. Setting boolean and array values using wp theme mod set
  30. Ask WP-CLI latest core WordPress version released
  31. WP-CLI sudden empty response
  32. How to get all posts related to a term with WP-CLI?
  33. WP CLI: there has been critical error
  34. How to verify a correct wp-cli installation?
  35. wp-cli: wp term generate xxxxx – Error: ‘xxxxx’ is not a registered taxonomy
  36. How can I add an RSS widget using WP-CLI?
  37. MAMP PRO WP-CLI Error: Error establishing a database connection
  38. “Class ‘Phar’ not found” error setting up WP-CLI with Cygwin
  39. Running WP-CLI without SSH
  40. How do you kill WP-CLI execution?
  41. Is it possible to delete a range of posts by ID with WP-CLI?
  42. Formatting messed up when piping wp commands
  43. wpcli: Error on post_content or post_title if accents
  44. wp-cli configuration in php?
  45. Lock User and Enforce Password change via wp-cli
  46. BackupBuddy WP CLI Invalid Profile Error
  47. How to find what pages/posts contain a particular reusable block?
  48. How can I search and replace by post type?
  49. WP CLI not outputting anything
  50. Only the WP CLI command, wp –info, runs under my cPanel account
  51. Error establishing a database connection when running phpunit
  52. Set Site Icon programmatically (eg. using `wp cli`)
  53. Bulk remove custom post type and its attachments with wp-cli?
  54. How to rename default category name and slug using WP CLI?
  55. Resetting internal WordPress state during its cycle
  56. How do I add HTML code to a widget with wp-cli?
  57. WP-CLI can not find Url
  58. Wildcard for wp-cli search-replace
  59. Update BackupBuddy with WP-CLI
  60. Get media url (featured image) with wp-cli
  61. MySQL 5.6 Causes Errors with WP CLI
  62. Using WP-CLI, how do I delete a post by title or slug, not ID?
  63. Can I use wp-cli to create posts with a custom post types?
  64. wp-cli only displays PHP version for all input options
  65. WP CLI: search and replace specific directory name of URL
  66. WP-CLI plugin install causes PHP fatal error – Using $this when not in object context
  67. How to delete a single post using wp cli in command line?
  68. Adding content from file with wp post create
  69. WP-CLI media import error
  70. How to run wp cli from a wp hook?
  71. wp-cli PHP Notice after moving server behind load balancer
  72. Is it possible to view WP documentation within the WordPress shell?
  73. What is the purpose of the “user” global parameter in wp-cli.yml config?
  74. Userless db-only wordpress instalation
  75. WPCLI doesn’t recognize the site
  76. Combine WPCLI commands for plugin installation and activation?
  77. Add passwords to config.yml to manage multiple sites
  78. What user should I use for wp-cli on Ubuntu VPS [closed]
  79. WP-CLI mysteriously stopping while downloading the core [closed]
  80. WP-CLI: Does “wp post create” will create post normally and will ping to Ping Service?
  81. Mocking WP_CLI static methods in unit tests
  82. How to add an array to a command “wp config set”?
  83. WP-CLI: detect altered core files and restore them automatically
  84. wp-cli core install unknown: fatal: file /etc/postfix/main.cf: parameter mail_owner: user postfix has same user ID as _postfix
  85. How to specify which editor is used when editing posts with WP-CLI?
  86. WP changes siteurl, but some URLs then don’t work
  87. Install plugin on remote wordpress
  88. WP-CLI is unable to update password
  89. Make WordPress more like Jekyll (using wp-cli package?)
  90. Find latest/published version of post using wp-cli
  91. Wp-cli from a plugin?
  92. Is it possible to update a single page using WP-CLI?
  93. undefined function apache_request_headers()
  94. ignoring, hidding mu plugins when wp-cli is run
  95. Install WordPress using PHP
  96. How to install WordPress with Composer?
  97. WordPress CLI isn’t working while use WordPress development repository
  98. Remote Export DB w. WP-cli.phar Over SSH
  99. is it possible to use wp cli to export custom post types
  100. Why doesn’t “wp db cli” enable tab completion?