Execute an SQL file

[FCouples]

Hey everyone I have an SQL file I would like to execute, is there any easy way of doing this without using

system("mysql -uUsername -pPassword dbname < file.sql");

Basically it's a whole bunch of this:

DROP TABLE IF EXISTS downloads;
CREATE TABLE downloads (
  teacherid bigint(100) NOT NULL default '0',
  url varchar(255) NOT NULL default '',
  title varchar(255) NOT NULL default '',
  visible char(1) NOT NULL default '1',
  section varchar(50) default 'General',
  path varchar(255) NOT NULL default ''
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `homeworkapr`
#

DROP TABLE IF EXISTS homeworkapr;
CREATE TABLE homeworkapr (
  teacherid bigint(20) NOT NULL default '0',
  period char(3) NOT NULL default '',
  d1 text,
  d2 text,
  d3 text,
  d4 text,
  d5 text,
  d6 text,
  d7 text,
  d8 text,
  d9 text,
  d10 text,
  d11 text,
  d12 text,
  d13 text,
  d14 text,
  d15 text,
  d16 text,
  d17 text,
  d18 text,
  d19 text,
  d20 text,
  d21 text,
  d22 text,
  d23 text,
  d24 text,
  d25 text,
  d26 text,
  d27 text,
  d28 text,
  d29 text,
  d30 text,
  d31 text
) TYPE=MyISAM;
# --------------------------------------------------------

Thanks!

- Jeff

[chrisranjana]

If you have PHPmyadmin installed in your server, you could upload this sql file too.

[spikeZ]

You can just put it into a mysql_query().

$sql=mysql_query("

CREATE TABLE downloads (

  teacherid bigint(100) NOT NULL default '0',

  url varchar(255) NOT NULL default '',

  title varchar(255) NOT NULL default '',

  visible char(1) NOT NULL default '1',

  section varchar(50) default 'General',

  path varchar(255) NOT NULL default ''

) TYPE=MyISAM;

") or die(mysql_error()); 

Mike

[rain5017]

phpMyAdmin

I like it

[ruchit]

you can also use SQLYog... google for sqlyog download for the latest version