importing a 200mb file to phpmyadmin

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
fabby
Forum Commoner
Posts: 62
Joined: Tue Feb 15, 2005 1:06 am
Location: Romania
Contact:

importing a 200mb file to phpmyadmin

Post by fabby »

i tried to upload a database that have the size=200mb, but, it stay's to long, and don't update all the data!
Do you have another idea because it not import all
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Post by Christopher »

Try uploading the data file to the server and using "LOAD DATA INFILE".
(#10850)
fabby
Forum Commoner
Posts: 62
Joined: Tue Feb 15, 2005 1:06 am
Location: Romania
Contact:

Post by fabby »

i don't know what is about..can you tell me more?
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Post by John Cartwright »

you might be interested in http://www.ozerov.de/bigdump.php
Post Reply