Find and Replace text in all tables in a database using Mysql query?
Allen_Jolynn0
New member
- Joined
- Apr 26, 2018
- Messages
- 1
- Points
- 3
If you want to edit from all tables, best way is to take the dump and then find/replace and upload it back.
KnownHost-DanielP
Well-known member
- Joined
- Mar 1, 2018
- Messages
- 121
- Points
- 28
Best answer
I agree with Allen, perform a database dump, and then do the search/replace on that dump and re-import.
So to dump MySQL (assuming linux) lets go ahead and make two, one we're going to mess with, the other is a backup incase something goes wrong.
Next you can use sed to search and replace.
Finally, re-import the database.
That autta do the trick. I you run into any issues lemme know but always take backups first 
So to dump MySQL (assuming linux) lets go ahead and make two, one we're going to mess with, the other is a backup incase something goes wrong.
Code:
mysqldump -u username -P database_name -> /path/to/dump/file.sql
mysqldump -u username -P database_name -> /path/to/dump/full_backup.sql
Code:
sed -i 's/http:\/\//https:\/\//g' /path/to/dump/file.sql
Code:
mysql -u username -P databae_name < /path/to/dump/file.sql
Older Threads
Newer Threads
Latest Threads
Recommended Threads
Similar Threads
Latest postsNew threads
-
New threads
-
Decoding Server Location: How It Affects Your Website’s Performance
- Started by BlueLeaf
- Replies: 0
-
-
-
Latest Hosting OffersNew Reviews
-
Latest hosting offers
-
SystemInPlace - Low cost Dual E5 384GB/512GB RAM DEDI. 30% OFF FIRST MONTH! 1gb/2.5gb/5gb/10gbAffordable enterprise grade dedicated servers at a price you can afford.- systeminplace
- Updated:
-
KVM VPS SSD⚡Worldwide Locations |UP TO 30% OFF⚡Full Root Access Instant DeployKVM VPS SSD Worldwide Locations UP TO 30% OFF
- greenwebpage
- Updated:
-
Surf Hosting | Path.net DDoS Protection - NVMe SSD - Eco Friendly | ⚡ 24/7 SupportCheap & High Performance Web Hosting- Surf Hosting
- Updated:
-
