Fix Lame Nameserver Error
A lame server, is one that is specifed at the registrar to be authoritative for a domain, but the server itself is not setup in …
Latest articles
Fix nameservers not working for Linux servers
If you have your own namerservers or you are using nameservers provided by host, and these nameservers aren’t working : Solution — Edit the file …
Copy MySQL database to another server through shell?
Copying MySQL Databases to another server If you are using MySQL 3.23 or later, you can copy the .frm, .MYI, and .MYD files for MyISAM …
When I check my logs, I see a lot of messages about lame servers.
A lame server is one that is specified at the registrar to be authoritative for a domain, but the server itself is not setup in …
Use mysql_fix_privilege_tables script
Solution mysql_fix_privilege_tables — Upgrade MySQL System Tables Some releases of MySQL introduce changes to the structure of the system tables in the mysql database to …
What database software does Hivelocity support?
Hivelocity supports Microsoft SQL server AKA MSSQL , PostgreSQL , and MYSQL.
Delete a Database
Databases are destroyed with the command DROP DATABASE: DROP DATABASE name; Only the owner of the database, or a superuser, can drop a database. Dropping …
Run MySQL with a normal user?
On Unix, the MySQL server mysqld can be started and run by any user. To change mysqld to run as a normal unprivileged Unix user …
Why should I disable autocommit while dumping a database?
Turn off autocommit and just do one commit at the end. (In plain SQL, this means issuing BEGIN at the start and COMMIT at the …
How does memory overcommit affect PostgreSQL?
In Linux 2.4 and later, the default virtual memory behavior is not optimal for PostgreSQL. Because of the way that the kernel implements memory overcommit, …
Create PostgreSQL user account
It is advisable to run PostgreSQL under a separate user account. This user account should only own the data that is managed by the server, …
Showing 793 - 803 of 1347 articles