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!
Articles récents
- WordPress – Modifier ses adresses web dans sa base de données 14 novembre 2017
- WordPress oui mais pourquoi Cre4tic ? 23 mars 2017
Pingback: What is nature's best antibiotic
Pingback: porn
Pingback: Äèçàéí ÷åëîâåêà
Pingback: Can I drink milk after taking antibiotics
Pingback: anti viagra pills
Pingback: vardenafil cost
Pingback: What are signs you need an antibiotic
Pingback: vardenafil 40 mg
Pingback: What happens when you take probiotics everyday buy stromectol 6mg online
Pingback: madridbet
Pingback: What happens if you don't take antibiotics for an infection
Pingback: What are strong antibiotic side effects
Pingback: meritking
Pingback: What are the top 5 antibiotics
Pingback: What can easily cure infection
Pingback: Is it OK to stop antibiotics after 2 days
Pingback: What is a natural antibiotic
Pingback: 2023
Pingback: Which fruit is good for killing bacteria
Pingback: Do antibiotics damage body cells
Pingback: How do I know if I need antibiotics ivermectin 1
Pingback: Qu'est-ce qui rend une famille heureuse - sildenafil pfizer.
Pingback: madridbet
Pingback: How many years will minoxidil work finasteride 1mg for hair loss
Pingback: https://tinyurl.com/2lacn6n3
Pingback: vsovezdeisrazu
Pingback: Can you still get hard if you have erectile dysfunction?
Pingback: What are the 7 tools of TQM?
Pingback: What is the biggest strength of a man?
Pingback: Should I get tested after every partner | stromectol 12mg
Pingback: How do I know the relationship is over?
Pingback: Does playing hard for guys work?
Pingback: buy letrozole online
Pingback: pramipexole dosage
Pingback: madridbet
Pingback: Quelles sont les qualites d'une bonne famille meilleure parapharmacie en ligne
Pingback: Quels sont les quatre parametres du son pharmacie en ligne sans ordonnance
Pingback: where buy clomid
Pingback: Ist Cialis gut fur das Herz - kamagra kaufen holland
Pingback: How did she get pregnant if pulled out otc Azithromycin
Pingback: vidalista 90 purchase sildenafil online
Pingback: can you buy cheap propecia without prescription
Pingback: Cialis headache: What age are most dads | ScwCMD.com
Pingback: Ivermectin injection
Pingback: What are three easy exercises to lower blood pressure immediately Zestril
Pingback: What do Americans call each other
Pingback: How often can I use my nebulizer
Pingback: Is rice hard on the liver
Pingback: batmanapollo.ru - psychologist
Pingback: Can I stop antibiotics after 1 tablet
Pingback: shopping for cialis
Pingback: batmanapollo
Pingback: pfizer viagra 100mg price
Pingback: kinokrad
Pingback: sibluevi.com sildenafil
Pingback: What are the two most common parasitic infections to infest humans get azithromycin over counter
Pingback: What happens right before sepsis azithromycin treatment for chlamydia
Pingback: jozsildenafil.com prescription drugs
Pingback: sildenafil sndz
Pingback: How quickly does turmeric reduce inflammation or fish mox walmart
Pingback: What makes a man fall deeply in love with a woman cialis 100mg
Pingback: tretinoin costco
Pingback: tretinoin creams
Pingback: What foods make sperm thicker and stronger priligy 30mg drug
Pingback: What happens to a female when they are turned on fildena 100 online india
Pingback: What is a true love viagra cialis kamagra levitra
Pingback: How much free time does the average person need vidalista 20
Pingback: What foods restore gut after antibiotics and stromectol tablets uk
Pingback: Can I ask for antibiotics from pharmacist without plaquenil hydroxychloroquine
Pingback: What are a woman's needs in a relationship levitra 20
Pingback: What are the seven signs you need magnesium levitra professional reviews
Pingback: What food can add sperm purchase cenforce without prescription
Pingback: Why does Activia work so well with side effects of plaquenil
Pingback: ivermectin australia
Pingback: Can your liver hurt in your back and who makes plaquenil
Pingback: How can I detox my liver in 2 days and does hydroxychloroquine cause hair loss
Pingback: What are 3 problems with antibiotics with buy hydroxychloroquine
Pingback: How much antibiotic is too much such as where to buy ivermectin pills
Pingback: What is GREY discharge such as ivermectin cream canada cost
Pingback: Do breakups change you dapoxetine 30mg brand
Pingback: purchase dapoxetine for sale
Pingback: buy kamagra online
Pingback: buy kamagra oral jelly australia
Pingback: Devam edersen ederim ananı sıkerım
Pingback: What makes a man stronger sildenafil 100 mexico?
Pingback: What makes men wanna marry how to take sildenafil 20 mg?
Pingback: zithromax 500 mg lowest price online
Pingback: How many times should a man release sperm in a day 20 mg sildenafil?
Pingback: What is the number one thing a man wants in a woman 100 mg viagra?
Pingback: Why can't you take your shirt off at Planet Fitness sildenafil generic?
Pingback: Is it harder to have a boy or girl citrate tablets ip 100mg?
Pingback: What is the sweetest way to talk to your boyfriend walgreens pharmacy sildenafil citrate 20mg?
Pingback: Does the dollar store sell magazines sildenafil citrate?
Pingback: What is the best routine everyday walmart pharmacy sildenafil price?
Pingback: Is ED a permanent thing sildenafil walmart price?
Pingback: How do you know a man loves you sildenafil?
Pingback: How many ejaculation a week is healthy sildenafil walmart cost?
Pingback: What are signs your partner is cheating cialis 5 mg price cvs?
Pingback: eczema treatment over the counter
Pingback: How does a man show his love without saying it cialis tadalafil 20mg?
Pingback: What time of day is sperm count highest cialis tadalafil 20mg tablets?
Pingback: 123movies
Pingback: xnxx
Pingback: 9xflix
Pingback: x
Pingback: dating sites online
Pingback: https://gdznew.ru/
Pingback: aarp recommended canadian online pharmacies
Pingback: azithromycin canadian pharmacy
Pingback: order dapoxetine 60mg online cheap
Pingback: ed treatment drugs
Pingback: buy cipro cheap
Pingback: mangalib
Pingback: madridbet
Pingback: fuck google
Pingback: modafinil online pharmacy
Pingback: fuck google
Pingback: canadian pharmacies comparison
Pingback: okey oyna
Pingback: fuvk google
Pingback: sikiş
Pingback: fuck google
Pingback: https://bitbin.it/X5y9A1Fd/
Pingback: https://bitbin.it/yeCU06m7/
Pingback: 2022-film
Pingback: madridbet
Pingback: https://bit.ly/n39i18b
Pingback: https://bit.ly/okaybaybay
Pingback: Medication tidings in return patients. Cautions paxil pill color?
Pingback: tqmFEB3B
Pingback: Panacea prescribing information. Brand name names. In Canada paxil cr generic?
Pingback: Pills info sheet. Brand names. finasteride 1mg buy online?
Pingback: where to buy fildena
Pingback: klondayk2022
Pingback: irannews.ru
Pingback: Pills information. What side effects? avodart prostate?
Pingback: uluro-ado
Pingback: rusnewsweek
Pingback: 24hours-news
Pingback: icf
Pingback: How long will it take him to miss me buy viagra online cheap canada?
Pingback: www
Pingback: bep5w0Df
Pingback: buy stromectol online cheap
Pingback: generic vardenafil
Pingback: grandpashabet
Pingback: Does jealousy make an ex come back or how to get rid of red face from viagra?
Pingback: Grandpashabet
Pingback: What vitamin makes you lose the most weight and the hoodia appetite suppressant?
Pingback: bit.ly/3GQNK0J
Pingback: bit.ly/3ig2UT5
Pingback: bit.ly/3ARFdXA
Pingback: vidalista 80
Pingback: bit.ly/3gGFqGq
Pingback: bit.ly/3OEzOZR
Pingback: Can smoker lungs return to normal how long for chantix to start working?
Pingback: Can you feel your sperm or order kamagra?
Pingback: buy kamagra
Pingback: matchonline2022.ru
Pingback: serialhd2023.ru
Pingback: does cenforce 100 work
Pingback: blue sky peptide tadalafil
Pingback: hdserial2023.ru
Pingback: 1703
Pingback: cttdu.ru
Pingback: 1c789.ru
Pingback: sitestats01
Pingback: https://bit.ly/3Esup4r
Pingback: grandpashabet
Pingback: propecia 1mg buy
Pingback: propecia tablets cheap
Pingback: site 2023
Pingback: brutv
Pingback: tftl.ru
Pingback: meritking
Pingback: newsukraine.ru
Pingback: history-of-ukraine.ru news ukraine
Pingback: buy kamagra online
Pingback: mb588.ru
Pingback: 3o9cpydyue4s8.ru
Pingback: kin0shki.ru
Pingback: zamazingo1
Pingback: https://clck.ru/32JaEo
Pingback: dolpsy.ru
Pingback: https://bitbin.it/JI5X9Xvu/
Pingback: https://bitbin.it/bn1QAiBO/
Pingback: buy hydroxychloroquine online
Pingback: madridbet
Pingback: rftrip.ru
Pingback: what is hydroxychloroquine made from
Pingback: wwwi.odnoklassniki-film.ru
Pingback: 3DGofO7
Pingback: 3SoTS32
Pingback: 000-1
Pingback: stromectol 12mg online
Pingback: psy-news.ru
Pingback: socionika-eniostyle.ru
Pingback: sezons.store
Pingback: video-2
Pingback: 3qAIwwN
Pingback: psycholog-moskva.ru
Pingback: psycholog-v-moskve.ru
Pingback: buy ivermectin 3 mg
Pingback: programma peredach na segodnya
Pingback: film onlinee
Pingback: lalochesia
Pingback: meriking
Pingback: psy 3CtwvjS
Pingback: TwnE4zl6
Pingback: Dim Drakona 2022
Pingback: Usik Dzhoshua 2 2022
Pingback: A片
Pingback: psikholog moskva
Pingback: ìûøëåíèå
Pingback: aOuSjapt
Pingback: JGXldbkj
Pingback: Dom drakona
Pingback: sY5am
Pingback: rodnoe-kino-ru
Pingback: filmgoda.ru
Pingback: cialis generico
Pingback: smotret-polnyj-film-smotret-v-khoroshem-kachestve
Pingback: liusia-8-seriiaonlain
Pingback: cialis over the counter at walmart
Pingback: generic cialis available in canada
Pingback: film
Pingback: video
Pingback: web
Pingback: mir dikogo zapada 4 sezon 4 seriya
Pingback: stats
Pingback: stromectol lotion for lice
Pingback: revatio
Pingback: gidonline
Pingback: movies
Pingback: Ukraine-war
Pingback: sildenafil citrate
Pingback: site
Pingback: stromectol 6 mg
Pingback: viagra
Pingback: The Latest Ukraine News
Pingback: Ukraine news live
Pingback: Ukraine
Pingback: War in Ukraine
Pingback: bucha killings
Pingback: cleantalkorg2.ru
Pingback: bit.ly
Pingback: buy stromectol 3mg for humans
Pingback: tor-lyubov-i-grom.ru
Pingback: stromectol price in india
Pingback: coupons for ivermectin
Pingback: Link
Pingback: meritroyalbet
Pingback: https://bit.ly/psikholog-muzhchina-onlayn
Pingback: netstate.ru
Pingback: Psikholog
Pingback: stromectol pills
Pingback: hdorg2.ru
Pingback: hd-tor-2022
Pingback: film-tor-2022
Pingback: tor-lyubov-i-grom
Pingback: 01211
Pingback: 3NOZC44
Pingback: 3Hk12Bl
Pingback: chelovek-iz-90-h
Pingback: russianmanagement.com
Pingback: Øêàëà òîíîâ
Pingback: SHKALA TONOV
Pingback: https://ria.ru/20100906/272903623.html
Pingback: D6tuzANh
Pingback: qQ8KZZE6
Pingback: DPTPtNqS
Pingback: bahis siteleri
Pingback: ivermectin at tractor supply
Pingback: slovar po psihoanalizu laplansh
Pingback: psy-
Pingback: stromectol price uk
Pingback: frontline doctors ivermectin
Pingback: cialis f
Pingback: where to buy viagra
Pingback: ivermectin scabies how fast does it work
Pingback: can you buy cialis without a prescription
Pingback: tadalafil 20 mg buy online
Pingback: canadian drug
Pingback: prescription drugs online
Pingback: ed doctor
Pingback: ivermectin cream 1%
Pingback: natural cure for ed
Pingback: rosacea ivermectin
Pingback: milbemycin oxime vs ivermectin
Pingback: how much is ivermectin
Pingback: cheap erectile dysfunction pills online
Pingback: otc ed drugs
Pingback: best ed pills online
Pingback: ivermectin new zealand
Pingback: child porn
Pingback: ivermectin rx
Pingback: stromectol cost
Pingback: ivermectin dose
Pingback: clomid online us
Pingback: meritroyalbet
Pingback: can i buy clomid online
Pingback: clomid online paypal
Pingback: clomid infertility
Pingback: cialissite:au
Pingback: can you buy stromectol over the counter
Pingback: eurocasino
Pingback: meritroyalbet
Pingback: ivermectin online
Pingback: when to take cialis for best results
Pingback: iver mectin
Pingback: hydroxychloroquine for sale
Pingback: side effects for ivermectin
Pingback: what does a cialis pill look like
Pingback: lucky land slots play now
Pingback: madridbet
Pingback: cialis daily
Pingback: ivermectin tablets for sale
Pingback: cost of stromectol
Pingback: how to get ivermectin in canada
Pingback: ivermectin dog
Pingback: eurocasino
Pingback: eurocasino
Pingback: ivermectin brand
Pingback: tadalafil india
Pingback: cialis online canada
Pingback: stromectol ivermectin
Pingback: furosemide 2018
Pingback: furosemide 20 mg price
Pingback: meritking
Pingback: meritking
Pingback: meritroyalbet
Pingback: ivermectin lotion cost
Pingback: buy ivermectin for humans australia
Pingback: buy minocycline 50mg otc
Pingback: generic ivermectin for humans
Pingback: ivermectin 12mg pills
Pingback: viagra and high blood pressure
Pingback: ivermectin bestellen
Pingback: can you buy generic cialis in canada
Pingback: ivermectin 3mg for sale
Pingback: order stromectol online
Pingback: ivermectin ingredients
Pingback: buy ivermectin 6 mg for humans
Pingback: where can i get doxycycline
Pingback: ivermectin tablets buy online
Pingback: ivermectin buy uk
Pingback: clomid online no prescription
Pingback: canada cialis no prescription
Pingback: ivermectin humans
Pingback: ivermectin 3mg cost
Pingback: ivermectin gold
Pingback: ivermectin 4 tablets price
Pingback: generic cialis
Pingback: ivermectin 12mg pills
Pingback: viagra generic online cheapest
Pingback: cialis pills
Pingback: real money slots
Pingback: ivermectin 18mg
Pingback: ivermectin generic name
Pingback: cheap tadalafil
Pingback: borgata pa online casino
Pingback: azithromycin uti
Pingback: cialis goodrx
Pingback: sildenafilo
Pingback: usa casinos no deposit free welcome bonus
Pingback: buy cialis online
Pingback: generic viagra side effects
Pingback: prednisone side effects in women
Pingback: ivermectin pill cost
Pingback: child porn
Pingback: tadalafil nebenwirkungen
Pingback: tadalafil online purchase
Pingback: cheap molnupiravir
Pingback: where to get cialis prescription
Pingback: merck covid pill ivermectin
Pingback: cialis prescription online usa
Pingback: what is prednisone 20mg tablets
Pingback: prednisone 20mg nebenwirkungen
Pingback: otc cialis
Pingback: how to buy cialis in india
Pingback: tombala siteleri
Pingback: cialis pills
Pingback: where can you buy sildenafil pills
Pingback: sildenafil pills generic brand
Pingback: horse paste ivermectin
Pingback: canadian online drugs
Pingback: how to buy cialis in uk
Pingback: baymavi
Pingback: sildenafil pills for men
Pingback: baymavi
Pingback: when will cialis be generic
Pingback: medshuku cialis generic best price
Pingback: buy brand cialis canada
Pingback: side effects of tadalafil
Pingback: tadalafil without a doctor prescription
Pingback: can you buy cialis safely online
Pingback: ivermectine
Pingback: zithromax
Pingback: buying viagra online
Pingback: tadalafilo
Pingback: viagra professional sale
Pingback: ivermectin buy australia
Pingback: ivermectin tablet 1mg
Pingback: provigil cialis
Pingback: walgreens provigil cost
Pingback: meritroyalbet
Pingback: buy ventolin online no prescription
Pingback: goodrx cialis
Pingback: coupons for tadalafil
Pingback: cialis generic canada
Pingback: prednisone 20mg uk
Pingback: stromectol cream
Pingback: cialis generic
Pingback: ivermectin australia
Pingback: stromectol walgreens
Pingback: ignition casino legal
Pingback: ivermectin online
Pingback: stromectol for sale
Pingback: flccc ivermectin
Pingback: where to get ivermectin
Pingback: order ivermectin
Pingback: stromectol walgreens
Pingback: buy ivermectin online
Pingback: stromectol walgreens
Pingback: cheap viagra buy
Pingback: flccc ivermectin
Pingback: ivermectin treatment for covid
Pingback: ivermectin nz
Pingback: stromectol generic
Pingback: price of ivermectin tablets
Pingback: ivermectin cost in usa
Pingback: stromectol for humans
Pingback: generic stromectol
Pingback: ivermectin tablet 1mg
Pingback: ivermectin 2mg
Pingback: ivermectin 3mg tablets price
Pingback: stromectol 3 mg dosage
Pingback: flccc alliance treatment protocol
Pingback: meritroyalbet
Pingback: flccc ivermectin
Pingback: flccc ivermectin
Pingback: tombala siteleri
Pingback: tombala siteleri
Pingback: ventolin in usa
Pingback: trcasino
Pingback: ivermectin eye drops
Pingback: ivermectin nz
Pingback: womens viagra
Pingback: discount viagra online canada
Pingback: how to buy cialis in india
Pingback: stromectol generic
Pingback: buy cheap ventolin inhalers
Pingback: trcasino
Pingback: elexusbet
Pingback: ivermectin 5 mg
Pingback: madridbet
Pingback: buy viagra generic
Pingback: perabet
Pingback: viagra for men under 30
Pingback: order viagra without rx
Pingback: cialis 50mg
Pingback: viagra sildenafil 50mg tablets
Pingback: levitra com
Pingback: meritroyalbet
Pingback: bets baccaratonline money
Pingback: meritroyalbet
Pingback: meritking
Pingback: eurocasino
Pingback: eurocasino
Pingback: meritroyalbet
Pingback: madridbet
Pingback: eurocasino
Pingback: elexusbet
Pingback: meritking
Pingback: buy viagra 50mg online
Pingback: female cialis 20mg pills
Pingback: best website for online blackjack