# BDD

# Changement d'IP ou de nom de domaine

Se connecter sur la base de données du site WP

Remplacer OLD.OLD par l'ancienne URL et NEW.NEW par la nouvelle

```mysql
UPDATE wp_options SET option_value = replace(option_value, 'https://OLD.OLD', 'https://NEW.NEW') WHERE option_name = 'home' OR option_name = 'siteurl';
```

```mysql
UPDATE wp_posts SET guid = replace(guid, 'https://OLD.OLD','https://NEW.NEW');
```

```mysql
UPDATE wp_posts SET post_content = replace(post_content, 'https://OLD.OLD', 'https://NEW.NEW');
```

```mysql
UPDATE wp_postmeta SET meta_value = replace(meta_value,'https://OLD.OLD','https://NEW.NEW');
```

Depuis le CLI du serveur

```bash
wp search-replace http://OLD.OLD https://NEW.NEW --all-tables
```

```bash
wp elementor replace_urls http://OLD.OLD https://NEW.NEW
```