Mysql backup question

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • acctman
    Confirmed User
    • Oct 2003
    • 2840

    #1

    Mysql backup question

    anyone know how to back up a mysql database via shell?
  • mrthumbs
    salad tossing sig guy
    • Apr 2002
    • 11702

    #2
    mysqldump -u username -ppassword databasename > database.sql

    Comment

    • mrthumbs
      salad tossing sig guy
      • Apr 2002
      • 11702

      #3
      and its -ppassword not -p password like it is with username!

      Comment

      • notjoe
        Confirmed User
        • May 2002
        • 5599

        #4
        Originally posted by mrthumbs
        and its -ppassword not -p password like it is with username!


        The other option is to run it with replication

        Comment

        • Babaganoosh
          ♥♥♥ Likes Hugs ♥♥♥
          • Nov 2001
          • 15841

          #5
          You have a BSD image in your sig but you don't know how to back up mysql? Too funny. Poseur.
          I like pie.

          Comment

          • rickholio
            Confirmed User
            • Jan 2004
            • 1914

            #6
            Originally posted by Babaganoosh
            You have a BSD image in your sig but you don't know how to back up mysql? Too funny. Poseur.


            And another for reference to Takeshi's Castle.
            ~

            Comment

            • fris
              Too lazy to set a custom title
              • Aug 2002
              • 55679

              #7
              when you do -p it prompts you for a pass
              Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence.

              Comment

              • acctman
                Confirmed User
                • Oct 2003
                • 2840

                #8
                many thanks =)

                Comment

                • acctman
                  Confirmed User
                  • Oct 2003
                  • 2840

                  #9
                  Originally posted by Babaganoosh
                  You have a BSD image in your sig but you don't know how to back up mysql? Too funny. Poseur.
                  to many commands to remember. plus i've never done a manual backup usually do it through phpmyadmin but now i know

                  Comment

                  • teksonline
                    So Fucking Banned
                    • Jan 2005
                    • 2904

                    #10
                    why dont you just download the mysql administrator for your windows machine

                    Comment

                    Working...