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...

Recommended Answers

All 5 Replies

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

Try it piece by piece to find the error, if it doesnt say what line.

Is line 62 complete? You haves VALUES but nothing after it.

Thanx Guys :)

Got It Solved :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.