MyBB Community Forums

Full Version: SQL help
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Please note the flowing was my fault and not mybb

I try to update to mybb 1.2 and I did not do it right so I had to clear my SQL sever

i tride to run my SQL back up in phpadmin but it did not work

but i am now running mybb 1.2 as I had to do a new instil want I want to now is if
I add the tables my self by hand if that can be done. So I will have all my mebers and fourms and posts

Ps if any wants to see my SQL back feel free to ask me and I will show u it

this the SQL mess i get when tring to use my back up

Error

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.7.0-pl2
-- http://www.phpmyadmin.net
--
-- Host: mysql7.streamline.net
-- Generation Time: Sep 02, 2006 at 06:30 PM
-- Server version: 4.1.15
-- PHP Version: 4.3.11
--
-- Database: supermega2
--
CREATE DATABASE supermega2 DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

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

Hope someone can



Help me Tazfan
Open up the SQL backup you downloaded and change the line:
--
CREATE DATABASE supermega2 DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
--

To:
--
USE supermega2;
--
cheers Chris i will look at this thx