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

Reply via email to