FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


LARGE MYSQL FILE : Need HELP





k_s_baskar
Hi all,
I am having a SQL file with 30MB Size. i can't able to execute this file from phpmyAdmin using upload command in my server (even i can't able to open the file in notepad bcoz of its size). Can anyhbody guide to handle this problem?
Thanks in advance.
Smile
kv
If it is a text file, there is a solution. Just gzip the file and upload it. phpmyadmin recognizes gzipped files.
rvec
http://www.frihost.com/forums/vt-72043.html

Use the bigdump thing suggested by Bondings.
k_s_baskar
rvec wrote:
http://www.frihost.com/forums/vt-72043.html

Use the bigdump thing suggested by Bondings.


Oh thanks a lot i will try BIGDUMP recommended by admin at
http://www.ozerov.de/bigdump.php
thankyou again
Smile
AOP Web Development
I got the same problem here, but since the reply of using the thrid party from the other site solves it.. anyway thanks for the great help, very useful.
Aidmar
Well, i've got the same problem, but the file size was VERY smaller... In PhpMyAdmin, i opened the sql query window, copy a huge block of lines of the sql file, and paste in the query window. I made this and executed many times, until the complete sql file was executed. Its not the faster way, but works...hehehe.

Forgive my Bad, Bad english...
Related topics
SQL Server 2000 and MYSQL, pls help me.
mysql/php help please
phpBB Error, seems to be a MYSQL DB error...
Question about film binding
Shout Boxes, NO MySQL PLEASE
Error connecting to mysql ; please help
MySQL Database questions
PHP Read File Help needed.
Needing help.
would you like play counter-strike with superhero mod?
How can I log in to MySQL? Please help!
PHP and Mysql Project. Help
PHP and MySQL login...Help
mysql file size increase
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.