[asterisk-users] sql schema without alembic

[George Joseph]

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>