• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

Problem with importing .sql

Iprototype

New Member
Joined
Nov 5, 2012
Messages
12
Reaction score
0
Hey guys ..
I'm trying to import a .sql file it has 2800 kb , more than the 2k allowed by phpmyadmin , so i've made it a zip file , then when i import it gives me this message :
Error
SQL query:

-- -- Banco de Dados: `tibera-world` -- -- -------------------------------------------------------- -- -- Estrutura da tabela `accounts` -- CREATE TABLE IF NOT EXISTS `accounts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(32) NOT NULL DEFAULT '', `password` varchar(255) NOT NULL, `salt` varchar(40) NOT NULL DEFAULT '', `premdays` int(11) NOT NULL DEFAULT '0', `lastday` int(10) unsigned NOT NULL DEFAULT '0', `email` varchar(255) NOT NULL DEFAULT '', `key` varchar(20) NOT NULL DEFAULT '0', `blocked` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'internal usage', `warnings` int(11) NOT NULL DEFAULT '0', `group_id` int(11) NOT NULL DEFAULT '1', `page_lastday` int(11) NOT NULL, `email_new` varchar(255) NOT NULL, `email_new_time` int(15) NOT NULL, `created` int(11) NOT NULL DEFAULT '0', `rlname` varchar(255) NOT NULL DEFAULT '', `location` varchar(255) NOT NULL DEFAULT '', `page_access` int(11) NOT NULL DEFAULT '0', `email_code` varchar(255) NO[...]

MySQL said:

#1046 - No database selected

this is the first time i'm using mysql :(

cya
 
hmm i understood , but where is it ? i mean php.ini

- - - Updated - - -

aw i didnt work , i've changed all those values and it gives me the same problem x.x
 
Example in command-line interface (linux):
Code:
mysql -u root -p12345 database < file.mysql
 
Last edited:
Back
Top