Restore mysql database using php

Question

I'm trying to restore MySQL dump created the following way:

require_once 'mysql_restore.class.php';
$restore_obj = new MySQL_Restore();

$restore_obj->server = 'localhost';
$restore_obj->username = 'root';
$restore_obj->password = '';
$restore_obj->database = 'database';
if (!$restore_obj->Execute(MSR_FILE, 'bk.sql.gz', true, false))
{
  die($restore_obj->error);
}

but its showing an error

Warning: gzuncompress() [function.gzuncompress]: data error in C:\wamp\www\nidhin\mysql_restore.class.php on line 42 Warning: Invalid argument supplied for foreach() in C:\wamp\www\nidhin\mysql_restore.class.php on line 215

Any idea what I'm doing wrong?

I think as the error states there may be an mismatch of object type which is passed to the class.. Unless we have a glimpse of the mysql_restore.class.php we can find the bug.. Can you post what the line no 215 exactly contains? — Vijay
– Vijay, Commented Aug 4, 2011 at 5:36
Hi kvijayahari , its working now , its mistake in the function param order — NidhinRaj
– NidhinRaj, Commented Aug 4, 2011 at 6:09

yokoloko · Accepted Answer · 2011-08-04 05:52:17Z

1

function Execute($param, $mode = MSR_STRING, $is_compressed = false, $split_only = false)

You inverted the params order.

It's :

!$restore_obj->Execute('bk.sql.gz', MSR_FILE, true, false))

Instead of :

!$restore_obj->Execute(MSR_FILE, 'bk.sql.gz', true, false))

answered Aug 4, 2011 at 5:52

yokoloko

2,8603 gold badges23 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Restore mysql database using php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related