install an older version of mysql

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

install an older version of mysql

Postby chihwahli » 26. May 2010 13:56

My website hoster is using a older version of mysql, version 5.051a.
I am having trouble importing the database that is exported from my website that , into my local xamp version 1.7.3 which has mysql version 5.1.x

I am getting the error:
SQL-query:

-- -- Database: `deb2345a_test` -- -- -------------------------------------------------------- -- -- Tabelstructuur voor tabel `banner` -- CREATE TABLE IF NOT EXISTS `banner` ( `bid` int(11) NOT NULL auto_increment, `cid` int(11) NOT NULL default '0', `type` varchar(30) NOT NULL default 'banner', `name` varchar(255) NOT NULL default '', `alias` varchar(255) NOT NULL default '', `imptotal` int(11) NOT NULL default '0', `impmade` int(11) NOT NULL default '0', `clicks` int(11) NOT NULL default '0', `imageurl` varchar(100) NOT NULL default '', `clickurl` varchar(200) NOT NULL default '', `date` datetime default NULL, `showBanner` tinyint(1) NOT NULL default '0', `checked_out` tinyint(1) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `editor` varchar(50) default NULL, `custombannercode` text, `catid` int(10) unsigned NOT NULL default '0', `description` text NOT NULL, `sticky` tinyint(1) unsigned NOT NULL d[...]

MySQL retourneerde: Documentatie
#1046 - No database selected

I am 100% sure I selected the exported sql file from my webserver. I tried installing mysql 5.0.51a into the xamp mysql directory, but that doesn't work....
I am a sql beginner.
Really could need some help... thanks :!:
chihwahli
 
Posts: 6
Joined: 23. May 2010 12:28

Re: install an older version of mysql

Postby Altrea » 26. May 2010 14:07

chihwahli wrote:#1046 - No database selected

In most cases, there is one big difference between a webspace-hoster phpmyadmin and a local one:
Your hoster automatically opens your (default) Database if you open phpmyadmin. locally you have all rights, like add unlimited databases.
So, if you want to import a dump, you must select a database in your local phpmyadmin first. Otherwise mysql don't know, where to put your data.
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 112 guests