Jump to content
Violet

[SOLVED] How to export page URLs via phpMyAdmin?

Recommended Posts

Sorry for this noob question, but I'm having trouble finding where the page URL's are stored in the database. Would anyone please be willing to point me in the right direction? Using phpMyAdmin, I've managed to find my other fields, like "body" "title" etc etc. However, I'm struggling to find the page URL's. I also tried searching the forum for this info, but I could not seem to find anything that matched.

Ultimately when I find the URLs I'm going to export them as a CSV. I've already exported body, title, etc with no problems at all. But the page URL for some reason I can't seem to find.

In the meantime, I've gotten some of the URLs from my sitemap.xml, but in that situation it's not indexed by page ID. Its a decent workaround for now and I'm happy to match URLs to page ID's manually, but for the future in case I didn't happen to have a sitemap.xml on my website, how should I find my page URL's using phpMyAdmin?

⚠️ To clarify, when I mean the URL, not necessarily the full https://.... I just mean the relative URL I defined in the place where I created that new page in the admin screen. I don't care about parents, children, domain name etc, just the url of that particular page (e.g. how-to-inflate-a-basketball ).

Edited by Violet
marked as solved

Share this post


Link to post
Share on other sites

You will find a page's basename in the "name" column of the "pages" table.

  • Thanks 1

Share this post


Link to post
Share on other sites

Oh thank you! 😳 Can't believe I missed it.... I actually looked at the pages table but silly me was looking for "URL" as column label so I didn't even think to look at "Name". Oops. Yes, it's there, thank you so much! I exported the pages table as CSV and all is good now! Marking as solved. Thanks! 😍

Share this post


Link to post
Share on other sites

You could also get such a list with a few lines in the Tracy Debugger console, e.g.

$pgs = $pages->find("template=project|basic-page|offer-index, parent!=2, include=all, sort=parent, sort=title");
foreach($pgs as $p) {
    echo "{$p->url}<br>";
}

of course, adjust the selector as needed. If you need the full URL, just replace $p->url with $p->httpUrl

  • Like 1

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...