inserting data from one mysql table into another mysql table
insert into destinationtablename select * from srctablename
insert into destinationtablename select * from srctablename
Login to mysql and run the below command: set global net_buffer_length=1000000; set global max_allowed_packet=1000000000;
Dump and restore from .sql Dump mysqldump db_name table_name > table_name.sql Restore mysql -u <user_name> -p db_name mysql> source <full_path>/table_name.sql or in one line mysql -u username -p db_name < /path/to/table_name.sql Dump and restore from a compressed (.sql.gz) format Dump mysqldump db_name table_name | gzip > table_name.sql.gz Restore gunzip < table_name.sql.gz | mysql -u username … Read more
You have the 6 channels, and basically you have 6 calls going on… Now when you hang up the do hang up, they dont get stuck right? So you have 6 different peopel on the line and when 7 hits they block you and essentially your phone system is dead….? Ok, one thing you could … Read more
In host machine iptables is running and is blocking the port 5901. Kill all the vncserver desktop in the host machine and run the following command in the terminal. Type the password for the user when prompted. sudo iptables -I INPUT 1 -p tcp –dport 5901 -j ACCEPT The above command will add the port 5901 … Read more
Terminology/Files Driver – A compiled module containing database specific code that accepts the generalized function calls that RealTime makes. As of this writing, only ODBC, MySQL (via asterisk-addons) and LDAP (see http://free.oxymium.net/Asterisk/ and http://bugs.digium.com/view.php?id=5768) drivers are available. Family – A name associated with a RealTime call. Examples: sippeers, sipusers, voicemail. extconfig.conf – The configuration file … Read more
I’ve installed the Apache web server on Kali Linux and I’m able to start/stop it with: /usr/usr/local/apache2/bin/apachectl restart[start/stop] But if I try to launch it with service command service httpd restart[start/stop] it says httpd: unrecognized service I would use the second way to launch Apache because it’s shorter and I can keep it in mind. … Read more
You can use these 3 tools http://toolbar.netcraft.com/site_report?url=google.com http://builtwith.com/techcrunch.com http://whatcms.org/?s=wordpress.com Which lists all the technologies, the website is apparently using. OR You can run this command wget –save-headers google.com This will save the server header information in an index.html file, which you can open in an editor to view site’s server details. OR You can use … Read more
Job Description —-Should have knowledge of MySql + PHP Send your resume at hr@eduguru.in info@eduguru.in
Job Description —-Should have working knowledge of Asterisk Dial plan —-Should have knowledge of installation and configuration of PRI Cards. —-Should have knowledge of MySql + PHP Send your resume at hr@eduguru.in info@eduguru.in