Print

[TheRealDragonboy]

TheRealDragonboy

Need Database Help

My friend Telltolin has exported an .sql database backup file of Virtual Security. But when I try to import that to Draxor.org, it won't work. I'm using the host www.hosting2go.nl where they use a kind of Cpanel named "Plesk". When I import the file, the following error comes up:

SQL query:

--
-- Database: `miridcom_yetanotherdraxor`
--
-- --------------------------------------------------------
--
-- Table structure for table `challenges`
--
CREATE TABLE `challenges` (
`username` varchar( 20 ) NOT NULL ,
`challenge` varchar( 30 ) NOT NULL
) ENGINE = MYISAM DEFAULT CHARSET = latin1

MySQL said: Documentation
#1046 - No database selected

I don't have that database (which I think is the problem) but I can't make a new database with that name because Plesk doesn't allow that name length.

Anyone got ideas what I can do to import it?

• 

[Cassyblanca]

Cassyblanca

Re: Need Database Help

What it means by 'no database selected' is that you're trying to execute that query on... well, nothing, really <_<

You need to select a database by executing a 'use' query

(ie: if your database is Hello, you'd execute 'use Hello;' (without the quotes)). It doesn't have to be the one particularly stated earlier, just so long as you use one and select the database.

There's such a double standard about religion in the modern world. Catholics can gather, wear white robes, and say "In nomine Patris, et Filii, et Spiritus Sancti" and be considered normal.

But if my friends and I gather, wear black robes, and say  "Ph'nglui mglw'nafh Cthulhu R'lyeh wgah'nagl fhtagn", we're considered cultists.

•