开发者

Mysql : Problem in exporting the database

开发者 https://www.devze.com 2023-03-01 17:22 出处:网络
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开发者_Stack

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

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号