Results 1 to 3 of 3

Thread: mysql backup

  1. #1

    mysql backup

    i have a mysql database in mysyatem, i want to take backup and transfer it to another database, how it can be done.

  2. #2
    you can use mysqldump:

    mysqldump -u USER -p DATABASE > file.sql
    will login as USER (and prompt for password) and dump the contents of DATABASE to file.sql

    Then on the new server, run:
    mysql -u USER -p DATABASE < file.sql
    Make sure the charsets match, I've had troubles with this when going from different versions of mysql.
    63,000 bugs in the code, 63,000 bugs,
    ya get 1 whacked with a service pack,
    now there&#039;s 63,005 bugs in the code!!

  3. #3
    It works, Thanks..

Similar Threads

  1. MySQL Backup and Reanimation
    By Ashcrow in forum Linux - General Topics
    Replies: 3
    Last Post: 04-26-2011, 12:07 AM
  2. Automatic MySQL Backup Script
    By peter in forum Tutorials
    Replies: 1
    Last Post: 09-22-2009, 09:13 AM
  3. Automatic MySQL Backup Script
    By canela in forum Programming
    Replies: 2
    Last Post: 12-20-2006, 04:59 AM
  4. MySQl backup script
    By girlygeek in forum Programming
    Replies: 5
    Last Post: 11-11-2006, 11:23 PM
  5. mysql backup
    By elovkoff in forum Linux - Hardware, Networking & Security
    Replies: 28
    Last Post: 08-13-2004, 02:15 PM


Posting Permissions

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