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