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.

mysql < backup.sql -p
You may want to drop the tables before running the script, as it will re-create the tables.

--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: www.nusconsulting.com


---------------------------------------------------------------------
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