Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2006
    Posts
    1

    Unanswered: copy mysql database in linux

    How to copy mysql database in linux and use it on windows

  2. #2
    Join Date
    Apr 2005
    Location
    Baltimore, MD
    Posts
    297
    Well, since this question hasn't been answered before...

    The most common use of mysqldump is probably for making a backup of an entire database:
    shell> mysqldump --opt db_name > backup-file.sql
    You can read the dump file back into the server like this:
    Code:
    shell> mysql db_name < backup-file.sql
    Or like this:
    Code:
    shell> mysql -e "source /path-to-backup/backup-file.sql" db_name
    from:http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

    You may also need to specify the host, username, password, etc.

    http://www.eklekt.com/tutorials/tutorial.php?t=1
    Give a man a fish and you feed him for a day. Teach a man to fish and you lose a steady customer.
    -----------
    Eclectic Web Development (under heavy construction)

Posting Permissions

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