Solved DB- Backup /Transfer to Dedi server

[ChronicleGM]

Hey guys,

Can anyone tell me how i transfer my current server database to my new dedi?

Do i just rar up the lom2.dbf in the MySQL Data folder and download /restor?



Thanks.
Code

 

[Celsius]

Do you have any sort of database manager like NaviCat?

 

[ChronicleGM]

Nope i dont.

 

[Tai]

It's 2.3 don't you just copy the server files over and restore the SQL?

 

[Gezza]

With 2.3 im sure everything is saved in sql so its just a matter of backing the db up and restoring. So where ever u backed the files up, rar and send to the dedi and restore.

 

[ChronicleGM]

Sorry for being a complete idiot but which files do i backup?

Ive rar'd the files in the MySQL folder (lom2.dbf) and tried restoring it but it cant.

 

[Gezza]

right click your db in sql and backup, you can choose what location to.

 

[ChronicleGM]

Your a star Gezza, ill see if it works (it seems to have)

 

[Gezza]

Tbh as a server owner you should be taking regular backups.

 

[ChronicleGM]

I had it setup as auto backup.

But now i know for future reference.