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