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.
C:\xampp\mysql\bin>mysql -u root -D name -o < sql.sql
Altrea wrote:Does the database phpbb3 exist?
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
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
Users browsing this forum: No registered users and 165 guests