On Mon, Feb 8, 2016 at 2:54 AM, Marek Červenka <[email protected]> wrote:
> Dne 4.2.2016 v 12:17 A J Stiles napsal(a): > >> On Thursday 04 Feb 2016, Marek Červenka wrote: >> >>> hi, >>> >>> is there way to get SQL schema for Asterisk 13.7.0 without alembic? >>> thanks >>> >> Assuming you already have Asterisk up and running, you can just use >> >> $ mysqldump -d -uroot DATABASE TABLE1 TABLE2 TABLE3 ... >> >> will print (on STDOUT, so you can just use > to write it to a new file, >> >> to >> join onot an existing file or | to pass it through a program) the SQL >> statements required to recreate the given tables in the given database. >> (If >> you don't specify any tables, it will assume you mean all of them.) >> >> The -d means "don't dump any data", so it will dump just the CREATE >> statements >> and not the INSERT statements that would actually populate the database. >> > > i have asterisk 13.3.0 running on box where i cannot install alembic > i need upgrade to latest asterisk. > for me is the best way apply only "alter table ..." commands for upgrade > 13.3.0->13.7.2 If you can run alembic on a different box, you can run it in offline mode with the --sql option to generate an upgrade script. https://alembic.readthedocs.org/en/latest/offline.html > > > -- > --------------------------------------- > Marek Cervenka > ======================================= > > > -- > _____________________________________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > New to Asterisk? Join us for a live introductory webinar every Thurs: > http://www.asterisk.org/hello > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
