search

phpmyadmin / phpmyadmin

A web interface for MySQL and MariaDB
https://www.phpmyadmin.net/
GNU General Public License v2.0
7.06k stars 3.35k forks source link

import? #1842

Closed pma-import closed 8 years ago

pma-import commented 22 years ago

i want to import this: CREATE TABLE xoops_cwe_class_range ( low int(4) NOT NULL default '0', high int(4) NOT NULL default '0' ) TYPE=MyISAM COMMENT='THIS TABLE SHOULD NEVER HAVE MORE THAN ONE ROW!!!!!!!!!!!!!!';

CREATE TABLE xoops_cwe_event_signups ( eventid int(4) NOT NULL default '0', uid int(11) unsigned NOT NULL default '0' ) TYPE=MyISAM COMMENT='Links users to events (aka being signed up)';

CREATE TABLE xoops_cwe_events ( eventid int(4) NOT NULL auto_increment, name varchar(80) NOT NULL default '', date date NOT NULL default '0000-00-00', time varchar(20) NOT NULL default '', location varchar(255) NOT NULL default '', description text NOT NULL, materials varchar(255) NOT NULL default '', mapurl text, slots1 int(2) NOT NULL default '0', slots2 int(2) NOT NULL default '0', slots3 int(2) NOT NULL default '0', slots4 int(2) NOT NULL default '0', addedby int(11) unsigned NOT NULL default '0', notifysignups char(1) binary NOT NULL default '', PRIMARY KEY (eventid) ) TYPE=MyISAM COMMENT='Community Wellness Events';

But i don't know what to fill in where. Is there a program/script that does this for me?

ps. the database is on a remote host NOT on my own pc.

awnsers please to vjspeedy@wish.net

pma-import commented 22 years ago

Logged In: YES user_id=144058

Hi!

If you're romte server knwos php, just setup phpMyAdmin there and put your queries in the query box.

Loc

pma-import commented 22 years ago
pma-import commented 22 years ago