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.