Bayes converstion: SQL--> Redis?

["Dan Mahoney (Gushi)" <da...@prime.gushi.org>]

Hey there all,

In looking at my sql server, it looks like the on-disk size of my MySQL 
DB's is like 9G (because of InnoDB, it's hard to glean just from the 
filesystem what tables are which).

Anyway, I'd like to move over to a global redis system, but I don't see an 
easy way to convert from bayes SQL to redis bayes.

Is this somewhere and I can't find it?

-Dan

-- 

--------Dan Mahoney--------
Techie,  Sysadmin,  WebGeek
Gushi on efnet/undernet IRC
FB:  fb.com/DanielMahoneyIV
LI:   linkedin.com/in/gushi
Site:  http://www.gushi.org
---------------------------

Re: Bayes converstion: SQL--> Redis?

["Kevin A. McGrail" <km...@apache.org>]

On 2/4/2021 5:32 AM, Giovanni Bechis wrote:
> On 2/4/21 10:47 AM, Dan Mahoney (Gushi) wrote:
>> Hey there all,
>>
>> In looking at my sql server, it looks like the on-disk size of my MySQL DB's is like 9G (because of InnoDB, it's hard to glean just from the filesystem what tables are which).
>>
>> Anyway, I'd like to move over to a global redis system, but I don't see an easy way to convert from bayes SQL to redis bayes.
>>
>> Is this somewhere and I can't find it?
>>
> "sa-learn --backup" with old config and "sa-learn --restore" with new one should do what you need.
>
>   Giovanni
Hi Gushi, I also like to use innodb-file-per-table = 1 so I don't have 
one centralized innodb file.

Re: Bayes converstion: SQL--> Redis?

[Giovanni Bechis <gi...@paclan.it>]

On 2/4/21 10:47 AM, Dan Mahoney (Gushi) wrote:
> Hey there all,
> 
> In looking at my sql server, it looks like the on-disk size of my MySQL DB's is like 9G (because of InnoDB, it's hard to glean just from the filesystem what tables are which).
> 
> Anyway, I'd like to move over to a global redis system, but I don't see an easy way to convert from bayes SQL to redis bayes.
> 
> Is this somewhere and I can't find it?
> 
"sa-learn --backup" with old config and "sa-learn --restore" with new one should do what you need.

 Giovanni