I have 40MB sql, i cant import it using phpmyadmin. I try to use BigDump, but I encounter error, that bigdump stop at line 1 and it says "Congratulations: End of file reached, assuming OK" please help me. thanks skywalkerph
Looks like to me, the big dump utility worked just fine.. That is not really an error. That is what it looks like when it is done importing the database. And when it says "Congratulations: End of file reached, assuming OK" that means all went well.. How or why do you think there is an error? Now you would just need to hook your script to that database, as the data should be in there. You can look at the tables in phpmyadmin and see the entries. Boulder
That doesn't mean the SQL import didn't work! Do you have PHP errors outputting to a LOG file somewhere? Check that. Have you checked the SQL settings on you're website? Make a simple file that doesn't connect to you're database, a HTML file and access that. Then try a php file (with no connection to the database). Finally make a phpfile with the connection settings, but no actual query etc. etc.
don't use phpmyadmin for that stuff. try to use a GUI like: http://www.navicat.com/detail.html with this one, you can import very large dumps. i use phpmyadmin for small db manipulations only.
I second navicat. If you administer a lot of databases it is indispensable. I can honestly say that we've saved hundreds if not thousands of hours over the years using this software. It has easily paid for itself a hundred times over.
The best way to import a large SQL is through CLI. Do you have SSH access at your host? If not you can always ask your host to import it for you, they should be able to help out!
I used BigDump for importing MySQL files of 100 to 200MB. Looking at the screenshot, it seems that BigDump imported the DB just fine. See the size of the DB. If it has just imported one line, it will show the DB size in KBs.