Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2006
    Posts
    26

    Unanswered: Backing up MySQL in Windows

    I am just learning MySQL 5 and have it running on a Windows 2K3 box. What would be the best way to backup my databases? Can I simply copy files in a folder or does a command need to be run?

    I was also thinking about having it auto-backup by creating a scheduled task. Any ideas on how to accomplish that if I have to do a command in the MySQL CLI?

    Thanks!

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Have a look at MySQL adminsitrator
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jan 2006
    Posts
    26
    Thanks that seems to do the job quite nicely.

  4. #4
    Join Date
    Jun 2004
    Posts
    57
    Quote Originally Posted by healdem
    Have a look at MySQL adminsitrator
    how about to backup innodb database?

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Quote Originally Posted by GongXi
    how about to backup innodb database?
    if its a MySQL database, then as far as I can see MySQL Administrator works, if you are using INNODB in another SQL engine then mebbe not....
    I'd rather be riding on the Tiger 800 or the Norton

  6. #6
    Join Date
    Nov 2006
    Posts
    4

    backing mysql databases

    hi

    i would recommend getting phpMyAdmin. It is pure magic and FREE, to quote them:

    "phpMyAdmin 2.9.0.3 is released

    Welcome to phpMyAdmin 2.9.0.3, a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields." .... and do backups!

    see their website http://www.phpmyadmin.net/home_page/index.php

    check with your host if they don't have it installed

    hope this helps

    regards

    clive

  7. #7
    Join Date
    Oct 2002
    Location
    greenwich.ct.us
    Posts
    279

  8. #8
    Join Date
    Jun 2004
    Posts
    57
    Quote Originally Posted by healdem
    if its a MySQL database, then as far as I can see MySQL Administrator works, if you are using INNODB in another SQL engine then mebbe not....
    only can backup to .sql text file?

Posting Permissions

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