adding 23mb data into tables

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts
  • PipSqueak
    Sergeant

    • Aug 2005
    • 23

    adding 23mb data into tables

    Hi

    I uploaded a 23mb file (with sql commands) onto my server then I tried running the text file through phpmyadmin's and it only added 1098 entries out of 11000 entries. Is there any solution to add all my entries in one go?

    Thanks
    Wei-Ni
  • VodaHost
    General & Forum Administrator

    • Mar 2005
    • 12356

    #2
    Re: adding 23mb data into tables

    Try breaking it down into smaller chunks.

    VodaHost

    Your Website People!
    1-302-283-3777 North America / International
    02036089024 / United Kingdom
    291916438 / Australia

    ------------------------

    Top 3 Best Sellers

    Web Hosting - Unlimited disk space & bandwidth.

    Reseller Hosting - Start your own web hosting business.

    Search Engine & Directory Submission - 300 directories + (Google,Yahoo,Bing)


    Comment

    • PipSqueak
      Sergeant

      • Aug 2005
      • 23

      #3
      Re: adding 23mb data into tables

      Bigdump worked well....
      I knew about this from the thread: http://www.vodahost.com/vodatalk/mys...-database.html

      Comment

      • VodaHost
        General & Forum Administrator

        • Mar 2005
        • 12356

        #4
        Re: adding 23mb data into tables

        Excellent!!!

        VodaHost

        Your Website People!
        1-302-283-3777 North America / International
        02036089024 / United Kingdom
        291916438 / Australia

        ------------------------

        Top 3 Best Sellers

        Web Hosting - Unlimited disk space & bandwidth.

        Reseller Hosting - Start your own web hosting business.

        Search Engine & Directory Submission - 300 directories + (Google,Yahoo,Bing)


        Comment

        Working...
        X