Restore Backup

**Tanzy** · 7th October 2006, 05:18 PM

OK finally got around to doing a bit of development. I have MySQL 5.0.24 installed on a local virtual machine. I have the sql file from a Redfox backup.

However, when I try to restore it to my local MySQL database I get all sorts of errors. Any help would be great. (I'm most likely restoring it wrong, I'm an MS SQL man not MySQL)

Ken

**Staff: Warren Ashcroft** · 7th October 2006, 05:33 PM

What sort of errors?

**Tanzy** · 7th October 2006, 05:58 PM

seems to be basic SQL errors Warren. I'm trying to put a copy of my VBulletin forums onto my development virtual machine so that I can then do some further development.

My main issue in some ways is that I'm not even sure where to start restoring a MySQL database, so any pointers would be great.

**Staff: Warren Ashcroft** · 7th October 2006, 09:41 PM

Just use MySQL Query Analyser (from mysql.com) to execute the script against any MySQL server.

**Tanzy** · 7th October 2006, 10:20 PM

Tried that Warren and got the errors. Just in the middle of rebuilding my new PC due to other issues. I will try again tomorrow and let you know how I get on. Also created a new backup to see if it was the file.

**Tanzy** · 8th October 2006, 04:34 PM

Seem to have it working now Warren, I reinstalled the MySQL tools on my virtual machine and it worked ???? Oh well at least it works now.

All I have to do now is work out why I'm getting a

'Fatal error: Call to undefined function mysqli_init'

may be because of a change I made to MySQL.. not sure