i'm new to mysql. currently i have a database with 2 tables in it. my database name is malibu_udnerconstruction. the problem now is that i wan to do a backup on the database, but i don know how to do it. can any1 pls help me?
As Guelphdad mentioned, you can use the mysqldump command, here is an example:
mysqldump --opt --host=localhost --user=myUser --password=myPass --result-file=C:\Backups\myBackupFile.sql myDatabase
in this case "myDatabase" will be your database name "malibu_udnerconstruction"
Also, if you are new to mysql there are many tools that can help you with the backup process. Take a look at MySQLBackupFTP ,the interface is very friendly and the tool has good features like file compression, ftp, and mail notifications.