Backing up Wordpress and Databases

[LordCuttlefish]

Hi,
I'm running a wordpress installation which I use for writing on Xampp and I want to back it up.
I've been going to PHPMyAdmin and downloading the "WordpressName" Database and copying the files in htdocs to my cloud service.
I've always been a bit worried this wouldn't work so I tested it on another PC yesterday and I was unable to import the database.
Does anyone know what I'm doing wrong? Any help would be appreciated.

[Altrea]

Hi,

and I was unable to import the database.

What does this mean exactly?
You need to be much more detailed in your explanation.
What error message do you get for example?

Best wishes,
Altrea

[LordCuttlefish]

Sorry about that.
Here is the error I get.

Error
SQL query:


--
-- Database: `storywiki`
--

-- --------------------------------------------------------

--
-- Table structure for table `wp_commentmeta`
--

CREATE TABLE `wp_commentmeta` (
`meta_id` bigint(20) UNSIGNED NOT NULL,
`comment_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
`meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`meta_value` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

MySQL said: Documentation

#1046 - No database selected

[Altrea]

You need to create a database first and import the dump in context of this database.

[LordCuttlefish]

That does it! Awesome!
Thank you!