• 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!

How i transfer my sql data base?

Elizabeth

New Member
Joined
Jul 3, 2009
Messages
115
Reaction score
2
Hello!!!

Im transfering my server to another computer, and i cant import my data base info, like guilds, players, accs, etc..

i install xampp, enter to localhost/phpmyadmin, create a data base with same name of the database in original computer and i import the sql document, that make fails and i cant complete..

can someone please tell me step by step how to do it??

Thaaaanks!!! ^_^
 
from comp1 to comp2

go on comp2
<ip>/phpmyadmin ---the xampp on comp1 must be on!
then make a file called mysql.mysql save on screen and do like allways
inport and its all done all chars done ;P
 
go in your database, and press export then save your database file. save it and upload it on net or a pen drive. then upload it on a new pc databases.
 
Start menu -> Run -> "cmd.exe"

Navigate through the console to your /mysql/bin/ folder, xampp/mysql/bin/ if you're using xampp.
Code:
mysqldump -u root -p DB_NAME > db.sql
on the target machine put your db.sql in the same folder, do the same steps but execute this command:
Code:
mysql -u root -p DB_NAME < db.sql
 
Back
Top