Re: WordPress Move to New Domain & Server. Image Thumbnail Fail.

[Krist]

Basic code

$your_db = 'your_db';

$your_host = 'localhost';

$your_access = 'root';

$your_pass = 'password';



$old = 'your/path/';

$new = 'your/new/path/';



$con = mysql_connect($your_host,$your_access,$your_password);

mysql_select_db($your_db , $con);



$get_all = mysql_query("SELECT * FROM your_table WHERE your_column LIKE '%$old%'");



while($row = mysql_fetch_array($get_all))

{

mysql_query("UPDATE your_table SET your_colum=$new WHERE id = $row");

}

?>