How to copy a table in MySQL
In MySQL, a table's structure and data can be copied easily. For example, create table_new with the structure and data from table_name as follows.
394 notes on Linux, tools and troubleshooting
In MySQL, a table's structure and data can be copied easily. For example, create table_new with the structure and data from table_name as follows.
The network ports used by Zimbra mail server fall into two groups. 1. External Access - Ports accessed by Clients or services outside the Zimbra system.
If you have upgraded Zimbra Collaboration Server (ZCS) to version 7 and encounter the error below: Table upgrade required. Please do "REPAIR TABLE" (2045019), from mysqlcheck, as in this example: D…
There are several ways to disable IPv6. The recommended method is to edit /etc/sysctl.conf rather than disable the IPv6 module, which causes problems with SELinux and other components…
System email on a Zimbra server normally uses the system MTA. To send system mail using the Zimbra mailer instead of the default OS MTA, follow these steps. Backup default OS MTA [root@E
mysqldump normally exports both database structure and data. Add -d or --no-data to export only the structure or schema.
Zimbra webmail supports new email notifications through Yahoo! Browser Plus, as described in How to setting pop-up email notification in Zimbra, but Yahoo! decided to close the project.
Zimbra detects duplicate messages to prevent multiple copies of the same email. This check is enabled by default and can be disabled for the server or individual accounts.
MySQL binary logs consume disk space. Configure their expiry carefully and use MySQL commands to purge them rather than deleting files from the operating system.