• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Moving database

exique

Natala-ot.com
Joined
Sep 28, 2008
Messages
1,673
Reaction score
25
Location
Sweden
How do I do if I would like to move my database to another computer?
Where is the data saved?


I am using tfs 0.3.2
 
It depends on where you have installed your databse.
I advise you to dump database in phpmyadmin (export), and then import on another computer.
 
I tried to export it..
but this error came:
Code:
 #1146 - Table 'outlander.player_skills' doesn't exist
And I choose "INSERT" when I wanted to import..

Here is a screenie:
 

Attachments

Its hard to move it, i did it today because of crash. You cant simply import that what u exported before because you get errors then etc. I splitted the file so imported everything myself in parts. First created the db's, then inserted all contents. Takes some time but it works without loosing anything ;)
 
There are different ways to move database to another computer. You can simply export it in to a doc file, and than import it on other pc. But you will probably get errors(I always do). Super nooby but easy way - replace xampp folder installed on other pc with your xampp folder. Cuz all data are there. It worked for me when I had to reninstall operating system :D
 
EASY WAY: go to xampp/mysql/data (there's all the databases that appear in PhpMyAdmin), just take your database folder out.

Same goes to insert it, just put your folder in xampp/mysql/data and you won't need to update anything.
 
EASY WAY: go to xampp/mysql/data (there's all the databases that appear in PhpMyAdmin), just take your database folder out.

Same goes to insert it, just put your folder in xampp/mysql/data and you won't need to update anything.

Thanks! :D
Reputation for the master! Xd
 
EASY WAY: go to xampp/mysql/data (there's all the databases that appear in PhpMyAdmin), just take your database folder out.

Same goes to insert it, just put your folder in xampp/mysql/data and you won't need to update anything.

Well I did what you said, but after that I started my server and got huge amount of errors about trigers. If I trie to login in my acc Im getting debug. :S Here is ss:



Im getting this triger error everytime ot starts.
 
Back
Top