I'm transitioning to a new host. I dumped my database into several .sql files. However I can't use phpmyadmin/Telnet/ssh yet to import them.
So what little script can I use to import the whole dealie, considering the entire file is just a bunch of SQL queries like this:
Code:# phpMyAdmin MySQL-Dump # version 2.2.5 # http://phpwizard.net/phpMyAdmin/ # http://phpmyadmin.sourceforge.net/ (download page) # # Host: localhost # Generation Time: Jun 14, 2002 at 04:55 AM # Server version: 3.23.48 # PHP Version: 4.0.6 # Database : `dh2255` # -------------------------------------------------------- # # Table structure for table `access` # CREATE TABLE access ( userid int(10) unsigned NOT NULL default '0', forumid smallint(5) unsigned NOT NULL default '0', accessmask smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (userid,forumid) ) TYPE=MyISAM; # # Dumping data for table `access` # INSERT INTO access VALUES (2, 45, 1); INSERT INTO access VALUES (12, 45, 0); INSERT INTO access VALUES (61, 52, 1); INSERT INTO access VALUES (119, 76, 1); # -------------------------------------------------------- # # Table structure for table `adminlog` # CREATE TABLE adminlog ( adminlogid int(10) unsigned NOT NULL auto_increment, userid int(10) unsigned NOT NULL default '0', dateline int(10) unsigned NOT NULL default '0', script varchar(20) NOT NULL default '', action varchar(20) NOT NULL default '', extrainfo varchar(200) NOT NULL default '', ipaddress varchar(15) NOT NULL default '', PRIMARY KEY (adminlogid) ) TYPE=MyISAM; # # Dumping data for table `adminlog` # INSERT INTO adminlog VALUES (1, 1, 1024023292, 'index.php', '', '', '68.54.85.254'); INSERT INTO adminlog VALUES (2, 1, 1024023294, 'options.php', '', '', '68.54.85.254'); INSERT INTO adminlog VALUES (3, 1, 1024023299, 'options.php', 'dooptions', '', '68.54.85.254'); . . .




Reply With Quote