{"id":10324,"date":"2025-06-03T01:19:59","date_gmt":"2025-06-03T00:19:59","guid":{"rendered":"https:\/\/stevepedwards.today\/DebianAdmin\/?p=10324"},"modified":"2025-06-03T01:57:22","modified_gmt":"2025-06-03T00:57:22","slug":"viewing-wordpress-post-name-to-number-mappings-in-linux-mysql","status":"publish","type":"post","link":"https:\/\/stevepedwards.today\/DebianAdmin\/viewing-wordpress-post-name-to-number-mappings-in-linux-mysql\/","title":{"rendered":"Viewing WordPress Post Name to Number mappings in Linux MYSQL"},"content":{"rendered":"
<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n

Look in vi wp-config.php\u00a0<\/span>to find your DB prefix first!<\/p>\n

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

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n

Look in vi wp-config.php\u00a0to 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 | | ...\u00a0 Viewing WordPress Post Name to Number mappings in Linux MYSQL<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-10324","post","type-post","status-publish","format-standard","hentry","category-post"],"a3_pvc":{"activated":true,"total_views":1,"today_views":0},"_links":{"self":[{"href":"https:\/\/stevepedwards.today\/DebianAdmin\/wp-json\/wp\/v2\/posts\/10324","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/stevepedwards.today\/DebianAdmin\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/stevepedwards.today\/DebianAdmin\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/stevepedwards.today\/DebianAdmin\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/stevepedwards.today\/DebianAdmin\/wp-json\/wp\/v2\/comments?post=10324"}],"version-history":[{"count":4,"href":"https:\/\/stevepedwards.today\/DebianAdmin\/wp-json\/wp\/v2\/posts\/10324\/revisions"}],"predecessor-version":[{"id":10332,"href":"https:\/\/stevepedwards.today\/DebianAdmin\/wp-json\/wp\/v2\/posts\/10324\/revisions\/10332"}],"wp:attachment":[{"href":"https:\/\/stevepedwards.today\/DebianAdmin\/wp-json\/wp\/v2\/media?parent=10324"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/stevepedwards.today\/DebianAdmin\/wp-json\/wp\/v2\/categories?post=10324"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/stevepedwards.today\/DebianAdmin\/wp-json\/wp\/v2\/tags?post=10324"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}