Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
1 registered members (isaac), 65 guests, and 393 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
TGCsanderson
TGCsanderson
Hackelton U.K.
Posts: 67
Joined: September 2007
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 16
FREAK 11
M4TT 11
Ruben 6
mmkk 5
isaac 4
Latest Photos
Chinese Buddhist temple.
My buddha beads.
Rendered Walls
Multi-Screen wallpaper
Stockholm Metro
Previous Thread
Next Thread
Print Thread
Page 1 of 2 1 2
Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) #178189
02/10/07 10:30 PM
02/10/07 10:30 PM
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
Gizmo Offline OP
UBB.threads Developer
Gizmo  Offline OP
UBB.threads Developer
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
1. Backup your current files, this is simple with the "tar" command in Linux/Unix/BSD as:
Code
tar -cvpzf my_ubb_backup.tgz /path/to/threads


Additionally, if you're on a "windows" machine you can zip the directory or use any other archival tools available on the machine; if you don't have any you *could* download them file by file via FTP but it will take quite a while.

2. Now you'll want to backup your database, you can do this from free tools like PHPMyAdmin, however I recommend doing so through the command line (in Linux/Unix/BSD) as:
Code
mysqldump -uusername -ppassword my_database_name > my_database_name.sql


(Note that you can optionally use the -hhostname and -Pport trigger should you be communicating with a non-local SQL server; please note that most servers do not allow non-local access.)

You can also tar the output by:
Code
tar -cvpzf my_ubb_database.tgz my_database_name.sql


Alternatively, if you're on another OS or cannot use Linux command line tools, you can use web utilities like PHPMyAdmin to download an archive of your sql data. Please note that on large forums this is not recommended, and it is always recommended to use the "compression" options within PHPMyAdmin itself (tar/globalzip are recommended).

The Linux/Command Line versions will take MUCH less time to import/export, as you're not going through a php script which uses the web server; you're accessing the SQL server directly.

3. Now you'll want to transfer your backups to your new server. You'd do this either by downloading the database and forum backups to your hard disk, and uploading them to the new server -OR- you can place them both in a web-accessible directory on your old server, and use the "wget" command in Linux/Unix/BSD to download them, ex:
Code
wget http://www.yousite.tld/files/my_ubb_database.tgz
wget http://www.yoursite.tld/files/my_ubb_backup.tgz


From here you'll need to decide how you'll put the old files on the new server. If the new server is a Linux machine and you can access it via SSH and have access to "tar" and mysql command line this is a simple process. If your new server is windows based you'll want to be sure it has compression tools if you wish to place a compressed archive (that you likely created in steps 1 and 2) on it.

You'll want to decompress the files on the new server; in Linux/Unix/BSD with tar you'd do:
Code
tar -xzvf my_ubb_backup.tgz
tar -xzvf my_ubb_database.tgz


Once tar has extracted the files, you'll want to change to the appropriate directories within the extracted files, and use the "mv" command to move the forum files to their proper new location, EX:
cd the/directories/that/where/created/when/you/made/your/backup/ (by not using a starting slash you tell the command to go from where you are now vs the physical path ont he server)
mv forum /the/new/location/of/your/forum

4. Now that the old files are on the new server, you need to import your database; you can again use PHPMyAdmin or use the command line to import the database. The command line way of doing this (note, this is not the MySQL command line, simply the Linux command line) would be:
Code
mysql -h localhost -uuser -ppass database_name < databasebackupfile.sql


(Note that you can optionally use the -hhostname and -Pport trigger should you be communicating with a non-local SQL server; please note that most servers do not allow non-local access.)

The Linux/Command Line versions will take MUCH less time to import/export, as you're not going through a php script which uses the web server; you're accessing the SQL server directly.

Now that the database and files are now on the new server, you need to update your permissions of files and directories, they may or may not have been carried over via your backup (if you used tar), so you'll want to make sure that your files are chmodded 666 and your directories 777.

After checking your permissions, you'll want to update your includes/config.inc.php file, updating the paths (and urls if they're different) for the new server. At the time I'm writing this article, these lines are:
Code
  'FULL_URL' => '',
  'BASE_URL' => '',
  'FULL_PATH' => '',
  'SESSION_PATH' => '',
  'REFERERS' => '',
  'ATTACHMENTS_PATH' => '',
  'ATTACHMENTS_URL' => '',


You'll also want to update the MySQL connect information in your includes/config.inc.php file:
Code
  'DATABASE_SERVER' => 'localhost',
  'DATABASE_USER' => 'username',
  'DATABASE_PASSWORD' => 'password',
  'DATABASE_NAME' => 'databasename',
  'TABLE_PREFIX' => 'table_prefix',
  'HOMEPAGE_URL' => 'http://www.example.com',


5. From here, you should be completely moved over, it may sound quite difficult at first, but it's really not. Time can vary based on the size of your database, and some sites will be larger than others.

Additionally, if you don't feel comfortable about preforming the move yourself, you can always hire a developer *ahem*orme*ahem* to preform the migration for you.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: Gizmo] #178205
02/11/07 07:01 AM
02/11/07 07:01 AM
Joined: Jul 2006
Posts: 4,704
Liverpool : England : UK
Mark S Offline
Mark S  Offline

Joined: Jul 2006
Posts: 4,704
Liverpool : England : UK
Very handy Gizmo smile

If only for the comand lines at the very least.
I'm going to be doing a sort of transfer when we have 7.1 Final
so i can give it a blast.


Version v7.5.8
People who inspire me Gizmo ID242 SD
Its been a long road. . . .to be waiting
Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: Mark S] #178225
02/11/07 05:00 PM
02/11/07 05:00 PM
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
Gizmo Offline OP
UBB.threads Developer
Gizmo  Offline OP
UBB.threads Developer
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
hehe, i need to write an upgrade guide for within 7.x wink


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: Gizmo] #178650
02/17/07 06:33 PM
02/17/07 06:33 PM
Joined: Aug 2004
Posts: 466
Conrad Offline
addict
Conrad  Offline
addict
Joined: Aug 2004
Posts: 466
Good work, Gizmo. smile

Regarding "tar" and file/directory permissions, does anyone know for sure whether they carry over or not?

Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: Conrad] #178654
02/17/07 07:33 PM
02/17/07 07:33 PM
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
Gizmo Offline OP
UBB.threads Developer
Gizmo  Offline OP
UBB.threads Developer
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
they should with the -p flag


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: Gizmo] #178707
02/18/07 06:20 PM
02/18/07 06:20 PM
Joined: Aug 2004
Posts: 466
Conrad Offline
addict
Conrad  Offline
addict
Joined: Aug 2004
Posts: 466
I can move a tar file manually to the new server by downloading it to my desktop first, right? And I take it that I would use binary for this, which seems to be the way to move zip files as well?

If I was to do it using the "wget" command then how do I then transfer & unpack it in the right directory, namely the "/public_html/" one?

And how would I be able to "wget" the database dump into a directory that is not the www one, say one level above the web root?

Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: Conrad] #178710
02/18/07 07:18 PM
02/18/07 07:18 PM
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
Gizmo Offline OP
UBB.threads Developer
Gizmo  Offline OP
UBB.threads Developer
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
1. You CAN.
2. You'd untar it, then cd to the directory of files you wish to move, then:
mv old_public_html/* /path/to/new_public_html

And WGet is a linux command, you can run it from any directory that you have permissions to run it from; but on the site you're grabbing it from, it has to be in the webroot to use wget to grab it.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: Gizmo] #178725
02/19/07 11:22 AM
02/19/07 11:22 AM
Joined: Aug 2004
Posts: 466
Conrad Offline
addict
Conrad  Offline
addict
Joined: Aug 2004
Posts: 466
The directory I'm currently in when I type in "tar -cvpzf my_ubb_backup.tgz /path/to/threads" is where the zipped file will be placed?

OR is there a command that I can add to that line that will point to the directory where I want the zipped file to be saved?

Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: Conrad] #178737
02/19/07 03:06 PM
02/19/07 03:06 PM
Joined: Jun 2006
Posts: 4,372
Essex, UK
I
Ian Offline
Carpal Tunnel
Ian  Offline
Carpal Tunnel
I
Joined: Jun 2006
Posts: 4,372
Essex, UK
just put the full path to the chosen directory before the my_ubb_backup.tgz - so /full/path/to/my_ubb_backup.tgz

Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: Ian] #178743
02/19/07 04:44 PM
02/19/07 04:44 PM
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
Gizmo Offline OP
UBB.threads Developer
Gizmo  Offline OP
UBB.threads Developer
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
If you do ian's route you can specify the directory, if no directory is defined the file will be created wherever you execute the command (assuming you have write access to that directory)


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: Gizmo] #178759
02/19/07 07:18 PM
02/19/07 07:18 PM
Joined: Aug 2004
Posts: 466
Conrad Offline
addict
Conrad  Offline
addict
Joined: Aug 2004
Posts: 466
Guys, can I make the tar files and do the wget thing when logged in as root?

Because in SFTP for instance you are logged in as root and if you upload a file then disconnect and FTP in normally you will not be able to delete that file as it is owned by root and not the user.

Will something like this be the case with making the tar file or doing the wget if I am logged in as root via ssh?

Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: Conrad] #178792
02/20/07 12:01 AM
02/20/07 12:01 AM
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
Gizmo Offline OP
UBB.threads Developer
Gizmo  Offline OP
UBB.threads Developer
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
You CAN do that just fine as root; in fact, I did it when I was writing it up lol...



If you planned to SCP the file to your local computer you'd have to chown the file to a username you can access the machine with though.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: Gizmo] #178900
02/20/07 09:09 PM
02/20/07 09:09 PM
Joined: Aug 2004
Posts: 466
Conrad Offline
addict
Conrad  Offline
addict
Joined: Aug 2004
Posts: 466
Just a purely hypothetical question about moving the db dum...

Is it going to be quicker to tar the dump, then wget it on the new server, and then (un)tar the dump... or would it be quicker to just wget the dump without doing the tar and untar?

What kind of compression ratio are we looking at when doing a tar of a dump file?

Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: Conrad] #178907
02/20/07 10:03 PM
02/20/07 10:03 PM
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
Gizmo Offline OP
UBB.threads Developer
Gizmo  Offline OP
UBB.threads Developer
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
If you're going to be transferring it from one machine to another with WGet and they're both on professionally hosted lines (IE a non DSL/Cable line) then it should be fine to just forget tarring it, as it's text it'll transfer pretty fast on it's own and would take about the same time, but it may affect yoru bandwith quota on either host; so tarring would be best if possible.

And we're looking at a 200mb dump being 20mb.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: Gizmo] #178913
02/20/07 10:22 PM
02/20/07 10:22 PM
Joined: Aug 2004
Posts: 466
Conrad Offline
addict
Conrad  Offline
addict
Joined: Aug 2004
Posts: 466
Righto, I just tried moving my forum to a new server and failed miserably. wink

I was able to do the following:
-dump the db
-tar both the dump as well as the forum folder titled "ubb"
-wget both to the new server

What I couldn't do: tar (unpack) any of the files on the new server

1. This is what I got when I typed "tar -xzvf forumdump.tgz" into the command prompt:

...a pause that lasted a few seconds, and then this...


gzip: stdin: unexpected end of file
tar: Unexpected EOF in archive
tar: Unexpected EOF in archive
tar: Error is not recoverable: exiting now


2. I was also unable to tar (unpack) the forum files. I did the wget while being in the web root of the new server account, so the tgz file was naturally saved in "public_html" which was what I wanted. But when I tried to unpack it (tar -xzvf ubb.tgz) it simply listed all the compressed files like this... but no new files appeared anywhere so nothing got unpacked:

home/forum/public_html/ubb/file1.whatever
home/forum/public_html/ubb/file2.whatever
home/forum/public_html/ubb/file3.whatever
home/forum/public_html/ubb/file4.whatever
and so on...

What's interesting is that it was listing the path that was used on the old server: home/forum/... (which surprised me because why should a compressed file list the previous absolute path of all its elements), whereas on the new one the correct path is home/ubb/... Still, nothing was unpacked anywhere.

============

Any thoughts on how I can move my forum files across successfully? Is there a way to move over the ubb folder using wget but without a) having to compress anything -and- b) keep the original file permissions? The compression thing is messing me up and I can afford to go without it. But how can I keep all forum file permissions intact?

Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: Conrad] #178916
02/21/07 12:08 AM
02/21/07 12:08 AM
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
Gizmo Offline OP
UBB.threads Developer
Gizmo  Offline OP
UBB.threads Developer
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
Very odd, generally that means that the tar archive wasnt' fully created on the source...

And yes, it iwll list what is listed, the -v flag is verbose, which means it'll list all files as they're extracted. It should have extracted all the files to home/forum/public_html/ubb (from the directory you're in; so if you're in /home/gizmo they'd be in /home/gizmo/home/forum/public_html/ubb).

the reason it's listing the path is that when you tarred them you specified a full path to the files, so it was backed up as paths; you can use mv to move the files to where you want them once they're on the server.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: Gizmo] #178940
02/21/07 05:57 AM
02/21/07 05:57 AM
Joined: Aug 2004
Posts: 466
Conrad Offline
addict
Conrad  Offline
addict
Joined: Aug 2004
Posts: 466
Had a few questions earlier but it's all cleared up now.

I had a problem removing files via ftp later after moving and untarring them while logged in as root (funnily enough I could erase the tgz file but not the files that came out of it), but this is not a problem as I can ssh my way in under the account shell login instead.

I'll give the entire move operations another shot in the evening. smile

Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: Conrad] #178942
02/21/07 07:26 AM
02/21/07 07:26 AM
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
Gizmo Offline OP
UBB.threads Developer
Gizmo  Offline OP
UBB.threads Developer
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
ahh, that'd be due to the -p flag (the deletion issue) as it preserves user permissions; so if you run it as root on one machine and don't have root access on the other, you could run into a pickle...



I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: Gizmo] #178964
02/21/07 11:39 AM
02/21/07 11:39 AM
Joined: Aug 2004
Posts: 466
Conrad Offline
addict
Conrad  Offline
addict
Joined: Aug 2004
Posts: 466
Actually it doesn't seem like the -p tag is the reason as that is used to compress the files/folders. It actually seems to depend on what I'm logged in as (root or user) when I unpack the tgz file on the new server.

So if I use the -p tag to compress the file when logged in as root, I can then uncompress the file on the new server while logged in as the account user and everything will be fine.

Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: Conrad] #178965
02/21/07 12:00 PM
02/21/07 12:00 PM
Joined: Aug 2004
Posts: 466
Conrad Offline
addict
Conrad  Offline
addict
Joined: Aug 2004
Posts: 466
Just a quick last-minute question: how would you compare the time it takes to make a mysql dump to the time that it takes to restore the dump on the new server? What kind of ratio are we looking at? Similar... twice as long... more?

Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: Conrad] #178986
02/21/07 04:58 PM
02/21/07 04:58 PM
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
Gizmo Offline OP
UBB.threads Developer
Gizmo  Offline OP
UBB.threads Developer
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
-z is the compress (globalzip), -p is preserve permissions.

and I'd say they should take similar times, at max a large db should only be a couple of minutes.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: Gizmo] #184509
05/20/07 05:02 AM
05/20/07 05:02 AM
Joined: May 2007
Posts: 3
C
cclapper Offline
stranger
cclapper  Offline
stranger
C
Joined: May 2007
Posts: 3
What is the parameter to preserve the document permissions if -p does not work?


http://www.you-switch.org - Youswitch provides advice on switching utility bills.
http://www.broardband.net - broadband advice
Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: Gizmo] #190354
07/07/07 05:41 PM
07/07/07 05:41 PM
Joined: Dec 2003
Posts: 2,046
Texas
AllenAyres Offline
Pooh-Bah
AllenAyres  Offline
Pooh-Bah
Joined: Dec 2003
Posts: 2,046
Texas
Thanks for the review, I just moved a 700mb tar of someone's html/php files (yes, it's a huge site, the db tar is about the same size eek ). It only took me about 8 hours as opposed to 3 days my old way wink


- Allen
- ThreadsDev | PraiseCafe
Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: AllenAyres] #190363
07/07/07 07:16 PM
07/07/07 07:16 PM
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
Gizmo Offline OP
UBB.threads Developer
Gizmo  Offline OP
UBB.threads Developer
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
Totally overlooked this post...

Originally Posted by cclapper
What is the parameter to preserve the document permissions if -p does not work?


I believe -p is the only way to preserve permissions while utilizing Tar to create an archive...

Originally Posted by AllenAyres
Thanks for the review, I just moved a 700mb tar of someone's html/php files (yes, it's a huge site, the db tar is about the same size eek ). It only took me about 8 hours as opposed to 3 days my old way wink
Yeh, theres often faster ways to do things hehe...

My favorite is to create the archive, move it to a web directory, then use wget on the destination machine to snag the file... No downloading on your part required, and can usually do a 700mb file in seconds...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: Gizmo] #190369
07/07/07 07:41 PM
07/07/07 07:41 PM
Joined: Dec 2003
Posts: 2,046
Texas
AllenAyres Offline
Pooh-Bah
AllenAyres  Offline
Pooh-Bah
Joined: Dec 2003
Posts: 2,046
Texas
There wasn't ssh on the old server. :smash:


- Allen
- ThreadsDev | PraiseCafe
Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: AllenAyres] #190376
07/07/07 07:45 PM
07/07/07 07:45 PM
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
Gizmo Offline OP
UBB.threads Developer
Gizmo  Offline OP
UBB.threads Developer
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
Yikes, that's one heck of a drawback... SSH just makes things fun wink...

If it's a linux maxhine, you could use system() or exec() to issue shell commands (if the machine allows it); I have a site on a server I don't have SSH access to and that's how I roll out my maintenance (backups)


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: Gizmo] #190378
07/07/07 07:47 PM
07/07/07 07:47 PM
Joined: Dec 2003
Posts: 2,046
Texas
AllenAyres Offline
Pooh-Bah
AllenAyres  Offline
Pooh-Bah
Joined: Dec 2003
Posts: 2,046
Texas
hmm... I do have this shell script I probably could have used...


- Allen
- ThreadsDev | PraiseCafe
Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: AllenAyres] #190380
07/07/07 07:50 PM
07/07/07 07:50 PM
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
Gizmo Offline OP
UBB.threads Developer
Gizmo  Offline OP
UBB.threads Developer
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
There are a lot of "PHP Virtual Shell" scripts out there that I've been guilty of using; when you get backed into a wall... lol


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: Gizmo] #196831
09/09/07 10:06 AM
09/09/07 10:06 AM
Joined: Feb 2007
Posts: 23
B
BillT Offline
stranger
BillT  Offline
stranger
B
Joined: Feb 2007
Posts: 23
Is this still a fairly accurate guide? This is exactly why I logged in this morning. Thanks, Gizmo! Problem is ... I don't have command line access on the old server and I want to move to a new server at some point. Any recommendations on hosting providers? smile

Thanks,
Bill

Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: BillT] #196884
09/09/07 01:38 PM
09/09/07 01:38 PM
Joined: Feb 2007
Posts: 23
B
BillT Offline
stranger
BillT  Offline
stranger
B
Joined: Feb 2007
Posts: 23
Ok, it still appears to be fairly accurate. I'm getting the following error when trying to backup the forums:

write failed, user disk limit reached mysqldump: Got errno 69 on write

Does anyone know if there are any options to store the backup elsewhere during the backup? I'll also post on the hosting support forums. Thanks!

Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: BillT] #196904
09/09/07 09:08 PM
09/09/07 09:08 PM
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
Gizmo Offline OP
UBB.threads Developer
Gizmo  Offline OP
UBB.threads Developer
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
This is the guide that i use (hence why I threw it on the forum ;)). I would totally recommend only using hosts with CLI access as it makes certain tasks much easier (backing up with tar, utilizing the mysqldump command, etc).

That error occours becasue you're reaching your space limit (see Disk limit reached), you can't write after you reach your limit.

Most hosts "secure" the mysql server by not allowing external (off site) connections, otherwise i'd tell you to use sqlyog (as i believe it will allow you to dump all data to your local machine). The backup utility in the forum will also reach this space limit, so no use recommending that... You may contact your host, and ask if they could dump the sql database for you as you reach this limit, a lot of them will actually be helpful for "backups".

As for recommending a host, I only really recommend VPS for larger sites, and in that I recommend www.webintellects.com



I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: Gizmo] #196917
09/10/07 12:19 AM
09/10/07 12:19 AM
Joined: Nov 2006
Posts: 3,390
ntdoc Offline
Carpal Tunnel
ntdoc  Offline
Carpal Tunnel
Joined: Nov 2006
Posts: 3,390
Quote:
utilizing the mysqldump command, etc).


Not easy to debug, but wonder if you could run that stuff from CRON job on hosts that don't allow SSH.

Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: ntdoc] #196920
09/10/07 01:16 AM
09/10/07 01:16 AM
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
Gizmo Offline OP
UBB.threads Developer
Gizmo  Offline OP
UBB.threads Developer
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
If they allow you access to cron, i don't see why it wouldn't work... most webhosts that don't give you cli access though likely don't give you access to cron either wink


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: Gizmo] #196980
09/10/07 11:21 PM
09/10/07 11:21 PM
Joined: Nov 2006
Posts: 3,390
ntdoc Offline
Carpal Tunnel
ntdoc  Offline
Carpal Tunnel
Joined: Nov 2006
Posts: 3,390
Well not sure - I've been on a few Linux hosts that did not have or charged extra for SSH but they do have CRON (via Web interface)

FTP up what you want to do then let CRON do it grin

Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: ntdoc] #196988
09/11/07 01:33 AM
09/11/07 01:33 AM
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
Gizmo Offline OP
UBB.threads Developer
Gizmo  Offline OP
UBB.threads Developer
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
Yeh, cron can be a really useful tool; in fact I use it to run backups on the 1 site I don't host myself that I own...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: Gizmo] #202280
12/01/07 07:09 AM
12/01/07 07:09 AM
Joined: Feb 2007
Posts: 23
B
BillT Offline
stranger
BillT  Offline
stranger
B
Joined: Feb 2007
Posts: 23
Thanks Gizmo, for the GREAT guide to get me started with the transfer! One note for you to possibly include in future editions of your guide: When the SQL and Web servers are different, the --host= command can be added to the mysqldump command (e.g. mysqldump --host=mysql.serverhost.tld -uusername -ppassword my_database_name > my_database_name.sql).

Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: BillT] #202283
12/01/07 08:46 AM
12/01/07 08:46 AM
Joined: Feb 2007
Posts: 23
B
BillT Offline
stranger
BillT  Offline
stranger
B
Joined: Feb 2007
Posts: 23
It worked! Yay! Thanks again, Gizmo!!!

Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: BillT] #202291
12/01/07 12:43 PM
12/01/07 12:43 PM
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
Gizmo Offline OP
UBB.threads Developer
Gizmo  Offline OP
UBB.threads Developer
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
I just updated both SQL sections with:
(Note that you can optionally use the -hhostname and -Pport trigger should you be communicating with a non-local SQL server; please note that most servers do not allow non-local access.)


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: Gizmo] #214147
06/07/08 05:06 PM
06/07/08 05:06 PM
Joined: Mar 2008
Posts: 268
Austin, AR
Iann128 Offline

enthusiast
Iann128  Offline

enthusiast
Joined: Mar 2008
Posts: 268
Austin, AR
I just followed the instructions to move a copy of my site to a testing site, and all I get is a blank page when I try to bring up the site. No errors or anything, just a blank page. I did the sql dump, and imported it into a new database. Any suggestions?

Thanks,
Ian


Ian
http://www.firstgenmc.com/ubbthreads

"Experience is a hard teacher because she gives the test first, the lesson afterwords."
Re: Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) [Re: Iann128] #214148
06/07/08 05:30 PM
06/07/08 05:30 PM
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
Gizmo Offline OP
UBB.threads Developer
Gizmo  Offline OP
UBB.threads Developer
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
Did you set the information in your includes/config.inc.php?


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Page 1 of 2 1 2

Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Users Unable to Upload Avatar
by M4TT. 12/13/17 08:51 AM
Shout Box Sound Effect
by M4TT. 11/29/17 08:28 PM
Ad island
by TGCsanderson. 11/25/17 06:41 PM
Taking to long to connect to DB
by AstroCat. 11/24/17 12:34 PM
Forum Statistics
Forums36
Topics35,015
Posts190,536
Members12,045
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.1
(Snapshot build 20171106)