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