11Tami Posted March 19, 2007 Share Posted March 19, 2007 Hi, I am learning how to export and import mysql files. It will only import them if database is brand new. How do I upload an existing database? I tried using, all different options under “Export Type” .....insert, update, and replace, but none of them would update an existing database with the same name. Please let me know what I'm doing wrong? Thank you very much. Quote Link to comment Share on other sites More sharing options...
SammyGunnz Posted March 19, 2007 Share Posted March 19, 2007 When you're exporting, are you importing both structure and data? Quote Link to comment Share on other sites More sharing options...
11Tami Posted March 19, 2007 Author Share Posted March 19, 2007 Thank you, Yes this is how it looks. I'll put an asterick next to the ones that have checkmarks. *Structure Add DROP TABLE Add IF NOT EXISTS *Add AUTO_INCREMENT value *Enclose table and field names with backquotes Data *Complete inserts *Extended inserts Maximal length of created query Use delayed inserts Use ignore inserts *Use hexadecimal for binary fields Export type INSERT Quote Link to comment Share on other sites More sharing options...
bwochinski Posted March 19, 2007 Share Posted March 19, 2007 What is already in the database that you are trying to restore to? That is what will determine how the exported SQL should be structured. Quote Link to comment Share on other sites More sharing options...
11Tami Posted March 20, 2007 Author Share Posted March 20, 2007 Thank you. Just the usual database name, several tables and several things in the tables. Nothing special done with tables or the fields in the tables. On the fields in the tables I only adjust one column for "type." There most fields are marked as "text" one for "date" and a few for "varchar" so I can limit how many items are added to a few of the fields. "Type" is the only category for fields that I use. Quote Link to comment Share on other sites More sharing options...
11Tami Posted March 23, 2007 Author Share Posted March 23, 2007 I have a super easy database I am trying to upload to. Can't anyone help me please tell me how to upload an sql file to my database? Thank you very much. ??? Quote 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.