Mysql database import problem

[deisel79]

I have an educational program that stores its information in a "flavor" of mysql. Unfortunately our tech support has run out and i need access to this database directly because it has crashed.

This software supplies a backup feature that stores a .sql file on the drive. This file is over 600 megs. I am trying to import the file over to an apache/php/mysql server or if possible a SQL Server 2005 server. I am not having any luck with either of them. On the apache i have edited the php.ini and the mysql.ini to allow for such a large file but still have not had any success?

I haven't tried much yet with importing it to SQL 2005, I am not even sure that can be done?

If anyone has any advice it would be much appreciated. I have a little bit of experience with mysql but it has all been small databases under 30meg or so. This is not really my area of expertise so im sorry if this is a noob question.

[kennethl]

Hi,

I would suggest you to try this tool for database import - Navicat for MySQL. There's a feature called Execute Batch File. You can locate your SQL file and import the data into database.

It includes Data Transfer and Import Export features. You can also set a schedule to automate the process.

URL - (http://mysql.navicat.com/download.html)

There's a free lite version too.

good luck,

Kenneth