...

View Full Version : How do i see my DB in phpmyadmin



johay
08-30-2006, 05:08 PM
Right i use cpanel, and im just wondering where do i save my DB to, and then how do i see it in phpmyadmin....:)

guelphdad
08-30-2006, 05:47 PM
you don't choose where to save your database, phpmyadmin will save it for you in the data directory of where you have mysql installed.

you will select your databases using the pulldown on the left side of phpmyadmin.

johay
08-30-2006, 05:54 PM
you don't choose where to save your database, phpmyadmin will save it for you in the data directory of where you have mysql installed.

you will select your databases using the pulldown on the left side of phpmyadmin.

I dont have mysql installed i'm doing it all on the web....
All i've really done is save my DB to my system. then in 'cpanel' added it in "backups"'.

johay
08-30-2006, 05:58 PM
And that's the main problem there isent a database to chose from "no databses"

And when i do try to create table

"create databasedisaster_underwor"

i get:

#1044 - Access denied for user 'disaster'@'localhost' to database 'disaster_underwor'

what would it be im doing wrong. im preety dumb in mysql....

guelphdad
08-30-2006, 07:57 PM
well you'd have to have mysql installed or you wouldn't be using phpmyadmin which relies on having mysql or sqllite installed.

maybe you don't have permissions to create a database. have you tried creating a table?

johay
08-31-2006, 03:24 PM
Nope, im all so new to mysql. i have a database made i just need to add it but i dont know how....

here's the DB i made


-- phpMyAdmin SQL Dump
-- version 2.6.4-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 06, 2006 at 04:58 PM
-- Server version: 4.0.25
-- PHP Version: 4.3.11
--
-- Database: `disaster_underwor`
--

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

--
-- Table structure for table `NEWcities`
--

CREATE TABLE `NEWcities` (
`cityid` smallint(6) unsigned NOT NULL auto_increment,
`name` varchar(20) NOT NULL default '',
`location` varchar(20) NOT NULL default '',
`traincost` int(10) unsigned NOT NULL default '1000',
`planecost` int(10) unsigned NOT NULL default '5000',
`bfstock` smallint(5) unsigned NOT NULL default '5000',
`bfprice` smallint(5) unsigned NOT NULL default '100',
`bfowner` varchar(20) NOT NULL default '',
`bfproduce` int(11) unsigned NOT NULL default '0',
`bfactive` tinyint(1) unsigned NOT NULL default '0',
`bfsellprice` int(10) unsigned NOT NULL default '0',
`rtowner` varchar(20) NOT NULL default 'State',
`rtmaxbet` int(7) unsigned NOT NULL default '100',
`rtofferprice` int(7) unsigned NOT NULL default '0',
`rtprofit` int(13) NOT NULL default '0',
`rtloss` int(13) NOT NULL default '0',
`bjowner` varchar(20) NOT NULL default 'State',
`bjmaxbet` int(7) unsigned NOT NULL default '0',
`bjofferprice` int(7) unsigned NOT NULL default '0',
`roowner` varchar(20) NOT NULL default 'State',
`romaxbet` int(7) unsigned NOT NULL default '0',
`roofferprice` int(7) unsigned NOT NULL default '0',
`kowner` varchar(20) NOT NULL default 'State',
`kmaxbet` int(7) unsigned NOT NULL default '100',
`kofferprice` int(7) unsigned NOT NULL default '0',
`drugprices` text NOT NULL,
`yzowner` varchar(20) NOT NULL default 'State',
`yzmaxbet` int(10) unsigned NOT NULL default '100',
`yzofferprice` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`cityid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `NEWcities`
--


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

--
-- Table structure for table `NEWgangreplies`
--

CREATE TABLE `NEWgangreplies` (
`threadid` mediumint(8) unsigned NOT NULL auto_increment,
`topicid` mediumint(8) unsigned NOT NULL default '0',
`creator` varchar(20) NOT NULL default '',
`message` text NOT NULL,
`dtposted` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`threadid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `NEWgangreplies`
--


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

--
-- Table structure for table `NEWgangtopics`
--

CREATE TABLE `NEWgangtopics` (
`topicid` mediumint(8) unsigned NOT NULL auto_increment,
`title` varchar(40) NOT NULL default '',
`message` text NOT NULL,
`dtmade` datetime NOT NULL default '0000-00-00 00:00:00',
`creator` varchar(20) NOT NULL default '',
`replycount` smallint(5) unsigned NOT NULL default '0',
`lastreply` datetime NOT NULL default '0000-00-00 00:00:00',
`locked` tinyint(1) NOT NULL default '0',
`sticky` tinyint(1) NOT NULL default '0',
`important` tinyint(1) NOT NULL default '0',
`normal` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`topicid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `NEWgangtopics`
--


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

--
-- Table structure for table `News`
--

CREATE TABLE `News` (
`newsid` tinyint(5) NOT NULL auto_increment,
`poster` varchar(150) NOT NULL default '',
`title` varchar(250) NOT NULL default '',
`news` text NOT NULL,
`posted` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`newsid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `News`
--


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

--
-- Table structure for table `Ticker`
--

CREATE TABLE `Ticker` (
`newsid` tinyint(5) NOT NULL auto_increment,
`news` text NOT NULL,
`dt` datetime NOT NULL default '0000-00-00 00:00:00',
`tos` text NOT NULL,
PRIMARY KEY (`newsid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `Ticker`
--


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

--
-- Table structure for table `activation`
--

CREATE TABLE `activation` (
`username` varchar(20) NOT NULL default '',
`code` varchar(64) NOT NULL default '',
`expires` int(11) NOT NULL default '0',
KEY `username` (`username`,`code`),
KEY `code` (`code`)
) TYPE=MyISAM;

--
-- Dumping data for table `activation`
--


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

--
-- Table structure for table `adrec`
--

CREATE TABLE `adrec` (
`adrecid` mediumint(8) unsigned NOT NULL auto_increment,
`userid` mediumint(8) unsigned NOT NULL default '0',
`event` varchar(20) NOT NULL default '',
`ipaddress` varchar(15) NOT NULL default '',
`dt` datetime NOT NULL default '0000-00-00 00:00:00',
`safe` tinyint(1) unsigned NOT NULL default '0',
`pldata` text NOT NULL,
PRIMARY KEY (`adrecid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `adrec`
--


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

--
-- Table structure for table `airport`
--

CREATE TABLE `airport` (
`id` int(11) NOT NULL auto_increment,
`owner` varchar(40) NOT NULL default '',
`location` enum('England','Japan','France','Usa','China','Canada') NOT NULL default 'England',
`travel_prices` varchar(100) NOT NULL default '100-100-100-100-100-100',
`profit` varchar(100) NOT NULL default '0-0-0-0-0-0',
PRIMARY KEY (`id`),
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `airport`
--


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

--
-- Table structure for table `attempts`
--

CREATE TABLE `attempts` (
`id` int(11) NOT NULL auto_increment,
`username` char(40) NOT NULL default '',
`target` char(40) NOT NULL default '',
`outcome` enum('Dead','Survived') NOT NULL default 'Dead',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `attempts`
--


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

--
-- Table structure for table `auctions`
--

CREATE TABLE `auctions` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(40) NOT NULL default '',
`min_starting` int(11) NOT NULL default '0',
`current_bid` int(11) NOT NULL default '0',
`winning` varchar(40) NOT NULL default '',
`winning_bid` int(11) NOT NULL default '0',
`item_type` varchar(100) NOT NULL default '',
`time` varchar(100) NOT NULL default '',
`item_id` varchar(100) NOT NULL default '',
`an` enum('0','1') NOT NULL default '0',
`pvt` enum('0','1') NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `auctions`
--


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

--
-- Table structure for table `ban`
--

CREATE TABLE `ban` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(40) NOT NULL default '',
`by` varchar(40) NOT NULL default '',
`type` enum('0','1') NOT NULL default '0',
`reason` text NOT NULL,
`length` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `ban`
--


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

--
-- Table structure for table `bank`
--

CREATE TABLE `bank` (
`id` int(11) NOT NULL auto_increment,
`owner` varchar(40) NOT NULL default '',
`location` enum('England','Japan','France','Usa','China','Canada') NOT NULL default 'England',
`send_interest` int(11) NOT NULL default '0',
`profit` int(100) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `bank`
--


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

--
-- Table structure for table `bar`
--

CREATE TABLE `bar` (
`id` int(11) NOT NULL auto_increment,
`owner` char(40) NOT NULL default '',
`location` enum('England','Japan','France','Usa','China','Canada') NOT NULL default 'England',
`profit` int(50) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `bar`
--


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

--
-- Table structure for table `bf`
--

CREATE TABLE `bf` (
`id` int(11) NOT NULL auto_increment,
`owner` varchar(40) NOT NULL default '0',
`stock` int(100) NOT NULL default '0',
`producing` enum('Yes','No') NOT NULL default 'Yes',
`price` int(100) NOT NULL default '100',
`location` enum('England','Japan','France','Usa','China','Canada') NOT NULL default 'England',
`profit` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `bf`
--


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

--
-- Table structure for table `bgarage`
--

CREATE TABLE `bgarage` (
`id` int(11) NOT NULL auto_increment,
`owner` varchar(40) NOT NULL default '',
`boat` varchar(100) NOT NULL default '',
`damage` varchar(100) NOT NULL default '',
`origion` varchar(100) NOT NULL default '',
`location` varchar(100) NOT NULL default '',
`upgrades` varchar(100) NOT NULL default '0-0-0-0-0-0-0-0',
`status` enum('0','1','2','3','4') NOT NULL default '0',
`worth` int(32) NOT NULL default '0',
`shiptime` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `bgarage`
--


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

--
-- Table structure for table `bidders`
--

CREATE TABLE `bidders` (
`id` int(11) NOT NULL auto_increment,
`bidder` char(40) NOT NULL default '',
`amount` int(11) NOT NULL default '0',
`auction_id` int(11) NOT NULL default '0',
`time` datetime NOT NULL default '0000-00-00 00:00:00',
`an` enum('0','1') NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `bidders`
--


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

--
-- Table structure for table `bj`
--

CREATE TABLE `bj` (
`gameid` int(11) NOT NULL auto_increment,
`card1` char(3) NOT NULL default '',
`card2` char(3) NOT NULL default '',
`card3` char(3) NOT NULL default '',
`card4` char(3) NOT NULL default '',
`card5` char(3) NOT NULL default '',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`bet` bigint(20) NOT NULL default '0',
`winlose` tinyint(4) NOT NULL default '0',
`dealer1` char(3) NOT NULL default '',
`dealer2` char(3) NOT NULL default '',
`dealer3` char(3) NOT NULL default '',
`dealer4` char(3) NOT NULL default '',
`dealer5` char(3) NOT NULL default '',
`uid` int(11) NOT NULL default '0',
PRIMARY KEY (`gameid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `bj`
--


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

--
-- Table structure for table `boat_sell`
--

CREATE TABLE `boat_sell` (
`id` int(11) NOT NULL auto_increment,
`owner` char(40) NOT NULL default '',
`boat_id` int(50) NOT NULL default '0',
`price` int(50) NOT NULL default '0',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`boat_type` char(40) NOT NULL default '',
`location` enum('England','Japan','Colombia','Usa','South Africa','Mexico') NOT NULL default 'England',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `boat_sell`
--


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

--
-- Table structure for table `car_sell`
--

CREATE TABLE `car_sell` (
`id` int(11) NOT NULL auto_increment,
`owner` char(40) NOT NULL default '',
`car_id` int(50) NOT NULL default '0',
`price` int(50) NOT NULL default '0',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`car_type` char(40) NOT NULL default '',
`location` enum('England','Japan','France','Usa','China','Canada') NOT NULL default 'England',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `car_sell`
--


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

--
-- Table structure for table `casinos`
--

CREATE TABLE `casinos` (
`id` int(11) NOT NULL auto_increment,
`owner` varchar(40) NOT NULL default '0',
`casino` enum('Slots','Roulette','RPS','Race') NOT NULL default 'Slots',
`profit` varchar(100) NOT NULL default '',
`max` int(11) NOT NULL default '0',
`location` enum('England','Japan','France','Usa','China','Canada') NOT NULL default 'England',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `casinos`
--


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

--
-- Table structure for table `chat`
--

CREATE TABLE `chat` (
`id` int(32) NOT NULL auto_increment,
`user` varchar(100) NOT NULL default '',
`chat` varchar(100) NOT NULL default '',
`timeh` varchar(20) NOT NULL default '',
`timem` varchar(20) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `chat`
--


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

--
-- Table structure for table `cities`
--

CREATE TABLE `cities` (
`cityid` smallint(6) unsigned NOT NULL auto_increment,
`name` varchar(20) NOT NULL default '',
`location` varchar(20) NOT NULL default '',
`traincost` int(10) unsigned NOT NULL default '1000',
`planecost` int(10) unsigned NOT NULL default '5000',
`bfstock` smallint(4) unsigned NOT NULL default '1500',
`bfprice` int(15) unsigned NOT NULL default '100',
`bfowner` varchar(20) NOT NULL default '',
`bfproduce` int(11) unsigned NOT NULL default '0',
`bfactive` tinyint(1) unsigned NOT NULL default '0',
`bfsellprice` int(10) unsigned NOT NULL default '0',
`rtowner` varchar(20) NOT NULL default 'State',
`rtmaxbet` int(7) unsigned NOT NULL default '100',
`rtofferprice` int(7) unsigned NOT NULL default '250000',
`rtprofit` int(13) NOT NULL default '0',
`rtloss` int(13) NOT NULL default '0',
`bjowner` varchar(20) NOT NULL default 'State',
`bjmaxbet` int(7) unsigned NOT NULL default '0',
`bjofferprice` int(7) unsigned NOT NULL default '0',
`bjprofit` int(48) unsigned NOT NULL default '0',
`bjloss` int(48) unsigned NOT NULL default '0',
`roowner` varchar(20) NOT NULL default 'State',
`romaxbet` bigint(20) unsigned NOT NULL default '100',
`roofferprice` int(7) unsigned NOT NULL default '0',
`roloss` int(32) unsigned NOT NULL default '0',
`roprofit` int(32) unsigned NOT NULL default '0',
`kowner` varchar(20) NOT NULL default 'State',
`kmaxbet` int(7) unsigned NOT NULL default '100',
`kofferprice` int(7) unsigned NOT NULL default '0',
`drugprices` text NOT NULL,
`yzowner` varchar(20) NOT NULL default 'State',
`yzmaxbet` int(10) unsigned NOT NULL default '100',
`yzofferprice` int(10) unsigned NOT NULL default '0',
`yzprofit` bigint(20) NOT NULL default '0',
`yzloss` bigint(20) NOT NULL default '0',
`slowner` varchar(20) NOT NULL default 'State',
`slmaxbet` int(10) unsigned NOT NULL default '100',
`slofferprice` int(10) unsigned NOT NULL default '15000000',
`slprofit` bigint(20) NOT NULL default '0',
`slloss` bigint(20) NOT NULL default '0',
`powner` varchar(20) NOT NULL default 'State',
`pmaxbet` int(10) unsigned NOT NULL default '100',
`pofferprice` int(20) unsigned NOT NULL default '2000000',
`pprofit` bigint(20) NOT NULL default '0',
`ploss` bigint(20) NOT NULL default '0',
PRIMARY KEY (`cityid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cities`
--


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





Thats just some of it...

oracleguy
08-31-2006, 06:24 PM
You might want to talk to your host if you don't have permission to create a database. Or also look in cPanel if there is a place to create a mysql database. I know under Plesk, I create the database and db users through it, then I can use phpMyAdmin. But that is just an example of how my host has it setup.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum