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 …
Latest articles
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 …
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, …
Install Microsoft SQL Server
The installation of Microsoft SQL Server, like that of various modern products is fairly easy, whether you are using a CD called SQL Server Developer …
Using the mysql_upgrade Command
What is mysql_upgrade? If your server runs MySQL databases, then the mysql_upgrade command is one you’ll want to familiarize yourself with. Available only in Unix, …
How to Install MySQL Server
With it’s ease of use and high reliability, MySQL is one of the most popular database solutions in the world. If you’re looking for instructions …
Access MySQL from the command line
mysql -u -p -h By default you would use the root user with no password if connecting to localhost only. While it does simplify administration …
MySQL Cluster vs. Replication
In a replication setup, a master MySQL server updates one or more slaves. Transactions are committed sequentially, and a slow transaction can cause the slave …
What to Do if MySql.sock File is Missing
If your MySQL connection is failing and returning the message ERROR 2002 (HY000): Can’t connect to local MySQL server through socket, then chances are your …
Enable the full text indexing for a MSSQL database
Syntax sp_fulltext_database Initializes full-text indexing or removes all full-text catalogs from the current database. sp_fulltext_database [@action =] ‘action’ Arguments [@action =] ‘action’ Is the action …
Showing 364 - 374 of 672 articles