Mysql Question.....

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Juicy D. Links
    So Fucking Banned
    • Apr 2001
    • 122992

    #1

    Mysql Question.....

    New Version on one box , older version on other box

    Trying to take DB dump from new box and put into old box.

    Now I will need to upgrade Mysql on older box correct? Seem to be getting errors importing the dump..
  • fusionx
    Confirmed User
    • Nov 2003
    • 4618

    #2
    The dump should be backwards compatible - there should be no problem importing a dump to an older MySql version. A dump file should just contain data, and create and alter statements - nothing special.

    Have you tried a backup and restore, or just the dump file? Restore could screw up, as could directly attaching a newer DB.

    What errors are you seeing?

    Comment

    • Juicy D. Links
      So Fucking Banned
      • Apr 2001
      • 122992

      #3
      Originally posted by fusionx
      The dump should be backwards compatible - there should be no problem importing a dump to an older MySql version. A dump file should just contain data, and create and alter statements - nothing special.

      Have you tried a backup and restore, or just the dump file? Restore could screw up, as could directly attaching a newer DB.

      What errors are you seeing?

      dumps are from phpMyadmin

      error upon import is "No SQL query!"

      Comment

      • 2HousePlague
        CURATOR
        • Jul 2004
        • 14572

        #4
        do in phpmyadmin.
        tada!

        Comment

        • Juicy D. Links
          So Fucking Banned
          • Apr 2001
          • 122992

          #5
          Originally posted by 2HousePlague
          do in phpmyadmin.

          I am yo

          Comment

          • fusionx
            Confirmed User
            • Nov 2003
            • 4618

            #6
            Originally posted by Juicy D. Links
            dumps are from phpMyadmin

            error upon import is "No SQL query!"
            Would it be possible to look at your dump file?

            Comment

            • pornpf69
              Too lazy to set a custom title
              • Jun 2004
              • 15782

              #7
              Originally posted by Juicy D. Links
              New Version on one box , older version on other box

              Trying to take DB dump from new box and put into old box.

              Now I will need to upgrade Mysql on older box correct? Seem to be getting errors importing the dump..
              what error are you getting?

              Comment

              • newbreed
                Confirmed User
                • Nov 2003
                • 9898

                #8
                How big is the DB? Can you do it in steps (like by table/data) until it throws the error?

                Example, run a basic INSERT command and see if that works, just create a table or something. If that works try to poulate the table with data. if you don't get the error then move to the next query until it breaks.

                Loryn ‎(3:16 PM):
                I love it, just as long as we keep the bedroom door closed from all ears then we can have throw down hard core sex that makes us money haha
                fuck it we can have sex on money never did that before

                Comment

                • grumpy
                  Too lazy to set a custom title
                  • Jan 2002
                  • 9870

                  #9
                  you prob have a field with a timestamp. phpmyadmin has a problem with that.

                  do the dump and delete all the stuf behind the comma where the timestamp field is and replace it with the term : default.

                  hope this solves your problem.
                  Don't let greediness blur your vision | You gotta let some shit slide
                  icq - 441-456-888

                  Comment

                  Working...