Backing up your SQL database using XAMPP and phpMyAdmin

 by bunglesmate
warning.jpg
I have just started to play with Joomla 1.5 content management system, to run a charity website, on a local host. One of the most important things to do is to work out how to back up the database so that I have something to fall back on just in case I mess it up.

These instructions are based on my own setup where the database is on a localhost on my own computer. Situations may be slightly different if the database is hosted elsewhere.

For this example we're looking at backing up a database named 'joomla15'.


IMPORTANT NOTE : Within the SQL structure it is possible to select databases, tables, or  individual fields for editing, backup, deletion etc. These work instructions however are only concerned with backing up the WHOLE database. Unless you know what you're doing I would suggest you don't deviate from them as you can really screw things royally.

 
Remove these adsRemove these ads by Signing Up

Step 1: Step 1 - XAMPP control panel

Image1.jpg
Open the XAMPP control panel. If they are not already running you need to start  the Apache and MySql modules.

stone578 says: Feb 12, 2013. 1:56 AM
Backup and restore sql databases due to sql server repair

http://www.sqlrepair.sqlserverrepairtoolbox.com supports Windows 98/.../7 and any version of MS SQL Server application as well
vikrostiks says: Jun 25, 2012. 5:03 PM
To backup and recover sql data you need to use following source SQL Server Repair Toolbox software very likely will help you
akrenvalk says: Apr 30, 2012. 4:13 AM
Backup and restore .sql databases you may perform with the help of programming way.

You need to software recovering .sql databases of any version SQL Server.

I would recommend you to try tool below

sql server fix
mrmath says: Jan 14, 2010. 11:21 AM
I've been playing with Joolma! as well, and was thinking about doing an instructable on setting it up with XAMPP!
bunglesmate (author) in reply to mrmathJan 14, 2010. 1:13 PM
 If you spot something not quite right or can provide some better explanation on parameters etc I'll update the instructable as appropriate.
Pro

Get More Out of Instructables

Already have an Account?

close

PDF Downloads
As a Pro member, you will gain access to download any Instructable in the PDF format. You also have the ability to customize your PDF download.

Upgrade to Pro today!