Category Archives: MySQL

Posted on January 25, 2012 by zo

How to Backup MySQL Database automatically (for Linux users) 15 2 * * * root mysqldump -u root -pPASSWORD –all-databases | gzip > /mnt/disk2/database_`data ’ %m-%d-%Y’`.sql.gz This post will show you how to backup MySQL Database automatically if you are a linux user. You can use cron to backup your MySQL database automatically.”cron” is a time-based … Continue reading →

Posted in MySQL, Web Development | Tagged , , , , , , , | Leave a comment

Install & Setup LAN & Worldwide Access Guide for WAMP

Posted on October 23, 2008 by zo

STEP 1: Enable Associate Port in all Firewalls In order to communicate between your computer and other computers, either within your LAN or worldwide, you need to enable HTTP port in all firewalls. Different people use different firewalls and each … Continue reading →

Posted in MySQL, Php, Server Management, WAMP, Web Development | Tagged , , , , , , , | Leave a comment

Reset root password on MySQL Server

Posted on June 27, 2008 by zo

[root@host root]# mysql Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 1 to server version: 3.23.41 Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the buffer. mysql> USE mysql Reading … Continue reading →

Posted in MySQL, Web Development | Leave a comment

MySQL – Query Browser Connecting

Posted on August 16, 2007 by zo

To be able to remotely access your MySQL databases, you have to allow access to the databases from your computer. To do so, visit whatismyip.com, and copy your IP address. Then, log in to cPanel, go to MySQL Databases and … Continue reading →

Posted in MySQL, Web Development | Leave a comment