Does anyone know how to get this to work

Discussions and advertising of dedicated, private servers made by players, for players

TheZar
 
Posts: 108
Joined: 20 Jan 2015, 01:50

Does anyone know how to get this to work

Post by TheZar » 24 Dec 2017, 00:55

I used to run my own server, with a server hoster, and i want to get it back up for a while in the ingame dedicated to take pictures, the sql file from the back up is empty i tried doing the below but i can't seem to get it to work, does anyone here know how to do it?

Code: Select all
Even though this thread is older then a year now I do want to tell you a way to migrate from local to dedicated server.

Here is a Website that describes how you can recover DB Tables form the *.frm / *.ibd files http://www.voxteneo.com/restoring-tables-mysql-database-frm-ibd-files-available/

The steps I have done:
Create empty dedicated server.
Using HeidiSQL connect to Dedicated Server DB
Save in a txt file all Create Tables that have Constraints and remove the Constraints from the tables.
User command
CODE: SELECT ALL
ALTER TABLE `table_name` DISCARD TABLESPACE;
to remove all the connection to the .ibd file / File will be deleted automatically.
When all .idb files are removed you can copy the files from your local server to the dedicated mysql folder.
User command
CODE: SELECT ALL
ALTER TABLE `table_name` IMPORT TABLESPACE;
to link the new table files.
Restore Constraints form the Create Tables that where saved at the beginning.


TheZar
 
Posts: 108
Joined: 20 Jan 2015, 01:50

Re: Does anyone know how to get this to work

Post by TheZar » 23 Mar 2018, 04:24

anyone

Return to Private Servers