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. Link to comment https://forums.phpfreaks.com/topic/43363-need-help-uploading-a-saved-mysql-server-file-please/ 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? Link to comment https://forums.phpfreaks.com/topic/43363-need-help-uploading-a-saved-mysql-server-file-please/#findComment-210611 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 Link to comment https://forums.phpfreaks.com/topic/43363-need-help-uploading-a-saved-mysql-server-file-please/#findComment-210665 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. Link to comment https://forums.phpfreaks.com/topic/43363-need-help-uploading-a-saved-mysql-server-file-please/#findComment-210671 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. Link to comment https://forums.phpfreaks.com/topic/43363-need-help-uploading-a-saved-mysql-server-file-please/#findComment-210963 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. ??? Link to comment https://forums.phpfreaks.com/topic/43363-need-help-uploading-a-saved-mysql-server-file-please/#findComment-213195 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.