dumb_question Posted December 14, 2003 Share Posted December 14, 2003 Is there a simple way of creating a table for mysql database? I have no knowledge of mysql Thank you for your help Link to comment Share on other sites More sharing options...
Guest Posted December 14, 2003 Share Posted December 14, 2003 depends upon if you have shell access and rights to create sql databases. some hosts do not allow you to create your own database. if you do, then you can logon to your server via SSH, shell> mysqladmin [OPTIONS] command [command-option] command ... http://www.mysql.com/doc/en/mysqladmin.html cut and paste that into your browser Link to comment Share on other sites More sharing options...
dumb_question Posted December 14, 2003 Author Share Posted December 14, 2003 Thanks John my host has phpmyadmin in capnel...how can i add a table using phpmadmnin Link to comment Share on other sites More sharing options...
Guest Posted December 14, 2003 Share Posted December 14, 2003 In phpMyAdmin (after connecting): 1. Select your database (sometimes done for you automatically). 2. In the right hand side, you should have a list of tables in your database. Scroll to the bottom of the page. There you should find two input boxes for creating a table. One is the table name; the other is the number of fields. Click Go after entering the correct values. 3. A new page should come up, asking you for field names, types, lengths, defaults, etc. Fill in the data and click on the Save button when finished. Hth, Matt Link to comment Share on other sites More sharing options...
dumb_question Posted December 14, 2003 Author Share Posted December 14, 2003 thanks matt..that was very helpful. I, however, got this error after creating the table, when trying to access admin ( i cant access admin at all now) "1146 - Table 'database name .TABLE_ADMIN_FILES' doesn't exist select admin_files_id from TABLE_ADMIN_FILES where FIND_IN_SET( '', admin_groups_id) and admin_files_is_boxes = '1' and admin_files_name = 'configuration.php' [TEP STOP] What did I mess up with ?...Please help Link to comment Share on other sites More sharing options...
dumb_question Posted December 14, 2003 Author Share Posted December 14, 2003 I actually installed information unlimited mod and created table for it....thought this information might be helpful Link to comment Share on other sites More sharing options...
Guest Posted December 14, 2003 Share Posted December 14, 2003 It looks like it is missing a define (for TABLE_ADMIN_FILES) from either admin/includes/database_tables.php (MS2) or admin/includes/application_top.php (MS1 and earlier). Hth, Matt Link to comment Share on other sites More sharing options...
dumb_question Posted December 15, 2003 Author Share Posted December 15, 2003 thanks matt...i fixed it Link to comment Share on other sites More sharing options...
yogidegr8 Posted December 15, 2003 Share Posted December 15, 2003 Thanks for the information.... It was very usefull. I have one question relating, is there any way we can do bulk product upload from phpMyAdmin??? I am looking for a way to upload many products at one time without using Easy populate.. Link to comment Share on other sites More sharing options...
Guest Posted December 16, 2003 Share Posted December 16, 2003 If you format the products, descriptions, and category relations in CSV (comma-separated value format) files, then you should be able to import with phpMyAdmin. Backup first; issues may arise. Note: this is essentially what Easy Populate does for you. Hth, Matt 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.