You are browsing the old.JoomlaHacks.com. Checkout the newly redesigned responsive JoomlaHacks.com.
Home arrow Help & Tips arrow Backing Up Remote MySQL Database To Your Local Desktop
Strict Standards: Non-static method mosCache::getCache() should not be called statically in /home/joomlaha/www_old/components/com_content/content.php on line 36

Strict Standards: call_user_func_array() expects parameter 1 to be a valid callback, non-static method HTML_content::show() should not be called statically in /home/joomlaha/www_old/includes/Cache/Lite/Function.php on line 93

Strict Standards: Non-static method HTML_content::Title() should not be called statically in /home/joomlaha/www_old/components/com_content/content.html.php on line 486

Strict Standards: Non-static method HTML_content::PdfIcon() should not be called statically in /home/joomlaha/www_old/components/com_content/content.html.php on line 489

Strict Standards: Non-static method mosHTML::PrintIcon() should not be called statically in /home/joomlaha/www_old/components/com_content/content.html.php on line 492

Strict Standards: Non-static method HTML_content::EmailIcon() should not be called statically in /home/joomlaha/www_old/components/com_content/content.html.php on line 495

Backing Up Remote MySQL Database To Your Local Desktop


Strict Standards: Non-static method HTML_content::EditIcon() should not be called statically in /home/joomlaha/www_old/components/com_content/content.html.php on line 595

Strict Standards: Non-static method mosAdminMenus::ImageCheck() should not be called statically in /home/joomlaha/www_old/mambots/content/mosvote.php on line 32

Strict Standards: Non-static method mosAdminMenus::ImageCheck() should not be called statically in /home/joomlaha/www_old/mambots/content/mosvote.php on line 33
User Rating: / 6
PoorBest 

Strict Standards: Non-static method HTML_content::Section_Category() should not be called statically in /home/joomlaha/www_old/components/com_content/content.html.php on line 527

Strict Standards: Non-static method HTML_content::Section() should not be called statically in /home/joomlaha/www_old/components/com_content/content.html.php on line 710

Strict Standards: Non-static method HTML_content::Category() should not be called statically in /home/joomlaha/www_old/components/com_content/content.html.php on line 713

Strict Standards: Non-static method HTML_content::Author() should not be called statically in /home/joomlaha/www_old/components/com_content/content.html.php on line 530

Strict Standards: Non-static method HTML_content::CreateDate() should not be called statically in /home/joomlaha/www_old/components/com_content/content.html.php on line 533

Strict Standards: Non-static method HTML_content::URL() should not be called statically in /home/joomlaha/www_old/components/com_content/content.html.php on line 536

Strict Standards: Non-static method HTML_content::ModifiedDate() should not be called statically in /home/joomlaha/www_old/components/com_content/content.html.php on line 552

Strict Standards: Non-static method HTML_content::ReadMore() should not be called statically in /home/joomlaha/www_old/components/com_content/content.html.php on line 555
Written by Editor in Chief   
Saturday, 26 March 2005

Strict Standards: Non-static method HTML_content::TOC() should not be called statically in /home/joomlaha/www_old/components/com_content/content.html.php on line 542
MySQL Administrator 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.

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.

  1. 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.
  2. When you have your IP, go to your control panel and click MySQL Databases icon on your control panel.
  3. 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.

    cPanel-X

    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:

  1. Launch MySQL Administrator and login to your remote server.

    MySQL Administrator

  2. Select "Backup" from the menu

    MySQL Administrator 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.

    MySQL Administrator Project

  6. Click the "Advanced Options" tab. And just follow what's on the figure below.

    MySQL Administrator Advanced Options

  7. If you want to schedule a backup, click "Schedule" tab. I think this part is just self explainatory.

    MySQL Administrator Schedule

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.
Comments (5)add feed
... : kozuch82
:grin :grin :grin
January 25, 2006
bigAPE Backup : johnnydement
There is a pretty nice component for mambo for backing up your site and SQL database, is called bigAPE Backup

www.bigape.co.uk

I use it for my site and works pretty good
August 13, 2005
Amateur : Guest
great!

my hosting company dont allow to make backups with mysql administrator software...my hosting service sucks! warning with Evanzo hosting....it sucks!


Stop crying like a baby. Read the description and log into your SQL directly. It's actually quite simple ..

// Charlie
June 24, 2005
great : ruigato
thank you for this tutorial
July 7, 2005
Nice article : aravot
You have to use your database login name and password.
March 28, 2005
Write comment

You must be logged in to post a comment. Please register if you do not have an account yet.

 
Strict Standards: Non-static method HTML_content::Navigation() should not be called statically in /home/joomlaha/www_old/components/com_content/content.html.php on line 566

Strict Standards: Non-static method mosHTML::CloseButton() should not be called statically in /home/joomlaha/www_old/components/com_content/content.html.php on line 569

Strict Standards: Non-static method mosHTML::BackButton() should not be called statically in /home/joomlaha/www_old/components/com_content/content.html.php on line 572


Strict Standards: Non-static method mosCache::getCache() should not be called statically in /home/joomlaha/www_old/includes/frontend.php on line 103

Strict Standards: Non-static method mosCache::getCache() should not be called statically in /home/joomlaha/www_old/includes/frontend.php on line 103

Strict Standards: Non-static method modules_html::module() should not be called statically in /home/joomlaha/www_old/includes/frontend.php on line 140

Strict Standards: Non-static method modules_html::modoutput_xhtml() should not be called statically in /home/joomlaha/www_old/includes/frontend.html.php on line 40

Strict Standards: Non-static method mosCache::getCache() should not be called statically in /home/joomlaha/www_old/includes/frontend.php on line 103

Strict Standards: Non-static method modules_html::module() should not be called statically in /home/joomlaha/www_old/includes/frontend.php on line 140

Strict Standards: Non-static method modules_html::modoutput_xhtml() should not be called statically in /home/joomlaha/www_old/includes/frontend.html.php on line 40
Joomla Themes Joomlart Joomla Template Club Joomla Comment System Cheap Joomla Hosting from $4.95

Strict Standards: Non-static method mosCache::getCache() should not be called statically in /home/joomlaha/www_old/includes/frontend.php on line 103

Strict Standards: call_user_func_array() expects parameter 1 to be a valid callback, non-static method modules_html::module() should not be called statically in /home/joomlaha/www_old/includes/Cache/Lite/Function.php on line 93

Strict Standards: Non-static method modules_html::modoutput_table() should not be called statically in /home/joomlaha/www_old/includes/frontend.html.php on line 50
Joomla Hacks is a Joomla Components, Joomla Modules, Joomla Templates, & Joomla Mambots resource portal. None of the text or images in this public website may be copied without the expressed written consent of the authors. Copyright 2005 by JoomlaHacks.com. Powered by Joomla. All rights reserved.
Terms of Use






Strict Standards: call_user_func_array() expects parameter 1 to be a valid callback, non-static method modules_html::module() should not be called statically in /home/joomlaha/www_old/includes/Cache/Lite/Function.php on line 93

Strict Standards: Non-static method modules_html::modoutput_table() should not be called statically in /home/joomlaha/www_old/includes/frontend.html.php on line 50


Joomla Hacks German Lang French Lang Italian Lang Spanish Lang Japanese Lang Chinese Lang
Strict Standards: Non-static method mosCache::getCache() should not be called statically in /home/joomlaha/www_old/includes/frontend.php on line 103

Strict Standards: Non-static method modules_html::module2() should not be called statically in /home/joomlaha/www_old/includes/frontend.php on line 134

Strict Standards: Non-static method modules_html::modoutput_table() should not be called statically in /home/joomlaha/www_old/includes/frontend.html.php on line 102
About Advertise

Strict Standards: Non-static method mosCache::getCache() should not be called statically in /home/joomlaha/www_old/includes/frontend.php on line 103

Strict Standards: Non-static method modules_html::module() should not be called statically in /home/joomlaha/www_old/includes/frontend.php on line 140

Strict Standards: Non-static method modules_html::modoutput_naked() should not be called statically in /home/joomlaha/www_old/includes/frontend.html.php on line 45

You are browsing the old JoomlaHacks.com
Click here for the redesigned JoomlaHacks.com!