Importing Database

Discussion in 'Server Operation' started by dayjahone, Sep 6, 2008.

  1. dayjahone

    dayjahone Member

    Trying to update Pixelpost, it got screwed up and everything was gone. It installed a new version and didn't pick up any of the tons of photos already uploaded.

    I had everything backed up, so I uploaded all of the files from the "web" directory, deleted all of the table in the database and imported the exported database backup using phpMyAdmin and I get the following error:

    Code:
    Error
    SQL query:
    
    -- phpMyAdmin SQL Dump
    -- version 2.10.1
    -- http://www.phpmyadmin.net
    -- 
    -- Host: localhost
    -- Generation Time: Sep 06, 2008 at 07:07 AM
    -- Server version: 4.0.21
    -- PHP Version: 5.2.0
    SET SQL_MODE =  "NO_AUTO_VALUE_ON_ZERO";
    
    
    MySQL said: 
    
    #1193 - Unknown system variable 'SQL_MODE' 
     
  2. falko

    falko Super Moderator ISPConfig Developer

    Try
    Code:
    SET sql_mode =  "NO_AUTO_VALUE_ON_ZERO";
    instead.
     

Share This Page