From: asterisk-users-boun...@lists.digium.com 
[mailto:asterisk-users-boun...@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 
<cerv...@fpf.slu.cz<mailto:cerv...@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.

-- 
_____________________________________________________________________
-- 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

Reply via email to