Re: import/export db from windows to linux
Posted by: al lelopath
Date: February 02, 2005 10:47AM

Thanks for your repply, I'm just getting back to this now
I followed your instructions.
Everything is fine until the last action.
It creates the database, but there is nothing in it.
The .sql file looks good, I'll show just the first part to show:

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `ecotonedatabase`;
USE `ecotonedatabase`;
CREATE TABLE `semaphoretable` (
`semaphore` varchar(48) NOT NULL default '',
PRIMARY KEY (`semaphore`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `soilmaptable` (
`rowNumber` int(10) unsigned NOT NULL default '0',
`columnNumber` int(10) unsigned NOT NULL default '0',
`layerNumber` int(10) unsigned NOT NULL default '0',
...bla, bla bal
PRIMARY KEY (`rowNumber`,`columnNumber`,`layerNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `soilmaptable` (`rowNumber`,`columnNumber`,`layerNumber`,`horizon`,`regionNumber`,`depth`,`bulkDensity`,`percentSand`,`percentSilt`,`percentClay`,`
percentRock`,`SOC`,`Nitrogen`) VALUES (0,0,0,'A1',1,1,1.05767,90,4,6,0,0.0289698,0.028925),(0,0,1,'A2',1,4,1.05731,11,30,37,22,0.0287907,0.0287459),(0,0,2,'B1'
,1,9,1.05695,32,12,19,37,0.0286115,0.0285667),(0,0,3,'B2',2,16,1.0566,53,6,16,25,0.0284323,0.0283875),(0,0,4,'C1',2,25,1.0591,6,80,4,10,0.0296865,0.0296417),(0
,0,5,'C2',3,36,1.05875,27,70,2,1,0.0295073,0.0294625),(0,1,0,'A1',1,1,1.05839,48,13,9,30,0.0293281,0.0292833),(0,1,1,'A2',1,4,1.05803,69,10,20,1,0.029149,0.029
1042),(0,1,2,'B1'
bla bla bla

What could be wrong?

Options: ReplyQuote


Subject
Written By
Posted
Re: import/export db from windows to linux
February 02, 2005 10:47AM


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.