View Single Post
  #2 (permalink)  
Old 01-23-04, 04:44 PM
blaw's Avatar
blaw blaw is offline
Junior Code Guru
 
Join Date: Dec 2003
Location: Vancouver, BC, Canada
Posts: 550
Thanks: 0
Thanked 0 Times in 0 Posts
Hi there,

You may get some errors that may ring the bell by rewriting the last line as follows:

PHP Code:

$res mysql_query(file_get_contents('forumbackup-01-22-2004.sql'));

if (!
$res) {
      echo 
'Query Failed (ErrNo: '.mysql_errno().') '.mysql_error()';

Also, if you are trying to excute INSERT statements, there is a LOAD FILE statements in MySQL that suck up your CSV files, rather than INSERT statements, which they claim is faster.

If this doesn't help, then if you could share a couple of lines from forumbackup-01-22-2004.sql (assuming those are INSERT) and corresponding table definitions, it may be faster.

Good luck.
__________________
Blavv =|
Reply With Quote