Hi,

I am newbie in MySql. Currently we are using MySql version 5, and first i develop all the thing in my local machine, and now boss request to move all to server. I try to copy all file from data folder to server, but when i use query browser to view these table, it always prompt me table doesnt exist.

How i can move the whole database ?

Thanks in advance.

Regards

Try mysqldump. For example, . This will dump SQL code for the table creation and so on, and all the INSERTs required to populate the tables. You can restore from this dump on the server machine by simply reversing the procedure: Possibly you will have to edit the file to add "CREATE DATABASE yourDB;" and stuff like that. There are also backup tools, but I have never used them, so I can't recommend anything

Hope it helps!