XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Q and A 
  4.  / change my domain - how do i change all links in database?
Register
1
irmtfan
change my domain - how do i change all links in database?

  • 2004/12/26 7:16

  • irmtfan

  • Module Developer

  • Posts: 3419

  • Since: 2003/12/7


i lost my [dot]com domain. the registerant refuse to update it.
http://whois.sc/jadoogaran.com
then i should change domain to [dot]org.
http://whois.sc/jadoogaran.org
my big deal is how can i change all hard coded [dot]com links to [dot]org in whole site?( all links in forum,news,article,comments,...)
is this possible from database with sql query?
database is about 150 Mb.
thanks in advance
2
Anonymous
Re: change my domain - how do i change all links in database?

  • 2004/12/26 8:00

  • Anonymous

  • Posts: 0

  • Since:


Hello,
if ur MySQL db have small size u can export it as text or sql then edit it by notepad and replace what u want easliy.

But now u need to export needed tables then search/repacle by notepade ( use Ctrl+H )

Good luck
3
irmtfan
Re: change my domain - how do i change all links in database?

  • 2004/12/26 15:31

  • irmtfan

  • Module Developer

  • Posts: 3419

  • Since: 2003/12/7


thanks Mowaffak but the database is too big to edit by hand.
anyone know a query to change a word via phpmyadmin?
for example change "jadoogaran.com" to "jadoogaran.org" in all links.
many thanks
4
irmtfan
Re: change my domain - how do i change all links in database?

  • 2004/12/27 8:42

  • irmtfan

  • Module Developer

  • Posts: 3419

  • Since: 2003/12/7


** bump **
5
carnuke
Re: change my domain - how do i change all links in database?

  • 2004/12/27 9:58

  • carnuke

  • Home away from home

  • Posts: 1955

  • Since: 2003/11/5


if you are a surpasshosting member, have a look at this thread. Otherwise I can abstract it to here. It details scripts to make global changes in your DB

BTW bigdump will export your database. See the faq section. A simple search and replace will then do the job.
6
irmtfan
Re: change my domain - how do i change all links in database?

  • 2004/12/27 17:30

  • irmtfan

  • Module Developer

  • Posts: 3419

  • Since: 2003/12/7


yeah my site hosted by surpass
i look at that link and that exactly my problem. what do you do for change domain in all linkes finally?
if i want change it by hand IMO its better to use a powerful edit software for example ultra edit.
thanks for your help carnuke.
7
carnuke
Re: change my domain - how do i change all links in database?

  • 2004/12/27 19:20

  • carnuke

  • Home away from home

  • Posts: 1955

  • Since: 2003/11/5


The scripts detailed on surpass are NOT tested, but in theory they would work. Best tried on a test DB first.

BTW you could use <{$xoops_url}> in place of your domain! Always a useful trick...
8
irmtfan
Re: change my domain - how do i change all links in database?

  • 2004/12/30 18:49

  • irmtfan

  • Module Developer

  • Posts: 3419

  • Since: 2003/12/7


lool finally i do it
http://www.jadoogaran.org
now another question:
i have 30 gig bandwidth per month and in december main site and all subdomains use 22 gig bandwidth.
i want to know how many band use by google , yahoo , ... for index it again?
sould i dissalowed for example xcgal? ( we have 1700 pics in gallery)

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

187 user(s) are online (99 user(s) are browsing Support Forums)

Members: 0

Guests: 187

more...

Donat-O-Meter

Stats
Goal: AU$15.00
Due Date: May 31
Gross Amount: AU$0.00
Net Balance: AU$0.00
Left to go: AU$15.00
Make donations with PayPal!

Latest GitHub Commits