Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
2 registered (driv, id242), 41 Guests and 9 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/05/06
Posts: 708
Top Posters (30 Days)
Ruben 49
DennyP 24
Gizmo 23
Dunny 18
SteveS 14
AllenAyres 12
dbremer 10
SD 9
drkknght00 9
driv 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Page 2 of 3 < 1 2 3 >
Topic Options
#175795 - 01/27/07 02:13 AM Re: Does this make sense? [Re: Ian]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
You know, most of those migration tools are complete pieces of crap lol... just use tar and build a solid archive by hand; at least then you know for certain what is backed up...
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
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."
#175802 - 01/27/07 05:29 AM Re: Does this make sense? [Re: Gizmo]
Mark S Offline
Carpal Tunnel
Registered: 07/04/06
Posts: 4447
Loc: Liverpool : England : UK
1&$ have there own control panel,
so a import / export of a site via migrate i doubt is possible.

But as Gizmo says about tar it all up \:\)
And you can backup the Databases too.
You may have see there help files to find where that
1 little option is but it can be done.
_________________________
Version v7.5.6 smile smile < Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
Oooo i hear 8 is coming? just after 7 my friend.
Top
#175812 - 01/27/07 12:58 PM Re: Does this make sense? [Re: Mark S]
Stan Offline

old hand
Registered: 06/05/06
Posts: 708
I can do a dump of the mysql, i did that of my beta forum http://www.adventistcafe.com and trying to bring it over as a sample move to godaddy. I have created http://www.adventistblog.com to test it.


HOWever I am not sure how to import the database... vie mysqlphp or what ever that is called...

Really appreciate the help...

Ian both 1and1 and godaddy have proprietary control panels
Top
#175813 - 01/27/07 01:01 PM Re: Does this make sense? [Re: Stan]
Stan Offline

old hand
Registered: 06/05/06
Posts: 708
I am not a programmer... and have trouble even spelling that word... \:\)

HOWEVER
It is not clear to me, in the ubb Control panel, where we can back up the database.. why I could not do that, copy it over to new server and then import each of those files..

OR is that possible? One would think if you can back up you can restore?

RIght????
Top
#175817 - 01/27/07 02:03 PM Re: Does this make sense? [Re: Stan]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
The UBB does have a backup system, however I wouldn't use it...

If you have access to SSH (which any decent host would allow) You can do the following:
MySQL Export: mysqldump -uusername -ppassword database_name > file_to_write.sql
MySQL Import: mysql -h localhost -uusername -ppassword database_name < file_to_insert.sql
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#175827 - 01/27/07 05:06 PM Re: Does this make sense? [Re: Gizmo]
Mark S Offline
Carpal Tunnel
Registered: 07/04/06
Posts: 4447
Loc: Liverpool : England : UK
Or if you go into your 1&1 control pannel
navigate to database managment or phpmyadmin, i think there is a back up
on that page somewhere.

Its over 8 months ago now,
i tryied back then to do what gizmo sugests above,
but it would time out \:\( and no dump.

At the time my DB was v7.0.0 and it was 135mb
so i was over quota by 35mb and this could have
been part of the problem and there constrictions
to perfom normal operations.

You will get there.
_________________________
Version v7.5.6 smile smile < Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
Oooo i hear 8 is coming? just after 7 my friend.
Top
#175828 - 01/27/07 05:08 PM Re: Does this make sense? [Re: Mark S]
Stan Offline

old hand
Registered: 06/05/06
Posts: 708
am pretty sure I can dump it, i just don't know how to import it to a new install...
Top
#175829 - 01/27/07 05:10 PM Re: Does this make sense? [Re: Gizmo]
Stan Offline

old hand
Registered: 06/05/06
Posts: 708
 Originally Posted By: Gizmo
The UBB does have a backup system, however I wouldn't use it...

If you have access to SSH (which any decent host would allow) You can do the following:
MySQL Export: mysqldump -uusername -ppassword database_name > file_to_write.sql
MySQL Import: mysql -h localhost -uusername -ppassword database_name < file_to_insert.sql


OK I read this wrong before... may try that...
Top
#175838 - 01/27/07 09:00 PM Re: Does this make sense? [Re: Stan]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
I would highly advise against using a php script (PHPMyAdmin, the UBB, etc) to create an SQL dump; especially with a large (over 100mb) database (as it will time out or in extreme cases not give you a complete database dump).

Instead, by using SSH (commands provided above) one can create the dump from the MySQL service directly (and it will be created MUCH faster).
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#175859 - 01/28/07 05:00 AM Re: Does this make sense? [Re: Gizmo]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
If you are not used to SSH - then download a copy of putty and run that assuming you have command line access to your hosting (not all allow this for security reasons)
Top
Page 2 of 3 < 1 2 3 >



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Custom forum permissions
by ntdoc
05/18/12 02:07 PM
Forum Stats
10489 Members
36 Forums
33841 Topics
181698 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image