Sometime you want to backup a table and all its contents in MySQL Database and then you might want to restore or copy the table to different MySQL database.
To do this you need to dump the table first and then restore to the target database. continue reading…
Archive
Category: MySQLIn some cases you might want to change or reset MySQL root password.
To do this there are two ways, using mysqladmin command or using UPDATE sql command.
1. Using mysqladmin command.
Login to the server where the MySQL database is installed. From the current shell run mysqladmin command below:
continue reading…
This tutorial will show you on how to install MySQL server from source distribution. I use Slackware for this tutorial but it should be application in other Linux distros (Centos, Ubuntu, Redhat, Fedora, Debian, etc) and BSDs varian (FreeBSD, PC-BSD, NetBSD, and OpenBSD).
Basically the explanation on how to install MySQL is already explained the INSTALL-* files included in the source file. This tutorial is only a quick step and straightforward way because if you are a newbie you will take some times to read the INSTALL-* files. continue reading…
