How do I move mambo from one domain to another

[leo77]

Here is what I want to do:

I already have one site set up.(lots of stuff in the DB) I want to move the same exact site ( all PHPs and DB) to a different domain with different name. What is the easiest way to do that?

Any help will be greatly appreciated.

[mamboguy.com]

First of all, your host may be able to handle it for you.
Second, what domain control panel are you using? Cpanel allows you to backup your entire site and then you can restore to new site.

[leo77]

Thanks for your reply.

I use Cpanel and I tried the back up yesterday but when I open the site, all the links were pointing to the old site.

[mamboguy.com]

Originally Posted by leo77

Thanks for your reply.

I use Cpanel and I tried the back up yesterday but when I open the site, all the links were pointing to the old site.

You will have to edit your configuration.php with the new settings. And ensure you put in settings for your 'new' database.

[leo77]

Thanks again. I tried and I thought I got everything right, but the site didn't want to open after that .. I guess I might've done something wrong (eventhough I checked several times) Will try again. Any tips?

[mamboguy.com]

Is you database visable in phpmyadmin?
Are the settings in your 'new' configuration.php?

[leo77]

Yes it is. Should I use the same DB connect password?

[mamboguy.com]

Originally Posted by leo77

Yes it is. Should I use the same DB connect password?

Most likely... however you can always add a new user to the db to be sure you are using the correct password.

BTW can you host help you with these issues? It should be simple for them.

[leo77]

They don't want to help Will try again later tonight. Thanks a lot.

[karz10]

Hi Brad,

Since you replied to poster about their issue, maybe you have an idea for me????

I read this and other threads before moving my site from one domain to another...

I use cPanel w/ a hosting reseller account...I tried it myself first, moving all the files in the pub-html folder of my site, ftp'd them to new domain...

Then I back-ed up the old database, and restored it to new domain, this is first failure, out of the 35 items in the database, only 4 made it...

Asked host for help, after several hours they finally got the db over and working, navigation did not work, I had already editedthe various config files, but realized something they did blanked out the .htaccess file needed to run the standard SEF (wanted to move before getting any advanced sef)

So now all navigation seems to work..

So the point of all this, after telling you what i have done and what did work...the new db now also has 35 items like old db, and it seems as if all hard files are moved over, HOWEVER**** For some reason, over half my content items are missing from within mambo...don't know if host understands mambo, they seem to think it's missing files in pub-html, whereas I am inclined to think that despite the number of db items are consistent, that maybe something still did not make a complete transition...

So my main questions are:

Where exactly are content items stored?
How can I ensure a successful move of the content items?

I don't know what to do next, if they say they've done everything to move the db, and I've tried to move all the physical files, I need to focus on exactly what is missing. The weird thing about it, it seems I HAD dozens of items in each category, and now like 2-4 items are in each category, so most categories still have *something* in them, but not the complete list, so I only have a couple dozen pages on the site, instead of a couple hundred...

But the *structure* of the site seems intact, the menu still points somewhere, but instead of seeing a content item, you see *you are not authorized to access this page, please log in....* So I thought maybe the item got its public access turned off, but in reality, the item is not present anywhere in the admin area, published/public or not, the item is JUST GONE...

We're talking about 150 items or more, I don't want to do this manually over again, or move individually, surely there is some way to restore this effectively...

Any help is appreciated!!!!

Karz

[karz10]

Additional info...

I also sent this finding to my host, but thought I'd post here to, in effort to follow up on above post...

I don't know much about this, but this seems important..

In the old domain DB here is the size attributes of the
mos_content area of the DB:
Space usage:
Type Usage
Data 833,372 Bytes
Index 8,192 Bytes
Total 841,564 Bytes


In the new domain DB, there is only a fraction of that data in the
mos_content section of the DB:
Space usage:
Type Usage
Data 88,380 Bytes
Index 8,192 Bytes
Total 96,572 Bytes


It would seem to me that this would be a critical part of the site, and only
having 10% of the data may be the missing content items I'm speaking of. Any idea how to move this one piece most effectively? Or make another attempt at restoring the DB altogether?

Thanks...keep in mind I tried restoring db before and it would not work, i guess it timed out, so i have to get help from my host to do that, but if there was some way to move certain pieces of it, maybe i could do that, if i knew what to do..

Karz

[mamboguy.com]

Sounds like the database backup/restore did not go as it should have. Perhaps try again???

[mambo_chris_au]

It looks like that most likely only the tables are backed up and transferred. and not the fields.
Or maybe you/they did not enclose the table and/or field names with single quotes.

After all, it is very easy to transfer one site to another.
I never had a problem.
Export the database to a zip file.
Copy all the folders and files to the new site.
With phpMyAdmin go to your new site, query and browse to the zip file.
Password etc. here depends on what your provider/administrator told you to use.

The main change is in the configuration.php file.
Should be about the same as with phpMyAdmin.
Just enter the new details there, using a text editor and it should run.

[karz10]

Here is the latest from the host = "We have recreated your table mos_content but you will have to insert the data of the table and let us know if you face any other problem regarding this issue so that we can investigate further."

I'm not sure what they mean to do here. And regarding the comments from Chris, I've moved all the folders over, and was not able to upload the db, the host then tried to do it, and this is where we're at, I've got a database with no content items in it...this has been going on for 3 days now, and I'm becoming increasingly frustrated, and no one seems to understand why it is not working...

I have all the config files set up and the site is navigating, there is just nothing in any of the pages, coz I can't get the DB over, and apparently my hosts idea of getting it to work doesn't seem to matter that the content is completely missing...