<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:10pt"><DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"><FONT face="courier, monaco, monospace, sans-serif">Please bear with me as I need to understand this completely to ensure I get it right.</FONT></DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"><FONT face="courier, monaco, monospace, sans-serif"></FONT> </DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"><FONT face="courier, monaco, monospace, sans-serif">The issue is how to move one or more assets from a regions AssetStorage.db in sqlite to import into a grids mysql database. Let me take the tables first. Here is the sqlite table for assets.</FONT></DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"><FONT face="courier, monaco, monospace, sans-serif"></FONT> </DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"><FONT face="courier, monaco, monospace, sans-serif">$ sqlite3 AssetStorage.db<BR>sqlite> .tables<BR>assets<BR>sqlite> describe assets;<BR>SQL error: near "describe": syntax error<BR>sqlite> .schema assets<BR>CREATE TABLE assets(<STRONG>UUID</STRONG> varchar(255) primary key,<BR><STRONG>Name </STRONG>varchar(255),<BR><STRONG>Description</STRONG> varchar(255),<BR><STRONG>Type</STRONG> integer,<BR><STRONG>InvType</STRONG> integer,<BR><STRONG>Local</STRONG> integer,<BR><STRONG>Temporary</STRONG> integer,<BR><STRONG>Data</STRONG> blob);<BR>sqlite> </FONT></DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"><FONT face="courier, monaco, monospace, sans-serif"></FONT> </DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"><FONT face="courier, monaco, monospace, sans-serif">mysql> describe assets;<BR>+-------------+-------------+------+-----+---------+-------+<BR>| Field | Type | Null | Key | Default | Extra |<BR>+-------------+-------------+------+-----+---------+-------+<BR>| <STRONG>id</STRONG> | binary(16) | NO | PRI | | |<BR>| <STRONG>name</STRONG> | varchar(64) | NO | | | |<BR>| <STRONG>description</STRONG>| varchar(64) | NO |
| | |<BR>| <STRONG>assetType</STRONG> | tinyint(4) | NO | | | |<BR>| <STRONG>invType </STRONG> | tinyint(4) | NO | | | |<BR>| <STRONG>local</STRONG> | tinyint(1) | NO | | | |<BR>| <STRONG>temporary</STRONG> | tinyint(1) | NO | | | |<BR>|
<STRONG>data</STRONG> | longblob | NO | | | |<BR>+-------------+-------------+------+-----+---------+-------+<BR>8 rows in set (0.00 sec)</FONT></DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"><FONT face="courier, monaco, monospace, sans-serif">mysql></FONT> </DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"> </DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif">So, we have names that are slightly different (capitalization mainly) and types that are somewhat different.</DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"> </DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif">Can one expect to do something like</DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"> </DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif">1. $ sqlite3 AssetStorage > assetFile</DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif">2. $ scp assetFile computerRunningGrid</DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif">3. $ ssh computerRunningGrid</DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif">4. $ mysql </DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif">5. $ import from assetFile to assets;</DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"> </DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif">And expect all the details to be worked out?</DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"> </DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif">Pardon my naivety a bit as I work through something I have not done before, but I would like to understand it completely first before fubarring anything. Also, I suspect a recipe describing this would be helpful on wiki. If I can get a recipe to work, then I will be delighted to add it to the wiki.</DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"> </DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif">Charles </DIV></div></body></html>