Stuart Bird wrote: > Mark > > I've got a bit further. > > There is a database called peterboro. > > The sql file wants to create a database called gpbroadband, which is > whats being denied as far as I can tell. > > How do I import just the tables from the sql file to the peterboro > database? I would suggest changing the .sql file. Any text editor will do.
Replace "CREATE DATABASE gpbroadband;" with "USE peterboro". This will force the SQL to change to the peterboro database,which exists and then create the tables there, rather than the SQL trying to create a new database which it seems is outside your realm of permissions. HTH, Mark -- .~. Mark Brier - Open Source Tech Consultant / v \ mark AT openitup DOT org / lists AT openitup DOT org /( _ )\ PubKey - http://www.openitup.org/keys/markatopenitup.asc ^ ^ +44 (0)161 2422132 / +44 (0)7793 036840 _______________________________________________ Peterboro mailing list [email protected] https://mailman.lug.org.uk/mailman/listinfo/peterboro
