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

    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,
    Pat

  2. #2
    Join Date
    Mar 2004
    Posts
    480
    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 15:02.

  3. #3
    Join Date
    Nov 2011
    Posts
    3

    mysqldump

    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
    Location
    Toronto, Canada
    Posts
    20,002
    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
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Jun 2007
    Posts
    197
    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
  •