Oct 02 2009
This is a reminder of how to backup the schema of a complete database
mysqldump –no-data -h localhost -u root -ppassword mydatabase > mydatabase_backup
This is if you want to only backup certain tables schema.
mysqldump –no-data -h localhost -u root -ppassword mydatabase table1 table2 > mydatabase_backup.sql
Continua”MySQL Backup Table Schema Structure and Backup only Data”
Aug 17 2009
A day will eventually come when your need to find and replace a string of text in your database. You don’t know which row, or which column, or which table. Heck, you may not even know which database. Your options are: spend the rest of the summer hunting down the elusive table cells, or use the weapon of mass replacement described below. Naturally and as usual, you absolutely must back up your database (or databases) before attempting any far-reaching scripted mumbo jumbo.
Continua”Search and Replace String MySQL”
Nov 24 2008
An important tool for debugging PostgreSQL performance issues is the ability to view all the currently executing queries. Thankfully this is easy to do. Read on for how.
Configuration
Storing of query strings is usually disabled in PostgreSQL by default. To enable it, use this line in your postgresql.conf
Continua”Viewing Current PostgreSQL queries”
May 21 2008
Original Article at
http://dev.mysql.com/tech-resources/articles/recovering-from-crashes.html
Here we discuss how to recover data after a crash in case of:
The version of MySQL we will use is MySQL 4.1.8. We’ll consider data is
stored into the InnoDB storage engine of MySQL, which has support for
transactions and automatic crash recovery. We’ll always assume the MySQL
server is under load at the time of crash. If it were not, no recovery would
ever be needed.
May 21 2008
By Tepezcuintle
An Optimized table structure is different than a well-designed table. Table structure optimization has to do with reclaiming unused space after delitions and basically cleaning up the tables after a structural modifications have been made. The OPTIMIZE SQL command can help you take care of that.
mysql>OPTIMIZE TABLE table_name[,table_name]
May 19 2008
system administration Advanced Guides Mysql guides MySQL Replication
This guide is designed to help do the initial setup on a MySQL cluster in which multiple MySQL servers all serve the same content through the use of the replication function. We have successfully deployed this solution for multiple clients and it is a very good option for those needing a more powerful mysql solution. Carlos (theuruguayan) actually created this document so please direct any questions to carlos@totalserversolutions.com .
Be sure your mysql servers are running the same version before starting this guide, yes, is possible to have a few combinations of master-slave versions, for more information about this you can check:
May 07 2008
Great Instroduction to the basics of MySQL Replication and Clustering
May 07 2008
An important aspect of an enterprise database engineering is replication to ensure maximum availability.
PostgreSQL provides (as of this writing) four options for replication.
Each offers it’s own features, benefits and issues.
This is only an overview, hopefully leading the reader to the more relevant packages for their needs.
Mar 17 2008
Howto Backup PostgreSQL Databases Server With pg_dump command
Generally, I like to work with MySQL but some time my work force me to work with PostgreSQL database server.
Recently I had received a request to backup PostgreSQL databases as one of our client want to format and reinstall RHEL server.
PostgreSQL is a one of the robust, open source database server. Like MySQL database server, it provides utilities for creating a backup.
Continua”How to backup PostgreSQL”
Comments Off
Feb 11 2008
Here is are some quick reminders to help troubleshoot mysql connections.
Show a list of active processes:
mysqladmin -u root -p processlist
enter your password and you will get a list of processes running on the server.
mysqladmin can help you do other cool stuff.
Comments Off
