need help please

Evil · **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

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

Evil · 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

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

mikem · 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

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

Evil · 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

Evil · 12-30-2002, 06:16 PM

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

lol go figure..

thanks for the help

dar63 · 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

Evil · 12-31-2002, 02:20 AM

but wait now you cant post on my forums could these cause it?