Import/export MySQL database

[obkfixx]

hi everyone im new here.. and ive got this problem... actually im a newbie in programming so.. im gonna need every ounce of help. so here goes :

i have a database in my localhost named hostel. But our instructor says to put that database or provide a copy of that database to the server. how do i dump a db on a navicat then put it on the server???

I am a computer science student.... help me! please...

[mwasif]

In navicat you can export you database as a sql file. And on your server you can import it either by command line or phpMyAdmin.

[obkfixx]

In navicat you can export you database as a sql file. And on your server you can import it either by command line or phpMyAdmin.

ooooh. thanks.. its like.... ahmm i could just ahm execute a batch file in navicat? is that what u mean??

[mwasif]

I used Navicat a long time ago. There will be an option similar to import/export. Or look for the manual on their site.

Now I prefer to use HeidiSQL (it is free).