[gulfan]

I’m having some problems moving a mysql database from one server to another. I’ve managed to export the database and ftp it to the server. I don’t have SSH access on the server so I’m unable to do a normal import like this:

mysql -uUSERNAME -p newdbname < /path/to/dump.sql

So I’m trying to do it using a php script but I’m not having much luck with it.

PHP Code:

<?php



$dbh = mysql_connect('localhost', 'viforum_viforum', 'PASSWORD') or die(mysql_error() . " :: mysql_connect error");

$sdb = mysql_select_db('viforum_viforum', $dbh);



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



?>

The script is in the same directory as forumbackup-01-22-2004.sql and when executed it doesn’t return any errors. I’m not sure what I’m doing wrong, or if what I want to accomplish is even possible.

[blaw]

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.