Re: MySQL help please

On 14 Aug, Matt McClanahan wrote: > On Mon, 14 Aug 2000, paul wrote: > >> Hey ! I don't have telnet access :-( >> can somebody help with connecting and/or importing sql info into a >> database? >> I am able to create a database thru a web front end, but can't import >> onfo like this >> mysql database -u <username> -p < sqlinfo.sql >> is there a way of doing it from FTP or web ? > > That depends largely on what sort of web front-end you're using. FTP > won't accomplish much if you don't have access to a command line. > > If the web front end is phpMyAdmin, or has similar functionality, it > should provide both a textarea for sending arbitrary SQL commands, and a > file upload form for uploading commands stored in a file (Such as those > generated by a dump) > > Matt And don't forget there is always the LOAD DATA INFILE syntax to load data into an established table; you can run this from a php script as a mysql query . But if you have a choice, install phpMyAdmin as Matt mentions. Cheers -- David Robley | WEBMASTER & Mail List Admin RESEARCH CENTRE FOR INJURY STUDIES | http://www.nisu.flinders.edu.au/ AusEinet | http://auseinet.flinders.edu.au/ Flinders University, ADELAIDE, SOUTH AUSTRALIA