• Unable to search entire database for a string. Can only search a single table at a time. Would be useful to also be able to export the database and download it directly from wp-admin, rather than setup a backup to file.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Sorry, it does not make sense to search the entire database for a specific string. Each query on a RDBMS returns a table. Joining the result tables of all available tables creates a meaningless table. Searching a group of specific tables might make sense, but is more a kind of application specific requirement. You can use the plugin API to create such a feature.

    >>> Would be useful to also be able to export the database and download it directly from wp-admin, rather than setup a backup to file.

    This is exactly how WP Data Access works! You just need to use batch export. ??

    Thread Starter joec002

    (@joec002)

    I were working on a clients website that was hosted by someone else. I only had WP-ADMIN access otherwise I would have used phpMyAdmin which supports searching the entire database for a string.

    The batch export exports locally, but without write access, or the ability to change the right access, I were unable to use it. phpMyAdmin allows you to download directly to your browser without having to store the download locally first. I guess I could have used the uploads folder however.

    I’m aware of the phpMyAdmin plugin but the developers used PHP 5.4 which limited the plugin choice.

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Sorry for my late reply! I was on a ship with very limited internet access…

    Okay, I see the need for a global search if you have no access to a database tool. It’s on my to do list with low priority.

    >>> The batch export exports locally, but without write access, or the ability to change the right access,

    Can you explain this? What do you mean with: the ability to change the right access?

    Thanks,
    Peter

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Check out the latest update @joec002!

    You can now globally search multiple tables and even multiple databases. And it has a replace features as well… ??

    Thread Starter joec002

    (@joec002)

    Excellent news. Thank you for your hard work.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Useful, but not for searching’ is closed to new replies.