Can you divert one database to another database if the former has crashed? My site crashed and would like to have a backup database if this happens again (hopefully not!).

Thanks.

Recommended Answers

All 4 Replies

It seems to me that you want to make a backup of your database. If you have acces to the mysql folder of the server and are able to open prompt:

Then insert this into prompt:

- Direct to the mysql folder:
C:
cd \xampp
cd \mysql
cd \bin

Or in short:

cd C:\xampp\mysql\bin

Then execute the following command:

mysqldump.exe --user=username --password=mypass databasename >path\back-upname

I have been using this method for some time, but if you dont have acces to such methods, i suggest you google a bit further on the problem.

~G

you can simply backup the database as a query forms or in data form using the CMS's export feature or backup database feature :)

Is it possible to make the backup from phpMyAdmin?

You could, depending on your database size

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.