DanielA Posted November 30, 2005 Report Share Posted November 30, 2005 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? Quote Link to comment Share on other sites More sharing options...
olajideolaolorun Posted November 30, 2005 Report Share Posted November 30, 2005 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. Quote Best Regards Olajide Olaolorun The Uniform Server Development Team Link to comment Share on other sites More sharing options...
DanielA Posted November 30, 2005 Author Report Share Posted November 30, 2005 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.. Quote Link to comment Share on other sites More sharing options...
olajideolaolorun Posted November 30, 2005 Report Share Posted November 30, 2005 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. Quote Best Regards Olajide Olaolorun The Uniform Server Development Team Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.