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, email

Software, FTP Servers

Software, Graphic Design

Software, Instant Messaging

Software, Internet Browsers

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 Daimler 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
How can I repair my Fiat Punto?
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 the fix.
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 how to mend it.
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 how to mend it.
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 how to mend it.
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 how to mend it.
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 the fix.
Fix what?
Furniture, Garden Furniture - fix/mend/repair/service information
Computers, Modems - fix/mend/repair/service information
Software, Instant Messaging - fix/mend/repair/service information
Help wanted!
Advertisements
Fixed!
Amazing. Thank you for this ingenious fix.

Bill
Nov 2020


Mend it
Need help installing Driver Files?
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 Olympia Cash Register?
Fault find
Click here to fix Olympia 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.