SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Feb 2011
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question mysqldump from MySQL 5.5 then restore to 5.1

    I'm running vBulletin (forum software) on a Windows dedicated server. I recently had to upgrade the operating system to the latest version of Windows Server and in the process I also installed all the current versions of everything, including MySQL. (I restored the database from a mysqldump that was done before the upgrades).

    Well now there are some small issues with vBulletin, and vBulletin kinda recommends downgrading MySQL (to make a long story short). So I'm going to use mysqldump to back up the current database, then I will simply uninstall MySQL 5.5 and then install 5.1, and restore the database from the dump file.

    Is it safe to do that? I mean, is it safe to do the mysqldump from a later version of MySQL (in this case 5.5) and then restore it to an earlier version (in this case 5.1)? Any guidance would be greatly appreciated!

    Thanks

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,325
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    you should be okay, since the data is dumped using CREATE TABLE and INSERT statements, and there is general backwards compatibility

    why not set up a separate mysql instance for the 5.1 version and test it?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


Tags for this Thread

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
  •