Results 1 to 3 of 3

Thread: mysql backup

  1. 12-16-2008, 05:18 PM #1
    svar
    svar is offline
    Member
    Join Date
    Dec 2008
    Posts
    132

    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.
    Reply With Quote Reply With Quote
  2. 12-25-2008, 05:36 AM #2
    countach44
    countach44 is offline
    Mentor
    Join Date
    Dec 2003
    Posts
    1,616
    you can use mysqldump:

    Code:
    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:
    Code:
    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!!
    Reply With Quote Reply With Quote
  3. 01-01-2009, 07:16 AM #3
    svar
    svar is offline
    Member
    Join Date
    Dec 2008
    Posts
    132
    It works, Thanks..
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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

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
  •  

Forum Rules