By kakajoe on

hi everyone...please someone help me out, i got a big and huge problem with my mysql, the size is too large .. 600mb, can u imagine that?? did i do something wrong ?? thanks for helping me

⋅ Categories: Drupal 6.x

Comments

kakajoe’s picture

kakajoe commented

anyone can help ?

appraveen’s picture

appraveen commented

First,

This is a vague question. . . How do you know its big. Please provide more detail. You hav'nt even mentioned if it is a back-end to Drupal site(s). Weather you have data there or if its empty? Please speak out tell us more about the environment tell us more about the usage if any.

If you just say too big People would say good for you.

kakajoe’s picture

kakajoe commented

1. I want to upgrade to 6.14, when i dump my mysql, im a lil bit surprise..mysql is 600mb after i zip it. how can i import it again ? if the size is too large ? is there any way to export cck,views, user, taxonomy etc ??

2. and i got an error while im upgrading too.. the error said

An unrecoverable error has occurred. You can find the error message below. It is advised to copy it to the clipboard for reference.
Please continue to the error page
An HTTP error 0 occurred. http://www.slank.com/update.php?id=41&op=do

..
my website is dying...someone please help me.

appraveen’s picture

appraveen commented

I have dumped mysql but have never restored. I guess you are using the backup wizard that is available in CPanel. The wizard allows you to take a backup of:

  1. DB only
  2. Application only
  3. Both DB and Application

So what is the type of back-up you have taken? ? ? I guess you need to two back-ups. One for DB only and another complete back up.

Dont backup from phpmyadmin.

Praveen

EDIT

Also, if you use the Wizard the backup will be a tarball.

So, you dont have to worry.

The first time I backed-up my site. I used phpmyadmin and I was shocked too to see 16 MB of data right after a plain install.

It was a very fresh install. I had only 1 user and thts the admin. So dont use phpmyadmin for backup. If you have to use it and if there is no other go, use the option wherein you can export a tarball.

Praveen

kakajoe’s picture

kakajoe commented

thanks again Praveen,
im not using phpmyadmin, im using mysqldump unix command and i made my mysql to .zip not a tarball,that why unzip command can't read it, now im trying to extract it on my localhost, but its take 4 days and still downloading :( .....

how bout the error when im updating ?? my status keep ask me to update my dabatase, but i can't work it out :(

appraveen’s picture

appraveen commented

I guess you are using FF??? It seems it has a bug handling JS.

http://drupal.org/node/122114

Try disabling javascript in the browser and see what happens. Do let me know If it helps.

Also, you can know the data size in your db through phpmyadmin. See if the total shows as what you say ie 600 MB.

Praveen

EDIT

TRY using different browsers, different machine and Let me know if it works

Praveen

kakajoe’s picture

kakajoe commented

i already try it with intenet explorer, but still can't fixed it..it still stucked with the same error..
backup the sites folder and sub, deleted all root files..upload the backup sites folder and sub, still cant fixed...very confused and make me stress out