import a large mysql database using php

Question

im having a mysql database which around 300mb but unfortunately i cant import this file to my web host using phpmyadmin and i dont have shell access.

i tried the below alternatives

MySQLDumper

bigdump

but could get it inserted to the database.

The database has been uploaded to a folder in .sql format. is it possible to create a php script to read the .sql file and execute the queries?

the sql file was dumped using mysqldump.

below is the format. (please not that i have removed some lines coz there are so many)

DROP TABLE IF EXISTS `prime_lands`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hotels` (
  `hotel_id` int(11) DEFAULT NULL,
  `chain_id` int(11) DEFAULT NULL,
  `chain_name` varchar(100) DEFAULT NULL,
  `brand_id` int(11) DEFAULT NULL,
  `brand_name` varchar(100) DEFAULT NULL,
  `hotel_name` varchar(100) DEFAULT NULL,
  `hotel_formerly_name` varchar(100) DEFAULT NULL,
  `hotel_translated_name` varchar(100) DEFAULT NULL
...........
)

-- Dumping data for table `prime_lands`
--

LOCK TABLES `prime_lands` WRITE;
/*!40000 ALTER TABLE `prime_lands` DISABLE KEYS */;

INSERT INTO `prime_lands` VALUES (1,421,'Samed Resorts Group',921,'Samed Resorts Group','Sai Kaew Beach Resort','','Sai Kaew Beach Resort',.......................)

....................................

Most likely, can you provide a simple of the format of the sql file? Was it created with mysqldump? Is it just a file of queries? — Paronity
– Paronity, Commented Dec 5, 2012 at 19:06

score 2 · Accepted Answer · 2012-12-05 19:26:04Z

2

should work:

$run=   exec ('mysql -u username -p password database_name < filename.sql ', $out);
var_dump($run);
var_dump($out);

May be better for debugging:

$out = shell_exec('mysql -u username -p password database_name < filename.sql');
var_dump($out);

as a one off you may be able to ask your host to run the command for you, most 'nice' hosts would help you out with this.

edited Dec 5, 2012 at 19:26

answered Dec 5, 2012 at 19:08

user557846

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

3 Comments

LiveEn Over a year ago

i tried that but didnt work. i contacted my hosting godaddy bt they keep on sending a guide on how to import using phpmyadmin, which doesnt work for me.

user557846 Over a year ago

what error did you get back? go-daddy is the worst host on the planet- so easy answer - move.

LiveEn Over a year ago

@Dragon when i run the first code i get this note "default-auth (No default value)"

Collectives™ on Stack Overflow

import a large mysql database using php

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related