database already exists

Regular Joined: Feb 17, 2006 Posts: 94

i have droped my databasetables but when i try to upload the backup i get this message "Can't create database 'xxxxxxxxx'; database exists"

cheers

registered · Site Admin Joined: Jun 04, 2004 Posts: 6437

It seems that problem is how you are backing up and restoring. The restore you're using expects that database not to be present, not just the tables. If you rename or delete the database, you should be able to restore it.

Posted: Thu Jun 29, 2006 11:20 am

i tried to rename the database but it just says i dont have permission, when i make a backup how do i do it so that only the tables are saved?

cheers

Posted: Thu Jun 29, 2006 12:57 pm

If you mean just the tables and not the data that is in them, you could do that through phpmyadmin if your host has provided you with that facility.

registered · Posted: Fri Jun 30, 2006 6:12 am

Couldn't you just edit your backup file and remove the first line where it's trying to create the database? Then it should just start creating and populating the tables.

Posted: Fri Jun 30, 2006 8:04 am

Well that would be another option but you would have to be careful if the backup contained data as it would insert it again.

registered · Posted: Wed Jul 05, 2006 5:52 pm

broose wrote:

i tried to rename the database but it just says i dont have permission, when i make a backup how do i do it so that only the tables are saved?

cheers

If you are using phpMyAdmin to export your database, you need to be IN the database first, where you are seeing all the tables in the right-hand panel in a list. From there, when you go to Operations --> Export, you will now see a textbox with the full list of tables. Select them all, elect to "Drop Table if exists" and now you won't have the "CREATE DATABASE" anymore in your export...