Database Migration


Hello, this is my problem…


Moving my Vb4 forum from Fatcow to Dreamhost.

I uploaded ctdrag folder to the Dreamhost account.

I uploaded Database file (backup.sql) to Dreamhost root folder.

I access the database VIA Putty (ssh)

I input the following commands in order to migrate the backup database to the new database…

mysql -h -u b[/b] -pb[/b] ctdragmain < backup.sql

But I then get this error:

ERROR 1007 (HY000) at line 12: Can’t create database ‘ctdragmain’; database exists

I created the database as stated in the wiki.

I don’t understand any of this, some help would be appreciated



Open up the backup.sql file in a text editor and delete line 12 (which is probably something like “CREATE DATABASE ctdragmain”). Since the database already exists, trying to create it anew just gives an error.