how to move a database

[lt1camaro13]

Hi,
I was wondering how i could move my database/repack to another computer without having anything deleted on my server.

Thanks in advance

[y2kss66]

to move your database you could dump the database into an sql file and then execute that sql file on the other computer.

using sqlyog or navicat.

[lt1camaro13]

And how do i dump the databse into the sql file? im sorry im really new to this

[y2kss66]

right click on the db and there should be an option to dump or make a backup.

[lt1camaro13]

oo this helped alot +rep for you !

[cello1993]

If you use SQLyog :
-Right click your database
-Click on "Backup Database as SQL Dump..."
-Make sure all the tables are check marked (should be by default)

.Include "CREATE database" statement
.Include "DROP table" statement =>> these two should be marked.

-Select a path file clicking in the "..." buttom
-Simply click "Export"

When it's done, you should have the text file you've choosen filled with your database

(Do this for every database you need to run the server)