Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2004

    Unhappy Unanswered: how to backup MySQL DB

    Hey guys,

    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?

    many thanks,

  2. #2
    Join Date
    Mar 2004
    use mysqldump to dump the entire data and table structure.
    if you just need to save the data you can do that by using the --no-creaete-info option.

    Edit: Sorry I had originally put --no-data where it should be --no-create-info option
    Last edited by guelphdad; 04-30-04 at 14:02.

  3. #3
    Join Date
    Nov 2011


    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.

  4. #4
    Join Date
    Apr 2002
    Toronto, Canada
    alejandro, thanks for your effort, but please do not revive a thread that has been dead for so many years

    the original poster is surely not still waiting over seven years for an answer, and if there's anyone else who has a question about mysql backups, we want them to start a new thread | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Jun 2007
    Seven year old thread Revived
    Please make any check such case not going to happen again

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts