Importing Table

[liamloveslearning]

Hi everyone,

 

Ive recently purchased a dedicated server and im trying to move across my database from my old host, I managed to export it as an .SQL file but im at my wits end trying to connect to it, It imports fine but I cant manage to connect to it no matter what I try, literally at my wits end!

 

Im new to this so excuse my "naivity" but if anybody could point me in the right direction in regards to this it would help a bunch, thanks!

[liamloveslearning]

my .SQL file has

 

-- phpMyAdmin SQL Dump
-- version 2.11.9.5
-- http://www.phpmyadmin.net
--
-- Host: mysql1.namesco.net
-- Generation Time: Dec 09, 2009 at 01:41 PM
-- Server version: 4.1.22
-- PHP Version: 5.2.9

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 */;

--
-- Database: `signshop`
--
CREATE DATABASE `signworld_s` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `signworld_s`;

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

--
-- Table structure for table `osc_address_book`
--

 

at the top, However Ive created the database and all I need to do is import the data, can i just delete this all will it corrupt the file?

[liamloveslearning]

Cracked it! trial and error was the winner!