How to backup database from MySQL itself.

[Galaxy Computers]

Well to me its a waste of time. I am not going to mess with it. Thanks for your help.

[Galaxy Computers]

I don't know why you need to have another database to restore your backup to your forum.

[Antechinus]

You don't. However you have saved that backup with a "create database" code in it which means, naturally, that it will want to create a database when you import it. If you already have a database with the same name then the import attempt will result in an error. This is your problem.

Need computer help? Frustrated?  

[Galaxy Computers]

So what do I need to do delete the database whats in it then import the backup it should work?

[Antechinus]

Yes, you can do it that way or as I mentioned before you can change the name of the database it wants to create by altering this code in the backup file itself:

Code Select Expand

CREATE DATABASE `aids_forum` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

You can also rename the existing database rather than dumping it if for some reason you want to keep it.