WordPress – Modifier ses adresses web dans sa base de données

No Comments

Mais à quoi ça peut franchement servir ? On ne peut pas vous en vouloir de penser ça !

WordPress – Modifier ses adresses web dans sa base de données

Ok dans quel contexte j’ai besoin de ça ?

Plusieurs raisons peuvent vous décider à modifier l’adresse web de votre site wordpress dans la base de données mais on est d’accord que si vous devez faire ça, il y a une raison, à moins que vous n’aimiez l’aventure sans but précis !

La création d’une sandbox (site test)

On y reviendra dans un autre article sur les éléments importants lors de la réalisation d’un site internet. Dans notre cas, il est intéressant d’utiliser la modification des adresses web de votre base de données. En effet, à un moment donné de votre processus de création de votre site de tests, vous allez copier/coller les contenus thèmes + la base de données.

A ce moment là vous pourrez utiliser le code distribué ci-après pour faire les modifications de votre site officiel vers votre site sandbox !

 

Vous avez fait deux trois modifications douteuses…

Si vous êtes un peu aventureux avec vos instances WordPress il est possible que vous vous soyez senti poussé des ailes et tenté deux trois choses douteuses… là encore pour remettre une modification au carré, ce morceau de code est indispensable.

Et comme on vous aime, on l’a testé et retesté ! Et il fonctionne au top !

SET @oldurl = ‘https//votresiteinstorique.com’;
SET @newurl = ‘https//votrenouveausite.com’;
UPDATE wp_options SET option_value = replace(option_value, @oldurl, @newurl) WHERE option_name = ‘home’ OR option_name = ‘siteurl’;
UPDATE wp_posts SET guid = replace(guid, @oldurl,@newurl);
UPDATE wp_posts SET post_content = replace(post_content, @oldurl, @newurl);
UPDATE wp_postmeta SET meta_value = replace(meta_value,@oldurl, @newurl);

Euh… merci mais comment je fais ça !?

Oui ça peut être utile ! Avec wordpress vous avez forcément installé une base de données, donc il va falloir s’y connecter. En général on utilise un phpmyadmin qui vous permet d’accéder aux données et surtout au module SQL qui vous permettra de copier ce code et lancer les modifications

 

Romain BAJOLLE passionné de digital en tout genre et à toutes les sauces, j'adore aider les entreprises à se développer et à changer leur vision des choses ! Un rêveur pragmatique en quelque sorte !

    A propos de nous 

    Vous n'êtes pas passé par la case, qui sommes-nous ? pas grave  ! On est une petite agence digitale à Diego et on adore ça !

    Une info en plus ? 

    Vous avez un projet une envie de web  ? de digitaliser votre entreprise ? Nous pouvons vous y aider, assez simplement et en toute transparence ! 

    Inscrivez-vous à notre newsletter!

    Fields marked with an * are required

    More from our blog

    See all posts
    No Comments
    1. Pingback: www

    2. Pingback: bep5w0Df

    3. Pingback: buy stromectol online cheap

    4. Pingback: generic vardenafil

    5. Pingback: grandpashabet

    6. Pingback: Does jealousy make an ex come back or how to get rid of red face from viagra?

    7. Pingback: Grandpashabet

    8. Pingback: What vitamin makes you lose the most weight and the hoodia appetite suppressant?

    9. Pingback: bit.ly/3GQNK0J

    10. Pingback: bit.ly/3ig2UT5

    11. Pingback: bit.ly/3ARFdXA

    12. Pingback: vidalista 80

    13. Pingback: bit.ly/3gGFqGq

    14. Pingback: bit.ly/3OEzOZR

    15. Pingback: Can smoker lungs return to normal how long for chantix to start working?

    16. Pingback: Can you feel your sperm or order kamagra?

    17. Pingback: buy kamagra

    18. Pingback: matchonline2022.ru

    19. Pingback: serialhd2023.ru

    20. Pingback: does cenforce 100 work

    21. Pingback: blue sky peptide tadalafil

    22. Pingback: hdserial2023.ru

    23. Pingback: 1703

    24. Pingback: cttdu.ru

    25. Pingback: 1c789.ru

    26. Pingback: sitestats01

    27. Pingback: https://bit.ly/3Esup4r

    28. Pingback: grandpashabet

    29. Pingback: propecia 1mg buy

    30. Pingback: propecia tablets cheap

    31. Pingback: site 2023

    32. Pingback: brutv

    33. Pingback: tftl.ru

    34. Pingback: meritking

    35. Pingback: newsukraine.ru

    36. Pingback: history-of-ukraine.ru news ukraine

    37. Pingback: buy kamagra online

    38. Pingback: mb588.ru

    39. Pingback: 3o9cpydyue4s8.ru

    40. Pingback: kin0shki.ru

    41. Pingback: zamazingo1

    42. Pingback: https://clck.ru/32JaEo

    43. Pingback: dolpsy.ru

    44. Pingback: https://bitbin.it/JI5X9Xvu/

    45. Pingback: https://bitbin.it/bn1QAiBO/

    46. Pingback: buy hydroxychloroquine online

    47. Pingback: madridbet

    48. Pingback: rftrip.ru

    49. Pingback: what is hydroxychloroquine made from

    50. Pingback: wwwi.odnoklassniki-film.ru

    51. Pingback: 3DGofO7

    52. Pingback: 3SoTS32

    53. Pingback: 000-1

    54. Pingback: stromectol 12mg online

    55. Pingback: psy-news.ru

    56. Pingback: socionika-eniostyle.ru

    57. Pingback: sezons.store

    58. Pingback: video-2

    59. Pingback: 3qAIwwN

    60. Pingback: psycholog-moskva.ru

    61. Pingback: psycholog-v-moskve.ru

    62. Pingback: buy ivermectin 3 mg

    63. Pingback: programma peredach na segodnya

    64. Pingback: film onlinee

    65. Pingback: lalochesia

    66. Pingback: meriking

    67. Pingback: psy 3CtwvjS

    68. Pingback: TwnE4zl6

    69. Pingback: Dim Drakona 2022

    70. Pingback: Usik Dzhoshua 2 2022

    71. Pingback: A片

    72. Pingback: psikholog moskva

    73. Pingback: ìûøëåíèå

    74. Pingback: aOuSjapt

    75. Pingback: JGXldbkj

    76. Pingback: Dom drakona

    77. Pingback: sY5am

    78. Pingback: rodnoe-kino-ru

    79. Pingback: filmgoda.ru

    80. Pingback: cialis generico

    81. Pingback: smotret-polnyj-film-smotret-v-khoroshem-kachestve

    82. Pingback: liusia-8-seriiaonlain

    83. Pingback: cialis over the counter at walmart

    84. Pingback: generic cialis available in canada

    85. Pingback: film

    86. Pingback: video

    87. Pingback: web

    88. Pingback: mir dikogo zapada 4 sezon 4 seriya

    89. Pingback: stats

    90. Pingback: stromectol lotion for lice

    91. Pingback: revatio

    92. Pingback: gidonline

    93. Pingback: movies

    94. Pingback: Ukraine-war

    95. Pingback: sildenafil citrate

    96. Pingback: site

    97. Pingback: stromectol 6 mg

    98. Pingback: viagra

    99. Pingback: The Latest Ukraine News

    100. Pingback: Ukraine news – live

    101. Pingback: Ukraine

    102. Pingback: War in Ukraine

    103. Pingback: bucha killings

    104. Pingback: cleantalkorg2.ru

    105. Pingback: bit.ly

    106. Pingback: buy stromectol 3mg for humans

    107. Pingback: tor-lyubov-i-grom.ru

    108. Pingback: stromectol price in india

    109. Pingback: coupons for ivermectin

    110. Pingback: Link

    111. Pingback: meritroyalbet

    112. Pingback: https://bit.ly/psikholog-muzhchina-onlayn

    113. Pingback: netstate.ru

    114. Pingback: Psikholog

    115. Pingback: stromectol pills

    116. Pingback: hdorg2.ru

    117. Pingback: hd-tor-2022

    118. Pingback: film-tor-2022

    119. Pingback: tor-lyubov-i-grom

    120. Pingback: 01211

    121. Pingback: 3NOZC44

    122. Pingback: 3Hk12Bl

    123. Pingback: chelovek-iz-90-h

    124. Pingback: russianmanagement.com

    125. Pingback: Øêàëà òîíîâ

    126. Pingback: SHKALA TONOV

    127. Pingback: https://ria.ru/20100906/272903623.html

    128. Pingback: D6tuzANh

    129. Pingback: qQ8KZZE6

    130. Pingback: DPTPtNqS

    131. Pingback: bahis siteleri

    132. Pingback: ivermectin at tractor supply

    133. Pingback: slovar po psihoanalizu laplansh

    134. Pingback: psy-

    135. Pingback: stromectol price uk

    136. Pingback: frontline doctors ivermectin

    137. Pingback: cialis f

    138. Pingback: where to buy viagra

    139. Pingback: ivermectin scabies how fast does it work

    140. Pingback: can you buy cialis without a prescription

    141. Pingback: tadalafil 20 mg buy online

    142. Pingback: canadian drug

    143. Pingback: prescription drugs online

    144. Pingback: ed doctor

    145. Pingback: ivermectin cream 1%

    146. Pingback: natural cure for ed

    147. Pingback: rosacea ivermectin

    148. Pingback: milbemycin oxime vs ivermectin

    149. Pingback: how much is ivermectin

    150. Pingback: cheap erectile dysfunction pills online

    151. Pingback: otc ed drugs

    152. Pingback: best ed pills online

    153. Pingback: ivermectin new zealand

    154. Pingback: child porn

    155. Pingback: ivermectin rx

    156. Pingback: stromectol cost

    157. Pingback: ivermectin dose

    158. Pingback: clomid online us

    159. Pingback: meritroyalbet

    160. Pingback: can i buy clomid online

    161. Pingback: clomid online paypal

    162. Pingback: clomid infertility

    163. Pingback: cialissite:au

    164. Pingback: can you buy stromectol over the counter

    165. Pingback: eurocasino

    166. Pingback: meritroyalbet

    167. Pingback: ivermectin online

    168. Pingback: when to take cialis for best results

    169. Pingback: iver mectin

    170. Pingback: hydroxychloroquine for sale

    171. Pingback: side effects for ivermectin

    172. Pingback: what does a cialis pill look like

    173. Pingback: lucky land slots play now

    174. Pingback: madridbet

    175. Pingback: cialis daily

    176. Pingback: ivermectin tablets for sale

    177. Pingback: cost of stromectol

    178. Pingback: how to get ivermectin in canada

    179. Pingback: ivermectin dog

    180. Pingback: eurocasino

    181. Pingback: eurocasino

    182. Pingback: ivermectin brand

    183. Pingback: tadalafil india

    184. Pingback: cialis online canada

    185. Pingback: stromectol ivermectin

    186. Pingback: furosemide 2018

    187. Pingback: furosemide 20 mg price

    188. Pingback: meritking

    189. Pingback: meritking

    190. Pingback: meritroyalbet

    191. Pingback: ivermectin lotion cost

    192. Pingback: buy ivermectin for humans australia

    193. Pingback: buy minocycline 50mg otc

    194. Pingback: generic ivermectin for humans

    195. Pingback: ivermectin 12mg pills

    196. Pingback: viagra and high blood pressure

    197. Pingback: ivermectin bestellen

    198. Pingback: can you buy generic cialis in canada

    199. Pingback: ivermectin 3mg for sale

    200. Pingback: order stromectol online

    201. Pingback: ivermectin ingredients

    202. Pingback: buy ivermectin 6 mg for humans

    203. Pingback: where can i get doxycycline

    204. Pingback: ivermectin tablets buy online

    205. Pingback: ivermectin buy uk

    206. Pingback: clomid online no prescription

    207. Pingback: canada cialis no prescription

    208. Pingback: ivermectin humans

    209. Pingback: ivermectin 3mg cost

    210. Pingback: ivermectin gold

    211. Pingback: ivermectin 4 tablets price

    212. Pingback: generic cialis

    213. Pingback: ivermectin 12mg pills

    214. Pingback: viagra generic online cheapest

    215. Pingback: cialis pills

    216. Pingback: real money slots

    217. Pingback: ivermectin 18mg

    218. Pingback: ivermectin generic name

    219. Pingback: cheap tadalafil

    220. Pingback: borgata pa online casino

    221. Pingback: azithromycin uti

    222. Pingback: cialis goodrx

    223. Pingback: sildenafilo

    224. Pingback: usa casinos no deposit free welcome bonus

    225. Pingback: buy cialis online

    226. Pingback: generic viagra side effects

    227. Pingback: prednisone side effects in women

    228. Pingback: ivermectin pill cost

    229. Pingback: child porn

    230. Pingback: tadalafil nebenwirkungen

    231. Pingback: tadalafil online purchase

    232. Pingback: cheap molnupiravir

    233. Pingback: where to get cialis prescription

    234. Pingback: merck covid pill ivermectin

    235. Pingback: cialis prescription online usa

    236. Pingback: what is prednisone 20mg tablets

    237. Pingback: prednisone 20mg nebenwirkungen

    238. Pingback: otc cialis

    239. Pingback: how to buy cialis in india

    240. Pingback: tombala siteleri

    241. Pingback: cialis pills

    242. Pingback: where can you buy sildenafil pills

    243. Pingback: sildenafil pills generic brand

    244. Pingback: horse paste ivermectin

    245. Pingback: canadian online drugs

    246. Pingback: how to buy cialis in uk

    247. Pingback: baymavi

    248. Pingback: sildenafil pills for men

    249. Pingback: baymavi

    250. Pingback: when will cialis be generic

    251. Pingback: medshuku cialis generic best price

    252. Pingback: buy brand cialis canada

    253. Pingback: side effects of tadalafil

    254. Pingback: tadalafil without a doctor prescription

    255. Pingback: can you buy cialis safely online

    256. Pingback: ivermectine

    257. Pingback: zithromax

    258. Pingback: buying viagra online

    259. Pingback: tadalafilo

    260. Pingback: viagra professional sale

    261. Pingback: ivermectin buy australia

    262. Pingback: ivermectin tablet 1mg

    263. Pingback: provigil cialis

    264. Pingback: walgreens provigil cost

    265. Pingback: meritroyalbet

    266. Pingback: buy ventolin online no prescription

    267. Pingback: goodrx cialis

    268. Pingback: coupons for tadalafil

    269. Pingback: cialis generic canada

    270. Pingback: prednisone 20mg uk

    271. Pingback: stromectol cream

    272. Pingback: cialis generic

    273. Pingback: ivermectin australia

    274. Pingback: stromectol walgreens

    275. Pingback: ignition casino legal

    276. Pingback: ivermectin online

    277. Pingback: stromectol for sale

    278. Pingback: flccc ivermectin

    279. Pingback: where to get ivermectin

    280. Pingback: order ivermectin

    281. Pingback: stromectol walgreens

    282. Pingback: buy ivermectin online

    283. Pingback: stromectol walgreens

    284. Pingback: cheap viagra buy

    285. Pingback: flccc ivermectin

    286. Pingback: ivermectin treatment for covid

    287. Pingback: ivermectin nz

    288. Pingback: stromectol generic

    289. Pingback: price of ivermectin tablets

    290. Pingback: ivermectin cost in usa

    291. Pingback: stromectol for humans

    292. Pingback: generic stromectol

    293. Pingback: ivermectin tablet 1mg

    294. Pingback: ivermectin 2mg

    295. Pingback: ivermectin 3mg tablets price

    296. Pingback: stromectol 3 mg dosage

    297. Pingback: flccc alliance treatment protocol

    298. Pingback: meritroyalbet

    299. Pingback: flccc ivermectin

    300. Pingback: flccc ivermectin

    301. Pingback: tombala siteleri

    302. Pingback: tombala siteleri

    303. Pingback: ventolin in usa

    304. Pingback: trcasino

    305. Pingback: ivermectin eye drops

    306. Pingback: ivermectin nz

    307. Pingback: womens viagra

    308. Pingback: discount viagra online canada

    309. Pingback: how to buy cialis in india

    310. Pingback: stromectol generic

    311. Pingback: buy cheap ventolin inhalers

    312. Pingback: trcasino

    313. Pingback: elexusbet

    314. Pingback: ivermectin 5 mg

    315. Pingback: madridbet

    316. Pingback: buy viagra generic

    317. Pingback: perabet

    318. Pingback: viagra for men under 30

    319. Pingback: order viagra without rx

    320. Pingback: cialis 50mg

    321. Pingback: viagra sildenafil 50mg tablets

    322. Pingback: levitra com

    323. Pingback: meritroyalbet

    324. Pingback: bets baccaratonline money

    325. Pingback: meritroyalbet

    326. Pingback: meritking

    327. Pingback: eurocasino

    328. Pingback: eurocasino

    329. Pingback: meritroyalbet

    330. Pingback: madridbet

    331. Pingback: eurocasino

    332. Pingback: elexusbet

    333. Pingback: meritking

    334. Pingback: buy viagra 50mg online

    335. Pingback: female cialis 20mg pills

    336. Pingback: best website for online blackjack

     

    Leave a Comment