How do I backup and relocate an entire integramod site?

[bassphine]

Hi everyone <img>

I recieved an e-mail with a cease and desist order for my domain name. Apparently a company with a name very similar to mine exists, and we both offer multimedia creation services, just of different genres. I have had my lawyer call their company and verify that they in fact did issue the order.
Instead of fighting it I'm willing to change my startup companys name slightly to distance the "product brand collusion" as they called it. I have picked out and registered a new domain name with my free hosting provider. However as a subdomain like the one I was using before, it comes with its own database and serverspace.
I need to know how to best go about moving everything over without starting from scratch, I have added a few mods and tweaked a couple of themes to make the site flow seamlessly.

I searched the site and found some information on databas backup and such but no clear and diffinitive step by step guide to backup and restore a site for either hack attacks or moving to a new server.

Any help would be very much appreciated

[Fubie]

You can use the "Safe Upgrade" tutorial I created to help you with that. It walks you thru backing up your entire database to your PC and back to your host. Even if it's another host.

Then download your files and upload them to your new host.

http://integramod.com/forum/portal.php?page=9

[bassphine]

That sort of helps but I need to relocate the entire site to another server, this includes all photos in the album as well as all of the altered IM files. I understand that I need to backup the SQL DB and copy the whole site, all 800mb worth to my HD. It's after that, that I have no real clue what to do. I assume I copy the site to the new server, but how do I add the SQL DB and how do I get IM to recognize the new domain and settings so that everything works smothly without breaks and file/object not found errors?

[found it]

Hi

Firstly you need to upload all your files to your new server.......

Regards to uploading your database a good way of doing it is to use mysqldumber found here...

http://www.mysqldumper.de/de/index.php?m=0

or you have to manually upload your database to your phpmyadmin....

once done you need to correct the queries in the config table that point to your old site..which are

Code: Select all

server_name and script_path

Also you need to change your config file to show the correct database edit it using as you normally would when changing code....

I think that is it ..let me know if there is anything else you need

[Bush]

Not to disregard what found it stated, but there ARE official MySQL tools that have been released to support JUST this procedure.

http://www.mysql.com/products/tools/

I recommend MySQL Administrator, but MySQL Migration Toolkit looks promising as well. I've used MySQL Administrator before when I moved my live site to another machine, worked like a charm.

I kept my database usernames and passes the same on the new machine, so all I did was copy over the files (maintaining same dir structure) and then used MySQL Administrator to move the databases from server to server.

HtH.

[found it]

Not to disregard what found it stated, but there ARE official MySQL tools that have been released to support JUST this procedure.

http://www.mysql.com/products/tools/

I recommend MySQL Administrator, but MySQL Migration Toolkit looks promising as well. I've used MySQL Administrator before when I moved my live site to another machine, worked like a charm.

I kept my database usernames and passes the same on the new machine, so all I did was copy over the files (maintaining same dir structure) and then used MySQL Administrator to move the databases from server to server.

HtH.

A nice find too...I shall be looking at this today....

[Mandoo]

[quote=""found it";p="12354""]Hi

Firstly you need to upload all your files to your new server.......

Regards to uploading your database a good way of doing it is to use mysqldumber found here...

http://www.mysqldumper.de/de/index.php?m=0

or you have to manually upload your database to your phpmyadmin....

once done you need to correct the queries in the config table that point to your old site..which are

Code: Select all

server_name and script_path

Also you need to change your config file to show the correct database edit it using as you normally would when changing code....

I think that is it ..let me know if there is anything else you need

<!-- s]

Following your instructions everything seems to be fine with transfering my site. The only problem is that the cookies dont seem to be working. When i try to login to the site it wont display the next page but then if i return to index im loged in. If i try to log in to the ACP it wont diplay the page.

Any ideas?

[evolver]

Not to disregard what found it stated, but there ARE official MySQL tools that have been released to support JUST this procedure.

http://www.mysql.com/products/tools/

I recommend MySQL Administrator, but MySQL Migration Toolkit looks promising as well. I've used MySQL Administrator before when I moved my live site to another machine, worked like a charm.

I kept my database usernames and passes the same on the new machine, so all I did was copy over the files (maintaining same dir structure) and then used MySQL Administrator to move the databases from server to server.

HtH.

I found this one very interesting too, and tried it out...
Download - OK and free!
Install - OK
Configuration - not easy when you are trying to connect to a remote server...

I just couldn't get it connected...
So, I looked at the manual on the site, and looked and looked...
This is the information that did the trick:
[quote]When connecting to the MySQL server from a remote location You have to specify the "hosts"(remote location IP's) that you will be accessing the database from.

You must have access to CPANEL and have MySQL features enabled for this solution to work. A simple way to check if you have these features is to go into the CPANEL and look for the MySQL Databases Section.

If you have it listed, go into it.

Down towards the bottom of the page that loads you will see a heading called "Access Hosts".

By default you will only see "localhost" listed below this heading. This means only database access from the localhost(yourserver) is allowed.

You can add more hosts to this list by using the text box provided with the title "Host:"

For Example: if you wanted to give access to the MySQL server to a remote computer with this static IP address: 211.233.2.24 all you would simply do is type in the IP address in the textbox and hit the "add host" button.

If you had an entire network that you needed to give access to the MySQL server simply use the wildcard "%" symbol eg. 211.233.2.%

SECURITY WARNING: If you do not have a static IP address, using a wildcard "%" may open a security hole that can lead to unauthorized access to the MySQL server from a remote address. Make certain you delete all added hosts if you are not intending on using them and only set up wildcards if no one outside your network has access to the IP range you have specified.

Hope this helps - I know it did for me.

Oh, and don't use your FTP username and password,
but the ones to connect to database (as in config.php)

[Bush]

Well obviously you have to add your IP to the MySQL access list, and the user name and password is obviously the user and pass of the MySQL database.

I didnt think I needed to be so clear.

[found it]

[quote=""Mandoo";p="12625""][quote=""found it";p="12354""]Hi

Firstly you need to upload all your files to your new server.......

Regards to uploading your database a good way of doing it is to use mysqldumber found here...

http://www.mysqldumper.de/de/index.php?m=0

or you have to manually upload your database to your phpmyadmin....

once done you need to correct the queries in the config table that point to your old site..which are

Code: Select all

server_name and script_path

Also you need to change your config file to show the correct database edit it using as you normally would when changing code....

I think that is it ..let me know if there is anything else you need

[evolver]

Well obviously you have to add your IP to the MySQL access list, and the user name and password is obviously the user and pass of the MySQL database.

I didnt think I needed to be so clear.

It's not that obvious for someone who has never had the need to access MySQL remotely before...
Most people manage MySQL by local access directly on server...

You may not need to hear how to get access...
But many others will give up trying after failing to connect
So this information will be as usefull for them, as it was for me...

What's obvious to you, isn't so obvious for everyone...
But everyone who wants to learn...diserves a compliment <img>

[found it]

Hi

Could you please stick with the what was asked in the topic...if you wish to discuss something else please make a new topic for it....in GeneraL Discussion this froum is for support

[Dioncecht]

see next post.. couldn't delete this one

[Dioncecht]

I tried just exporting MySql databases to a text file, then I uploaded all my files and imported the SQL text file, changed my config.php and it works just fine.

[Dioncecht]

ok, I was mistaken apparently. I moved everything over and changed my config.php to reflect my database settings, but i didn't realize that after I logged in, it was referring to the install on my local machine still.

So I went in and added this to my copy on the server

UPDATE `phpbb_config` SET `config_value` = '/phpbbext/adr/' WHERE `config_name` = 'script_path' LIMIT 1 ;

but now it looks in the right spot for the PHP files but it gives a 404 Page Cannot be Displayed error on alot of them like Admin Panel. The URL has the correct address, so whats going on with it? Is there something else I gotta do to make it recognize that the file is exactly where its looking?

It does this on Admin Panel, login.php, and Memberlist. I also happens when I submit a post

[found it]

Hi

Have you changes your config sttings in your database so that these 2

Code: Select all

server_name and script_path

are ponting to the correct url

server_name---www.yourdomain.com

script_path---/phpbb (replace both with whatever you use...

[Dioncecht]

ummm.. i think so. I have to wait till I get home to check. I can't get into my CPanel from work.

[Dioncecht]

Ok.. that was the ticket! Thanks man!

[Dioncecht]

ok, for some reason now, when I submit a post, it doesn't show up. When I try to delete a forum or thread, it goes through all the motions and just doesn't do it. When I try to make a change in QBar, it goes through all teh motions and doesn't do it.

The weird thig is, it will submit other things like if I add an IM Portal block and populate it with some links.

Any ideas?

[Fubie]

I hate to say this but it sounds like CHMOD issue.

[found it]

glad you got the first bit sorted....and i have to agree with Fubie does sound like a chmod issue....

[Dioncecht]

You guys rock! I have no idea what I'd without all you guys! Probably have some broken dilapidated site or something.

Of course if I could keep my hands off of it for more than 5 minutes.. but then again, I'm a geek, I can't help it! I'm just glad you guys are around to point out what I screw up!

[found it]

lol

Glad you got it fixed....I know the feeling I cannot stop messing around with my sites either...