1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Sytax errors when trying to import sql backup

Discussion in 'General PHP and MySQL Discussions' started by Jim Kingsnorth, Feb 21, 2016.

  1. Jim Kingsnorth

    Jim Kingsnorth Active Member

    I have two older database backups I would like to import into my forum. One was from 2004 and one from 2009. These two database were downloaded on different versions of php and I am getting syntax errors when trying to import to an empty database. My current php is 5.6 The first backup is 4.2.3 and the second is 5.2.4. My question is, does anyone know of a service or software that can fix the issues with these two?
     
  2. wang

    wang Well-Known Member

    Can you please post here the error messages that you are getting when trying to restore the database backups?
     
  3. Jim Kingsnorth

    Jim Kingsnorth Active Member

    current error

    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM

    #
    # Dumping data for table `ibf_admin_logs`
    #

    INSERT INTO `i' at line 27
     
  4. wang

    wang Well-Known Member

    This does not seem to be related to php version. It is more an issue with the backup file itself. Is this an Ipb forum backup? If so, I think it would be better to post on their support forums. Alternatively, I can help you out with this as I am familiar with Ipb too. Drop me a conversation to discuss it further in private.
     

Share This Page