Find and Replace text in all tables in a database using Mysql query?

Dopani · Apr 26, 2018

I have a custom database and there is a word http:// that I want to change to https:// with a query in phpmyadmin or using CLI. What update command can I use to find and replace this text in all tables of my current database?

Allen_Jolynn0 · Apr 26, 2018

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 · Apr 26, 2018

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.

Code:

mysqldump -u username -P database_name -> /path/to/dump/file.sql
mysqldump -u username -P database_name -> /path/to/dump/full_backup.sql

Next you can use sed to search and replace.

Code:

sed -i 's/http:\/\//https:\/\//g' /path/to/dump/file.sql

Finally, re-import the database.

Code:

mysql -u username -P databae_name < /path/to/dump/file.sql

That autta do the trick. I you run into any issues lemme know but always take backups first

VirtuBox · Apr 26, 2018

Dopani said:
I have a custom database and there is a word http:// that I want to change to https:// with a query in phpmyadmin or using CLI. What update command can I use to find and replace this text in all tables of my current database?

Hello,
You can use the search and replace feature of phpmyadmin. At first une search to find tables with the word http://, and then go into the table and use search and replace.

Find and Replace text in all tables in a database using Mysql query?

Dopani

Well-known member

Allen_Jolynn0

New member

Dopani

Well-known member

KnownHost-DanielP

Well-known member

Dopani

Well-known member

KnownHost-DanielP

Well-known member

VirtuBox

Well-known member

Dopani

Well-known member

VirtuBox

Well-known member

Dopani

Well-known member

Latest posts New threads

Latest posts

New threads

Latest Hosting Offers New Reviews

Latest hosting offers

Popular Contributors - Past 30 Days

Sponsors

Tag Cloud