By prameya on

heres where i am...

i kinda released the website using the test install.. i was too lazy to do everything all over again... and to the mercy of the internet.. the site "actually" got popular... and then... it was dying everytime my articles came to google news frontpage.

after a little research i found out that the statistics module was a little fking nuts, stealing all my juice.. using my dual core 3.2 to 100%... so i turned it off.. and it relaxed to 60%

after a few hours.. the lust was over and the traffic was back to normal.. then i thought i'd start the module again.. and there you go.. satan was there with his halloween party.. he scared the hell out of me :), 57 corrupt database message at ONCE!!

it says the database table is dead (or crashed) and something about the data being dublicate.. so ofcourse i turned the module off again.. but now the system is freggin slow... i mean even i get bored surfin my site now.. its like joomla slow (hehe.. yea offence.. joomla is killing me in my job.. cant convince them to use drupal.. half them like it.. the other half think joomla is cuter... cuter.. are you kidding?)

so.. i thought i'd fix it.. i wanted to reinstall the OS [i still use windows :(], so i exporter my 50MB main database and my few kb user database (i use seperate database for drupal installation shared login).

but apparently the databse is too big to import.. it times out and says resubmit to resume i do it.. and it says.. there is an error with the script...

so i cant move my installation.. or atleast i dunno how to..

so yea.. is there a way to just copy my content (node? is that it?) table and just and use it on my new installtion? also.. will the auto_path be able to set path from these imported content? im finally being recognized by google.. dont want to loose that.. after all 53% of my traffic come from google.. hehe.. i sk...

so yea... help me out.. and i promise.. i will say thank you :D

⋅ Categories: Drupal 4.7.x

Comments

scriptnews’s picture

scriptnews commented

Hi

maybe You want to look at Your database using phpMysql or an other database admin system.

You most likely have some really huge tables, which can easily be reduced to normal:

cache ... this table can be easily emptied just EMPTY do not delete ...

sessions ... this table can be easily emptied just EMPTY do not delete ... BUT You and only You can know, if the sessions data is of importance for people coming back or other functions. If not: EMPTY it.

watchdog ... this is the nice guy who takes note of all the incidents - error reports etc. ... But once You know, You can empty this to.

ALTERNATIVE

There are people who never can let loose anything, but who have to store what ever they come across.

In such a case scenario You may want to backup a.k.a. export Your data table-wise. You can easily join several small tables for one process, and let the bigger ones for individual exports.

Later, whenever You need to restore, it is just the other way around: IMPORT.

TAKE CARE: maybe if You have a really busy site, You may want to close the site, while You are doing this, as otherwise data from different moments may produce errors when reinstalling.

Have Fun

Roland

Hope this helps

prameya’s picture

prameya commented

sometimes... you just are stupid... and cant do anything somehting about it.. unless ofcourse there is Roland to help you out.

obvious and easy solution... i wonder why it didn't come to my mind.. bc i remember the sessions table causing error!!

thank you... like promised ;)

prameya’s picture

prameya commented

ok.. it worked.. and i have sucessfully migrated drupal to a new system.. now i want to install a clean version of drupal with more features... how to i take my content from old system to the new?