Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2011
    Location
    india- new delhi
    Posts
    31

    Unanswered: How to back , restore and merge operation perform in mysql data base

    i m just a beginner of mysql
    i want to know the command of
    1- backup of database
    2-restore database
    3- merge two database and result will be one database...
    if any one want to share their knowledge with me then i will be highly obliged...
    Thank in advance

  2. #2
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    There are tools like phpMyAdmin which helps by providing a GUI interface for executing the various commands that you are looking for. However, if you want to execute the commands yourself from the command line:

    1. mysqldump - for taking backups
    2. The result of the mysqldump command is a file containing SQL statements to both recreate the tables with permissions as well as insert statements to populate the tables.
    3. To merge database contents you simply apply the SQL file above into the database you wish to merge the contents with.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •