Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • Cloning a MySQL database on the same MySql instance

    @deepak.mendiratta
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 261
    Comment on it

    Hi Guys,

    There are chances when we need to have a backup of the old database as a separate database so that if we make some experiments we should have the old database as a safe database which we can use again in the same state. So in mysql we have a command to make a copy of a database with new name. So below is the command and its parameters

    mysqldbcopy \ --source=root:123456@localhost \ --destination=root:123456@localhost \ old_database:new_database

    where root is the name of the mysql database and 123456 is the password and old_database is the source database and new_database is the destination database

    mysql clone database
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: