Mysql large file import

[eXceed69]

I have recently back-up my production database which is 160mb sql files... My problem is that I would like to have local back-up copy on my pc. Since restriction and exception hits on my phpmyadmin tool. Is that possible to chunk down each sql file into pieces let say 20mb sql file size... Is that posible and can you post it what software or steps should i take...


Thanks

[Nile]

To download a copy of your sql, simple go in phpmyadmin, click on a database, find the tabs that look like this:


And click "Export"

You should see something like this:


Select the file type on the left, and then click "Go."

As for "chunking down" the sql file to 20mb, I dont know.