how to mend it - Fix appliances, electricals, gadgets, cars... Ask for free help
:: home
:: add a question
:: search
:: help
:: most recent
:: unanswered
   Search: Go 
Fixed for free!
Ask Your Question
Popular

These categories may also be of interest ...

Software, Media Players

Software, Operating Systems

Software, Web Servers

Software, Web Site Design

Software, Word Processors

Full list

... mend, fix, or repair just about anything.

Help someone
  Are you good at fixing things?  

Click here to help

Fault info.
Click here for Lumicron repair information.
First time?

howtomendit.com costs nothing to use and you can ask a question without an account or logging in.

Click here to ask a question.

Answers

Who answers the questions?

Other users of howtomendit.com provide the answers. The more detail and information you provide in your question the easier it is for others to help you.

Search for a fix
How can I fix my
Backup?
Mend it
Why does my Home Page keep changing?
Categories > Mend Software, Backup > Question
Q & As - mend, repair, fix Navigate to ...
Software, Backup (28 other questions)
Other categories
Add a question



Mend > Backup

Question - mend, repair, fix

Which files would I need to backup to backup a MySQL database?

In which folder are MySQL Database files actually kept? Which files should I backup? Is there a good tool for backing these up and restoring them if nessesary?



Sil
March 2004

To add an answer, click here To add a new question, click here To find all other questions, click here

Answers - mend, repair, fix

Try this command:
mysqldump --user= | bzip2 -zc > bzipfile.bz2

The zipping is optional etc. the raw output is an SQL query that would rebuild and repopulate a database.

There are loads of options so try:
mysqldump --help

These are command line (sh or bsh etc.) which work on Unix/Linux, there is probably the same for Windows CMD.

Paul
February 2005

To add an answer, click here    

Add An Answer Form

Add your answer using the form below ...

The question: Which files would I need to backup to backup a MySQL database?
Your answer:

(Add your answer here. Try to include as much detail as possible.)
Your name:

(Enter your name as you wish it to be displayed.)
Other questions in this category - Software, Backup
How to backup my iPhone data?

I have an iPhone 5 and recently something went wrong. So someone advised me resetting my iPhone 5 to factory settings. But I know factory reset will erase all my data and settings on my iPhone. I don't want to lose the data. So is there a great and reliable way to backup my iPhone data?...

Click here for how to mend it.
What is the fastest application which burns data DVD?

Do CD/DVD burner application vary in the amount of time they take to burn a disk? I ask because some seem to take ages to prepare what they are going to burn whilst other don't. What is the best free one?...

Click here for the fix.
got no synoposis?

my dtr is on 14 day extended tv guide only got 6 dys but no info about any programmes comes up anymore the box is a thomson 250. top up tv will not help me because i dont subscribe. please help....

Click here for the repair.
Where can I find free Disk Imaging Backup Software?

I would like to backup my hard drive by creating an image of the disk. Years ago I used PowerQuest DriveImage. I can't afford to buy more software. Is there a good free opensource version for Windows 7?...

Click here for the repair.
my digivox xl went off last year?

my digivox went off last year i have just got it back out the box cos someone has told me thay can be put back on is this true and if so how. thanks gary...

Click here for the fix.
codes ?

codes for my digibox...

Click here for how to mend it.
NEED BLUETOOTH DRIVERS?

NEED DRIVER FOR MIKOMI BLUETOOTH DONGLE MODEL NUMBER BC03RUT-O1...

Click here for the fix.
switxhes its sellf of ?

hi my starveiw 3 wiill not go to the main menu all that happens is the box symble comes on the tv and tnhen switches of any idears abbo...

Click here for how to mend it.
Fix what?
Garden Tools, Grass Trimmers - fix/mend/repair/service information
Household Appliances, Steam Irons - fix/mend/repair/service information
Bathroom Appliances, Hairdryers - fix/mend/repair/service information
Help wanted!
Advertisements
Fixed!
Thank you so much! Worked with my ancient machine.

Sue
Sep 2019


Mend it
How can I mend my Vauxhall Movano?
All appliances!

To mend any household, kitchen, or other electrical appliance start here.

To search for repair advice click here.

To find out how to mend it click here.

Mend it
How can I repair my Brother Printer?
Fault find
Click here to fix Hygena products.
Advertisements
Important

Attempting repairs can be dangerous.
In many instances work should only be undertaken by a qualified professional.
Ensure you have read our Small Print page before using information supplied via this website.

©  2003 vE
We use Cookies. See our Privacy Policy.