How do I save my database?

[Mestor]

I want to save my database cuz I am going to move my server to another Host!

I heard by someone that you can go to database->export then import on new database...


But when I done that it says size to big <_<


How do I save database with all Accounts and chars ect SAVED?!

 

[TGYoshi]

Learnt from something that you can use your command line and execute this:

mysqldump -u root -p otserv | gzip > D:/OTServ/Backups/Latest.sql.gz
(Password will be asked then)

Unzip that file if you want.

 

[Kanakashy]

do you use xampp or uniserver?

 

[Pyromaniack]

Just go to phpmyadmin select ur database click on export...DONE thats all

 

[Kanakashy]

you can search the mysql folders and copy/paste it, that's how I did to save all my database