My DB crashed :( !! Now it shows error [See Plz]

[harry]

Hey allz ,

My sites DB crashed couple of hours ago . so i deleted that db and made a new one and imported the tables that i backed up by using phpmyadmin

but i cant import the table ... it says "I have allocated maximum space for Database 10k+ bytes (10 MB) and so it cant be imported etc"

so any solution ?

i can import tables which had less than 10 MB size.

 

[Grinder]

Use bigdump to import a large database.

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

 

[nEw_boY]

I think you are going with wamp server...
Check for tutorial to import it in some other manner..

IT`s easily google-able.
I`ve just done in my Dev DB.

 

[NewEraCracker]

Use MySQLDumper to import database.
(Google it)

 

[shadow.prx]

Use bigdump to import a large database.

+Bigdump works great for importing big databases

 

[CyberDeViLZ]

you should not do anything if yours error like this one, MySQL Error : Got error 28 from storage engine, its only temporary during server host upgrade etc, too bad you already remove your DB. I got same problem few hour ago.

 

[harry]

[02-Aug-2010 19:16:07] PHP Warning: POST Content-Length of 10795387 bytes exceeds the limit of 8388608 bytes in Unknown on line 0

same error with bigdump

any other alternative ?

 

[harry]

where would be my php.ini file located ??

any guess ??

This is what i found from googling

Solution:

In order to upload a larger size file, increase the value of post_max_size variable.

1) Edit the php.ini file. You ca retrieve the path to php.ini using “php -i | grep php.ini”

pico /usr/local/lib/php.ini

2) Search the variable post_max_size. Suppose you need to upload a file of 50M, set the value to 60M.

post_max_size = 60M
upload_max_filesize = 60M

3) Save the file and restart the Apache service.

service httpd restart

That is it. You will now be able to upload the file using POST method.

 

[nEw_boY]

Try not to do that edits unless you know what you are doing..
Just get me on Yahoo I`ll explain you step by step.

 

[chems]

try to devide it to 2 part

 

[Sponge Bob]

This was already sorted out.

This error was caused as we were upgrading our server with the latest version of Apache and PHP and other things.

We also had this issue open on our network issues page.

The site is back to normal after i uploaded the database, the issue is solved.

Thanks & Regards

 

[harry]

Thanks every1 for the support

appreciated and probs solved