Searching PHPmyadmin

I have about 200 databases in phpmyadmin.

I accidentally deleted all of the files in one of the directories, but I still need the .sql database.

Now I have no idea which one it is, because the wp-config file is gone.

Is there a way to search for the URL inside of wp-options without checking every single one?

Thanks!

 

Hi,

You have 200 databases or tables?

 

200 separate databases.

 

I think there is not direct way in phpmyadmin, you need to write a small php script and run it
You may try this

$con = mysql_connect('localhost', 'mysql_user', 'mysql_password');
$res = mysql_query("SHOW DATABASES");

while ($row = mysql_fetch_assoc($res)) {
    mysql_select_db($row['Database'], $con);
    $result2 = mysql_query("SELECT option_id FROM `wp_options` WHERE option_value like '%your_search_url%' and option_name ='siteurl'");
    $row2 = mysql_fetch_row($result2);
    if($row2[0]!=''){
        echo $row['Database'];
        exit;
    }
}

mysql_close($con);

Code (markup):