MySQL Forums
Forum List  »  Knowledge Base

import / export
Posted by: william wood
Date: August 06, 2007 07:18AM

i have cloned a linux machine (ubuntu) with MySQL DB running, so i have two identical machines.

I export the db using mysqladmin, accepting the default vaules and save the file to xxxx.sql

When i try to import to the clone machine (accepting the default values) i get this error. i am a noob so be gentle with me. thanks for any help


SQL query:

-- phpMyAdmin SQL Dump
-- version 2.10.0.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 06, 2007 at 01:36 PM
-- Server version: 4.0.24
-- PHP Version: 5.0.5-2ubuntu1.6
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

MySQL said: Documentation
#1193 - Unknown system variable 'SQL_MODE'

Options: ReplyQuote


Subject
Views
Written By
Posted
import / export
4992
August 06, 2007 07:18AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.