A very important task to do when you have a website is "always make a backup". For website that collects database data, it is recommended to do the backup process daily. Fortunately, most webhosting provider have this feature on their control panel. Just click and it's done or you can even schedule it. When a disaster occur, you can just always go through your backup and go from there. But, this process sometimes is not reliable. For additional peace of mind, this how-to will focus more on backing up your MySQL database seperately.
The tool to use is MySQL Administrator. It's a client software that can connect to a remote database. This article will explain just how to use the software and configure your connection to your webhosting server. With this tool, you can schedule your backup daily, weekly, or however you want it from your desktop.
The tool to use is MySQL Administrator. It's a client software that can connect to a remote database. This article will explain just how to use the software and configure your connection to your webhosting server. With this tool, you can schedule your backup daily, weekly, or however you want it from your desktop.
Download And Install MySQL Administrator:
Download this software from MySQL.com. Here's a direct link from the product page. Installing the software is just straight forward so there's no need for detail instruction about this process.
Configure Your Webhosting Control Panel:
My webhosting control panel is cPanel-X.
- Get your IP. To get your IP, go to "Start", "Run", type "cmd". Then on the DOS shell, type "ipconfig". If you are connected through a router or Wi-Fi network, you will not get the correct IP. What you will get is 192.168.0.xxx. That's not the IP you need. For this, you need to go to your Wi-Fi netowork administration and look for your gateway IP.
- When you have your IP, go to your control panel and click MySQL Databases icon on your control panel.
- In MySQL Database page, at the bottom you will see "Access Hosts". There is a field provided where you can put your IP. This just tells which machines can connect to your MySQL database. The IP is the identification of your machine.
If you internet connection is DHCP, please use a wildcard. So when your IP changes, you don't have to go back and put a new one. E.g.: If your IP is 209.123.123.123 you need to put 209.123.123.%. So if the last
3 digits of you IP changes, you're configuration will still be ok.
Configure Your MySQL Administrator For Backup:
- Launch MySQL Administrator and login to your remote server.
2. Select "Backup" from the menu
3. Click "New Project" button at the bottom.
4.Type the "Project Name" of your backup.
5. Click the database you want to backup. At the right area, you will see the list of tables from that database. By default everything is clicked. Which means, your backing up the whole database.
6. Click the "Advanced Options" tab. And just follow what's on the figure below.
7. If you want to schedule a backup, click "Schedule" tab. I think this part is just self explainatory.
That's It!
This is all you need to be safe when a disaster occur. Just launch MySQL Administrator and click the "Restore" menu if the need arise.
To backup your files, just use the backup feature from your webhosting control panel.
TrackBack URI for this entry
Subscribe to this comment's feed
