Jump to content
The Uniform Server Community

Can not import Table data


DanielA
 Share

Recommended Posts

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?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...