How to backup/restore very big mysql dbs?

[aqw]

Hi!

How do I backup/restore very big mysql dbs?

(phpmyadmin limit 16MB)

thanks

[ashutosh_sns]

export the data in the text file . for exporting the data u can use the mysql-front software which is free on the net.

[luxinterior]

Is mysql-front free? I just looked at their Website and I could only see paid versions? I usually used phpMyAdmin and export it to a text file. The pain is when you have to split it up manually into manageable sizes to import it again. There MUST be an easier way than this. Anybody shed some light on this for me and the OP?

Lux