Importing a pre-existing database
Posted by: Laura (---.hsd1.wa.comcast.net)
Date: June 30, 2012 02:14AM

I'm trying to import a pre-existing database into a database (that I named) in phpMyAdmin. Instead of loading into the database I've chosen, phpMyAdmin keeps creating a new database(named physical_goods), entirely separate from the database I've chosen.

Is there some way to load the tables in the sql file without phpMyAdmin creating a whole new database (with the wrong name)?

Thanks!

Options: ReplyQuote
Re: Importing a pre-existing database
Posted by: Laura (---.hsd1.wa.comcast.net)
Date: June 30, 2012 03:05AM

Never mind! The original SQL file had the following commands (which I corrected):

-- Create schema physical_goods
--

CREATE DATABASE IF NOT EXISTS physical_goods;
USE physical_goods;

Options: ReplyQuote


Sorry, only registered users may post in this forum.