unable to create a database

[drewzim1968]

hi community,

I was recently hacked into so decided on a fresh install of my website.
Ive uploaded all the files for nuke 7.9,however when i try and import the sql file through mysqladmin,it fails to do so.
I get the following message.Hope someone out there can help,it would be much apprieciated.


>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Invalid Identifer @ 182
STR: 4.01.
SQL: # phpMyAdmin MySQL-Dump
# version 2.3.1-rc1
# http://www.phpmyadmin.net/ (download page)
#
# servidor: localhost
# Tiempo de generaci󮺠08-05-2005 a las 20:26:29
# Versi󮠤el servidor: 4.01.10
# Versi󮠤e PHP: 5.0.3
# Base de datos : `nuke`
# --------------------------------------------------------

#
# Estructura de tabla para la tabla `nuke_authors`
#

CREATE TABLE nuke_authors (
aid varchar(25) NOT NULL default '',
name varchar(50) default NULL,
url varchar(255) NOT NULL default '',
email varchar(255) NOT NULL default '',
pwd varchar(40) default NULL,
counter int(11) NOT NULL default '0',
radminsuper tinyint(1) NOT NULL default '1',
admlanguage varchar(30) NOT NULL default '',
PRIMARY KEY (aid),
KEY aid (aid)
);



SQL query:

# phpMyAdmin MySQL-Dump # version 2.3.1-rc1 # http://www.phpmyadmin.net/ (download page) # # servidor: localhost # Tiempo de generaci󮺠08-05-2005 a las 20:26:29 # Versi󮠤el servidor: 4.01.10 # Versi󮠤e PHP: 5.0.3 # Base de datos : `nuke` # -------------------------------------------------------- # # Estructura de tabla para la tabla `nuke_authors` # CREATE TABLE nuke_authors ( aid varchar(25) NOT NULL default '', name varchar(50) default NULL, url varchar(255) NOT NULL default '', email varchar(255) NOT NULL default '', pwd varchar(40) default NULL, counter int(11) NOT NULL default '0', radminsuper tinyint(1) NOT NULL default '1', admlanguage varchar(30) NOT NULL default '', PRIMARY KEY (aid), KEY aid (aid) );

MySQL said:

#1046 - No database selected

[IanS]

You seem to have somehow selected a Spanish language version of the program. Is this intentional?

[drewzim1968]

thank you for the quick responce.
I was not aware that i had purchased a spanish version.
Ill see if i can get an english version and upload it.
Thank you once again

[drewzim1968]

HGi,ive now made a clean install of an english version of nuke 7.9 and have managed to upload the database.Unfortunately,im not having much luck accessing it as if you click on the link,you will see the message displayed.
Some help to addess this problem again would be very much apprieciated.
Thank you
http://www.goffal.com/nuke/admin.php