Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • Cloning a MySQL database on the same MySql instance

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 201
    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

 0 Comment(s)

Sign In
                           OR                           
                           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: