Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2006
    Posts
    24

    Unanswered: backup for old mysql from new

    mysql version is 5.1

    How can i backup it for old one (like mysql 4.x.x or less )

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    doing a backup in MySQL administrator should work OK,also could use PhPMyAdmin

    its possible you may have a problme with autonumber columns but judicous editing of the table & colum,n definiotnas should work OK
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jan 2006
    Posts
    24
    Quote Originally Posted by healdem
    doing a backup in MySQL administrator should work OK,also could use PhPMyAdmin

    its possible you may have a problme with autonumber columns but judicous editing of the table & colum,n definiotnas should work OK
    it is not compatibel with mysql 3.x.x

    i solved to be able to be compatible with old verison in order to backup i must use following command

    PHP Code:
    mysqldump --compatible mysql323 u zode -p123 db > /backup.sql 
    other wise

    while restoring to old server following error occured

    HTML Code:
    "MySQL: Bad syntax near DEFAULT CHARACTER SET..."

Posting Permissions

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