phpMyAdmin export/import question

[omoutop]

I know i have seen something in this forum in earlier posts but cant find it now, so i will ask again...

I have exported a large file from phpMyAdmin (around 16MB). I need a method to insert it in a new db (again with phpMyAdmin). I have no shell access, only the phpMyAdmin. How can i split the large file into many smaller ones safetly?

[dreamcatcher]

omoutop,

You use the SQL link and then browse to import the file. I don`t think you can split the file unless you edit it manually. Your best bet might have been to take individual backups of each table and then re-import each one. If you have large amounts of data in a table, export from certain rows only to keep it small.

Try exporting the structure only, then use a text editor to manually split it into several files. Also, the export function in PHPMyAdmin is known to time out on large exports, so check all your data is in place.

dc

[omoutop]

Well i thought of doing it manually, but there are more than 100 tables (and some of them are 3-4MB). I know i have read about a text tool that splits large text files into 1MB ones.

If anyone knows of it it would be nice - else its going to be a hellish weekend :)

[dreamcatcher]

There is something on the Classes Repository:

[phpclasses.org...]

dc

[maccas]

I think this is what you are looking for omoutop [webmasterworld.com...] the bigdump script.

[omoutop]

impressive!

did the job in secs :)

Thanks a lot! ./me bows :)