NukeXchange Network

          

Nuke Sites Link Directory
Nuke Fixes · NukeForums · NukeZone Hosting · Nuke Sites · Nuke Skins
Nuke Resources
 :: Home  :: Downloads  :: Your Account  :: Forums  :: Advertise :: 
Login or Register
Main Menu
General
 Main
 AvantGo
 Banner_Clients
 cfaq
 Donations
 Downloads
 Forums
 Members_List
 Private_Messages
 Search
 Stories_Archive
 Submit_News
 Surveys
 Topics
 Web_Links
 Your_Account
Your Account
 Login
 Register
 Lost Pass
Modules
Quick Links
· Domain Names
 . Game Quest
 · Learning Linux
 . MateMaker
 · NukeFixes
 · NukeForums
 · Nuke Sites
 · Nuke Skins
 · NukeZone Hosting
. SearchDevil
Other Options

Download Resources
· Nuke Downloads
· Add a Link
· New Files
· Top Rated
· Most Popular

Web Site Resources
· Nuke Sites
· Add A Site
· New Sites
· Top Rated
· Most Popular

Support
· NukeZone Hosting
· NukeSkins.com
· NukeForums.com
· phpnuke.org
· NukeFixes.com
Information
NukeForums
·Email not sending from forum
·Can't add articles
·Adding 'All' as a selection on Reviews
·php nuke background
·Php nuke one click install on plesk 10.4
·Blocks
·vbulletin migration
·How would I add a clickable link in a Modules Block?
·eregi_replace() is deprecated
·Admin Security login jpeg not showing

read more...
Top10 Links
· 1: Nuke Forums
· 2: Windows Installation: PHP
· 3: PHPNukeFiles
· 4: NukeSkins
· 5: Nuke Templates
· 6: EcomJunk
· 7: MDesign
· 8: FLASH-FOR-NUKE
· 9: Dezina
· 10: Global Dream News Sharing Portal!
Site Visitors
User Login:

Nickname:
Password:
Security Code: Security Code
Type Security Code Here:

Members List Membership:
Latest: born
Today: 0
Yesterday: 0
Overall: 16031
Visitation:
Guests: 218
Members: 0
Total: 218

You are Anonymous user. You can register for free by clicking here
Sponsor Links
Game Quest Online - Games and more!
Game Quest Online - Games and more!

NukeResources :: View topic - Import (Max: 2,048KB) txt size
NukeResources Forum Index

NukeResources Forum Index -> phpMyAdmin -> Import (Max: 2,048KB) txt size
Post new topic  Reply to topic    View previous topic :: View next topic 
Import (Max: 2,048KB) txt size
PostPosted: Mon Jun 12, 2006 11:51 am Reply with quote
s4ur0n
Resource Seeker
Resource Seeker
 
Joined: Jun 12, 2006
Posts: 1




Hi all, I need to import a 7mb txt file, ive tried .zipping it but phpmyadmin says " Error in ZIP archive: File is encrypted, which is not supported from this class." Any ideas how i can import my file using phpmyadmin or any other way.

Any help greatly appreciated.
View user's profile Send private message
PostPosted: Mon Jun 12, 2006 8:07 pm Reply with quote
darklord
Resourceful
Resourceful
 
Joined: Feb 25, 2006
Posts: 210




cut the file down...anywhere it says create table(just above)...looks like u may need to break it down into 7 files

ex:

#
# Estructura de tabla para la tabla `nuke_bbcategories`
#

CREATE TABLE nuke_bbcategories (
cat_id mediumint(8 ) unsigned NOT NULL auto_increment,
cat_title varchar(100) default NULL,
cat_order mediumint(8 ) unsigned NOT NULL default '0',
PRIMARY KEY (cat_id),
KEY cat_order (cat_order)
) TYPE=MyISAM;

#
# Volcar la base de datos para la tabla `nuke_bbcategories`
#

# --------------------------------------------------------

#
# Estructura de tabla para la tabla `nuke_bbconfig`
#

CREATE TABLE nuke_bbconfig (
config_name varchar(255) NOT NULL default '',
config_value varchar(255) NOT NULL default '',
PRIMARY KEY (config_name)
) TYPE=MyISAM;

#
# Volcar la base de datos para la tabla `nuke_bbconfig`
#

INSERT INTO nuke_bbconfig VALUES ('config_id', '1');
INSERT INTO nuke_bbconfig VALUES ('board_disable', '0');
INSERT INTO nuke_bbconfig VALUES ('sitename', 'MySite.com');
INSERT INTO nuke_bbconfig VALUES ('site_desc', '');
INSERT INTO nuke_bbconfig VALUES ('cookie_name', 'phpbb2mysql');
INSERT INTO nuke_bbconfig VALUES ('cookie_path', '/');
INSERT INTO nuke_bbconfig VALUES ('cookie_domain', 'MySite.com');
INSERT INTO nuke_bbconfig VALUES ('cookie_secure', '0');
INSERT INTO nuke_bbconfig VALUES ('session_length', '3600');
INSERT INTO nuke_bbconfig VALUES ('allow_html', '1');
INSERT INTO nuke_bbconfig VALUES ('allow_html_tags', 'b,i,u,pre');
INSERT INTO nuke_bbconfig VALUES ('allow_bbcode', '1');
INSERT INTO nuke_bbconfig VALUES ('allow_smilies', '1');
INSERT INTO nuke_bbconfig VALUES ('allow_sig', '1');
INSERT INTO nuke_bbconfig VALUES ('allow_namechange', '0');
INSERT INTO nuke_bbconfig VALUES ('allow_theme_create', '0');
INSERT INTO nuke_bbconfig VALUES ('allow_avatar_local', '1');
INSERT INTO nuke_bbconfig VALUES ('allow_avatar_remote', '0');
INSERT INTO nuke_bbconfig VALUES ('allow_avatar_upload', '0');
INSERT INTO nuke_bbconfig VALUES ('override_user_style', '1');
INSERT INTO nuke_bbconfig VALUES ('posts_per_page', '15');
INSERT INTO nuke_bbconfig VALUES ('topics_per_page', '50');
INSERT INTO nuke_bbconfig VALUES ('hot_threshold', '25');
INSERT INTO nuke_bbconfig VALUES ('max_poll_options', '10');
INSERT INTO nuke_bbconfig VALUES ('max_sig_chars', '255');
INSERT INTO nuke_bbconfig VALUES ('max_inbox_privmsgs', '100');
INSERT INTO nuke_bbconfig VALUES ('max_sentbox_privmsgs', '100');
INSERT INTO nuke_bbconfig VALUES ('max_savebox_privmsgs', '100');
INSERT INTO nuke_bbconfig VALUES ('board_email_sig', 'Thanks, Webmaster@MySite.com');
INSERT INTO nuke_bbconfig VALUES ('board_email', 'Webmaster@MySite.com');
INSERT INTO nuke_bbconfig VALUES ('smtp_delivery', '0');
INSERT INTO nuke_bbconfig VALUES ('smtp_host', '');
INSERT INTO nuke_bbconfig VALUES ('require_activation', '0');
INSERT INTO nuke_bbconfig VALUES ('flood_interval', '15');
INSERT INTO nuke_bbconfig VALUES ('board_email_form', '0');
INSERT INTO nuke_bbconfig VALUES ('avatar_filesize', '6144');
INSERT INTO nuke_bbconfig VALUES ('avatar_max_width', '80');
INSERT INTO nuke_bbconfig VALUES ('avatar_max_height', '80');
INSERT INTO nuke_bbconfig VALUES ('avatar_path', 'modules/Forums/images/avatars');
INSERT INTO nuke_bbconfig VALUES ('avatar_gallery_path', 'modules/Forums/images/avatars');
INSERT INTO nuke_bbconfig VALUES ('smilies_path', 'modules/Forums/images/smiles');
INSERT INTO nuke_bbconfig VALUES ('default_style', '1');
INSERT INTO nuke_bbconfig VALUES ('default_dateformat', 'D M d, Y g:i a');
INSERT INTO nuke_bbconfig VALUES ('board_timezone', '10');
INSERT INTO nuke_bbconfig VALUES ('prune_enable', '0');
INSERT INTO nuke_bbconfig VALUES ('privmsg_disable', '0');
INSERT INTO nuke_bbconfig VALUES ('gzip_compress', '0');
INSERT INTO nuke_bbconfig VALUES ('coppa_fax', '');
INSERT INTO nuke_bbconfig VALUES ('coppa_mail', '');
INSERT INTO nuke_bbconfig VALUES ('board_startdate', '1013908210');
INSERT INTO nuke_bbconfig VALUES ('default_lang', 'english');
INSERT INTO nuke_bbconfig VALUES ('smtp_username', '');
INSERT INTO nuke_bbconfig VALUES ('smtp_password', '');
INSERT INTO nuke_bbconfig VALUES ('record_online_users', '2');
INSERT INTO nuke_bbconfig VALUES ('record_online_date', '1034668530');
INSERT INTO nuke_bbconfig VALUES ('server_name', 'MySite.com');
INSERT INTO nuke_bbconfig VALUES ('server_port', '80');
INSERT INTO nuke_bbconfig VALUES ('script_path', '/modules/Forums/');
INSERT INTO nuke_bbconfig VALUES ('version', '.0.10');
INSERT INTO nuke_bbconfig VALUES ('enable_confirm', '0');
INSERT INTO nuke_bbconfig VALUES ('sendmail_fix', '0');
# --------------------------------------------------------

#
# Estructura de tabla para la tabla `nuke_bbdisallow`
#

CREATE TABLE nuke_bbdisallow (
disallow_id mediumint(8 ) unsigned NOT NULL auto_increment,
disallow_username varchar(25) default NULL,
PRIMARY KEY (disallow_id)
) TYPE=MyISAM;

#
# Volcar la base de datos para la tabla `nuke_bbdisallow`
#

# --------------------------------------------------------

#
# Estructura de tabla para la tabla `nuke_bbforum_prune`
#

CREATE TABLE nuke_bbforum_prune (
prune_id mediumint(8 ) unsigned NOT NULL auto_increment,
forum_id smallint(5) unsigned NOT NULL default '0',
prune_days tinyint(4) unsigned NOT NULL default '0',
prune_freq tinyint(4) unsigned NOT NULL default '0',
PRIMARY KEY (prune_id),
KEY forum_id (forum_id)
) TYPE=MyISAM;

#
# Volcar la base de datos para la tabla `nuke_bbforum_prune`
#

# --------------------------------------------------------

#
# Estructura de tabla para la tabla `nuke_bbforums`
#

CREATE TABLE nuke_bbforums (
forum_id smallint(5) unsigned NOT NULL auto_increment,
cat_id mediumint(8 ) unsigned NOT NULL default '0',
forum_name varchar(150) default NULL,
forum_desc text,
forum_status tinyint(4) NOT NULL default '0',
forum_order mediumint(8 ) unsigned NOT NULL default '1',
forum_posts mediumint(8 ) unsigned NOT NULL default '0',
forum_topics mediumint(8 ) unsigned NOT NULL default '0',
forum_last_post_id mediumint(8 ) unsigned NOT NULL default '0',
prune_next int(11) default NULL,
prune_enable tinyint(1) NOT NULL default '1',
auth_view tinyint(2) NOT NULL default '0',
auth_read tinyint(2) NOT NULL default '0',
auth_post tinyint(2) NOT NULL default '0',
auth_reply tinyint(2) NOT NULL default '0',
auth_edit tinyint(2) NOT NULL default '0',
auth_delete tinyint(2) NOT NULL default '0',
auth_sticky tinyint(2) NOT NULL default '0',
auth_announce tinyint(2) NOT NULL default '0',
auth_vote tinyint(2) NOT NULL default '0',
auth_pollcreate tinyint(2) NOT NULL default '0',
auth_attachments tinyint(2) NOT NULL default '0',
PRIMARY KEY (forum_id),
KEY forums_order (forum_order),
KEY cat_id (cat_id),
KEY forum_last_post_id (forum_last_post_id)
) TYPE=MyISAM;

#
# Volcar la base de datos para la tabla `nuke_bbforums`
#

# --------------------------------------------------------

#
# Estructura de tabla para la tabla `nuke_bbgroups`
#

CREATE TABLE nuke_bbgroups (
group_id mediumint(8 ) NOT NULL auto_increment,
group_type tinyint(4) NOT NULL default '1',
group_name varchar(40) NOT NULL default '',
group_description varchar(255) NOT NULL default '',
group_moderator mediumint(8 ) NOT NULL default '0',
group_single_user tinyint(1) NOT NULL default '1',
PRIMARY KEY (group_id),
KEY group_single_user (group_single_user)
) TYPE=MyISAM;

#
# Volcar la base de datos para la tabla `nuke_bbgroups`
#

INSERT INTO nuke_bbgroups VALUES (1, 1, 'Anonymous', 'Personal User', 0, 1);
INSERT INTO nuke_bbgroups VALUES (3, 2, 'Moderators', 'Moderators of this Forum', 5, 0);
# --------------------------------------------------------

#
# Estructura de tabla para la tabla `nuke_bbposts`
#

CREATE TABLE nuke_bbposts (
post_id mediumint(8 ) unsigned NOT NULL auto_increment,
topic_id mediumint(8 ) unsigned NOT NULL default '0',
forum_id smallint(5) unsigned NOT NULL default '0',
poster_id mediumint(8 ) NOT NULL default '0',
post_time int(11) NOT NULL default '0',
poster_ip varchar(8 ) NOT NULL default '',
post_username varchar(25) default NULL,
enable_bbcode tinyint(1) NOT NULL default '1',
enable_html tinyint(1) NOT NULL default '0',
enable_smilies tinyint(1) NOT NULL default '1',
enable_sig tinyint(1) NOT NULL default '1',
post_edit_time int(11) default NULL,
post_edit_count smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (post_id),
KEY forum_id (forum_id),
KEY topic_id (topic_id),
KEY poster_id (poster_id),
KEY post_time (post_time)
) TYPE=MyISAM;

#
# Volcar la base de datos para la tabla `nuke_bbposts`
#

# --------------------------------------------------------

#
# Estructura de tabla para la tabla `nuke_bbposts_text`
#

CREATE TABLE nuke_bbposts_text (
post_id mediumint(8 ) unsigned NOT NULL default '0',
bbcode_uid varchar(10) NOT NULL default '',
post_subject varchar(60) default NULL,
post_text text,
PRIMARY KEY (post_id)
) TYPE=MyISAM;

#
# Volcar la base de datos para la tabla `nuke_bbposts_text`
#

# --------------------------------------------------------


we brake this down now

highlight and save like this:









#
# Estructura de tabla para la tabla `nuke_bbcategories`
#

CREATE TABLE nuke_bbcategories (
cat_id mediumint(8 ) unsigned NOT NULL auto_increment,
cat_title varchar(100) default NULL,
cat_order mediumint(8 ) unsigned NOT NULL default '0',
PRIMARY KEY (cat_id),
KEY cat_order (cat_order)
) TYPE=MyISAM;

#
# Volcar la base de datos para la tabla `nuke_bbcategories`
#

# --------------------------------------------------------

#
# Estructura de tabla para la tabla `nuke_bbconfig`
#

CREATE TABLE nuke_bbconfig (
config_name varchar(255) NOT NULL default '',
config_value varchar(255) NOT NULL default '',
PRIMARY KEY (config_name)
) TYPE=MyISAM;

#
# Volcar la base de datos para la tabla `nuke_bbconfig`
#

INSERT INTO nuke_bbconfig VALUES ('config_id', '1');
INSERT INTO nuke_bbconfig VALUES ('board_disable', '0');
INSERT INTO nuke_bbconfig VALUES ('sitename', 'MySite.com');
INSERT INTO nuke_bbconfig VALUES ('site_desc', '');
INSERT INTO nuke_bbconfig VALUES ('cookie_name', 'phpbb2mysql');
INSERT INTO nuke_bbconfig VALUES ('cookie_path', '/');
INSERT INTO nuke_bbconfig VALUES ('cookie_domain', 'MySite.com');
INSERT INTO nuke_bbconfig VALUES ('cookie_secure', '0');
INSERT INTO nuke_bbconfig VALUES ('session_length', '3600');
INSERT INTO nuke_bbconfig VALUES ('allow_html', '1');
INSERT INTO nuke_bbconfig VALUES ('allow_html_tags', 'b,i,u,pre');
INSERT INTO nuke_bbconfig VALUES ('allow_bbcode', '1');
INSERT INTO nuke_bbconfig VALUES ('allow_smilies', '1');
INSERT INTO nuke_bbconfig VALUES ('allow_sig', '1');
INSERT INTO nuke_bbconfig VALUES ('allow_namechange', '0');
INSERT INTO nuke_bbconfig VALUES ('allow_theme_create', '0');
INSERT INTO nuke_bbconfig VALUES ('allow_avatar_local', '1');
INSERT INTO nuke_bbconfig VALUES ('allow_avatar_remote', '0');
INSERT INTO nuke_bbconfig VALUES ('allow_avatar_upload', '0');
INSERT INTO nuke_bbconfig VALUES ('override_user_style', '1');
INSERT INTO nuke_bbconfig VALUES ('posts_per_page', '15');
INSERT INTO nuke_bbconfig VALUES ('topics_per_page', '50');
INSERT INTO nuke_bbconfig VALUES ('hot_threshold', '25');
INSERT INTO nuke_bbconfig VALUES ('max_poll_options', '10');
INSERT INTO nuke_bbconfig VALUES ('max_sig_chars', '255');
INSERT INTO nuke_bbconfig VALUES ('max_inbox_privmsgs', '100');
INSERT INTO nuke_bbconfig VALUES ('max_sentbox_privmsgs', '100');
INSERT INTO nuke_bbconfig VALUES ('max_savebox_privmsgs', '100');
INSERT INTO nuke_bbconfig VALUES ('board_email_sig', 'Thanks, Webmaster@MySite.com');
INSERT INTO nuke_bbconfig VALUES ('board_email', 'Webmaster@MySite.com');
INSERT INTO nuke_bbconfig VALUES ('smtp_delivery', '0');
INSERT INTO nuke_bbconfig VALUES ('smtp_host', '');
INSERT INTO nuke_bbconfig VALUES ('require_activation', '0');
INSERT INTO nuke_bbconfig VALUES ('flood_interval', '15');
INSERT INTO nuke_bbconfig VALUES ('board_email_form', '0');
INSERT INTO nuke_bbconfig VALUES ('avatar_filesize', '6144');
INSERT INTO nuke_bbconfig VALUES ('avatar_max_width', '80');
INSERT INTO nuke_bbconfig VALUES ('avatar_max_height', '80');
INSERT INTO nuke_bbconfig VALUES ('avatar_path', 'modules/Forums/images/avatars');
INSERT INTO nuke_bbconfig VALUES ('avatar_gallery_path', 'modules/Forums/images/avatars');
INSERT INTO nuke_bbconfig VALUES ('smilies_path', 'modules/Forums/images/smiles');
INSERT INTO nuke_bbconfig VALUES ('default_style', '1');
INSERT INTO nuke_bbconfig VALUES ('default_dateformat', 'D M d, Y g:i a');
INSERT INTO nuke_bbconfig VALUES ('board_timezone', '10');
INSERT INTO nuke_bbconfig VALUES ('prune_enable', '0');
INSERT INTO nuke_bbconfig VALUES ('privmsg_disable', '0');
INSERT INTO nuke_bbconfig VALUES ('gzip_compress', '0');
INSERT INTO nuke_bbconfig VALUES ('coppa_fax', '');
INSERT INTO nuke_bbconfig VALUES ('coppa_mail', '');
INSERT INTO nuke_bbconfig VALUES ('board_startdate', '1013908210');
INSERT INTO nuke_bbconfig VALUES ('default_lang', 'english');
INSERT INTO nuke_bbconfig VALUES ('smtp_username', '');
INSERT INTO nuke_bbconfig VALUES ('smtp_password', '');
INSERT INTO nuke_bbconfig VALUES ('record_online_users', '2');
INSERT INTO nuke_bbconfig VALUES ('record_online_date', '1034668530');
INSERT INTO nuke_bbconfig VALUES ('server_name', 'MySite.com');
INSERT INTO nuke_bbconfig VALUES ('server_port', '80');
INSERT INTO nuke_bbconfig VALUES ('script_path', '/modules/Forums/');
INSERT INTO nuke_bbconfig VALUES ('version', '.0.10');
INSERT INTO nuke_bbconfig VALUES ('enable_confirm', '0');
INSERT INTO nuke_bbconfig VALUES ('sendmail_fix', '0');
# --------------------------------------------------------




The second file would be this:



#
# Estructura de tabla para la tabla `nuke_bbdisallow`
#

CREATE TABLE nuke_bbdisallow (
disallow_id mediumint(8 ) unsigned NOT NULL auto_increment,
disallow_username varchar(25) default NULL,
PRIMARY KEY (disallow_id)
) TYPE=MyISAM;

#
# Volcar la base de datos para la tabla `nuke_bbdisallow`
#

# --------------------------------------------------------

#
# Estructura de tabla para la tabla `nuke_bbforum_prune`
#

CREATE TABLE nuke_bbforum_prune (
prune_id mediumint(8 ) unsigned NOT NULL auto_increment,
forum_id smallint(5) unsigned NOT NULL default '0',
prune_days tinyint(4) unsigned NOT NULL default '0',
prune_freq tinyint(4) unsigned NOT NULL default '0',
PRIMARY KEY (prune_id),
KEY forum_id (forum_id)
) TYPE=MyISAM;

#
# Volcar la base de datos para la tabla `nuke_bbforum_prune`
#

# --------------------------------------------------------

#
# Estructura de tabla para la tabla `nuke_bbforums`
#

CREATE TABLE nuke_bbforums (
forum_id smallint(5) unsigned NOT NULL auto_increment,
cat_id mediumint(8 ) unsigned NOT NULL default '0',
forum_name varchar(150) default NULL,
forum_desc text,
forum_status tinyint(4) NOT NULL default '0',
forum_order mediumint(8 ) unsigned NOT NULL default '1',
forum_posts mediumint(8 ) unsigned NOT NULL default '0',
forum_topics mediumint(8 ) unsigned NOT NULL default '0',
forum_last_post_id mediumint(8 ) unsigned NOT NULL default '0',
prune_next int(11) default NULL,
prune_enable tinyint(1) NOT NULL default '1',
auth_view tinyint(2) NOT NULL default '0',
auth_read tinyint(2) NOT NULL default '0',
auth_post tinyint(2) NOT NULL default '0',
auth_reply tinyint(2) NOT NULL default '0',
auth_edit tinyint(2) NOT NULL default '0',
auth_delete tinyint(2) NOT NULL default '0',
auth_sticky tinyint(2) NOT NULL default '0',
auth_announce tinyint(2) NOT NULL default '0',
auth_vote tinyint(2) NOT NULL default '0',
auth_pollcreate tinyint(2) NOT NULL default '0',
auth_attachments tinyint(2) NOT NULL default '0',
PRIMARY KEY (forum_id),
KEY forums_order (forum_order),
KEY cat_id (cat_id),
KEY forum_last_post_id (forum_last_post_id)
) TYPE=MyISAM;

#
# Volcar la base de datos para la tabla `nuke_bbforums`
#

# --------------------------------------------------------

#
# Estructura de tabla para la tabla `nuke_bbgroups`
#

CREATE TABLE nuke_bbgroups (
group_id mediumint(8 ) NOT NULL auto_increment,
group_type tinyint(4) NOT NULL default '1',
group_name varchar(40) NOT NULL default '',
group_description varchar(255) NOT NULL default '',
group_moderator mediumint(8 ) NOT NULL default '0',
group_single_user tinyint(1) NOT NULL default '1',
PRIMARY KEY (group_id),
KEY group_single_user (group_single_user)
) TYPE=MyISAM;

#
# Volcar la base de datos para la tabla `nuke_bbgroups`
#

INSERT INTO nuke_bbgroups VALUES (1, 1, 'Anonymous', 'Personal User', 0, 1);
INSERT INTO nuke_bbgroups VALUES (3, 2, 'Moderators', 'Moderators of this Forum', 5, 0);
# --------------------------------------------------------

#
# Estructura de tabla para la tabla `nuke_bbposts`
#

CREATE TABLE nuke_bbposts (
post_id mediumint(8 ) unsigned NOT NULL auto_increment,
topic_id mediumint(8 ) unsigned NOT NULL default '0',
forum_id smallint(5) unsigned NOT NULL default '0',
poster_id mediumint(8 ) NOT NULL default '0',
post_time int(11) NOT NULL default '0',
poster_ip varchar(8 ) NOT NULL default '',
post_username varchar(25) default NULL,
enable_bbcode tinyint(1) NOT NULL default '1',
enable_html tinyint(1) NOT NULL default '0',
enable_smilies tinyint(1) NOT NULL default '1',
enable_sig tinyint(1) NOT NULL default '1',
post_edit_time int(11) default NULL,
post_edit_count smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (post_id),
KEY forum_id (forum_id),
KEY topic_id (topic_id),
KEY poster_id (poster_id),
KEY post_time (post_time)
) TYPE=MyISAM;

#
# Volcar la base de datos para la tabla `nuke_bbposts`
#

# --------------------------------------------------------

#
# Estructura de tabla para la tabla `nuke_bbposts_text`

_________________

for those who STAND shall NEVER fall and those who fall shall rise once more...never give up the end is just another beginning.
View user's profile Send private message Send e-mail Visit poster's website Yahoo Messenger
May be
PostPosted: Tue Jun 13, 2006 1:04 am Reply with quote
darleys
Resource Seeker
Resource Seeker
 
Joined: Aug 03, 2005
Posts: 8




did you try using mydbpanel, I think it will work in that. don't use the their hosted service , but download it from their website or in nuke resource download and try it.
Click MySQL Icon and "Run SQL query/queries from a file on database " , Browse that File and Submit it it should work for you .
View user's profile Send private message
It works
PostPosted: Tue Jun 13, 2006 1:12 am Reply with quote
darleys
Resource Seeker
Resource Seeker
 
Joined: Aug 03, 2005
Posts: 8




I just checked with 2Mb file, and it works just like that , it also shows a perfect result for each and every query. I think it will surely work for you
View user's profile Send private message
PostPosted: Thu Jun 15, 2006 8:58 pm Reply with quote
darklord
Resourceful
Resourceful
 
Joined: Feb 25, 2006
Posts: 210




the limits applied on a server are host set...as in some host may allow for bigger files to be executed through phpmyadmin

so thats where the limit is...through the server...an outside client would break it down just like i did..just automatically and not manually.

_________________

for those who STAND shall NEVER fall and those who fall shall rise once more...never give up the end is just another beginning.
View user's profile Send private message Send e-mail Visit poster's website Yahoo Messenger
Not Neat
PostPosted: Fri Jun 16, 2006 10:14 am Reply with quote
darleys
Resource Seeker
Resource Seeker
 
Joined: Aug 03, 2005
Posts: 8




Actually in phpmyadmin, when u execute multiple queries, it will not show results and output for each and every query, it will only show message (error/output) of the first query and moreover after executing the queries the tables list display at the left side of the layout will be disoeriented and the same error message will be displayed.
It will be confusing for anyone to execute queries without any output.
but mydbpanel is pretty straight forward in showing results for each and every query, and there is not disorientation in the layout.
View user's profile Send private message
PostPosted: Mon Jun 19, 2006 6:51 pm Reply with quote
darklord
Resourceful
Resourceful
 
Joined: Feb 25, 2006
Posts: 210




That all depends on the version of phpmyadmin used...for example if i try to run 3 queries and the second query has an error...itll display an error but it will still show the table structure to the left

It will also run the first query but will stop the minute it has an error

but u know the truth....ive never used the mydbpanel ur talkin bout matter of fact id like to know exactly what it is...im assuming a client but im not for sure.

_________________

for those who STAND shall NEVER fall and those who fall shall rise once more...never give up the end is just another beginning.
View user's profile Send private message Send e-mail Visit poster's website Yahoo Messenger
web client
PostPosted: Wed Jun 21, 2006 12:16 am Reply with quote
darleys
Resource Seeker
Resource Seeker
 
Joined: Aug 03, 2005
Posts: 8




I understand, you can try it at http://mydbpanel.com , may be download it and try.
Actually it is also a client , but it is more user friendly and straight forward to use. Say for example you need not do any configuration file editting to actually use the tool, you can have complete control over the flow of the tool in terms of functionalities and features, and there is not confusion whatsoever in the layout and work flow and even a layman can use it.
View user's profile Send private message
PostPosted: Wed Jun 21, 2006 10:19 am Reply with quote
Evaders99
Resource Master
Resource Master
 
Joined: May 25, 2004
Posts: 1796




For bigger .sql files, I recommend using the Big Dump script. It is designed for you to upload the .sql and it will break things down and execute it piece by piece.

_________________
- Star Wars Rebellion Network - Evaders Squadron Coding -

Need help? Nuke Patched Core, Coding Services, Webmaster Services
View user's profile Send private message Visit poster's website AIM Address
Import (Max: 2,048KB) txt size
 NukeResources Forum Index -> phpMyAdmin
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
 		All times are GMT - 4 Hours  
Page 1 of 1  
  
  
 Post new topic  Reply to topic     



Powered by phpBB © 2001-2005 phpBB Group.     Theme created by Vjacheslav Trushkin.
There have been 64 unique hit(s) in the past 24 hours.
Forums ©
Game Quest Online - Games and more!


Best viewed with a Browser
All logos and trademarks in this site are property of their respective owner.
The comments are property of their posters, all the rest © 2001 - 2007 by NukeResources.com
You can syndicate our news using the file .backend.php or ultramode.txt
PHP-Nuke Copyright © 2004 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.
Page Generation: 1.27 Seconds

:: Eos phpbb2 style by Cyberalien :: PHP-Nuke theme by www.nukemods.com ::