[snip] How can i import table structure and data which is there in a text file to database say test_database using phpmyadmin. I m asking using phpMyadmin as i don have shell access and hence can't use mysql commands. [/snip]
What format is the table structure in? As for the data it should be fairly straighht forward. Even as text it should be delimited (either by comma, tab, or other similar delimeter). Once the tables are created you can import in phpmyadmin by viewing the table properties page and clicking the 'Insert data from a textfile into table' link and following the directions. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]