Two Databases in MySQL

[ilokana]

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.

[Graphix]

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

[network18]

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

[ilokana]

Is it possible to make the backup from phpMyAdmin?

[SoN9ne]

You could, depending on your database size