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.
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.