Importing a Craft database error

Question

I dumped from Craft my database from server A and am trying to install it to a fresh copy of Craft on server B.

I've got Craft up and running, and when I try importing my Craft SQL file in PHPmyAdmin, I get an error every time:

craft error

Is there something I need to setup in Craft regarding asset files before my import will work?

carlcs · Accepted Answer · 2018-02-09 16:54:23Z

2

MySQL exports only include the tables, not the database settings. You need to create a database first, open it and then import the tables.

answered Feb 9, 2018 at 16:54

carlcs

36.2k5 gold badges62 silver badges139 bronze badges

I created a database on my new server, and then went to import the sql file into it, and still got this error.
– kingkelly
Feb 10, 2018 at 3:12
The error says no db selected though.
– carlcs
Feb 10, 2018 at 9:32

Add a comment |

Ryan · Accepted Answer · 2018-07-16 03:55:14Z

1

This caught me out too.

In PhpMyAdmin, click Databases tab, click the database you wish to import into, then Import tab.

answered Jul 16, 2018 at 3:55

Ryan

111 bronze badge

Add a comment |

2 Answers 2