Results 1 to 2 of 2

Thread: archiving

  1. #1
    Join Date
    Apr 2004
    Posts
    7

    Question Unanswered: archiving

    hello everyone! we have this project proposal in our school, and im wondering how and what are the techniqes in archiving in mysql. your help would e gratly appreciated. thanks...

  2. #2
    Join Date
    Jun 2004
    Posts
    12
    Hi,

    Personally I archive the MySQL databases by extracting the tables (both structure and data) into SQL scripts and then compress them with zip. I think, this is the most reliable way to make data archives in MySQL. There is a program called 'mysqldump', which can do that. It is included in every MySQL distribution package. Also there is another tool called MySQL Service Center, which provides a lot of extra abilities, such as extracting a database by schedule and compressing script after extraction is completed. The trial version of this tool is available at http://www.mysqlmaestro.com/products.../download.html.

Posting Permissions

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