Home | Webstore
Latest News: OOTP 26 Available - FHM 11 Available - OOTP Go! Available

Out of the Park Baseball 26 Buy Now!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 26 > OOTP Mods > OOTP Mods - Database Tools

OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome

Reply
 
Thread Tools
Old 05-08-2012, 04:38 PM   #1
Spindel
All Star Reserve
 
Spindel's Avatar
 
Join Date: Oct 2003
Location: Lambertville, NJ
Posts: 758
Moving Statslab to a new server/host

I've recently moved my league to a new host, and am wondering is there is a way to move statslab and keep award voting history, et all. Can anyone give me any help on this? I have statslab up and running on the new site, but award voting, etc is now blank.
__________________
Union League Baseball Commissioner since 2011.
Spindel is offline   Reply With Quote
Old 05-08-2012, 04:43 PM   #2
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,383
Back up your database.

Download your statslab folder to your computer.

Create a new db (preferably same name as the original).

Create a new user for that db (preferably the same as the original one).

(if you can't name them the same as before, you'll need to edit your config file)

Restore database from your backup.

Upload staslab folder to your new site.
Cooleyvol is offline   Reply With Quote
Old 05-08-2012, 04:55 PM   #3
Killebrew
Hall Of Famer
 
Killebrew's Avatar
 
Join Date: Dec 2001
Posts: 3,326
Quote:
Originally Posted by Spindel View Post
I've recently moved my league to a new host, and am wondering is there is a way to move statslab and keep award voting history, et all. Can anyone give me any help on this? I have statslab up and running on the new site, but award voting, etc is now blank.
You can make local PC data dumps of the MySQL tables from your old host if you still have access to them. You'd have to look through the tables in the older hosts "OOTPSQL" (or "_OOTPSQL" or whatever name you chose when you set up statslab) MySQL DB to see which ones stored your old vote data, but I think you might be wanting the "awards_vote" table data. Once you dump the data from the old table you can go to your new host's "OOTPSQL" MySQL DB and import that data from your local PC.

The MySQL interface allows lots of different format options for dumping the data, like a CSV/comma delimited format. Be sure that the table name and fields match what they were on the older host table and statslab should be able to read it. Hope that makes sense.
Killebrew is offline   Reply With Quote
Reply

Bookmarks


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 04:32 AM.

 

Major League and Minor League Baseball trademarks and copyrights are used with permission of Major League Baseball. Visit MLB.com and MiLB.com.

Officially Licensed Product – MLB Players, Inc.

Out of the Park Baseball is a registered trademark of Out of the Park Developments GmbH & Co. KG

Google Play is a trademark of Google Inc.

Apple, iPhone, iPod touch and iPad are trademarks of Apple Inc., registered in the U.S. and other countries.

COPYRIGHT © 2023 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
Copyright © 2024 Out of the Park Developments