Support Forums
08-28-2009, 05:37 AM
|
#1 |
|
Junior Member
Join Date: Jun 2009
Location: Oxford, UK
Posts: 18
Rep Power: 2  |
Using phpMyAdmin in cPanel
Dear experts
We need to add a few hundred new categories to the table class_categories in our sql DB yappydoc_clas. These new categories are duplicates of existing categories but with a different parent_id. I am using the phpMyAdmin app to view/change and I have exported one row to csv file and changed its id to the next one (incremented the last entry by one) and also changed the parent_id to reflect where the new row should appear. At the moment I am going to import one at a time from csv file to make sure that the categories display properly. Question, Will the imported row (in csv file) append to the existing rows or will it overwrite all existing rows with the imported one? If it appends, then using this import method will save a huge amount of time for us. Thanks Mark Holmes www.yappydo.com v4.1.3 developer Last edited by mark; 08-28-2009 at 07:39 AM. |
|
|
|
08-28-2009, 07:41 AM
|
#2 |
|
68 Evangelist & Developer
Join Date: Jan 2007
Location: Pennsylvania, USA
Posts: 1,693
Rep Power: 48 |
Using the built in "Import" function of phpMyAdmin will append the table.
__________________
Mike-N-Tosh IndianaPC.org - A community website (v3.1.10 Developer - heavily modified) Sandbox (v3.1.10, v4.0.9, 4.1.5) Visit My blog for tips, tricks, tutorials, reviews for 68 Classifieds as well as my store with Templates, Mods & Docs Web Hosting | Web Design & Development | 68 Classifieds Customizations I am not a 68C employee, just a user and try to help out |
|
|
|
|
08-28-2009, 07:51 AM
|
#3 |
|
Junior Member
Join Date: Jun 2009
Location: Oxford, UK
Posts: 18
Rep Power: 2 |
Mike-n-Tosh - Thanks for the quick reply. Not used the phpMyAdmin before and was a bit worried that the import would replace and not ammend.
Is it OK to include the ID for the imported rows or will this be done automatically? Mark |
|
|
|
|
08-28-2009, 09:12 AM
|
#4 |
|
68 Classifieds Staff
Join Date: Mar 2006
Location: Belmont, NC
Posts: 5,249
Rep Power: 122 |
I am not certain on that. I would try one as a test with out the id and see if it gets auto incremented.
__________________
Eric Barnes 68 Classifieds Developer Please do not send me a private message asking for support. Instead use these open forums or our ticket system. Customer Area | Issue Tracker | Documentation | 68C Mods | Submit a Ticket | 68 @ Twitter | My Modules |
|
|
|
|
08-28-2009, 10:08 AM
|
#5 |
|
Junior Member
Join Date: Jun 2009
Location: Oxford, UK
Posts: 18
Rep Power: 2 |
Tried it with an incremented ID and it worked.
Funny thing though, when browsing to the new category created on our site, the link went back to the original parent category (with ads in). In our admin panel the new subcat showed in the new parent category and when I opened the new sub category and submitted without any changes, our site displayed it correctly. Thanks again for the help Mark |
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| cant open template files in cpanel | fc2008 | v4.1 Questions & Support | 3 | 05-07-2009 11:55 AM |
