How can I go about importing a mysql database onto a server from my local machine? I have exported it into a .sql file, i.e "BS-DB.sql" but cannot find a way of importing it. There doesn't seem to be a MySQL data dir for me to ftp into. Do I have to creat the database then import the tables?
yes, create the database and the use the 'create table from file' option at the bottom of the page on the phpmyadmin control panel....
if you don't have pma, there usually is a a'load from file' option with the control panel you do have
Thanks for your quick response Bastien, that worked a treat.
