5 Mar
2008
5 Mar
'08
8:41 p.m.
[Ricardo Rodriguez] wrote:
[Ricardo Rodriguez] wrote:
Following a conversation in #xwiki IRC...
1. I've installed MySQL 5.0.45 on a Windows 2000 virtual box (Parallels on
Mac OS X 10.5.2).
2. Exported the main database and a couple virtual wikis' databases from
MySQL 5.0.27a running on the Mac OS X box.
3. Tried to import them in MySQL5.0.45: no way. Import process fails when
importing xwikiattachment_archive and/or xwikiattachment_content. I can
import any of these databases without these two tables.
Here the windowed error...
http://mire.environmentalchange.net/~webmaster/images/MySQLImportError.png
http://www.blogcfc.com/index.cfm/2006/7/21/BlogCFC-51003-Released
Quote:
"
I took these from the old version and added them to the new one and the
import ran sucessfully.
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
"
Here the logo in the Mac's console...
04/03/08 21:41:10 MySQL Administrator[2448] *** -[MARestore logWarning]:
unrecognized selector sent to instance 0x6651b70
04/03/08 21:41:10 MySQL Administrator[2448] *** NSThread: ignoring exception
'*** -[MARestore logWarning]: unrecognized selector sent to instance
0x6651b70' that raised during thread perform of target 0x6651b70 and
selector 'logWarning'
04/03/08 21:41:10 MySQL Administrator[2448] Backup Restore: WARNING: Error
while executing this query:INSERT INTO `xwiki`.`xwikiattachment_archive`
VALUES (1315139986,0x6865616409312E323B0A6163636573733B0A737....... the
whole BLOB...
Hope this makes some sense for you,
Ricardo
--
Sergiu Dumitriu
http://purl.org/net/sergiu/