Thread: Help a NooB today :-) please ???

Hi All

this is my first post on here and yes im a noob to dolphin aedating sql etc.

here's my problem... I purchased a database and i want to import it to dolphin 5.x.

Problem 1. i dont know if its an aedating DB ?, how do i tell ? (it has 2 folders, one with a sql file and another with tons of pics in it)

problem 2. how do i get it into dolphin.

bear in mind im technicaly minded but new to dolphin and mysql scripts etc.

please help :---)

Are there no information about the script version in the .sql file ?
What kind of tables are in it ?

Hi Cleetus

I have no understanding of the structure of sql so i opened the file with a text editor and copied the first chunk of it to show to you, see below:

-- phpMyAdmin SQL Dump
-- version 2.6.4-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 27, 2006 at 11:33 PM
-- Server version: 4.0.26
-- PHP Version: 4.3.11
--
-- Database: `xxxbust_czdating3`
--

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

--
-- Table structure for table `Profiles`
--

CREATE TABLE `Profiles` (
`ID` bigint( unsigned NOT NULL auto_increment,
`NickName` varchar(4 NOT NULL default '',
`Password` varchar(4 NOT NULL default '',
`RealName` varchar(40) NOT NULL default '',
`Country` smallint(5) unsigned NOT NULL default '0',
`City` varchar(30) default NULL,
`zip` varchar(23) NOT NULL default '',
`Children` tinyint(3) unsigned NOT NULL default '0',
`WhereChildren` enum('I will tell you later','living with me','not living with me','sometimes living with me') NOT NULL default 'I will tell you later',
`Headline` varchar(255) NOT NULL default '',
`DescriptionMe` mediumtext NOT NULL,
`DescriptionYou` mediumtext NOT NULL,
`Sex` enum('female','male','couple','TV','TS','Gay') NOT NULL default 'female',
`DateOfBirth` date NOT NULL default '0000-00-00',
`Relationship` set('act','fri','mar','rel','rom','cas','tra','pen ') NOT NULL default '',
`Height` int(11) NOT NULL default '0',
`BodyType` int(11) NOT NULL default '0',
`Religion` int(11) NOT NULL default '0',
`Ethnicity` int(11) NOT NULL default '0',
`MaritalStatus` int(11) NOT NULL default '0',
`Occupation` varchar(30) default NULL,
`Language1` int(11) NOT NULL default '0',
`Language2` int(11) NOT NULL default '0',
`Language3` int(11) NOT NULL default '0',
`WantChildren` enum('I will tell you later','No','Yes','Maybe','No matters') NOT NULL default 'I will tell you later',
`MerchantPrice` float unsigned NOT NULL default '3',
`Email` varchar(50) NOT NULL default '',
`EmailFlag` enum('HTML','Text','Not sure') NOT NULL default 'HTML',
`EmailNotify` enum('NotifyMe','NotNotifyMe') NOT NULL default 'NotifyMe',
`Phone` varchar(30) default NULL,
`HomeAddress` varchar(100) default NULL,
`IM` enum('none','icq','yahoo','msn','aol') NOT NULL default 'none',
`IcqUIN` varchar(15) NOT NULL default '',
`Status` enum('Unconfirmed','Approval','Active','Rejected', 'Suspended') NOT NULL default 'Unconfirmed',
`LastLoggedIn` datetime default NULL,
`LastModified` datetime NOT NULL default '0000-00-00 00:00:00',
`LastReg` datetime NOT NULL default '0000-00-00 00:00:00',
`Priority` smallint(5) unsigned NOT NULL default '1',
`HomePage` varchar(100) default NULL,
`LookingFor` enum('female','male','couple','all') NOT NULL default 'male',
`LookingAge` enum('I will tell you later','18-20','21-25','26-30','31-35','36-40','41-45','46-50','51-55','56-60','61-65','66-70','71-75') NOT NULL default '18-20',
`LookingHeight` int(11) NOT NULL default '0',
`LookingBodyType` int(11) NOT NULL default '0',
`Picture` enum('0','1') NOT NULL default '0',
`Pic_0_addon` varchar(32) NOT NULL default '',
`Pic_1_addon` varchar(32) NOT NULL default '',
`Pic_2_addon` varchar(32) NOT NULL default '',
`Pic_3_addon` varchar(32) NOT NULL default '',
`Pic_4_addon` varchar(32) NOT NULL default '',
`Pic_5_addon` varchar(32) NOT NULL default '',
`Pic_6_addon` varchar(32) NOT NULL default '',
`Pic_7_addon` varchar(32) NOT NULL default '',
`Pic_8_addon` varchar(32) NOT NULL default '',
`Pic_9_addon` varchar(32) NOT NULL default '',
`Pic_10_addon` varchar(32) NOT NULL default '',
`Sound` enum('0','1') NOT NULL default '0',
`Sound_addon` tinyint(3) unsigned NOT NULL default '0',
`Video` enum('0','1') NOT NULL default '0',
`Video_addon` tinyint(3) unsigned NOT NULL default '0',
`ExtraAddons` set('0','1') default NULL,
`LastNavTime` datetime NOT NULL default '0000-00-00 00:00:00',
`LastNavPage` int(4) NOT NULL default '0',
`Featured` enum('0','1') NOT NULL default '0',
`gm_avff_kiss` char(3) NOT NULL default '',
`priv_passwd` varchar(32) NOT NULL default '',
`PPNotify` enum('NotifyMe','NotNotifyMe') NOT NULL default 'NotifyMe',
`seed` int(11) NOT NULL default '0',
`guestbook` enum('Enable','Disable','Suspend','Register only','Friends only') default 'Enable',
`ProfileType` enum('single','couple') NOT NULL default 'single',
`Sex2` enum('female','male') NOT NULL default 'male',
`DateOfBirth2` date NOT NULL default '0000-00-00',
PRIMARY KEY (`ID`),
UNIQUE KEY `NickName` (`NickName`),
KEY `Country` (`Country`),
KEY `Sex` (`Sex`),
KEY `Status` (`Status`),
KEY `LastLoggedIn` (`LastLoggedIn`),
KEY `Priority` (`Priority`),
KEY `LookingFor` (`LookingFor`),
KEY `Picture` (`Picture`),
KEY `seed` (`seed`)
) TYPE=MyISAM AUTO_INCREMENT=2269 ;

--
-- Dumping data for table `Profiles`
--



Does this give you any idea what type it is ?.

Thanks for taking the time to help :--)