restore en database-dump.
jeg har en stor (20mb) database-dump fil fra en mysql server, og myphpadmin kan ikke bruge den, da den timer out længe inden den har fået hele filen...er der ikke en måde at eksekvere en sådan fil via et script hvis jeg uploader den til serveren?
-her er et uddrag af dump-filen:
# phpMyAdmin MySQL-Dump
# version 2.3.1-rc1
# http://www.phpmyadmin.net/ (download page)
#
# Vært: localhost
# Genereringstidspunkt: 15/11 2002 kl. 17:08:59
# Server version: 3.23.49
# PHP version: 4.2.2
# Database: : `psclan_com_1`
# --------------------------------------------------------
#
# Struktur dump for tabellen `psycotics_phpbb_auth_access`
#
CREATE TABLE psycotics_phpbb_auth_access (
group_id mediumint(8) NOT NULL default '0',
forum_id smallint(5) unsigned NOT NULL default '0',
auth_view tinyint(1) NOT NULL default '0',
auth_read tinyint(1) NOT NULL default '0',
auth_post tinyint(1) NOT NULL default '0',
auth_reply tinyint(1) NOT NULL default '0',
auth_edit tinyint(1) NOT NULL default '0',
auth_delete tinyint(1) NOT NULL default '0',
auth_sticky tinyint(1) NOT NULL default '0',
auth_announce tinyint(1) NOT NULL default '0',
auth_vote tinyint(1) NOT NULL default '0',
auth_pollcreate tinyint(1) NOT NULL default '0',
auth_attachments tinyint(1) NOT NULL default '0',
auth_mod tinyint(1) NOT NULL default '0',
KEY group_id (group_id),
KEY forum_id (forum_id)
) TYPE=MyISAM;
#
# Data dump for tabellen `psycotics_phpbb_auth_access`
#
INSERT INTO psycotics_phpbb_auth_access VALUES (3, 15, 1, 1, 1, 1, 1, 0, 0, 0, 1, 1, 0, 0);
INSERT INTO psycotics_phpbb_auth_access VALUES (4, 11, 1, 1, 1, 1, 1, 1, 0, 0, 1, 1, 0, 0);
INSERT INTO psycotics_phpbb_auth_access VALUES (4, 13, 1, 1, 1, 1, 1, 0, 0, 0, 1, 1, 0, 0);
INSERT INTO psycotics_phpbb_auth_access VALUES (5, 10, 1, 1, 1, 1, 1, 0, 0, 0, 1, 1, 0, 0);
INSERT INTO psycotics_phpbb_auth_access VALUES (3, 12, 1, 1, 1, 1, 1, 0, 0, 0, 1, 1, 0, 0);
INSERT INTO psycotics_phpbb_auth_access VALUES (2, 21, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO psycotics_phpbb_auth_access VALUES (8, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO psycotics_phpbb_auth_access VALUES (8, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO psycotics_phpbb_auth_access VALUES (8, 11, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO psycotics_phpbb_auth_access VALUES (8, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO psycotics_phpbb_auth_access VALUES (8, 12, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO psycotics_phpbb_auth_access VALUES (8, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO psycotics_phpbb_auth_access VALUES (8, 13, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO psycotics_phpbb_auth_access VALUES (8, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO psycotics_phpbb_auth_access VALUES (8, 14, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO psycotics_phpbb_auth_access VALUES (8, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO psycotics_phpbb_auth_access VALUES (8, 15, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO psycotics_phpbb_auth_access VALUES (8, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO psycotics_phpbb_auth_access VALUES (8, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO psycotics_phpbb_auth_access VALUES (8, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO psycotics_phpbb_auth_access VALUES (8, 9, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO psycotics_phpbb_auth_access VALUES (8, 16, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO psycotics_phpbb_auth_access VALUES (2, 22, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO psycotics_phpbb_auth_access VALUES (2, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO psycotics_phpbb_auth_access VALUES (2, 16, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO psycotics_phpbb_auth_access VALUES (2, 9, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
