MySql quick question

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • alex79
    Confirmed User
    • Jun 2002
    • 996
    #1

    MySql quick question

    i have a mySql database with around 100 tables.. what is the easyest way to copy all database to same server (make an identical copy of the database) without downloading the database on my computer (becouse the database is very big)
    i also have installeted the phpMyAdmin and i have root access with ssh
    Tags: None
    • fuzebox
      making it rain
      • Oct 2003
      • 22363
      #2
      If you've got shell access to the server, just mysqldump the database into a file.

      # mysqldump -uuser -p databasename > database.sql

      Then create a new database, and mysql -uuser -p databasename < database.sql .

        Comment

        • mrthumbs
          salad tossing sig guy
          • Apr 2002
          • 11702
          #3
          wasnt it -u username -ppassword ??

            Comment

            • fuzebox
              making it rain
              • Oct 2003
              • 22363
              #4
              Originally posted by mrthumbs
              wasnt it -u username -ppassword ??
              If you want your password in cleartext on your screen, or saved in your history file...

              I guess I'm paranoid. (-p by itself will prompt you)

                Comment

                • alex79
                  Confirmed User
                  • Jun 2002
                  • 996
                  #5
                  ok.. thanks.. it's worked

                    Comment

                    Previous template Next
                    Working...