SQL File Migration to XAMPP

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

SQL File Migration to XAMPP

Postby jetkoh » 22. February 2008 20:53

Hello, I am very new to MySQL and currently I am trying to run a database using XAMPP. I was given a PHP file and a SQL (.sql) file, I have configured the PHP but I am sure how to import this SQL file to XAMPP's MySQL.

Please help, thanks.
jetkoh
 
Posts: 3
Joined: 22. February 2008 20:46

Postby jetkoh » 22. February 2008 21:06

Sorry I forget to mention that the .sql file is 200mb large.
jetkoh
 
Posts: 3
Joined: 22. February 2008 20:46

Postby Wiedmann » 22. February 2008 21:33

but I am sure how to import this SQL file to XAMPP's MySQL.

http://dev.mysql.com/doc/refman/5.0/en/ ... mands.html
Wiedmann
AF Moderator
 
Posts: 17102
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby jetkoh » 22. February 2008 21:37

After much research on the internet, I found this php script that is very useful to import big SQL file. The script done the job for me in a instant and all I did was just to do some simple MySQL configuration to the php script.

BigDump: Staggered MySQL Dump Importer
http://www.ozerov.de/bigdump.php

I have imported my large SQL file and everything ok now.
jetkoh
 
Posts: 3
Joined: 22. February 2008 20:46


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 15 guests