Re: import/export db from windows to linux
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?