I've got a 40mb database file that I've exported from an old host and need to import it into a new host on a new domain. I normally open up the database in my code editor and find-replace, but as this file is so big, it's freezing my editor.
Is there a way to do this via Terminal / the command line? I saw something about using
sed when searching, but I can't get my head around how it works. Is there a simple command for doing this that exists already? I tried this but it doesn't work:
sed 's/http:\/\/www.domain.com/http:\/\/www.newdomain.com/g' mydatabase.sql
Thanks for any pointers.