sending and taking a database

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

sending and taking a database

Postby dotKer » 06. January 2021 02:45

I have two xampps.
The one is at D:/xampp201126.
The other is at D:/xampp210105.

I can get "downloads/myTest.sql" by the following process.
(1) After I activate phpmyadmin by clicking the control panel of D:/xampp201126, I open phpmyadmin.
(2) I click a database named "myDB".
(3) I click the "sending" button.
("sending" is translation of my mother tongue to English, it means, I guess, a kind of "dump" or "export")
(4) I click the "execution" button.
(5) Then, I can find a new file named "myDB.sql" in downloads directory.

And I try to do the following process.
(1) After I get the file "downloads/myDB.sql",
I activate phpmyadmin by clicking the control panel of D:/xampp210105.
(2) I open phpmyadmin.
(3) I click the "taking" button.
("taking" means, I guess, a kind of "import")
(4) I select "file selection" button.
(5) I choose the file "downloads/myDB.sql".
(6) I click the "execution" button.

As I click the "execution" button, it says like the following.(the following is all translation from my mother tongue)
"taking" is successfully finished. 48 query is executed. (myDB.sql)

ERROR
...
MySQL MESSAGE
#1046 - There is no selected database.


After the process above, I see no "myDB" is there.
What's wrong in your think?
Can I get "myDB" for D:/xampp210105 by your help?
dotKer
 
Posts: 40
Joined: 09. November 2020 13:28
XAMPP version: 7.4.11
Operating System: windows

Re: sending and taking a database

Postby Altrea » 06. January 2021 02:48

A default phpmyadmin export does not contain a statement to create the database itself.
So you need to create a new database first, select it and inside that database use the import.
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: 11935
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 140 guests