Mysql : Problem in exporting the database

I'm using php and mysql. When i try to export the database using phpMyAdmin. The database have 365 tables. But when i export i'm getting only 209 tables. The exported file size was 120mb开发者_StackOverflow中文版. What's the problem exporting the file?? Either i have to change any configuration settings ??

Try to export using linux console with mysqldump. A small tutorial can be found here.

there could be multiple problems. memory limit, execution time. I guess 120mb fits exactly your memory limit ;)

try to increase this limit or try mysqldump --opt -u username -ppassword database > foobar.sql on the cli