Apache Friends Support Forum

I have an .sql file with all of my old databases. However, some of those databases conflict with current ones.

How do I import a single database out of this .sql file?

i.e., I DO want phpbb database. I DO NOT want wordpress database.

Thanks.

Try this: http://stackoverflow.com/questions/2342 ... bases-dump

Great, mate.

But, where do I type this? I don't know of an SQL command prompt in xampp.

That would be typed at the Windows command prompt (Start > Run > cmd). The mysql it is talking about is in /xampp/mysql/bin

Thanks, mate.

Not having much luck. Any ideas?
And, I did put sql.sql in the bin folder.

You should not split up the steps, it should all be done in one run or you are no longer giving it command line options. For example:

Code: Select all

C:\xampp\mysql\bin>mysql -u root -D name -o < sql.sql

That fixed this problem, mate. I'm sorry to bug you again, but now I have a new issue.

I placed the sql.sql file into all folders: xampp, mysql, and bin. Just to make sure it wasn't looking in the wrong place.

I get this error, now.

Does the database phpbb3 exist?

Yeah, I highlighted it in the above image.

Altrea wrote:Does the database phpbb3 exist?

Is this a data only dump or does it include the db/table structures and the data?

You could try something like this as well:

Code: Select all

C:\xampp\mysql\bin>mysql -u root
mysql> CREATE DATABASE phpbb3;
mysql> exit
C:\xampp\mysql\bin>mysql -u root -D phpbb3 -o < sql.sql

Thanks, buddy!

hackattack142 wrote:Is this a data only dump or does it include the db/table structures and the data?

You could try something like this as well:

Code: Select all

C:\xampp\mysql\bin>mysql -u root
mysql> CREATE DATABASE phpbb3;
mysql> exit
C:\xampp\mysql\bin>mysql -u root -D phpbb3 -o < sql.sql