 Find various MySql Database Administratio related articles contributed by various user, to contribute you can become membor or send your article to publisher@tutorialsforu.info.
|
How to Backup and Restore MySQL Databases
phpMyAdmin can be used to export or backup MySQL databases easily.
However, if the database size is very big, it probably won’t
be a good idea. phpMyAdmin allows users to save database dump as
file or display on screen, which involves exporting SQL statements
from the server, and transmitting the data across slower network
connection or Internet to user’s computer. This process slow
the exporting process, increase database locking time and thus
MySQL unavailability, slow the server and may simply crash the
Apache HTTPD server if too many incoming web connections hogging
the system’s resources.
|
|
Read more...
|
|
Check and Optimize MySQL Database Automatically with
Crontab/Cron
MySQL is a very popular free yet powerful database system. But
even in great databases, the tables may get fragmented with
overhead due to continuous update, or delete and insert operation
on data stored in database. Beside, it’s also possibility
that the databases may get corrupted. Thus, performing health check
on database and optimize MySQL server regularly is an important
task.
|
|
Read more...
|
|
Administrating a MySQL server
Tips and tricks about administrating a MySQL server.
|
|
Read more...
|
|
Resyncing table on MySQL Slave
Sometimes MySQL Replication may run out of sync - because of its
own buts or operational limitations or because of application
mistake, such as writing to the slave when you should be only
writing to the master. In any case you need slave to be synced with
Master.
|
|
Read more...
|
|
how to recover corrupted Innodb
Assume you're running MySQL with Innodb tables and you've got
crappy hardware, driver bug, kernel bug, unlucky power failure or
some rare MySQL bug and mysql crash with assertion failure.
So what can you do to recover such a table ?
|
|
Read more...
|
|
|
|
MySql DBA 
