0

I'm making a SAMP server, with all the info of bans and bought vehicles in a MySQL database to get easy acces to it and to change it easily.

But setting it up wast that easy :/

Here is the MySQL info, can some1 please help me here?

-- phpMyAdmin SQL Dump
-- version 3.3.8
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1:7778
-- Erstellungszeit: 12. Februar 2012 um 04:02
-- Server Version: 5.1.49
-- PHP-Version: 5.3.3-7+squeeze3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Datenbank: `samp43_cnr`
--
CREATE DATABASE `samp43_cnr` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `samp43_cnr`;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `autobahn`
--

DROP TABLE IF EXISTS `autobahn`;
CREATE TABLE IF NOT EXISTS `autobahn` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `vehicleid` int(11) NOT NULL,
  `vehicleowner` varchar(24) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2232 ;

--
-- Daten für Tabelle `autobahn`
--


-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `bans`
--

DROP TABLE IF EXISTS `bans`;
CREATE TABLE IF NOT EXISTS `bans` (
  `user_banned` varchar(24) NOT NULL,
  `user_banned_ip` varchar(16) NOT NULL,
  `user_banner` varchar(24) NOT NULL,
  `ban_reason` varchar(60) NOT NULL,
  `ban_date` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Daten für Tabelle `bans`
--

INSERT INTO `bans` (`user_banned`, `user_banned_ip`, `user_banner`, `ban_reason`, `ban_date`) VALUES

If i press OK, it gives me error #1007 - Can't create database 'samp43_cnr'; database exists

Any help please...

Edited by Deminitous: n/a

3
Contributors
5
Replies
6
Views
5 Years
Discussion Span
Last Post by Deminitous
0

Already tried that :/

If i do that, and i also tried CREATE DATABASE IF NOT EXIST, but both give the same error

#1064 - You have an error in your SQL syntax

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.