Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
7 registered (UBBSystems, FordDoctor, VaGunTrader, Mike L, jfaliveno, Inter, Bjab), 26 Guests and 16 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 01/21/12
Posts: 2
Top Posters (30 Days)
Ruben 65
SD 57
Gizmo 53
gliderdad 32
Iann128 22
Dunny 21
Steve C 20
driv 18
dbremer 16
Stan 15
Latest Photos
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Gizzo Marx
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: 14904
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

addict
Registered: 06/05/06
Posts: 687
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
_________________________
As of Aug - 2010 I am using version 7.5.6 and hosted by http://www.mindraven.com/

UBBsite
http://clubadventist.com
Top
#175813 - 01/27/07 01:01 PM Re: Does this make sense? [Re: Stan]
Stan Offline

addict
Registered: 06/05/06
Posts: 687
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????
_________________________
As of Aug - 2010 I am using version 7.5.6 and hosted by http://www.mindraven.com/

UBBsite
http://clubadventist.com
Top
#175817 - 01/27/07 02:03 PM Re: Does this make sense? [Re: Stan]
Gizmo Offline

Registered: 06/05/06
Posts: 14904
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

addict
Registered: 06/05/06
Posts: 687
am pretty sure I can dump it, i just don't know how to import it to a new install...
_________________________
As of Aug - 2010 I am using version 7.5.6 and hosted by http://www.mindraven.com/

UBBsite
http://clubadventist.com
Top
#175829 - 01/27/07 05:10 PM Re: Does this make sense? [Re: Gizmo]
Stan Offline

addict
Registered: 06/05/06
Posts: 687
 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...
_________________________
As of Aug - 2010 I am using version 7.5.6 and hosted by http://www.mindraven.com/

UBBsite
http://clubadventist.com
Top
#175838 - 01/27/07 09:00 PM Re: Does this make sense? [Re: Stan]
Gizmo Offline

Registered: 06/05/06
Posts: 14904
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
A positive note
by SteveS
09:36 PM
How to locate links to particular site if they are only used in images?
by Conrad
02/10/12 09:41 PM
Pictures not displaying
by Marker23
02/09/12 10:04 PM
Issue with logging out constantly
by Flanuva
02/09/12 07:05 PM
Long thread, UBB code not parsing
by Bad Frog
02/09/12 07:47 AM
Forum Stats
10213 Members
36 Forums
33666 Topics
180902 Posts

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