SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Feb 2005
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Mysql Data Backup & Restore Problem

    Hi
    I m newbie with mysql i m trying to make a copy of mysql database to cd drive and then restore this one to another machine, but i m getting problem
    and i dont know the way to perform this task.
    I use mysqlhotcopy and mysqldump programs but mysql> give an error message saying that you have an error with your syntex, here is the code line i m doing

    mysql> mysqlhotcopy km c:\kmdata

    here km is my database name and c:\kmdata is the path for new dir.

    Please help me how can i perform my task.

  2. #2
    SitePoint Addict
    Join Date
    May 2004
    Location
    .
    Posts
    227
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,

    Try to use this line:

    mysqldump --opt -u USERNAME -p PASSWORD DATABASE > backup.sql

    Then move the backup.sql to a CD.
    Ilya Devyatovsky
    ThinkHost, Inc.
    Wind/solar powered web hosting - 6 months free!


Bookmarks

Posting Permissions

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