New 7.4 Install - problem importing database

Problems with the Windows version of XAMPP, questions, comments, and anything related.

New 7.4 Install - problem importing database

Postby Hawkeye2 » 14. February 2021 05:01

Currently attempting to upgrade to a new version of xampp. Old localhost/xampp was running Mariadb 10.1. No problem exporting the database using phpmyadmin however when I attempt to import the DB into 7.4 which has Mariadb 10.4 it produces the following error. Any positive advice would be appreciated.... Rod D

---- Database: ‘xxxxxxxxxxxxxx’------ Table structure for table `q3hqz_action_logs`--CREATE TABLE `q3hqz_action_logs` ( `id` int(10) UNSIGNED NOT NULL, `message_language_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `message` text COLLATE utf8mb4_unicode_ci NOT NULL, `log_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `extension` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `user_id` int(11) NOT NULL DEFAULT '0', `item_id` int(11) NOT NULL DEFAULT '0', `ip_address` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0.0.0.0') ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
Hawkeye2
 
Posts: 6
Joined: 23. March 2015 12:16
Operating System: win7

Re: New 7.4 Install - problem importing database

Postby Hawkeye2 » 14. February 2021 10:01

Forgot to add this portion.... MySQL said #1046 – no database selected! RD
Hawkeye2
 
Posts: 6
Joined: 23. March 2015 12:16
Operating System: win7

Re: New 7.4 Install - problem importing database

Postby Altrea » 14. February 2021 11:03

Hawkeye2 wrote:Forgot to add this portion.... MySQL said #1046 – no database selected! RD

That is the most important inormation.

Your database dump does not contain any create database statement. Thats okay, that is the most common type of dump.
In order to import this dump you need to create the database first by yourself and select it.
Inside the selected database you can switch to the import tab and choose your dump.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11933
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: New 7.4 Install - problem importing database

Postby Hawkeye2 » 14. February 2021 16:14

Thanks much for the advice. Just arrived at the same conclusion at 150105K. Definitely not enough time spent on general product knowledge is the only explanation I can offer he said!!
Stay safe....cheers Rod D
Hawkeye2
 
Posts: 6
Joined: 23. March 2015 12:16
Operating System: win7


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 231 guests