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.

harry Reviewed by harry on 2nd Aug 2010. My DB crashed :( !! Now it shows error [See Plz] 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. Rating: 5

[WarezFreaks]

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