mysql problems

shellsnetwork

New member
Joined
Jun 29, 2005
Messages
1
Hello guys


i created a db calle Fire_flux
username Fire_flux
password FiRe

then i opened phpmyadmin and loaded an sql file
before i loaded it i saw that more than 2048byte arent allowed
so i was forced to shorten the file (the orign file is 2800byte)
then i loaded it
and then nothin works nomore again mysql went down

i guess We need increase max filesize for sql-file at least to 3072bytes so we will be able to upload
something strange goes on
how to
increase max filesize for sql-file ?

also the error i get is

Server: localhost
Database: Fire_flux
Error

SQL query:

CREATE TABLE tf_users(
uid int( 10 ) NOT NULL AUTO_INCREMENT ,
user_id varchar( 32 ) NOT NULL default '',
PASSWORD varchar( 34 ) NOT NULL default '',
hits int( 10 ) NOT NULL default '0',
last_visit varchar( 14 ) NOT NULL default '0',
time_created varchar( 14 ) NOT NULL default '0',
user_level tinyint( 1 ) NOT NULL default '0',
hide_offline tinyint( 1 ) NOT NULL default '0',
theme varchar( 100 ) NOT NULL default 'mint',
language_file varchar( 60 ) default 'lang-english.php',
PRIMARY KEY ( uid )
) TYPE = MYISAM

MySQL said:
#1 - Can't create/write to file './Fire_flux/tf_users.frm' (Errcode: 9)
[ Back ]


We are new with directadmin if anyone can help us please.
 
Back
Top