A query to substitute images paths in gutenberg (website migration)?

I just found out the reason. It’s because I’m using ACF Pro as Blocks. The data will be written in database in json format, and the urls will escape all the slashes ad double quotes. So for example src=\”http:\/\/dev.example.com\/website\/wp-content\/uploads\/2019\/10\/identity.jpg\” So I should add a row like this: update wp_posts set post_content = replace(post_content,’http:\/\/dev.example.com\/website’, ‘http:\/\/www.website.com’);

Long loading site after migration

From what I see right now I can give such advice: Optimize images with https://squoosh.app/ for example https://consolezone.pl/wp-content/uploads/re.jpg can be optimized from 490kb to 188kb with mozJpeg 0.75 ratio (you need to adjust ratio for images according to their look and feel, 0.85 is usually quite enough). Also for JPG sometimes image of 2000×2000 px … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)