similar to: Rsync efficiency on SQL dump files

Hello group, I'm having a very hard time rsyncing efficiently a MySQL database which contains very large binary blobs. (Actually, it's the database of Mantis bug tracker [http://www.mantisbt.org/], with file attachments stored directly in the table rows. I know it's a bad idea from many other reasons, but let's say it was given to me as such.) First, I was dumping the

I need export an registers of a data base from command line. It is possible with mysqldump? for example: mysqldump -u user -ppass db "select *from users where id=20" ??? thank

we have multiple servers approx 10 and each has about 100 GB of data in the /var/lib/mysql dir , excluding tar , mysqldump and replication how do we take backup for these databases on to a remote machine and store them datewise , ( the remote machine is a 2TB HDD ) currently tar is not feasible as the data is too huge and the same goes with mysqldump suggestion will be of great help --

Hi all, Has anyone successfully set up asterisk to query a M$ SQL Server? I'd like to be able to query one in the dial plan and use the results to tamper with call priorities / CLID etc. If someone could point me to a howto / guide or relate their experiences with this, that would be great ! Thanking you all in advance. Callum P.S. Before anyone asks; it's a legacy database that

Hi, I'm trying to compile vmkit but am running into some problems. I followed the instructions at http://vmkit.llvm.org/get_started.html and checked out llvm and clang from svn, compiled them no problem and the same with classpath 0.97.2. I then checked out vmkit from svn and tried to build it. All these are located at /home/callum/vmkit/{llvm,classpath-0.97.2,vmkit}. I used this to

I am switching to a composite primary key (string and user ID) from the Rails conventional auto-incrementing integer primary ID. The table is large (2.5 million records) and I''d rather not discard the contents. The composite_primary_key gem doesn''t appear to support altering the table with a migration to do its magic, only creating a table from scratch. So I dumped the table

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

Hi, i was wondering if there was some kind of program i could download to keep track of my rails applications; something in the vicinity of subversion (a open-source backing-up tracking program - i.e to keep track of my applications once they are on the net, during a q&a period, where i''d be changing my application periodicly, but keeping a current version on the net, and one

Hi all. I usally make backups of databases mysql. I make buckups of all datbase for example: mysqldump -u user -ppassword name_db > backups.sql also I make backups just its schema for example mysqldump -u user -ppassword name_db --no-data > backups.sql but now I need a backups incrementals, because the size of DB is very big (500 mb) How to make this? regards -- *Atte.

Hi all, Has anyone had experience with installing AMP on a soekris box running Astlinux? Is it possible ? Cheers, Callum

Hello, We have MySQL running as a master which is replicating to a single slave server. We are, however, considering what is required when a 'disaster' of some sort happens to either server. By disaster, this could be some event which requires the entire server to be rebuilt, and which would usually include restoring from nightly backups directories such as '/var/lib/mysql' and

Hi all, Can someone point me to some information on the type of hardware that might / should be used for a high load on an asterisk machine ? I know that this is dependant on what services you plan to have running, and it's relevant to what you plan to do. We are likely to be running 4 E1's, Voicemail, IVR menus, Music on Hold, Pay-Over-The-Phone, lots of interdepartmental

I've setup up a single-use key on a remote host to run rsync in server mode. I've also setup .ssh/config locally with an IdentityFile to select the single-use ssh key. This works on my Debian sid machine: rsync --rsh="ssh remove_host" :: But on another machine that command (and others tried below) do not access .ssh/config. The machine is running these: $ ssh -v

Hi all, Just a quick query about something that my manager has asked about. While I have talked with Asterisk people about this before, I forget the actual answer. We currently have an ISDN 30 installed on a Dell 2850, using a single port Digium ISDN card. We would like to add an analogue card, plug our fax machine in and have Asterisk simply detect the fax and pass it through to the fax

Hi Team I am transferring to a new AD DC So I started transferring the fsmo roles the first five transferred fine the domaindns and forestdns had the following error! root at DC2:/etc/sudoers.d# samba-tool fsmo transfer --role=forestdns -UAdministrator Password for [BALEWAN\Administrator]: ERROR: Failed to add role 'forestdns': LDAP error 16 LDAP_NO_SUCH_ATTRIBUTE -? <attribute

Hi there I have the following setup Home - Main Tinc server with public IP running on PfSense work - tinc client running behind a CISCO ASA firewall with public IP running on Windows 10 offsite - tinc client running on tomato router behind a double NAT Home & offsite connect & i can see all PCs & devices & connect to them easily, on either side work to Home or offsite connects

Hi Guys, We have just set up Asterisk (CVS Head) for a realtime enviorment using MySQL & Asterisk Addons. I have populated the "sip_buddies" table with the same information that is came from our sip.conf, however registration seems to fail for the softphone we have set up. Does anyone have any idea as to what I should be looking for here? I'm not getting any error messages

Hi all, I have a question that I was hoping someone could answer for me. I would like to find a USB phone that works with Asterisk... preferably one that does not have any issues with NAT. Can anyone point me to something suitable ? We are essentially planning to do a beta for a few hundred customers on our network and would like them to be able to call one another @ no charge. Because

Hi all, We have just installed a * server (CVS head) with a TE110P card and a IDSN20 line, we are using the GXP-2000 handsets running the latest firmware (.9). Some of the calls we are receiving have echo at the our end (we can hear ourselves speak). We have a traditional ISDN telephone system here as well and when I make a call from one of the handsets asterisk answers, directs the call to

Hey guys + gals, Would you know where to point me to for an open source or commercial implementation of Theora & Vorbis for your mobile phone? Maybe as a Symbian app? Maybe a Java midlet? I'd like to be able to download & play video files to the mobile as well as maybe stream them too? Am I asking too much? :-) Thanks in advance for your help! Callum.