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.
_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
---------------------------------------------------------------------
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
- Re: importing form a file (question) Stick Dragon
- Re: importing form a file (question) Daniel Kasak
- Re: importing form a file (question) John Coder