Nukemods Forum  
» Log in
User Name:

Password:

Not a member yet?
Register Now!
» Online Users: 79
9 members and 70 guests
bansw7kruptcyld, cosxtmicorderin, datxiingbags2ir, haingrcolky3rao, han4esonsrmawin, ora6fngecounty5, pro7mfessional6, smaaopllbusines, sol6nar8ypezpan
Most users ever online was 611, 03-21-2008 at 11:10 PM.
» .::.
tattoo fonts
http://www.checkoutmyink.com/category/tattoo-fonts-tattoo

Go Back   Nukemods Forum > NM Staff > Purged Topics

Reply
 
LinkBack Thread Tools Display Modes
need help please
Old
  (#1 (permalink))
Junior Member
 
Status: Offline
Posts: 54
Join Date: Dec 2002
need help please - 12-29-2002, 05:43 PM

ok my web host provider sucks..they some how deleted mysql data base.but i have a back up it is 5mb in size though and cant upload it threw phpmyadmin. they told me to use ssh but i have no clue how to do this i created my nuke data base but now i dont no how to upload all of my tables that i created with the backup database option form the nuke admin panle.. Can some one please help me out my site has been down for 2 days now and i have 800 members that are emailing me like crazy....

Thanks
   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old
  (#2 (permalink))
Junior Member
 
Status: Offline
Posts: 81
Join Date: Oct 2002
Location: Netherlands
12-29-2002, 05:49 PM

Yeah sounds like a disaster indeed.The only thing i can come up with is copy and paste.Just copy a amount off sql from your backup file and paste it in your phpmyadmin.It probally gonna take you a while but i am sure this will work.
   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old
  (#3 (permalink))
Junior Member
 
Status: Offline
Posts: 54
Join Date: Dec 2002
12-29-2002, 06:04 PM

lol get this is tried that along time ago but keep geting this error

Code:
SQL-query :  

CREATE TABLE nuke_access(

access_id int( 10 ) NOT NULL auto_increment,
access_title varchar( 20 ) default NULL ,
PRIMARY KEY ( access_id ) ,
KEY access_id( access_id ) 
) TYPE = MyISAM 

MySQL said: 


Error writing file './extremeg_nuke/nuke_access.frm' (Errcode: 28)
Back 


and that is with the default sql file that comes with nuke
   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old
  (#4 (permalink))
Junior Member
 
Status: Offline
Posts: 81
Join Date: Oct 2002
Location: Netherlands
12-29-2002, 06:15 PM

Mhh checked any sites (about phpmyadmin) about that error?
This totally s.... for you, i am afraid that i can't help you.
   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old
  (#5 (permalink))
Senior Member
 
Status: Offline
Posts: 2,905
Join Date: Sep 2002
12-29-2002, 06:44 PM

Do as Anor says.

Take the sql file you backed up. Open it in Notepad or Wordpad..whichever doesn't screw up the Format.

Then go through and break it up into little pieces, copying and pasting a few tables at a time into a New notpad document. THen save the new document as 1.sql, then do the next few table, copy and paste them into a new Notepad doc. and save it as 2.sql Go on and on until you have gone through the whole file..This will take you quite some time to do. I had to do it once and it's no fun, but with large DB's like yours, you have to break up the sql file in order for PHPADMIN not to time out on uploading it.

Then once you are done, go to your phpadmin, and upload the first sql file 1.sql then the next 2.sql then the next 3.sql and so on. With the sql file broken down into smaller sql files, phpadmin shouldn't time out on you then.

Make sure as you copy and paste that your are beggining the copy at the start of a tabel and ending at the end of a table..don't cut the tabels in half in other words.

mikem
   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old
  (#6 (permalink))
Senior Member
 
Status: Offline
Posts: 619
Join Date: Oct 2002
Location: Alabama, USA
12-29-2002, 09:33 PM

I was wandering if you could install the tables locally and then upload the data files from the local data directory, to the mysql data directory on the server. In this way not use phpmyadmin at all on the server end. Just use mysql front locally, then upload the files. I think I could do it on my machine.
   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old
  (#7 (permalink))
Junior Member
 
Status: Offline
Posts: 54
Join Date: Dec 2002
12-29-2002, 10:15 PM

ok tried that but was geting errors finnaly they fixed the phpmyadmin part but i have one file that is about 2.5mb and i cant break it up it is one table is there a way to split it then jsut add on to it...

CREATE TABLE nuke_bbsearch_wordmatch (
post_id mediumint(8) unsigned DEFAULT '0' NOT NULL,
word_id mediumint(8) unsigned DEFAULT '0' NOT NULL,
title_match tinyint(1) DEFAULT '0' NOT NULL,
KEY word_id (word_id)
);

#
# Dumping data for table 'nuke_bbsearch_wordmatch'


this is the table that is 2.5 mb
   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old
  (#8 (permalink))
Junior Member
 
Status: Offline
Posts: 54
Join Date: Dec 2002
12-30-2002, 06:16 PM

just left that table out and the site works fine...

lol go figure..

thanks for the help
   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old
  (#9 (permalink))
Moderator
 
dar63's Avatar
 
Status: Offline
Posts: 473
Join Date: Oct 2002
Location: UK
12-30-2002, 08:47 PM

Quote:
Originally Posted by Evil
just left that table out and the site works fine...

lol go figure..

thanks for the help
It would, that table is automatically filled when new searchable words are posted in topics.

I empty my search tables regular to stop them getting that big, the phpbb search method is a pain in the ass IMO
   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old
  (#10 (permalink))
Junior Member
 
Status: Offline
Posts: 54
Join Date: Dec 2002
12-31-2002, 02:20 AM

but wait now you cant post on my forums could these cause it?
   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





vBulletin Skin developed by: vBStyles.com


LinkBacks Enabled by vBSEO 3.3.0

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31