MySQL Server Support - MySQL Server Help from MySQL Server Experts

Reduce mySQL slave setup time with r1soft

I have been using r1soft Continuous Data Protection for many years now with the mySQL Addon and wanted to share a trick I have used several times....

785 Views

I use MySQL for many of my development projects in a Windows environment.

To manage my databases (and perform queries) for years I used a tool ...

4553 Views

This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we ha...

473 Views

Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string param...

2025 Views

Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (http://www.sq...

1341 Views

Date	Title	Author
02/10/12	How to use localhost and mysql after installing zend framework?	dimensionav
02/10/12	mysql server keeps crashing every few seconds	andrew_lush
02/10/12	How to enable federated engine on Mysql 5.0.77 on centos 5.5	fcfang
02/10/12	creating error from trigger alert	Starquest321
02/10/12	Blob Picture Problem	shelton325
02/10/12	DBI connect displays Usage message	toolsmythe
02/10/12	MySql taking a along time to return results	hmstechsupport
02/10/12	SQL Query select companies who do not have any contact set as maincont…	bapkins
02/09/12	Drupal and MySql db security	omnitechnics
02/09/12	How do I find a raw partition within a CentOS linux server	rssdds
02/09/12	Export and Print Button in PHP	nsaghar
02/08/12	package load takes	aj200
02/09/12	vbscript to start a job on a SQL server	mphillip85
02/09/12	Doing SQL SELECT limited by field length	rkorts
02/09/12	How to get value from a query ?	dimensionav

Date

Title

Author

02/10/12

Date	Title	Author
02/10/12	Truncate table in Pervasive SQL	Gerhardpet
02/10/12	Moving through a table with gaps	steva
02/10/12	How can I get PHP, MYSQL to select a field and if it has data open a new …	GD_GRAY
02/10/12	Query Question	lvollmer
02/10/12	How to do an update to put the date one month considering other date - UR…	DistillingExperts
02/09/12	PHP Loop Error	brendan-amex
02/09/12	Handling mysql errors in PHP	EICT
02/08/12	Unable to connect to any of the specified MySQL hosts --in VB.NET	KennethSumerford1
02/08/12	How to do a cron job to backup my MySQL database and send it to my desktop	rmmarsh
02/08/12	Regarding MySQL Replication - Is multi-master replication the same as ma…	rssdds
02/08/12	Setting a column on some rows.	RQuadling
02/09/12	Parse MySQL statement	Mr_Shaw
02/09/12	How do I know my init-file=/var/lib/mysql/server.init statement is w…	rssdds
02/07/12	My SQL Questoin	hmcnasty
02/08/12	Is there a way to run Explain on a stored procedure or function? If not how …	rssdds

Date	Title	Author
01/30/11	Reduce mySQL slave setup time with r1soft	ScottMcintyre
02/09/11	MySQL Workbench Remote Administration using SSH to Windows Server	rcombis
01/23/12	Analyse This -- A Database Optimization Procedure	mwvisa1
10/19/11	Mysql LIVE Repplication guide (LINUX)	Maverickerko
10/03/11	A MySQL Tidbit: Dynamic Export To_XML Stored Procedure	mwvisa1
11/11/11	A MySQL Tidbit: In-line CSV Parsing	mwvisa1
10/19/11	A MySQL Tidbit: In-line XML Parsing	mwvisa1
10/19/11	A MySQL Tidbit: Quick Numbers Table Generation	mwvisa1
10/19/11	MyDumpSplitter-Extract tables from Mysql dump-shell script	theGhost_k8
09/16/10	Load Delimited Data into MySQL Server	theGhost_k8
10/19/11	MySQL Server Memory Usage general understanding and code	theGhost_k8
09/16/10	Finding tables, views, functions, procedures and triggers in MySQL Dat…	theGhost_k8
11/04/10	Database Developers' Quick-Reference to MySQL DDL	DanielWilson
09/16/10	Replication slave lag monitoring using heartbeat and windows batch scripts.	theGhost_k8
12/13/11	3 Ways to Speed Up MySQL	gr8gonzo