VoIP Mailing List Archives
Mailing list archives for the VoIP community |
|
| View previous topic :: View next topic |
| Author |
Message |
cervajs at fpf.slu.cz
Guest
|
 Posted: Thu Feb 04, 2016 5:32 am Post subject: [asterisk-users] sql schema without alembic |
 |
|
hi,
is there way to get SQL schema for Asterisk 13.7.0 without alembic?
thanks
--
---------------------------------------
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 |
|
| Back to top |
|
 |
asterisk_list at earth...
Guest
|
| Posted: Thu Feb 04, 2016 6:19 am Post subject: [asterisk-users] sql schema without alembic |
|
|
On Thursday 04 Feb 2016, Marek Červenka wrote:
| Quote: | 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 |
|
| Back to top |
|
|
cervajs at fpf.slu.cz
Guest
|
| Posted: Mon Feb 08, 2016 4:54 am Post subject: [asterisk-users] sql schema without alembic |
|
|
Dne 4.2.2016 v 12:17 A J Stiles napsal(a):
| Quote: | On Thursday 04 Feb 2016, Marek Červenka wrote:
| Quote: | 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 |
|
| Back to top |
|
|
george.joseph at fairv...
Guest
|
| Posted: Mon Feb 08, 2016 10:11 am Post subject: [asterisk-users] sql schema without alembic |
|
|
On Mon, Feb 8, 2016 at 2:54 AM, Marek Červenka <cervajs@fpf.slu.cz (cervajs@fpf.slu.cz)> wrote:
| Quote: | Dne 4.2.2016 v 12:17 A J Stiles napsal(a):
| Quote: | On Thursday 04 Feb 2016, Marek Červenka wrote:
| Quote: | 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
|
|
| Back to top |
|
|
RyanT at OscarWinski.com
Guest
|
| Posted: Mon Feb 08, 2016 10:15 am Post subject: [asterisk-users] sql schema without alembic |
|
|
From: asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-bounces@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 <cervajs@fpf.slu.cz (cervajs@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. |
|
| Back to top |
|
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|
Search
