Updating database after testing - UBB.threads PHP Forum Software Community

You are not logged in. [Log In] UBB.threads PHP Forum Software Community » Forums » UBB.threads 7 Discussion » General Assistance (How Do I?) » Updating database after testing

Site Links

Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com

Top Posters (30 Days)

Ruben	50
DennyP	24
Gizmo	23
Dunny	15
SteveS	13
AllenAyres	12
dbremer	10
SD	10
drkknght00	9
doug	8

Latest Photos

Basildon Town Centre looking from the rounderbout

Topic Options

#238654 - 08/15/10 06:15 PM

Updating database after testing

Iann128 Offline

enthusiast

Registered: 03/21/08
Posts: 234
Loc: Austin, AR

I am just about ready to go live on the new server. I have been testing with forum data from about a month ago. We have not changed any of the message board files, I did the transfer by following these directions http://www.ubbcentral.com/forums/ubbthre...html#Post178189

I assume I can just dump the test data and then import the live data into the new database and all will be good?

Thanks,

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

"Experience is a hard teacher because she gives the test first, the lesson afterwords."

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."

#238655 - 08/15/10 06:27 PM

Re: Updating database after testing [Re: Iann128]

SD	Registered: 04/19/07 Posts: 4056 Loc: SoCal, USA

yep, i do it all the time on my dev/production systems

usually the mysqldump will include a DROP TABLE, so you don't (normally) even have to dump the DB...

just import and it is like fresh/new

_________________________

Threads tutorials . Threads & Wordpress experts . UBB resume

If I

you, click this link as to why

Top

#238656 - 08/15/10 06:31 PM

Re: Updating database after testing [Re: SD]

Iann128 Offline

enthusiast

Registered: 03/21/08
Posts: 234
Loc: Austin, AR

Cool! All the hard work is just about done. Just waiting to hear back from the club president to make sure he is happy with my work

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

"Experience is a hard teacher because she gives the test first, the lesson afterwords."

Top

#238661 - 08/16/10 12:32 PM

Re: Updating database after testing [Re: Iann128]

Iann128 Offline

enthusiast

Registered: 03/21/08
Posts: 234
Loc: Austin, AR

Man that works great. I just tried it to refresh the testing copy and worked great, closed the live board did a dump of the database, imported it to the test one and all is great!

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

"Experience is a hard teacher because she gives the test first, the lesson afterwords."

Top