View Full Version : [ubuntu] restoring a mysql db with same name

May 25th, 2009, 05:16 AM
my friend helped me move my lamp/file server to another computer, and all is working fine so far except the wiki with my recipes... :(

for whatver reason it got all screwed up so i re installed phpmyadmin & mediawiki, but now can't restore the database. i get the following error:


SQL query:

-- Database: `wikidb`
CREATE DATABASE `wikidb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

MySQL said: Documentation
#1007 - Can't create database 'wikidb'; database exists

May 25th, 2009, 12:26 PM
why don't you just drop your old database from within phpmyadmin?