1

My server crashed yesterday and now I have the hard disk mounted in a Linux live environment. How can I backup all the databases so I can copy them to the new server?

I don't know all of my database names so I can't use mysqldump for each one of them.

EDIT: I don't have and can't install the MySQL service.

4
  • Try mysqldump5 --help at the command line - it is in there.
    – halfer
    Apr 5, 2012 at 9:21
  • Probably better suited over @ superuser?
    – Nanne
    Apr 5, 2012 at 9:22
  • Or maybe ServerFault
    – Cylindric
    Apr 5, 2012 at 9:23
  • mysqldump is the way. Apr 5, 2012 at 11:11

2 Answers 2

5
mysqldump --all-databases > databasebackup.sql
-1

You can try to copy your files from C:\xampp\mysql\data\DATABASE\ into your new database folder.

2
  • Can someone confirm this? I heard you can't just copy InnoDB databases.
    – LHolleman
    Apr 5, 2012 at 9:28
  • 1
    @hans..how do you know whether Lholleman is using xampp?
    – Ashwin A
    Apr 5, 2012 at 9:31

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .