Community & Support

Database error while importing db - cache_menu db table

I had to shift my Drupal website from my laptop to my desktop so I took the DB backup and website backup.
Im using the XAMPP server. When importing back the db, all the other tables except cache_menu db table have been uploded. Since the main drupal db was large in size, I broke down the whole db into sql files of each table. But even then cache_menu is not getting uploaded and is giving me the following error

Fatal error: Maximum execution time of 300 seconds exceeded in C:\xampp\phpMyAdmin\libraries\string_mb.lib.php on line 47

I have made some changes in the php.ini file

max_execution_time = 1800 ; Maximum execution time of each script, in seconds
max_input_time = 1800 ; Maximum amount of time each script may spend parsing request data
memory_limit = 128M ; Maximum amount of memory a script may consume (16MB)

Still its not helping. Im still getting the above error. Is some1 aware as to what i should do, plz??????????
I have to get it done by 2mrw!!!! Help!!!!

Comments

=-=

Id try to empty the cache_menu table. import a clean table and allow the cache to regenerate I think. There isn't any reason to carry over cached information in the DB.

Got the solution !!!!

I have got the solution regarding this .................... thanks for ur help ............. will post the soltn as soon as i can................ :)

I guess there's no need to

I guess there's no need to import the cache data after all.
Ref: http://drupal.org/node/342610

emptying cache

Empty the cache through admin>configuration>development.
Then open phpmyadmin, or refresh your phpmyadmin page, before exporting the DB.
You can also check the DB before and after caching: a series of entries should have been removed.

nobody click here