Jump to content


Photo

Can not import Table data


  • Please log in to reply
3 replies to this topic

#1 DanielA

DanielA

    Newbie

  • Member
  • Pip
  • 6 posts

Posted 30 November 2005 - 11:08 AM

I tried to use phpMyAdmin to import a database I have exported.
It is in the form of SQL. The table and fields setup ok, but no data was entered so I pasted only the insert into lines from the text file into the SQL window. Only the first instruction runs.

How can I get all this data impoted without cutting and pasting every single insert command into the SQL window one at a time?

#2 olajideolaolorun

olajideolaolorun

    Project Manager

  • Admin
  • PipPipPipPipPip
  • 2,347 posts
  • Gender:Male
  • Location:Atlanta, GA
  • SourceForge IDempirex
  • Wiki ID: olajideolaolorun
  • IRC Nickname: Olajide
  • Main OS: Windows 10

Posted 30 November 2005 - 12:03 PM

hmm, try exporting the database as a .gz file and then import it as that.

It should work. By the way, make sure the export corresponds with the MySQL version of the Uniform Server so it does nto cause problems. You can chose which version in phpMyAdmin when exporting.

#3 DanielA

DanielA

    Newbie

  • Member
  • Pip
  • 6 posts

Posted 30 November 2005 - 02:38 PM

I did export it as sql, but pasting that whole thing into the sql windows doesn not regenerate the data base and table entries. Same thing on file..

#4 olajideolaolorun

olajideolaolorun

    Project Manager

  • Admin
  • PipPipPipPipPip
  • 2,347 posts
  • Gender:Male
  • Location:Atlanta, GA
  • SourceForge IDempirex
  • Wiki ID: olajideolaolorun
  • IRC Nickname: Olajide
  • Main OS: Windows 10

Posted 30 November 2005 - 04:44 PM

hmm, and it does not give you an error? or say something is wrong?

It should....

Try downloading a new copy of the whole server and testing it on the new download/installation.

Thanks.




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users