Hi,

Is Phpmyadmin the only way to work with Database ?

If you can connect directly to the Database it would be much easier.

If you re using phpmyadmin its default is using myisam engine that use data lower than 2 gb, if you want to use it for more than 2 gb you just have to change the engine to innodb.

You need to identify also what is the source of dbms in th file is it mysql or oracle or sql because each one have its differentiation such as store procedure or tsql syntaks.

If its mysql with such big file maybe you can try sqlyog for importing the file.

@Marco I connected directly. But it executes for long time and says not enough memory in disk

@Dony when i tried with sqlyog and import the .sql file.. Run time error.. The application requested run time in an unusual way it would terminate..

Could you show us 5 first lines script on the .sql file?

You will find your solution here :

http://planet.mysql.com/entry/?id=19548

Indeed, you can increase the memory and Timeout

--

-- Create schema metadataindex

--

CREATE DATABASE IF NOT EXISTS metadataindex;

USE metadataindex;

--

-- Definition of table `metadataindex`.`indexkmiweb07eculturedirectclasses`

--

DROP TABLE IF EXISTS `metadataindex`.`indexkmiweb07eculturedirectclasses`;

CREATE TABLE `metadataindex`.`indexkmiweb07eculturedirectclasses` (

`id` int(11) NOT NULL auto_increment,

`ontologyId` bigint(20) default NULL,

`entityURI` char(255) default NULL,

`classURI` char(255) default NULL,

`classLabel` char(255) default NULL,

PRIMARY KEY (`id`),

KEY `entity_index` (`ontologyId`,`entityURI`)

) ENGINE=MyISAM AUTO_INCREMENT=71254 DEFAULT CHARSET=latin1;

--

-- Dumping data for table `metadataindex`.`indexkmiweb07eculturedirectclasses`

--

/*!40000 ALTER TABLE `indexkmiweb07eculturedirectclasses` DISABLE KEYS */;

LOCK TABLES `indexkmiweb07eculturedirectclasses` WRITE;

INSERT INTO `metadataindex`.`indexkmiweb07eculturedirectclasses` VALUES (1,3051643030,'http://www.chip-project.org/Rijksmuseum#artefactSK-C-6','http://www.vraweb.org/vracore/vracore3#Work','????? ?????????'),

(2,3051643030,'http://www.chip-project.org/Rijksmuseum#artefactSK-C-6','http://www.vraweb.org/vracore/vracore3#Work','???????????? ?????????'),

@Samir

I followed the instructions given in the link. I get this error..

Starting to parse config file...

Parse error: parse error in C:\wamp\apps\phpmyadmin3.1.3.1\config.inc.php on line 16

there are two kinds of way you can use.

First way:

find file php.ini, change memory_limit=128M into the filesize you have 2G and save it.

usually phpmyadmin limit memory for script file.

Second way:

*.Open config.inc.php file and set/add this line. $cfg['UploadDir'] = ‘upload’;

*. create upload folder inside your phpmyadmin folder and put your .sql file in upload folder.

*. open phpmyadmin in browser, go to import. You can see the file in dropdown just below browse button,Select it and Go.

or you can use BigDump script from http://www.ozerov.de/bigdump/

Change Memory Limit to 2GB in php.ini file.

In SQL Server you can use cqlcmd utility.

You should connect using SSH to source directly your huge file into MySQL

> ssh 

> mysql -u -p

> source yourfile.sql

XAMPP package is good choice also.

Pardon, answered in wrong question :)