Help required Re. MySQL

New Member Joined: Sep 15, 2006 Posts: 3

Hi,

I have just joined your Forum, and I am in need of your expert advice.

Few days back, my WordPress blog was running at crawling speed. When it was stabilized, I went to take the backup and to my utter surprise, the backup file was only 305 Kb (gzip), where as, it should be around 2MB (gzip). I suspected something wrong, then I checked Post management, and I got SQL error.

I had then entered into cPanel to check the status of the db, and I clicked to repair the DB, and this is what I have got:

Quote:

wp_posts
error : 12 when fixing table
warning : Number of rows changed from 698 to 3510
status : OK

After this blog started functioning normal and it worked for about four days without any problem. Just a day before, when I disconncted my internet, my blog was working absoultely fine. And after 7 hrs, when I started again.

The blog was crashing i.e. blog, theme, plugins etc nothing was loading, and this same things had happened about 25 days back also. That time, I had dropped Table from the blog DB, and re-uploaded from the lastest back and everything started working again.

So, I did the same thing yesterday also. and since then I am not able to upload my SQL dump. Becasue of the following quoted error:

Quote:

Fatal error: Maximum execution time of 300 seconds exceeded in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/string.lib.php on line 91

After trying for about 10 times, I gave up. Today again when I tried, at the first attempt I got the under quoted error:

Quote:

#1034 - Not enough memory for blob at 7224 (need 47497)

.

I had then deleted my DB and recreated and tried to re-upload and once again it failed with the following error:

Quote:

Fatal error: Maximum execution time of 300 seconds exceeded in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/sqlparser.lib.php on line 306

.

Can you please advice me, how do I upload my backup again, as my blog is down for the past 48 hrs.

Regards,
Rok...

Sells PC To Pay For Divorce Joined: Posts: 5661

ah wordpress huh...
well,if you have such litle database then there is something wrong,and simple uploading your database backup might be a temporary solution..

download this file big dump here..

http://www.ozerov.de/bigdump.php

read the simple how to use it,and it will upload the backup in a few seconds..