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 -- --------------------------------------- Marek Cervenka =======================================
On Mon, Feb 8, 2016 at 2:54 AM, Marek ?ervenka <cervajs at fpf.slu.cz> 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-------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20160208/5245f469/attachment.html>
From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of George Joseph Sent: Monday, February 08, 2016 10:11 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] sql schema without alembic On Mon, Feb 8, 2016 at 2:54 AM, Marek ?ervenka <cervajs at fpf.slu.cz<mailto:cervajs at fpf.slu.cz>> 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 [Ryan, Travis] I?m also very interested. I have tables that are already named the same as alembic uses, so it causes me issues on upgrades. -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20160208/f424b0bc/attachment.html>