mariavargas Posted August 22, 2006 Share Posted August 22, 2006 Hi, So far so good, love osCommerce - Great Job all of you! Need some help importing a table back into the database. I had no problem exporting each table as backup. Now, the issue is - how do I get them back in???? Wish there was an Import button just like the Export button. Anyway, I just need to know how to go about importing each one of my tables into the original database. Do I do it in myAdmin? Do I need a snippet of code? It should be straight forward since I exported it in an SQL format. Thanks! Maria Vargas Link to comment Share on other sites More sharing options...
kgt Posted August 22, 2006 Share Posted August 22, 2006 If you're using phpMyAdmin, you only need to select your database and go to the SQL tab. You can upload files or copy and paste the SQL from the file into the text area. Click Go. Contributions Discount Coupon Codes Donations Link to comment Share on other sites More sharing options...
mariavargas Posted August 23, 2006 Author Share Posted August 23, 2006 Hi KGT! Thanks... Just a bit more clarity for :'( me... Yes, it is phpMyAdmin and I selected the database, and then SQL and got a list of the tables, I selecte the table now I'm at a loss as to the "text area"? :blush: I have ACTIONS... I have: CREATE NEW TABLE ON DATABASE NAME, NO. OF FIELDS, GO Not clear as to do it.... BUT i'm almost there! :P This is so important, otherwise I could never re-instate the database should something go wrong... Thanks again, KGT :lol: Maria Vargas If you're using phpMyAdmin, you only need to select your database and go to the SQL tab. You can upload files or copy and paste the SQL from the file into the text area. Click Go. Link to comment Share on other sites More sharing options...
kgt Posted August 23, 2006 Share Posted August 23, 2006 You need to click the SQL tab at the top of the screen. It's up there with Stucture, Export, Search, etc. Contributions Discount Coupon Codes Donations Link to comment Share on other sites More sharing options...
mariavargas Posted August 23, 2006 Author Share Posted August 23, 2006 HI KG, Again, thanks for your assistance and patience. Yes, I clicked SQL at the top... Then what? Once I clicked SQL, my choice are: >ACTIONS >CREATE NEW TABLE ON DATABASE >NAME >NO. OF FIELDS >GO What is the next step on this page? :blink: MV You need to click the SQL tab at the top of the screen. It's up there with Stucture, Export, Search, etc. Link to comment Share on other sites More sharing options...
kgt Posted August 23, 2006 Share Posted August 23, 2006 Did you select your database from the dropdown first? You must choose which database you want to run the statements on. Contributions Discount Coupon Codes Donations Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.