weya

Okay, here's the deal.

I had a website on a friend's server (as a subdomain of his). I used Mambo there. I exported the SQL database to save the data. (btw, the old website still exists while I go through moving it here -- so if I need to do something else to get the data, I can)

I bought space here, registered a domain, installed Mambo. Now I want to move all my content over here.

Thing is ... when I look at the .txt file that the export created, I see lots of instances of my friend's domain (url, db names, etc) in there. So I assume I can't just click 'import' in mySQL and expect it all to work correctly.

Can I just go in and manually change the instances of his domain to match what I have here at surpass? Will it work if I import that?

Or is there some other (easier? better?) way of doing this that I just don't know about?

Bigjohn

you can use a good text editor (not notepad, I'm afraid - it will break the "line breaks" needed for the sql import) to replace all those, or edit them manually (with a good text editor). Then the import will work.

I don't think that there are more than a half dozen or so....

__________________
Proud to be a Surmunity Mod!
XEON PASS60 PASS61
Make a fundamental difference!
My Sites:
Curious about Brewing Beer? Join the community!
>>>>> Some Change is GOOD! Keep your paycheck! Support the Fair Tax
Get into an Art museum
Victorian London
It's your brain -ON WEB - mybrainhost.com (under development)
What SHOULD Government do? Much Less than it Does!

weya

So, what's a 'good text editor'?

sam

depends on OS. which do you run?

Ehaanaes

3 easy steps to finish this off.

Step 1. Install Linux if you haven't already.
Step 2. Install VI.
Step 3. Use VI to fix it.

(Replace VI with nano or pico if needed.)

__________________
Owner of Minerva and Server :: Beatiful P4's Surpass
http://www.case-spider.com
Winner of the Surpassies 2004 - Most Spirit. :bravo:
Google = Friend!

Bigjohn

LOL. The guy says he's a newbie... and you want him to kill himself with VI?

John

__________________
Proud to be a Surmunity Mod!
XEON PASS60 PASS61
Make a fundamental difference!
My Sites:
Curious about Brewing Beer? Join the community!
>>>>> Some Change is GOOD! Keep your paycheck! Support the Fair Tax
Get into an Art museum
Victorian London
It's your brain -ON WEB - mybrainhost.com (under development)
What SHOULD Government do? Much Less than it Does!

spartas

In order to fix the problem, the easiest way would probably to create another database on your site (not the one used by mambo) and import it there. Then you could just use PHPMyAdmin to fix the incorrect rows (you will want to go over every row, just to make sure you found them all). Then just copy the database over (or use mambo to point to the new database instead; I dunno if that's possible, I haven't used mambo previously).

__________________
Server: Pass15
twwright.net
NoE

Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.6) Gecko/20050405 Firefox/1.0 (Ubuntu package 1.0.2)

I run ubuntu hoary!

ladybeauty16

A HTML editor should do I think. Someone correct me if I'm wrong.

I use Cutehtml and I've had to do something similar. I just ran a search for say sub.domain.com and replace what it finds with newdomain.com.

__________________


Belle Femme Network
Cazaroonie.com

ladybeauty16

Those dates just keep hiding from me...

__________________


Belle Femme Network
Cazaroonie.com