Copy my data from a existing db to a new db

Question

I have a database which has my data's that I have been working for months. Now, I want to delete that db. What concern's me is that the data's that I have might come in handy in the future development. So I want to get a backup for this db, where I can get all the data's and table structures in this db as a backup and then delete it.

I am confused about how to do this.

Answer 1

Have a look at the mysql_dump dump utility (MySQL docu).

Alternatively you can use the Export function of PhpMyAdmin to generate a SQL file containing all you structure and data.

Answer 2

mysqldump database_name should do the trick.

Answer 3

Have a look at this one.

 mysqldump -u [username] -p [password] [databasename] > [backupfile.sql]    
    [username] - this is your database username
    [password] - this is the password for your database
    [databasename] - the name of your database
    [backupfile.sql] - the file to which the backup should be written.

URL

Answer 4

You can use mysqldump — a Database Backup Program to store database into SQL file, and use mysql — the MySQL Command-Line Tool to restore database from the dump file.

Also, you can use Database Backup and Restore features in dbForge Studio for MySQL (GUI or command line).

Answer 5

And it would even be much simpler if you have xampp or wampp,because all you would need to do is to export the whole database