Transfer Database to a new Server

For bug reports and fixes, installation issues, and new ideas for technical features.

Moderator: SEOW Developers

Post Reply
Riksen
Posts: 125
Joined: Thu 17 Jan 2013 2:35 am
Location: Florida, USA
Contact:

Transfer Database to a new Server

Post by Riksen »

Hi all,

I'm considereing transferring my SEOW DB (SEDB60_Reference) into a new server. Since I've made a lot o fmodifications to it, simply downloading and importing the default DB is not an option. I exported the data from my current server using phpmyadmin but the output file is considerably smaller then the original DB (65mb compared to the 111mb of the default db). Is this correct or am I missing something?

Thxs in advance
22GCT_Gross
Posts: 302
Joined: Fri 13 Apr 2007 1:13 pm
Location: Italy

Post by 22GCT_Gross »

The sedb60_reference database has all sectors data inside.
However, not all data are strictly required in order to properly run the MP.
On my side I usually tend to get several sedb60_reference tables empty (like highways or tile map codes (860.000 rows)) as I dont need into quiet sectors.
The sector_* tables are strictly required for MP to work, and some table are useful to show the map informations (such as industrial, airbases, loadouts) when you are planning some kind of new campaign.
Obviously, I keep a full copy of the database aside for any evenience.
Just try to upload your sedb60_reference copy and check if it works.
22GCT_Gross
Riksen
Posts: 125
Joined: Thu 17 Jan 2013 2:35 am
Location: Florida, USA
Contact:

Post by Riksen »

Thxs friend. I followed ur suggestions and it worked correctly, at least it seems to be ok
Post Reply