On Wed, 2002-11-20 at 18:19, Stick Dragon wrote: > I had a free mysql database and admined with phpmyadmin. well i got a back > up from called backup.sql > > in side the file it looks like this > > # Table structure for table `phpbb_auth_access` > # > > CREATE TABLE phpbb_auth_access ( > group_id mediumint(8) NOT NULL default '0', > forum_id smallint(5) unsigned NOT NULL default '0', > <editied for space> > KEY forum_id (forum_id) > ) TYPE=MyISAM; > > # > # Dumping data for table `phpbb_auth_access` > # > > INSERT INTO phpbb_auth_access VALUES (21,10,1,1,1,1,1,1,1,1,1,'','',''); > INSERT INTO phpbb_auth_access VALUES (4,9,1,1,1,1,1,1,1,1,1,'','',''); > <editied for space> > INSERT INTO phpbb_auth_access VALUES (19,10,1,1,1,1,1,1,1,1,1,'','',''); > # -------------------------------------------------------- > > is there a way to run, and restore the database with this file. i dont have > phpmyadmin installed, didnt really like the prog and trying to learn mysql > through the console.
you can run this type of file through the console. at the mysql prompt type: \. <file.sql> without the <> of course. look at the help blurb when you do a \h at the mysql prompt. John Coder --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php