Stick Dragon wrote:
I had a free mysql database and admined with phpmyadmin. well i got a back up from called backup.sqlmysql < backup.sql -p
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 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