[asterisk-users] sql schema without alembic

A J Stiles asterisk_list at earthshod.co.uk
Thu Feb 4 05:17:36 CST 2016


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.


-- 
AJS

Note:  Originating address only accepts e-mail from list!  If replying off-
list, change address to asterisk1list at earthshod dot co dot uk .



More information about the asterisk-users mailing list