- Create a dump file at the command prompt: mysqldump -h <your_host> -u <your_username> -p <your_database> > <your_outputfile>
- Create a database to insert this data into, at the mysql prompt enter: CREATE DATABASE <new_db_name>;
- At the command prompt type: mysql -h <your_host> -u <your_username> -p <new_db_name> < <your_outputfile>
I am assuming you are using MySQL, and if so you should really take a good look at the documentation mentioned in the previous post. The following is a simple example of how to create and restore a database dump: