By chaos theory on

hiya all,...

i wander if you can help me. I recently moved server and restored a database backup onto the new server. However,... i hit a snag. 1 of the tables was too large (7mg)

i have this table backed up,... but cannot import or restore with neither phpmyadmin,... mysql restore,... my sqldumper or running as one query. they all say packet size is too big

i was just wandering if anyone new of a way i can import this single table of 7meg into my database. any halp would be greatly apprectiated. im not at all up on mysql

thanks in advance for any help

chaos!

Comments

VM’s picture

VM commented

what table is it ? if the watchdog table, you can start afresh as there really is no need to maintain the old watchdog logs, same with cache tables.

if none of those table, you may have to chunk it in, in smaller pieces rather then all 7MB at one time.

chaos theory’s picture

chaos theory commented

how will i put it in in smaller pieces. the only backup i have now is 1 table. 1 backup. all previous versions have been removed,... lost,... or deleted :( thanks for reply

VM’s picture

VM commented

Have shell access to your server ? if so try : lists.evolt.org/archive/Week-of-Mon-20060109/179068.html

last resort: upload the dumped table to your site, open a help ticket or support ticket with your host, have them import it making sure to give them the location of the dumped file.

gurukripa’s picture

gurukripa commented

hi

i am using Drupal 5.1 and advanced cache...in case u havent used it...it means that all my core files like node, block etc are patched...

so the cache tables are very large..
the tables that exist are

cache
cache_block
cache_captcha
cache_comment
cache_content
cache_filter
cache_forum
cache_menu
cache_node
cache_page
cache_path
cache_search
cache_taxonomy
imagecache_action
imagecache_preset

of these tables cache_filter is very large ..over 30 MB or so.....

i am moving hosts...is it safe for me to delete all these cache tables..or only some...if so, which ones ?

also subscriptions holding is a large table...

i dont have access to the site..the host thinks..its heavy on shared servers....so am stuck with Clean URLs on.....and cant access the admin interface...so am in trouble...

do u have any help to offer ..thanks

yelvington’s picture

yelvington commented

http://dev.mysql.com/doc/refman/4.1/en/packet-too-large.html

mkalbere’s picture

mkalbere commented

It happened that some provider limits the execution time of the script or its allowed memory
http://www.ozerov.de/bigdump.php allow you to bypass all those limitations. The import is cut into slice before being imported, and the script recall until the import is completely done.
... all this is ,of course, transparent for the user ;-)

achusudhakar’s picture

achusudhakar commented

Hi
once i faced the same problem,and the result is here... First backup the entire database. Then put this database file in mysql/bin directory.

Open mysql in command prompt and create a database and exit from mysql. then give this command in your command prompt,

c:\>(Your Mysql PAth) > mysql -u username -p password databasename < databasefilename.sql - then press enter and give password.

by doing so it will import the entire database (wait somtimes for your output in command prompt).

dorien’s picture

dorien commented

I know it has been a long while, but here is a great solution: bigdump!
http://dorax.naturalp.org/?q=node/3

Max_Headroom’s picture

Max_Headroom commented

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

Quentin Campbell