hi, is there way to get SQL schema for Asterisk 13.7.0 without alembic? thanks -- --------------------------------------- Marek Cervenka =======================================
On Thursday 04 Feb 2016, Marek ?ervenka wrote:> hi, > > is there way to get SQL schema for Asterisk 13.7.0 without alembic? > thanksAssuming 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 .
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 =======================================