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
-- Host: localhost
-- Generation Time: Aug 06, 2007 at 01:36 PM
-- Server version: 4.0.24
-- PHP Version: 5.0.5-2ubuntu1.6

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

Options: ReplyQuote

Written By
import / export
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.