Problems moving DB

[Cognatus]

Hi

I'm trying to move my page from one provider to another. Following this instruction (Method 1): https://docs.cmsmadesimple.org/moving.

I'm obviously doing something wrong when it comes to moving the DB, and I guess it has to do with the DB-user. The import breaks and I get the message that the DB-user is not allowed to use the DB.

I don't know how to fix this.

And besides that I have difficulties to interpret what this text in the guide requires from me?

"It's important that you leave out the option to "create database" if it is available, as it is unlikely that the destination database name will be he same as the source database name. However, you must ensure that the export file will "create tables"."

Regards

[velden]

Moving a database is a little out of scope of CMSMS, you may ask your provider for some help. However, usually it's rather easy to do so and it might be handy to know how it works.

Regarding the second part of your question - which may help you with the first part:

On most hostings you can't create a database using phpmyadmin. You should do it using the admin interface your provider offers you (e.g. Plesk, DirectAdmin, cPanel, etc). Then in phpmyadmin you select the database and import the tables there. The export should therefor not contain a 'create database' statement, the database should already be created and selected.