Title: Export broken links with source url SQL
Last modified: April 12, 2023

---

# Export broken links with source url SQL

 *  Resolved [luisegan](https://wordpress.org/support/users/luisegan/)
 * (@luisegan)
 * [3 years, 1 month ago](https://wordpress.org/support/topic/export-broken-links-with-source-url-sql/)
 * If you need to export your broken links you can go to your phpMyAdmin and run
   this SQL within your WP database
   `CREATE TABLE broken_links ASSELECT url, guid,
   http_codeFROM wp_blc_linksINNER JOIN wp_blc_instances ON wp_blc_links.link_id
   = wp_blc_instances.link_idINNER JOIN wp_posts ON wp_blc_instances.container_id
   = wp_posts.IDWHERE wp_blc_links.broken != 0;Hope it helps!

Viewing 1 replies (of 1 total)

 *  Plugin Support [Nithin – WPMU DEV Support](https://wordpress.org/support/users/wpmudevsupport11/)
 * (@wpmudevsupport11)
 * [3 years, 1 month ago](https://wordpress.org/support/topic/export-broken-links-with-source-url-sql/#post-16652031)
 * Hi [@luisegan](https://wordpress.org/support/users/luisegan/),
 * Thanks for the tip, really appreciate.
 * Kind Regards,
 * Nithin

Viewing 1 replies (of 1 total)

The topic ‘Export broken links with source url SQL’ is closed to new replies.

 * ![](https://ps.w.org/broken-link-checker/assets/icon-256x256.png?rev=2900468)
 * [Broken Link Checker](https://wordpress.org/plugins/broken-link-checker/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/broken-link-checker/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/broken-link-checker/)
 * [Active Topics](https://wordpress.org/support/plugin/broken-link-checker/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/broken-link-checker/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/broken-link-checker/reviews/)

## Tags

 * [Broken-Links](https://wordpress.org/support/topic-tag/broken-links/)
 * [export](https://wordpress.org/support/topic-tag/export/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * 1 reply
 * 2 participants
 * Last reply from: [Nithin – WPMU DEV Support](https://wordpress.org/support/users/wpmudevsupport11/)
 * Last activity: [3 years, 1 month ago](https://wordpress.org/support/topic/export-broken-links-with-source-url-sql/#post-16652031)
 * Status: resolved