Look in vi wp-config.php to find your DB prefix first!
mysql> SELECT ID, post_name FROM wp_xubg_posts WHERE post_status = 'publish' AND post_type = 'post' ORDER BY ID ASC;
+-------+---------------------------------------------------------------------------------------------------------+
| ID | post_name |
+-------+---------------------------------------------------------------------------------------------------------+
| 53 | re-install-win-7-with-no-dvd-and-replace-laptop-auto-recovery-partition |
| 146 | cool-command-1-dd-progress |
| 181 | cool-cmd-2-find-with-exec |
| 230 | cool-command-3-rsync |
| 286 | simple-wordpress-css-text-size-and-color-tweaks |
| 319 | william-shotts-sysinfo-html-creator-script |
| 410 | basic-security-concepts-principles-for-any-system-or-os |
| 412 | protect-your-data-and-pc-basic-overview-recap-old-av-links |
| 772 | file-recovery-with-testdisk |
| 776 | cool-cmd-6-dd_rescue |
| 863 | cryptography |
| 978 | linux-commands-packages-how-many-and-what-for |
| 1075 | basic-maths-and-ideas-behind-password-complexity |
| 1322 | setup-and-access-a-1tb-fat32-usb-share-on-a-draytek-router |
| 1469 | mint-as-a-pxe-server-for-partedmagic-and-multi-oss |
| 1540 | pxe-menu-issues-and-iso-boot-file-problems |
| 1603 | a-quick-video-format-conversion-command-line-structure |
| 1624 | first-python-scripts-for-pi-camera |
| 1697 | testing-webcams-with-fswebcam-pi-noir-picam-and-remote-view-of-motion-on-the-pi |
| 1787 | working-motion-installs-on-2-identically-setup-pi2s |
| 1805 | using-sendemail-for-a-motion-alert-and-fixing-its-2-year-old-perl-tls-bug |
| 1915 | adding-a-ssh-share-during-an-open-ssh-session |
| 1941 | using-awk-and-sed-to-cut-a-column-list-and-for-character-substitution |
| 2007 | basic-useful-rsync-usage-summaries-from-man-page |
| 2026 | fix-double-minus-sign-problem-in-wordpress-in-theme-functions-php |
| 2087 | cool-command-8-lsof |
| 2219 | using-and-finding-the-attribute-of-i-immutable-assigned-to-a-file |
| 2226 | understanding-basic-ideas-behind-optimised-code-and-erastosthenes-sieve |
| 2274 | using-crontab-to-automate-commands-on-schedule-and-with-poweroff |
| 2354 | sed-basics-using-o_reilly-pdf-example-and-unexpected-mind-bending-parsing-behaviour |
| 2373 | when-beginners-ask-whats-an-ip-address |
| 2414 | raspberry-pi-cameras-ir-sensitivity |
| 2555 | 2555-2 |
| 2668 | encapsulation-from-bits-to-gigabytes-in-200-years-2 |
| 2891 | testing-agp-cards-with-phoronix-test-suite |
| 2972 | cool-command-10-mogrify |
| 3020 | multi-picam-webserver |
| 3051 | c-programming-chapters-1-4-notes-practical-c-programming-3rd-edition-by-steve-oualline |
| 3070 | chapter-6-notes-practical-c-programming-3rd-edition-by-steve-oualline |
| 3097 | chapter-8-notes-practical-c-programming-3rd-edition-by-steve-oualline |
| 3198 | creating-an-ebook-pdf-from-your-wordpress-posts |
| 3212 | chapter-9 |
| 3236 | practical-c-programming-switch-and-nested-switches-example |
| 3264 | practical-c-programming-using-fmod-to-find-float-remainder |
| 3306 | post-new-mint-install-steps-options |
| 3315 | experiment-with-pipes-redirection-command-substitution-and-variable-expansion |
| 3344 | setting-sudo-users-with-adduser-and-visudo-in-mint-and-raspbian |
| 3404 | remote-server-gkrellm-monitors-via-ssh-and-x11 |
| 3450 | exploring-find-cmd-options |
| 3831 | an-intro-to-metachar-search-methods-wreck-the-mp3s |
| 3944 | intro-to-gnuplot |
| 3962 | flame-graphs-by-www-brendangregg-com-intro-to-system-profiling |
| 4027 | linux-performance-tools-list-check-utilisation-saturation-errors |
| 4041 | how-slow-can-you-go-old-and-new-tech-moores-law-comparision-1-hard-drives |
| 4145 | gnuplot-basic-starter-example-data-file-for-system-profile-plots |
| 4188 | basic-ideas-to-capture-live-system-data |
| 4246 | how-slow-can-you-go-old-and-new-tech-moores-law-comparison-2-program-performance |
| 4262 | how-slow-can-you-go-old-and-new-tech-moores-law-comparison-3-memory |
| 4281 | how-slow-can-you-go-sysbench-comparisons-diskio |
| 4302 | cpu-bound-loop-to-load-1-cpu-core-to-100-to-test-observability-tools |
| 4320 | sysbench-simulated-database-testing |
| 4463 | converting-m4a-to-mp3 |
| 4553 | printing-ascii-histograms-from-a-numeric-data-file |
| 4716 | developing-one-liners-with-command-substitution |
| 4777 | awk-as-a-limited-spreadsheet-simulation-for-stats |
| 4838 | save-gigabytes-of-failed-rsync-video-transfers-on-a-drive |
| 4923 | intro-to-software-defined-radio-fm-stations-and-tracking-aircraft |
| 5212 | small-business-data-security-requirements-summary |
| 5864 | cisco-setup-via-linux |
| 5914 | cisco-setup-adsl-connection-wan |
| 5949 | cisco-setup-nat-connections-lan-to-wan |
| 5985 | cisco-setup-acl-settings-and-basic-routing-concepts |
| 5995 | cisco-setup-wifi-lan |
| 6075 | slick-canon-printer-support-for-linux-how-corporations-should-do-it |
| 6124 | cheap-but-handy-usbsata-backup-gizmos-from-the-web |
| 6297 | dd-and-cloning-windows-system-drives |
| 6403 | personal-data-awareness-for-brokenstolen-pcs-the-data-people-give-away-use-shred |
| 6941 | backing-up-working-picam-images-over-the-net-with-dd-and-netcat |
| 7099 | check-working-keys-using-ubuntus-handy-utility |
| 7361 | wordpress-upload-limit-user-ini |
| 7451 | booting-a-pi3-from-usb3-devices |
| 7470 | pi3-usb-boot-device-with-picam-motion |
| 7729 | search-replace-on-cmd-line-2 |
| 7842 | quickest-cloning-of-working-mint-system |
| 7855 | gparteds-efsck-fyvc0-dev-sda1 |
| 8393 | manipulating-pdfs-using-pdftk-and-pdf-shuffler |
| 8418 | joining-mp4-video-files-concatenating |
| 8431 | thumbdrive-performance-differences-v-usb-sata-disk |
| 8583 | grub-rescue-2 |
| 8626 | my-rsync-local-wordpress-backup-examples |
| 8627 | new-mint-install-want-wordpress-at-home-full-steps-i-take |
| 8628 | converting-dvd-vob-files-to-smaller-vob-and-mkv |
| 8737 | building-a-php-website-input-button-for-db-connection |
| 8885 | chapter-5-notes-practical-c-programming-3rd-edition-by-steve-oualline-2 |
| 8887 | chapter-7-notes-practical-c-programming-3rd-edition-by-steve-oualline-2 |
| 8890 | exploring-find-cmd-options-continuing-with-metacharacters-2 |
| 9035 | equivalent-prime-numbers-programs-for-java-python-c-and-jscript-testing |
| 9052 | js-html-and-css-todo-list-saves-list-to-json-file |
| 9083 | css-flex-positioning-options |
| 9148 | css-grid-layouts |
| 9209 | converting-js-functions-to-arrow-functions |
| 9247 | javascript-guess-number-game |
| 9252 | js-refactoring-the-guess-number-game-code |
| 9267 | js-behind-the-scenes-hoisting-and-the-tdz-temporal-dead-zone |
| 9286 | webdev-portfolio-1-first-solo-project-noughts-and-crosses |
| 9292 | webdev-portfolio-2-fun-conspiracy-theory-quiz |
| 9349 | form-validation-types-results-script-and-non-default-web-font-use |
| 9366 | webdev-embedded-video-code-for-landing-page-link |
| 9606 | downgrading-php-versions |
| 9614 | mysql-db-repair-commands |
| 9616 | 9616-2 |
| 9624 | wordpress-images-not-showing-rare-solution |
| 9656 | uploading-your-local-wordpress-mysql-site-to-a-new-hosting-cpanel-site |
| 9658 | first-site-pages-speed-and-seo-tweaks |
| 9659 | vs-code-live-server-ssl-settings |
| 9660 | ssl-on-ubuntu-apache2-creating-self-signed-certificates-checking-ssl-traffic-with-tcpdump-and-wireshark |
| 9680 | running-apache2-and-mysql-on-win11-wsl-ubuntu |
| 10098 | post-titles |
| 10100 | all-my-it-tech-post-knolwedge-introduction |
| 10118 | databases-a-research-paper-2009 |
| 10120 | awk-perl-sed-notepad |
| 10122 | some-linux-one-line-cmds |
| 10125 | linux-admin-webdev-beginner-to-intermediate-it-topics |
| 10268 | win11-to-wsl2-networking-chat-with-gemini-ai-2025 |
| 10288 | bitlocker-encryption-with-password-no-tpm-issues |
| 10324 | viewing-wordpress-post-name-to-number-mappings-in-linux-mysql |
+-------+---------------------------------------------------------------------------------------------------------+
126 rows in set (0.00 sec)