|< 1 2 >| | 11 Einträge, 2 Seiten |
1
2
3
4
5
6
7
8
9
10
11
DROP TABLE IF EXISTS `pb_attachment`;
CREATE TABLE `pb_attachment` (
`serverfilename` varchar(40) NOT NULL default '',
`contenttype` varchar(20) NOT NULL default '',
`threadid` bigint(20) NOT NULL default '0',
`position` bigint(20) NOT NULL default '0',
`userid` bigint(20) NOT NULL default '0',
`filename` varchar(64) NOT NULL default '',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`serverfilename`)
) TYPE=MyISAM COMMENT='fuer Uploads';
mysql datenbank < backupfile.sql
1
2
3
4
5
my $dbh = DBI->connect("DBI:mysql:database=".$config{'db_name'}.";host=".$config{'db_host'},$config{'db_user'},$config{'db_passwd'}) or die("Cannot open database connection: $DBI::errstr");
my $statement="$config{'db_name'} < $textdatei";
print $statement."<br>";
$dbh->do($statement) or die("Kann ($statement) nicht ausführen: $DBI::errstr");
$dbh->disconnect;
system("mysql -D$config{'db_name'} -h$config{'db_host'} -u$config{'db_user'} -p$config{'db_passwd'} < $textdatei");
system("mysql -D$config{'db_name'} -h$config{'db_host'} -u$config{'db_user'} -p$config{'db_passwd'} < $textdatei");
|< 1 2 >| | 11 Einträge, 2 Seiten |