help required soon

[csaskt]

hello i haven not access on my sql phpmyadmin how i can install wcddl table i mean how i can make install.php file and run in browser to install file on my sql i have sql server name username and password.But i have not cpanel to access the phpmyadmin.

csaskt Reviewed by csaskt on 24th Mar 2011. help required soon hello i haven not access on my sql phpmyadmin how i can install wcddl table i mean how i can make install.php file and run in browser to install file on my sql i have sql server name username and password.But i have not cpanel to access the phpmyadmin. Rating: 5

[Lock Down]

If you do not have ssh or phpmyadmin I don't think you can create a database.

You will have to ask host to create one for you.

[csaskt]

i have database but i cannot access it i have username password sql server too but i cannot access to import i want to install.php file like phpbb forum to create a table.

[fract]

install.php file is not creating any database for you. it only populate the database with tables. you need to create a database first...

[nidzabg]

If you don't have phpmyadmin installed, install this script. It's like phpmyadmin but anyone can install it.

http://bearsql.org/

[csaskt]

my dear brother i also want to create only tables i have database password ,username and sql server name.i just want to create a tables on it for WCDDL.

[jomasaco]

<?php
include "funcs.php";

// Create table
$sql = mysql_query("
CREATE TABLE IF NOT EXISTS `wcddl_blacklist` (
  `url` varchar(255) NOT NULL,
  PRIMARY KEY  (`url`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `wcddl_config` (
  `config_name` varchar(200) NOT NULL,
  `config_val` text NOT NULL,
  `config_group` varchar(30) NOT NULL default 'misc',
  PRIMARY KEY  (`config_name`),
  KEY `config_group` (`config_group`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `wcddl_downloads` (
  `id` int(11) NOT NULL auto_increment,
  `sid` int(5) NOT NULL,
  `title` varchar(200) NOT NULL,
  `type` varchar(20) NOT NULL,
  `url` text NOT NULL,
  `dat` varchar(15) NOT NULL,
  `views` int(5) NOT NULL,
  `rating` int(5) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `sid` (`sid`,`title`,`type`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `wcddl_queue` (
  `id` int(11) NOT NULL auto_increment,
  `sid` int(5) NOT NULL,
  `title` varchar(200) NOT NULL,
  `type` varchar(20) NOT NULL,
  `url` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `wcddl_recents` (
  `query` varchar(200) NOT NULL,
  `searches` int(5) NOT NULL,
  PRIMARY KEY  (`query`),
  KEY `searches` (`searches`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `wcddl_sites` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(200) NOT NULL,
  `url` text NOT NULL,
  `email` varchar(200) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `wcddl_whitelist` (
  `url` varchar(255) NOT NULL,
  PRIMARY KEY  (`url`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
");
?>

NOT Tested

[csaskt]

thanks for reply jomasaco its not work but my webmaster import database.sql file in my databse.Now i am facing the site path problem i dont know my site path name